Free template
Free Contract Tracking Template (Excel & Sheets)
Missing a renewal deadline can lock you into another year of a contract you meant to cancel. Our free contract tracking template keeps all your contracts in one place, with one row per contract. It works out each cancel-by date for you, counts down the days left and turns contracts red as their deadlines get close.
No email needed. For Google Sheets, upload the Excel file to Drive and choose File → Save as Google Sheets. Prefer automatic reminders? Start a free ExpirePilot trial, no credit card required.
Cancel-by dates worked out for youColor-coded deadlinesOne-tab dashboard8 sample contracts
The template works in Excel and Google Sheets. It comes with a one-tab dashboard, 8 sample contracts and a renewal log, and it handles contracts in more than one currency. Below the download, you’ll find what each column means, how to set up renewal alerts, and when a spreadsheet stops being enough.
→Skip the spreadsheet
Rather have the reminders sent for you?
A spreadsheet only works if someone opens it. ExpirePilot tracks the same contracts and emails the right people before every cancel-by date, then follows up until someone acts.
14-day free trial, no credit card required. Free plan for up to 20 contracts.
What ExpirePilot adds to this template
- Import this template in minutes, or scan contract PDFs and let AI fill in the dates for you to check
- Reminders on your schedule, to you, your team and the vendor or client
- Follow-ups and escalation to a manager when nobody acts
- The signed contract stored with each record
- A log of every reminder sent, opened and clicked
iDefinition
What is a contract tracking template?
A contract tracking template is a spreadsheet that lists every active contract in one place, one row per contract, with its counterparty, owner, value, start and end dates, notice period and status. Formulas work out the cancel-by date and the days left, so you can renew, renegotiate or cancel before an auto-renewal locks you in.
!Why teams start one
A contract renewed and nobody noticed
Most teams start a contract tracker right after a contract quietly renews without anyone noticing.
A software subscription rolls over for another year, a vendor price increase takes effect, or a lease notice window closes. The contracts themselves are usually stored somewhere. What’s missing is one view of the dates that matter, with a person named next to each one.
A contract tracker is useful if you're:
- An operations or office manager who handles leases, utilities and service vendors
- On a procurement or finance team that keeps track of vendor spend and renewal dates
- A small business owner or freelancer managing client agreements and subscriptions
- On an in-house legal team that needs a simple contract register before investing in a full system
✓What’s included
What's included in the free template
One workbook with seven tabs. Everything is already built, so you only need to add your contracts. A Start here tab explains each one.
Tab 1
Tracker
Where you list your contracts: 25 columns, from Contract ID to Notes. Dropdowns for status, category, auto-renew and currency keep entries consistent. The cancel-by date, days left and alert work themselves out, so you never type them.
Tab 2
Dashboard
A one-screen summary that updates as you edit the tracker: live contracts, overdue deadlines, cancel-by dates in the next 30, 60, 90 and 180 days, contracts that auto-renew, value by currency, contracts with no owner, and the next 10 deadlines.
Tab 3
Renewal log
A record of every renewal, cancellation and notice sent, with old and new end dates and values. Type the Contract ID and the title fills in.
Tab 4
Email reminders
An optional Google Sheets script that emails each contract owner 60, 30 and 7 days before the cancel-by date, with step-by-step setup.
Tab 5
Sample data
Eight filled-in examples: a software subscription, office lease, insurance policy, cleaning vendor, client agreement, NDA, equipment rental and marketing retainer. Delete them once you’ve added your own.
Tab 6
Settings
Change the dropdown lists (statuses, categories, currencies) and the alert thresholds. Colors and dashboard counts follow whatever you set here, for example 14 and 30 days instead of 30 and 60.
Already set up for you
Open the file and start adding contracts. Nothing to configure first.
- Color-coding: dark red when the cancel-by date has passed, red at 30 days or fewer, amber at 31–60 days, green beyond 60, and grey for terminated or expired contracts
- Frozen header row and filters, so you can sort by days left or by owner
- Grey formula columns, so it’s clear which cells work themselves out
- Dates that read the same everywhere (Jan 14, 2027), plus a currency column for contracts outside the US
#Columns
Contract tracker columns, explained
Each row is one contract. The columns marked auto work themselves out from your dates, so you never fill them in.
| Col | Column | What to enter | Example |
|---|---|---|---|
| A | Contract ID | A short, unique code you use to refer to the contract | VND-2026-014 |
| B | Contract title | What the contract covers, in plain words | Office cleaning services |
| C | Counterparty | The other party: vendor, client, landlord or partner | BrightClean LLC |
| D | Category | The type of contract (dropdown) | Vendor |
| E | Status | Draft, In review, Active, Renewal in progress, Renewed, Terminated or Expired | Active |
| F | Owner | The one person responsible for the renewal decision | Maria Lopez |
| G | Start date | The date the contract took effect | Jan 15, 2026 |
| H | End date | The date the current term ends | Jan 14, 2027 |
| I | Notice period (days) | Days of notice the termination or renewal clause requires | 60 |
| J | Auto-renew | Whether it renews automatically if nobody acts (Y/N) | Y |
| K | Cancel-by date (auto) | The last day to give notice: end date minus notice period | Nov 15, 2026 |
| L | Days left (auto) | Days until the cancel-by date. Negative means it has passed. | 9 |
| M | Contract value | The annual value, or the total for a one-off contract | 14,400 |
| N | Currency | The currency of the contract value (dropdown) | USD |
| O | Document link | A link to the signed copy in Drive, SharePoint or Dropbox | drive.google.com/… |
| P | Governing law | The country or state whose law applies | Texas, USA |
| Q | Owner email | Where the optional reminder script sends alerts | maria@example.com |
| R | Alert (auto) | Overdue, Act now, Plan, On track or Closed | Act now |
The Tracker also has Live, Department, Renewal term, Payment terms, Last reviewed and Notes columns, plus a helper column the dashboard uses.
Tips for filling it in
A few habits that keep the tracker accurate.
- Put one person in the Owner column, not a team. “Finance” can’t get a reminder or make a decision.
- Take the notice period from the contract, not from memory. It’s usually in the termination or renewal clause. If there’s none, enter 0.
- Auto-renew costs the most when it’s wrong. If you’re not sure, enter Y until you’ve checked.
- Keep the value annual, so the dashboard compares like with like.
- When a contract renews, update its end date in the same row and note it on the Renewal log.
→How to use it
How to use the contract tracking template
About 30 minutes to set up 20 contracts, then 10 minutes a week.
Step 1
Download or make a copy
Download the Excel file, or open it in Google Sheets. Save it where your team can reach it, not on one person’s desktop.
Step 2
Clear the sample rows
See how the 8 examples fill each column and change color, then delete them from the Tracker. A copy stays on the Sample data tab.
Step 3
Add the riskiest contracts first
Start with contracts that auto-renew, the highest-value ones and anything ending in the next 6 months. Recurring card charges often reveal forgotten ones.
Step 4
Fill in every notice period
Find it in the termination or renewal clause. It drives the cancel-by date. If you can’t find it yet, enter 90 and check later.
Step 5
Name an owner for each contract
One person per row, and tell them. The dashboard counts live contracts with no owner, so aim for zero.
Step 6
Check the dashboard weekly
Ten minutes on Monday: decide on every red row, start talks on every amber one, and update anything renewed or cancelled.
!Renewal alerts
How to set up contract renewal alerts
The template warns you in three layers: a cancel-by formula that works out the real deadline, color-coding so urgent rows stand out, and optional email reminders for when nobody opens the sheet.
1. The cancel-by formula
The date that matters isn’t the end date. It’s the last day you can give notice. If a contract ends on January 14 and needs 60 days’ notice, your real deadline is November 15.
Days left counts down to that date every time the file opens. A negative number means the deadline has passed.
Cancel-by date (K2): =IF(H2="","",H2-I2)
Days left (L2): =IF(K2="","",K2-TODAY())
Both formulas are already filled in on the template. They’re shown here if you’re building your own.
2. Color-coding
The template colors the whole row from the Alert column, using the thresholds on the Settings tab. To build it yourself, select your data range, open Format → Conditional formatting in Google Sheets (or Home → Conditional Formatting → New Rule in Excel) and add a custom-formula rule for each color.
| Rule (custom formula) | Color |
|---|---|
=OR($E2="Terminated",$E2="Expired") |
Grey: no action needed |
=AND(ISNUMBER($L2),$L2<0) |
Dark red: deadline passed |
=AND(ISNUMBER($L2),$L2<=30) |
Red: act now |
=AND(ISNUMBER($L2),$L2<=60) |
Amber: plan |
=ISNUMBER($L2) |
Green: on track |
Keep the rules in this order. Google Sheets applies the first one that matches; in Excel, tick Stop If True.
3. Email reminders in Google Sheets
Google Sheets’ own notifications only tell you when someone edits the sheet, not when a date is near. This short script runs once a day and emails each owner when a contract hits 60, 30 or 7 days before its cancel-by date.
- Fill in the Owner email column.
- Open Extensions → Apps Script and paste the code.
- Click Run once and allow the permissions.
- Click Triggers → Add Trigger: Time-driven, Day timer, 8 to 9 a.m.
In Excel, use Outlook calendar events on each cancel-by date, or a daily Power Automate flow.
function sendRenewalReminders() {
const ss = SpreadsheetApp.getActive();
const rows = ss.getSheetByName('Tracker').getDataRange().getValues();
const head = rows[0];
const col = name => head.indexOf(name);
const ALERT_DAYS = [60, 30, 7];
const tz = Session.getScriptTimeZone();
for (let i = 1; i < rows.length; i++) {
const r = rows[i];
const daysLeft = r[col('Days left')];
const email = r[col('Owner email')];
if (!email || typeof daysLeft !== 'number') continue;
if (r[col('Live')] !== 'Yes') continue;
if (!ALERT_DAYS.includes(daysLeft)) continue;
const cancelBy = Utilities.formatDate(r[col('Cancel-by date')], tz, 'MMM d, yyyy');
const title = r[col('Contract title')];
MailApp.sendEmail(email,
'Contract reminder: ' + title + ' (' + daysLeft + ' days to cancel-by date)',
title + ' with ' + r[col('Counterparty')] + '\n' +
'Cancel-by date: ' + cancelBy + '\n' +
'Auto-renews: ' + r[col('Auto-renew')] + '\n' +
'Contract: ' + r[col('Document link')] + '\n\n' +
'Update the tracker: ' + ss.getUrl());
}
}
A free Gmail account can send about 100 script emails a day. The same code is on the template’s Email reminders tab.
Why 60, 30 and 7 days?
One reminder isn’t enough, because each stage of a renewal decision takes time.
- 60 days: time to review usage, get competing quotes and decide. Renegotiation works when the vendor knows you could leave.
- 30 days: time to get approval and send formal notice, or sign the renewal on better terms.
- 7 days: the last chance, and a backstop if the owner was away.
- For leases and enterprise software with 90+ days’ notice, add a 90-day alert.
vsWhen to move on
When a contract tracking spreadsheet stops being enough
A spreadsheet works well for a few dozen contracts and one careful owner. It gets risky when more people, more contracts or more deadlines are involved.
| Capability | This template | ExpirePilot |
|---|---|---|
| Works out the cancel-by date | Yes | Yes |
| Reminds people before the deadline | Only with the script, one email per owner | On your schedule, to several people and the vendor or client |
| Follows up if nothing happens | No | Escalates to a manager and repeats until renewed |
| Keeps the signed contract | A link to another folder | Stored with the contract record |
| Reads dates from the contract PDF | Typed by hand | Scan with AI, you confirm |
| Shows who was reminded and when | No history | Log of every reminder sent, opened and clicked |
| Cost | Free, plus admin time | Free plan, paid from $15/month |
Import this template and your reminders start the same day.
Yes. Download the Excel file, make a copy in Google Sheets or download the CSV. No email or sign-up is needed, and you can use and change it however you like.
Yes. Every formula, dropdown and color rule works in Google Sheets, and the Email reminders tab adds automatic emails that only Google Sheets can send. Upload the Excel file to Google Drive and choose File → Save as Google Sheets, or use the Google Sheets button at the top of this page.
The end date is when the current term finishes. The cancel-by date is the last day you can give notice to stop it renewing: the end date minus the notice period. A contract ending January 14 with 60 days’ notice has to be cancelled by November 15.
In Google Sheets, use the script on the Email reminders tab, which emails each owner 60, 30 and 7 days before the cancel-by date. In Excel, add Outlook calendar events or a Power Automate flow. For reminders to several people with follow-ups, use contract tracking software such as ExpirePilot.
Yes. Pick each contract’s currency from the dropdown. The dashboard totals each currency separately and doesn’t convert them, and dates are shown as Jan 14, 2027, which reads the same in every country.
The Tracker has formulas ready for 300 contracts. To add more, copy the last row’s formulas further down. Past about 50 contracts or more than one person editing, most teams move to dedicated software.
Yes. ExpirePilot imports Excel and CSV files, so you can bring in this tracker as it is. The free plan covers up to 20 contracts, and every account starts with a 14-day trial with no credit card.
Never miss another contract renewal
Keep using the free template, or let ExpirePilot remind the right people before every cancel-by date and keep each signed contract to hand.
No credit card required. Free plan available.