Step-by-step guide · Free Excel template included
How to track contract renewals in Excel (so none of them slip)
A practical walkthrough: the columns that matter, the one formula that calculates your cancellation deadline, and how to set reminders that actually fire — before a renewal locks you in for another year.
Most teams track renewals in a spreadsheet, and for a small number of contracts that's genuinely fine. The trick is tracking the right date and setting a reminder that doesn't depend on anyone remembering. Here's how to do both — and a free template you can copy if you'd rather not build it from scratch.
Grab the free templateSet up the right columns
Open a new sheet and create these columns. The order matters less than making sure the bolded one exists, because it's the one most trackers skip:
- Vendor / Counterparty
- Contract type (SaaS, services, NDA…)
- Annual value
- Start date
- End date
- Renewal date
- Notice period (days) — e.g. 30, 60, 90
- Notice-window opens (calculated — see Step 2)
- Auto-renews? (Yes/No)
- Owner
- Status
Freeze the header row (View → Freeze Panes) so it stays put as the list grows.
Calculate when your notice window opens
The renewal date is not the date to watch. By the time it arrives, the contract has usually already renewed. The date that matters is when your notice window opens — the start of the period when you can still cancel in time.
If your renewal date is in column F and your notice period (in days) is in column G, the formula for "Notice-window opens" is:
=F2-G2That's the renewal date minus the notice period. A contract renewing on 1 March with a 60-day notice period gives you a notice window that opens on 31 December — miss that, and you're locked in for another term.
Drag the formula down the column. Now every contract shows you the real deadline, not the one that's already too late.
Turn on visual alerts with conditional formatting
A date in a cell won't save you if no one's looking at it. Make the sheet warn you:
- Select your Notice-window opens column.
- Home → Conditional Formatting → New Rule → Use a formula to determine which cells to format.
- Enter this formula (assuming the column starts at H2):
=AND(H2>=TODAY(), H2<=TODAY()+30)Set the fill to amber. Add a second rule for red:
=AND(H2>=TODAY(), H2<=TODAY()+14)Now any contract whose notice window opens within 30 days turns amber, and within 14 days turns red — every time you open the file. Sort by the notice-window column to push the urgent ones to the top.
Add calendar reminders off the notice-window date
Conditional formatting only works if someone opens the file. For anything important, back it up with a calendar reminder tied to the notice-window-opens date — not the renewal date:
- Google Calendar / Outlook: create an all-day event on the notice-window date, titled "Notice window opens: [Vendor] — decide renew/cancel," with a reminder 7 days before.
- Make it a shared/team calendar, not your personal one. Reminders in a personal calendar disappear when that person leaves.
Do this for every contract where a missed renewal would actually hurt. Yes, it's manual. That's the honest catch of the spreadsheet method — covered next.
Where this method starts to break
Done well, the Excel method works — up to a point. It's worth knowing where the point is:
- Every date is typed by hand. Someone has to open each contract, find the notice clause (often buried deep in the document), and enter the numbers. Miss one, and the sheet looks fine right until the renewal hits.
- It only warns you if someone opens it. The conditional formatting can’t email you.
- It’s only current as of the last update. Add a recurring calendar hold to keep it honest — and accept that it’ll still drift.
- It lives with one person. When they leave, so does the tracking.
Past roughly 30 contracts, keeping all of this accurate becomes its own part-time job.
Or skip the manual part
If maintaining this by hand sounds like a second job, that's the problem Uplena solves. Drop in your agreements — even messy scans — and it reads each one, finds the notice windows for you, and builds the renewal calendar automatically. The same tracker, without the typing, and it actually warns you in time.
It's free during early access.
Questions, answered.
How do I track contract renewals in Excel?+
Create a row per contract with the vendor, value, dates, and notice period. Calculate the notice-window date (renewal date minus notice period), use conditional formatting to flag dates coming up within 30 and 14 days, and set a shared calendar reminder off the notice-window date. The detailed steps are above.
What formula calculates a contract notice deadline in Excel?+
Subtract the notice period (in days) from the renewal date: =RenewalDate-NoticeDays. For a 1 March renewal with a 60-day notice period, that gives 31 December — the last day you can still serve notice in time.
How do I get Excel to remind me of a renewal?+
Excel can't send reminders on its own. Use conditional formatting for visual alerts when you open the file, and back it up with a calendar event (Google Calendar or Outlook) on the notice-window date, on a shared team calendar so it survives staff changes.
Is Excel the best way to track contract renewals?+
For a small number of contracts, it’s perfectly good. It struggles once you pass ~30 agreements, because every date is entered by hand, it only warns you when someone opens it, and it depends on one person keeping it current. At that point a tool that reads the contracts and sends alerts saves more time than it costs.