Back to blog
Excel and Google Sheets

Contract tracking spreadsheet: the columns, the renewal math and a monthly check

A contract tracking spreadsheet for Excel or Google Sheets: columns to copy, the notice-deadline formula, days left, color rules and a 15-minute monthly check.

Turn your spreadsheet into an app

Upload an Excel or CSV file. Free, no account needed.

Upload a spreadsheet
On this page

A contract tracking spreadsheet is one row per contract with the dates that matter: when it ends, how many days of notice you owe, and whether it renews on its own. Subtract the notice days from the end date and you get the notice deadline, the date you act by. A formula counts the days left.

This guide is for anyone who keeps leases, vendor agreements, service contracts and subscriptions in a folder and a memory. You get the columns to copy (and a block to paste), the formulas, a filled-in example, color rules, a 15-minute check for once a month, and a sign for when a spreadsheet stops being enough. If your contracts are already in a spreadsheet, the spreadsheet to app upload turns them into an app, with no account needed to try it. First, the layout.

How we researched this: in November 2026 we checked Microsoft’s and Google’s help pages for each function and each vendor’s own pricing page. We worked out every number in the example. This isn’t legal advice: your contract’s wording decides your notice rules.

What columns go in a contract tracking spreadsheet?

Ten columns you type, then five the sheet works out. The first ten are facts from the contract. If a column isn’t something you would look up, leave it out.

ColumnWhat to enter
A IDA number you assign, such as CT-2101
B VendorWho the contract is with
C CoversWhat it’s for, and which site: lease, cleaning, software
D OwnerThe one person who decides on renewal
E Annual costWhat you pay in a year
F End dateThe date the current term ends
G Notice daysDays before the end you must give notice
H RenewalAuto if it renews unless you cancel, Manual if not
I TermLength of a renewal, in months
J Signed copyA link to the PDF, plus the notice wording

Two columns do most of the work. Notice days is the number people forget to write down: the contract says “60 days before the end of the term,” and nobody puts it anywhere. Renewal matters because an Auto contract costs you another term if you say nothing, while a Manual one simply ends.

Make Owner and Renewal drop-downs (select the column, then Data > Data validation in both Excel and Google Sheets), so “Dana” is never typed as “Dana M.” and counted as two people.

Here is the example used in the rest of this guide: eight contracts for an invented 40-person business. Swap in your own.

IDVendor and what it coversOwnerCost a year
CT-2101Harbor Point Properties, office leaseDana$54,000
CT-2102Lakeshore Office Systems, copier leaseMarcus$3,600
CT-2103Cascade Telecom, phone and internetPriya$4,800
CT-2104BrightPath Janitorial, cleaningDana$9,600
CT-2105LedgerLine, accounting softwarePriya$1,188
CT-2106Summit Mutual, business insuranceDana$7,200
CT-2107Tri-County Equipment Service, service agreementMarcus$2,400
CT-2108NorthPeak Hosting, website hostingPriya$600

And the dates, which are what the formulas read:

IDEndsNotice daysRenewal
CT-2101Mar 31, 202790Auto, 12 months
CT-2102Dec 31, 202660Auto, 12 months
CT-2103Jan 31, 202730Auto, 12 months
CT-2104Feb 28, 202730Auto, 12 months
CT-2105Jun 30, 202730Auto, 12 months
CT-2106Sep 1, 202760Manual
CT-2107Dec 15, 202630Auto, 12 months
CT-2108Nov 30, 202714Manual
Paste it in one go

Click A1 on a blank sheet and paste this: all 15 headings and one example contract with its formulas. Fill K to O down for each new contract, and format F, K and M as dates.

ID	Vendor	Covers	Owner	Annual cost	End date	Notice days	Renewal	Term	Signed copy	Notice by	Days left	Renews to	Locked in	Status
CT-2102	Lakeshore Office Systems	Copier lease	Marcus	3600	12/31/2026	60	Auto	12		=F2-G2	=K2-TODAY()	=IF(H2="Auto",EDATE(F2,I2),"")	=IF(H2="Auto",E2*I2/12,0)	=IF(F2<TODAY(),"Ended",IF(L2<0,"Past notice",IF(L2<=30,"Act now",IF(L2<=90,"Coming up","OK"))))

Licenses, certificates and permits have the same shape of problem, with no notice period. For those, see our guide to employee certification tracking.

What about contracts for a site, a season or no end date?

  • One vendor, several buildings. Give each building its own row and ID, with the building in Covers (“Elevator service, 12 Oak St.”). Each can have its own end date, owner and cost, and a filter on Covers shows one site.
  • Seasonal terms. Snow removal that runs Nov 1 to Apr 15: type Apr 15 as End date, Manual as Renewal, and the days the vendor needs to hear from you before next season as Notice days. With 30 days, that row’s Notice by is Mar 16, 2027.
  • Month to month. Type the next date it could end as End date, Auto as Renewal, 1 as Term, and the notice days from the contract. Move End date forward when you review it.
  • A window, not a number. “Not more than 120 nor less than 90 days” means notice goes in between. Type 90, the last day, and put the 120 in Signed copy beside the link.

How do you work out the notice deadline and days left?

The deadline that matters is not the end date. It is the end date minus the notice days. Put these in row 2, in columns K to O, and fill them down for each contract. It’s the same with 70 contracts as with 8: copy the formulas to the last row.

K2  =F2-G2
L2  =K2-TODAY()
M2  =IF(H2="Auto",EDATE(F2,I2),"")
N2  =IF(H2="Auto",E2*I2/12,0)
O2  =IF(F2<TODAY(),"Ended",IF(L2<0,"Past notice",IF(L2<=30,"Act now",IF(L2<=90,"Coming up","OK"))))
  • K, Notice by. The last day to give notice, if the contract counts calendar days back from the end date. Format it as a date. Excel and Google Sheets store dates as numbers, so subtracting days works (TODAY is the same idea).
  • L, Days left. Notice by minus today. It goes down by one each day the file is opened, and below zero once the date has passed.
  • M, Renews to. If the contract renews on its own, EDATE adds the renewal term in months to the end date. This is the date you are committed to if you do nothing.
  • N, Locked in. The cost of another term: annual cost times months divided by 12. A Manual contract is 0 because it ends instead.
  • O, Status. One word per contract: Past notice, Act now (30 days or fewer), Coming up (31 to 90), OK, or Ended once the end date has passed.

If your contract counts business days, use =WORKDAY(F2,-G2) in K2 instead (WORKDAY skips weekends and any holidays you list). Check three things in each clause: whether the notice days are calendar or business days, which date they count from, and how notice must be sent (some require a letter or certified mail). Many people set their reminder a week before Notice by, so a letter that takes days to arrive still counts.

For the example, with the date set to November 13, 2026, the sheet works out:

IDNotice byDays leftLocked inStatus
CT-2102Nov 1, 2026-12$3,600Past notice
CT-2107Nov 15, 20262$2,400Act now
CT-2101Dec 31, 202648$54,000Coming up
CT-2103Jan 1, 202749$4,800Coming up
CT-2104Jan 29, 202777$9,600Coming up
CT-2105May 31, 2027199$1,188OK
CT-2106Jul 3, 2027232$0OK
CT-2108Nov 16, 2027368$0OK

The copier lease, CT-2102, doesn’t end until December 31. But its notice date was 12 days ago, so it renews for another year, $3,600, unless the vendor lets you out. That is the case a plain end-date column misses, and it’s the reason to track the notice deadline instead. The office lease, CT-2101, is the one to watch: $54,000 locks in if nobody acts by December 31.

Want a total? Leave column P empty, put a label in each Q cell and these in column R:

R2  =COUNTIF(O2:O200,"Past notice")
R3  =COUNTIF(O2:O200,"Act now")
R4  =COUNTIF(O2:O200,"Coming up")
R5  =SUMIFS(E2:E200,L2:L200,">=0",L2:L200,"<=90")

In the example that’s 1, 1, 3 and $70,800: the annual cost of the four contracts, the lease, phone, cleaning and equipment service, that need a decision in the next 90 days.

How do you color the contracts that need action?

Color rules read the Status column, so the sheet looks the same however you sort it. Select A2:O200, then:

  1. Excel: Home > Conditional Formatting > New Rule > “Use a formula to determine which cells to format.” Google Sheets: Format > Conditional formatting > “Custom formula is” (Google’s steps).
  2. Add one rule per status. Past notice: =$O2="Past notice", red fill. Act now: =$O2="Act now", amber fill. Coming up: =$O2="Coming up", pale yellow fill.
  3. Leave OK uncolored. A sheet where everything has a color tells you nothing.
  4. Sort by column K, Notice by, oldest first, so the next deadline is always at the top.

In Excel, sort a range with the Sort button. In Google Sheets, use Data > Sort range. Whichever you use, include every column in the sort, or the dates will no longer match their contracts.

What is a 15-minute monthly check for contracts?

A tracker only works if someone opens it. Pick a day, the first Monday of the month works, and put 15 minutes on one person’s calendar. A spreadsheet won’t email you, so the calendar is the reminder.

Print this page for the person who does it. The checklist below has a box for each step.

When a contract renews, don’t overwrite its history. Change End date to the new term’s end, and keep the old one in the notes column. When you cancel one, move its row to an Ended tab after the term runs out.

Write every signed contract in the sheet the week it’s signed, with its notice period, and give each one an owner, not a team.

When does a contract spreadsheet stop being enough?

A spreadsheet is a good place to start, and it needs nothing but a person with a calendar. These are the signs it has run out.

  • A renewal slipped through. Once is a good reason to look at something sturdier, and twice is a decision.
  • Several people own contracts. They each change the sheet, and one pasted-over formula turns a date into a number nobody trusts. Before you switch, protect K to O (Review > Protect Sheet in Excel, Data > Protect sheets and ranges in Google Sheets) and let one person add rows while the others send them their contracts.
  • People need to see only some contracts. A lease or a salary-linked agreement shouldn’t be open to everyone who opens the file. Hiding a sheet isn’t protection: Google says viewers can still access content in hidden sheets, and people can still print, copy and paste a protected spreadsheet (Google). Our guide to database vs spreadsheet covers more of these limits.
  • You want the signed contract and approvals in the same place as the dates.

You then have two paths: contract management software, or your own sheet as an app.

What does contract management software cost?

Contract software keeps signed contracts in one place and reads their key dates. Here is what each vendor’s own page showed in November 2026.

ProductWhat it costs
SpreadsheetFree, plus your time
ContractSafeFrom $450 a month, billed yearly ($540 monthly)
Concord$499 a month (Essentials), billed yearly
PandaDoc$19 a seat a month (Starter), billed yearly
Zoho ContractsFree plan, then paid per user
IroncladNo price listed. Quote on request

Who each one suits:

  • ContractSafe. A flat price with unlimited users. The price is set by how many contracts you keep, and the page lists only the starting price.
  • Concord. Includes 5 users, then $49 a month for each more. Business is $899 and Enterprise $1,299. Its page names legal, finance, procurement and operations users.
  • PandaDoc. Mainly for documents and e-signature. Business is $49 a seat. Expiration alerts are listed on Starter and up.
  • Zoho Contracts. The page lists a free plan with 10 contracts and 5 outside parties. We found no dollar prices on it.
  • Ironclad. The page says it’s for all contracting teams, not just legal, and prices by the products, set-up help and add-ons you pick.

For 50 contracts and five people who need access, a flat price like ContractSafe’s or Concord’s five-user plan comes to about $450 to $500 a month, and a spreadsheet costs nothing. So the real question is what a missed renewal costs you. In our example, one missed copier notice was $3,600 and the office lease is $54,000.

If you want software, look first at ContractSafe if you want one place for signed contracts and dates and don’t want to count seats, and at PandaDoc if the job is mostly proposals and signatures. Ask Ironclad for a quote only if you want to compare it.

How can your team use a contract tracker as an app?

The sheet works until it’s open to everyone. The spreadsheet to app upload turns your tracker, saved as an Excel or CSV file, into a web app your team opens in a browser, on a phone or a computer.

Upload the workbook. GoodTaco imports each contract as a record in the app’s own built-in database and rebuilds the formulas it can reproduce exactly. Check that Notice by, Days left and Status match your sheet before anyone relies on it. Then ask for Owner and Renewal as pick lists.

Or keep working in the sheet. Connect your Google Sheet, and with the Google Sheets app builder, the app reads and writes the same sheet your team already uses.

Then ask for what the sheet couldn’t do. Make the app private, so only the people you invite can sign in, with Google or an emailed link, before they see any data. Add your team in the app’s Users tab, then ask GoodTaco to show each person only their own contracts, with you seeing all of them. Put this in your first request:

Build a contract tracker from my sheet. A list sorted by Notice by with Past notice, Act now and Coming up colored. A form to add a contract. Each owner sees only their own contracts, and I see all of them. Show the annual cost of contracts with a decision due in 90 days.

You change it by chatting, and every version is saved, with one-click rollback. Keep the monthly check: someone still opens the Past notice list on the first Monday. GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.

Know which contracts need a decision this month, and who owns each one. Start free, no credit card needed.

Frequently asked questions

What is a contract tracking spreadsheet?

A contract tracking spreadsheet is a list with one row per contract: who it's with, what it costs, when it ends, how much notice you must give and whether it renews on its own. Formulas turn those dates into a notice deadline and a count of days left, so you see which contracts need a decision this month.

What columns should a contract tracking spreadsheet have?

Start with ten: contract number, vendor, what it covers, owner, annual cost, end date, notice days, renewal type (auto or manual), renewal term in months and a link to the signed copy. Then add formulas for notice by, days left, the date it renews to, the cost locked in if you miss it, and a status.

How do you calculate a contract notice deadline in Excel?

Subtract the notice days from the end date. With the end date in F2 and the notice days in G2, type =F2-G2 and format the cell as a date. If the contract counts business days, use =WORKDAY(F2,-G2). Check the contract's wording, because some count the notice from the renewal date.

How do you track contract renewal dates in Excel or Google Sheets?

Keep the notice deadline, not just the end date, and subtract today's date from it: =K2-TODAY(). The result is the days left to act. A status formula can then label each contract Past notice, Act now, Coming up or OK, and color rules make those labels easy to spot.

Is there a free contract tracking template for Excel?

Yes. You can build one free from the layout in this guide in Excel or Google Sheets. It has ten typed columns, five formula columns, color rules and a monthly check, and the guide has a block you can paste into row 1. It works while one careful person keeps it, and it stops working well when several people own contracts.

When should you switch from a spreadsheet to contract management software?

Switch when a renewal has been missed, when several people own contracts and edit the same sheet, when you need people to see only their own contracts, or when you want contracts, approvals and signatures in one place. Until then, a well-kept spreadsheet with a monthly check is free and does the job.

How much does contract management software cost?

In November 2026, ContractSafe listed plans starting at $450 a month billed yearly ($540 month to month) with unlimited users, priced by contract volume. Concord listed $499 a month for five users, billed yearly. PandaDoc listed $19 and $49 per seat a month, billed yearly. Ironclad publishes no price and quotes on request.

Customer story Active Trailers turned five spreadsheets into one app for 350+ trailers. “Every time a unit got wrote up, we had to fill out all the spreadsheets, and then we had a checklist for the checklist.” MW Myka Ware Active Trailers Read their story
Free · no account needed

Turn your spreadsheet into an app

Upload an Excel or CSV file and we’ll build an app around your records, with its own database. Free, no account needed.

Upload a spreadsheet

No file handy? Start from a template

Keep exploring

Related guides and templates

View all articles

Guide

How to create an Excel database in 9 steps, and when to stop

Set up an Excel database in 9 steps, from tables and drop-down lists to XLOOKUP and PivotTables, with a layout to copy and the signs it's time to move on.

Guide

How to make an app from a spreadsheet: 8 tools (2026)

Compare 8 tools that make an app from a spreadsheet, from Excel and CSV uploads to live Google Sheets, with current prices, limits and who each suits.

Guide

Convert Excel to a web app in 5 steps, formulas included

Convert Excel to a web app in 5 steps. Upload the workbook free, with no account, and get an app with your formulas rebuilt and checked.

For teams

Custom Business Software for Founders

Custom business software for founders built from the spreadsheet you are already running. CRM, project tracker, ops dashboard. No developer required.