Contract notice period reminders: how to catch the window before an auto-renewal

This article is AI-generated.

Many service, software, equipment and maintenance contracts renew automatically unless you give notice. The trap isn't the renewal date itself. It's the notice period in front of it. If a contract ends on 31 January and requires 90 days' written notice, the real deadline is early November, and by the time anyone notices the end date, the decision has already been made for you.

This guide shows a simple routine that works in any spreadsheet: a register that records the notice deadline rather than just the end date, one formula that tells you which contracts need a decision now, a fixed sequence for deciding and sending notice, and a habit of writing down proof that notice went out. It's written for operations, procurement and finance teams who look after a few dozen to a few hundred contracts.

Step 1: Read three things from each contract

For every contract that can renew automatically, find:

1. The end date of the current term. Not the signing date.
2. The notice period. Usually in days or months, and sometimes "before the end of the term" or "before the anniversary date".
3. How notice must be given. In writing, by email to a specific address, by letter to a registered office, through a customer portal. This matters as much as the date.

Write the clause reference next to each one so anyone can check it later. If the wording is unclear, mark the row "check with legal" rather than guessing. This guide is about tracking dates, not interpreting contracts.

Step 2: Build a register around the notice deadline

One row per contract. Illustrative (all names are placeholders):

Ref	Supplier	What it covers	Term end	Notice (days)	Notice deadline	Days left	Flag	Owner	How notice is given	Contract file (name and location)
CT-01	Supplier A	Equipment maintenance	2027-01-31	90	2026-11-02	20	ACT NOW	Ops lead X	Letter to registered office	Contracts / Suppliers / CT-01_signed.pdf
CT-02	Supplier B	Software subscription	2027-02-28	90	2026-11-30	48	DECIDE	IT lead Y	Email to named address	Contracts / IT / CT-02_signed.pdf
CT-03	Supplier C	Cleaning services	2026-11-30	60	2026-10-01	-12	MISSED	Facilities Z	Written notice	Contracts / Facilities / CT-03_signed.pdf

The key columns:

• Notice deadline is the date you sort and filter by. It's the term end minus the notice period.
• Owner is one named person who decides whether to renew, not a department.
• How notice is given saves a scramble on the last day, when someone discovers the letter needs a signature and a courier.

Step 3: Two formulas

With term end in column D and notice days in column E:

Notice deadline (column F):

=D2-E2

Days left until the deadline (column G):

=F2-TODAY()

Flag (column H):

=IF(G2<0,"MISSED",IF(G2<=30,"ACT NOW",IF(G2<=60,"DECIDE","")))

I checked these in LibreOffice Calc with 13 October 2026 standing in for TODAY(). The three illustrative rows above came out as shown: CT-01 gave a deadline of 2 November with 20 days left (ACT NOW), CT-02 gave 30 November with 48 days left (DECIDE), and CT-03's deadline had passed 12 days earlier (MISSED). Format column F as a date. In some locales, use semicolons between arguments.

If the notice period is in months, use =EDATE(D2,-E2) instead of =D2-E2 and enter months in column E. Calendar months and days don't line up, so match what the contract says.

Step 4: Decide early, act on a fixed sequence

The flags map to a routine:

• DECIDE (31–60 days before the deadline): the owner answers one question: renew as is, renegotiate, or end it? If renegotiating, this is the time to talk to the supplier, while you still have the option to leave.
• ACT NOW (0–30 days): if ending or renegotiating, prepare and send the notice in the required form. Don't wait for the last week. Letters get lost, the named email address may have changed, and a signatory may be away.
• MISSED: record it, check the contract for the next opportunity to give notice, and set the new deadline in the register. Then look at why it was missed, which is usually an owner who left or a contract that was never in the register.

A short message from whoever runs the weekly check keeps things moving. Illustrative:

Notice reminder (illustrative): CT-01 Equipment maintenance, Supplier A. Term ends 31 Jan 2027, 90 days' notice, so the deadline is 2 Nov 2026 (20 days left). Notice must be a letter to their registered office. Please confirm by Friday: renew, renegotiate or end?

Step 5: Keep proof that notice was sent

Add two columns: Notice sent on and Proof (file name and location). Proof might be a scanned letter with a courier receipt, or an email saved as a file with its headers. When someone asks a year later whether you really cancelled, you can point to the file rather than to someone's memory.

Once notice is sent, clear the flag by adding a status column ("Notice sent", "Renewed", "Ended") at the end of the register (column N, if the two proof columns are L and M) and wrapping the flag formula so it only shows for open rows:

=IF(N2<>"","",IF(G2<0,"MISSED",IF(G2<=30,"ACT NOW",IF(G2<=60,"DECIDE",""))))

Step 6: One weekly check, one owner for the register

• Weekly: someone sorts by notice deadline, filters on the flag column, and messages each owner with a flagged row. Ten minutes.
• When contracts are signed: the new contract doesn't count as filed until its row exists. This is how you stop contracts from never entering the register.
• When people leave: their rows get a new owner as part of the handover.

Checklist

• [ ] Every auto-renewing contract has a row.
• [ ] Term end, notice period and notice method are taken from the contract, with the clause reference.
• [ ] Notice deadline is calculated, and the register is sorted by it.
• [ ] Flags show DECIDE, ACT NOW and MISSED.
• [ ] Each row has one named owner.
• [ ] Notice sent date and proof are recorded.
• [ ] Someone checks weekly, and new contracts are added on signing.

Common mistakes

• Tracking only the end date. The decision window has closed before the end date looks urgent. Fix: sort by notice deadline.
• Assuming email is enough. Some contracts require a letter or a specific address. Fix: record the notice method in the register.
• A department as owner. Nobody acts. Fix: one named person.
• No proof kept. Disputes become your word against theirs. Fix: file the proof and note its location.
• Months treated as days. "Three months" isn't always 90 days. Fix: use EDATE when the contract says months.