# IT Vendor Contract Renewal Tracker Worksheet

> Source: https://netray.co/tools/it-vendor-contract-renewal-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track support, license and hosting contracts with notice deadlines and a forecast of next year cost after expected price uplifts.

## Category

cost-finance

## Industry

Discrete Manufacturing

## Audience

- IT manager
- Procurement
- CIO

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Vendor

**Key:** vendor

**Type:** text

#### Service

**Key:** service

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- Support and maintenance
- Subscription
- Hosting
- Hardware warranty
- Managed service

#### Annual cost

**Key:** cost

**Type:** number

**Format:** currency

#### Expected uplift %

**Key:** uplift

**Type:** number

**Unit:** %

#### Next year cost

**Key:** next

**Type:** number

**Expr:** cost * (1 + uplift / 100)

**Format:** currency

#### Renewal date

**Key:** renewal

**Type:** date

#### Notice days

**Key:** notice

**Type:** number

#### Owner

**Key:** owner

**Type:** text

**Rows:**

**Vendor:** ERP vendor

**Service:** Annual maintenance and support

**Type:** Support and maintenance

**Cost:** 84000

**Uplift:** 5

**Renewal:** 2027-03-31

**Notice:** 90

**Owner:** IT manager

**Vendor:** Backup software vendor

**Service:** Subscription, 40 TB

**Type:** Subscription

**Cost:** 18500

**Uplift:** 7

**Renewal:** 2027-01-15

**Notice:** 60

**Owner:** Infrastructure lead

**Vendor:** Colocation provider

**Service:** Half rack and bandwidth

**Type:** Hosting

**Cost:** 22800

**Uplift:** 3

**Renewal:** 2026-12-31

**Notice:** 90

**Owner:** Infrastructure lead

**Vendor:** Server OEM

**Service:** Warranty extension, 6 hosts

**Type:** Hardware warranty

**Cost:** 9600

**Uplift:** 0

**Renewal:** 2027-06-30

**Notice:** 30

**Owner:** System admin

**Vendor:** Managed SOC

**Service:** Monitoring and response

**Type:** Managed service

**Cost:** 36000

**Uplift:** 4

**Renewal:** 2027-02-28

**Notice:** 60

**Owner:** Security officer

**Totals:**

#### Current annual spend

**Key:** cost

**Agg:** sum

**Format:** currency

#### Forecast next year spend

**Key:** next

**Agg:** sum

**Format:** currency

**Summary:**

#### Forecast increase

**Key:** increase

**Expr:** sum_next - sum_cost

**Format:** currency

#### Forecast increase %

**Key:** increase_pct

**Expr:** if(gt(sum_cost, 0), (sum_next - sum_cost) / sum_cost * 100, 0)

**Format:** percent

**Notes:** Notice deadline is renewal date minus notice days; add it to your calendar. Verify auto-renewal and price-cap clauses in the actual contract, which this sheet does not replace.

## Content

**Intro:** IT contracts quietly auto-renew with a price uplift if no one sends notice on time. This tracker keeps every support, subscription and hosting contract in one list with its notice window and next year cost.

**Sections:**

#### How to use the tracker

**Body:** Enter each contract with annual cost, expected uplift, renewal date and notice days. Next year cost is computed for you and totals roll up into the budget impact. Sort by renewal date and calendar the notice deadline, which is the renewal date minus the notice days. Export to Excel for finance or procurement reviews.

#### Why notice dates matter

**Body:** Many support and subscription agreements renew automatically for a year unless notice is given within a window, often 30 to 90 days. Missing it removes your leverage to renegotiate or exit. Put a reminder at least two weeks before the deadline, and begin benchmarking and quoting well ahead of it so alternatives are credible.

**Bullets:**

- Record auto-renewal and price-cap clauses
- Note multi-year commitments and termination fees
- Confirm who has authority to sign notice
- Keep copies of the signed order forms

#### Negotiating uplifts

**Body:** Annual increases are frequently tied to inflation indexes or fixed percentages. Compare against usage: unused licenses, retired servers and abandoned modules can be removed at renewal. Bundle renewals with the same vendor to improve leverage, and ask for caps on future increases. Vendor lists and ERP user counts should be reconciled before you sign.

#### Common mistakes

**Body:** Teams lose track of contracts bought by departments, forget hardware warranty expiries, and treat the uplift as a certainty rather than something to negotiate. Review the register quarterly with finance and make sure retired systems have their contracts cancelled, not just powered off.

**Cta:** If you are weighing ERP support costs against alternatives, Netray can discuss where AI on top of your existing ERP might reduce the need for add-on licenses.

**Faq:**

#### How early should I start a renewal review?

**Answer:** Start four to six months before the renewal date, or earlier for ERP and hosting contracts. You need time to measure usage, collect competing quotes and still have notice time left if you decide to change.

#### What uplift should I assume?

**Answer:** Use the figure in your contract if one is stated. Otherwise many teams budget a range of roughly 3 to 8 percent for software support and hosting, then adjust once the vendor quote arrives. Treat it as an assumption.

#### Where do I find the notice period?

**Answer:** It is in the term and renewal clause of the master agreement or order form, sometimes in an addendum. If you cannot find it, ask the vendor for written confirmation and keep it with the contract.

#### Should hardware warranties be included?

**Answer:** Yes. Expiring server and storage warranties often lead to emergency purchases or risky operation without support. Track them with the same notice and cost fields so replacement planning starts early.

## Search terms

contract renewal tracker excel, IT contract tracker template, software renewal tracker, vendor contract management spreadsheet, license renewal calendar, support contract renewal template, IT budget renewal forecast, auto-renewal notice tracker

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json