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.

Download for ExcelUse in Google SheetsDownload CSV

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

Preview: the Tracker tab
Contract tracker8 sample contracts · sorted by cancel-by date
1 overdue
Copier lease and serviceOfficeTech Rentals · Auto-renews · Cancel by Oct 31, 2026Overdue
Office cleaning servicesBrightClean LLC · Auto-renews · Cancel by Nov 15, 2026Act now
General liability insuranceSummit Mutual · Auto-renews · Cancel by Dec 1, 2026Act now
Head office lease, Suite 400Harbor Point Properties · 180 days' notice · Cancel by Jan 1, 2027Plan
Master services agreementNorthwind Retail Ltd · GBP · Cancel by Jul 2, 2027On track
Cancel-by date = end date minus notice period. Rows change color as the deadline gets close.

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.

Start free trial →

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

See all features →

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.

  1. Fill in the Owner email column.
  2. Open Extensions → Apps Script and paste the code.
  3. Click Run once and allow the permissions.
  4. 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
Start free trial →

Import this template and your reminders start the same day.

?FAQ

Frequently asked questions

Still have a question? Email support@expirepilot.com.

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.

Start free trial →Download the template

No credit card required. Free plan available.

Privacy Preference Center