Free Excel template

Contract renewal tracker

Most contracts don’t end. They roll over. This spreadsheet shows every notice deadline in one place, so you decide what happens before the date passes, not after.

Excel tracker and one-page guide · No sign-up needed

At a glance

Every notice deadline in one place

01Fill in the shaded columns. Supplier, owner, annual value, end date, notice period, uplift and renewal term. The tracker works out the rest.
02See what needs action. Every contract is flagged: notice date passed, act now, review soon or OK.
03Check the Summary tab monthly. What’s overdue, what’s due in the next 60 days and the value coming up for renewal.

Contents

1. Set it up in four steps
2. What the status means
3. Before every renewal, ask

1. Set it up in four steps

List every contract over a set annual value, such as £5,000. Start with software, facilities, fleet and professional services: they’re most likely to auto-renew.
Fill in the shaded columns. Supplier, owner, annual value, end date, notice period, uplift and renewal term. The tracker works out the notice deadline, the status and what the next term will cost.
Name an owner for every contract. The person who decides what happens at renewal, not whoever signed it.
Check the Summary tab every month. It shows what’s overdue, what needs action in the next 60 days and the value coming up for renewal.

2. What the status means

Status	What to do
Notice date passed	Too late to give notice. Check the terms: some suppliers will still negotiate.
Act now	Notice deadline within 60 days. Decide this week: renew, renegotiate or retire.
Review soon	Notice deadline within 120 days. Check usage and pricing now.
OK	No action yet.

3. Before every renewal, ask

Are we still using it, and how much?
Have invoices matched the agreed price?
What will it cost next term, with the uplift?
Is there a better option?

Outgrown the spreadsheet? Webexpenses Contract Management keeps every agreement in one place, reads key dates from the contract on upload and flags renewals before the date.