The Complete Guide

How to Track SaaS
Subscription Renewals

To track SaaS subscription renewals properly, you need two dates for every contract: the expiry date and the notice deadline. The notice deadline — expiry minus the required notice period — is the date that actually matters for action. Most teams only track expiry dates, and that's how they end up with a $12,000 charge for software nobody uses anymore. Here's how to build a system that prevents it.

Try Renewl Free →
Section 01

Why SaaS renewals keep surprising finance teams

According to Zylo's 2024 SaaS Management Index, the average company manages 275 SaaS applications — and even at smaller scale, most ops teams are surprised by how many tools they're actually paying for. Marketing has their stack. Engineering has theirs. Finance is running three overlapping tools for the same job. Nobody has a complete list, and nobody's job description officially includes "track all software renewal dates."

The fundamental problem is that renewals happen on vendor timelines, not yours. Your fiscal year runs January to December. Your Salesforce contract renews in April. Your AWS agreement renews in August. Your Figma subscription, your Notion workspace, your security tooling — they all have different anniversary dates, and none of them cared about your planning calendar when they were signed.

Auto-renewal clauses make this worse in a specific way. They are, by design, engineered to be overlooked. The clause is buried in section 14.3 of the agreement. The notice period requirement — the date by which you need to cancel to avoid renewal — is stated in days, not as an actual calendar date. Nobody does that math. The contract rolls over. You find out when the invoice arrives.

The cost comes in two forms. First, there's wasted spend: paying for software your team stopped using six months ago because nobody caught the auto-renewal in time. According to Zylo's 2024 SaaS Management Index, companies use only 49% of their provisioned SaaS licenses on average. Second, there are missed negotiation windows: most SaaS vendors expect to negotiate at renewal, but only if you initiate it in advance. Miss the window, and you're renewing at last year's rate with no leverage.

Without a dedicated tracker, teams default to what they know. BetterCloud's 2025 State of SaaS found that 40% of organizations still manage renewals with spreadsheets and calendar reminders. The spreadsheet gets built once, during an audit, and then sits untouched for eight months. By the time someone checks it, half the dates are wrong and two contracts have already auto-renewed. The problem isn't spreadsheet software — it's that spreadsheets require discipline to maintain, and discipline is hard to sustain for something that only matters four times a year.

Section 02

The 5 fields that matter for every SaaS contract

Most teams track too many fields and miss the ones that actually matter. A contract tracker with 30 columns is harder to maintain, not easier to use. These are the five fields that drive decisions.

1.
Expiry date

The date the contract ends. This is the obvious one — but it's not actually the most important date. Most people treat this as the deadline. It isn't.

2.
Notice period

The number of days advance notice you need to give the vendor to cancel or renegotiate. Commonly 30, 60, or 90 days. This is buried in the contract and almost always overlooked.

3.
Notice deadline

Expiry date minus notice period. This is the real deadline — the date by which you need to decide whether to renew, cancel, or negotiate. Everything else is too late.

4.
Auto-renew flag

Yes or no. If the contract auto-renews, missing the notice deadline locks you in for another year. If it doesn't, you have more flexibility — but you still need to track it.

5.
Contract value

Annual cost. This determines how much effort is worth putting in. A $200/month tool can just auto-renew. A $48,000/year enterprise contract needs active management 60 days out.

Example: Salesforce Enterprise
FieldValueWhy it matters
Expiry date31 Dec 2026When the contract ends
Notice period60 daysMust notify by this window
Notice deadline1 Nov 2026The real action date
Auto-renewYesMissing deadline = locked in
Contract value$48,000/yrEffort proportional to this
Section 03

Three ways to track SaaS renewals

There's no single right answer here. The right approach depends on how many contracts you manage, how much time you have to maintain the system, and how badly a missed renewal would hurt. Here are the three realistic options.

Option 1: Google Sheets or Excel (free, manual)

A well-designed spreadsheet is genuinely useful for teams with under 20 contracts. Build it with these columns:

  • Vendor
  • Contract Name
  • Category
  • Annual Value
  • Effective Date
  • Expiry Date
  • Notice Period (days)
  • Notice Deadline (formula: expiry date minus notice period)
  • Auto-Renew (Y/N)
  • Owner
  • Status

The two formulas that make it work: =A2-B2 for notice deadline (expiry cell minus notice period cell), and =DATEDIF(TODAY(),A2,"D") for days remaining. Use conditional formatting to colour rows red under 30 days, amber for 30–60 days.

✓ Pros
Free
You own and control it
Flexible — add any column you want
✗ Cons
Requires manual updates
Easy to forget
No automatic alerts — you have to check it

Option 2: Your existing tools (calendar, Notion, etc.)

If the spreadsheet feels like overhead, you can work renewal tracking into tools you're already using. In Google Calendar or Outlook, create a dedicated "Contract Renewals" calendar and add events at 60, 30, and 7 days before each notice deadline. In Notion, a simple database with date properties and a filtered view sorted by "Notice Deadline" works well. In Linear or Jira, create recurring tasks for high-value contracts.

The limitation is fragmentation. Renewal dates end up scattered across tools, there's no single view of everything due in the next 90 days, and alerts require manual setup for every contract.

✓ Pros
Already in your workflow
No new tools to adopt
Works for small contract volumes
✗ Cons
Scattered across tools — no central view
Alerts require manual setup per contract
Hard to maintain as contract count grows

Option 3: Dedicated renewal tracking software

Once you're managing 15 or more contracts, the manual overhead of spreadsheets and calendar reminders starts to exceed the cost of a dedicated tool. Purpose-built renewal trackers handle the parts that manual systems get wrong: they extract dates from PDFs automatically, calculate notice deadlines, and send alerts without anyone having to remember to check a spreadsheet.

The calculation is straightforward. If you have 20 contracts averaging $15,000/year each, missing a single renewal negotiation window costs more than a year of software subscription. The tool pays for itself the first time it surfaces a renewal you would have missed. (Renewl estimates, based on analysis of contracts uploaded by small ops teams, 10–100 employees.) Renewl handles this — upload a PDF, AI extracts the key dates, and you get email alerts at 60, 30, and 7 days before each notice deadline. First 20 contracts free.

✓ Pros
Automated date extraction from PDFs
Alerts fire automatically — nothing to maintain
Central view of all contracts sorted by urgency
✗ Cons
Monthly cost (justified if you have 15+ contracts)
Takes 30 minutes to set up initially
Section 04

The mistake that costs companies thousands

The notice period trap catches teams who understand renewal dates but haven't internalized notice deadlines. BetterCloud's 2025 State of SaaS found that 34% of companies rely only on automated alerts that trigger at the last minute, leaving little time to evaluate or negotiate. Here's how it happens.

Your Salesforce contract expires December 31st. The contract includes a 60-day notice period for cancellation. You have it in the calendar. You feel organized. The problem: you've calendared the wrong date.

The notice deadline — the date by which you actually need to send a cancellation notice — is November 1st. By December 1st, it's already too late. The contract is rolling. The invoice is coming.

Notice period trap — Salesforce example
Contract start
Jan 1
⚠ Notice deadline
Nov 1 — act by here
Most people check here
Dec 1 — already too late
Contract expiry
Dec 31
Negotiation window open
Getting tight
Locked in

The fix is simple: always track notice deadlines, not expiry dates. Set your primary alert to fire at the notice deadline, not at the contract expiry. Expiry dates tell you when something ends. Notice deadlines tell you when you need to act.

Section 05

How to set up your renewal calendar

Here's the full setup process, from zero to a working system. Budget two to three hours for the initial build.

01
List all your SaaS tools

Start with three sources: your bank statements or corporate card transactions (search for recurring charges), your SSO dashboard if you use one (Okta, Google Workspace, or Azure AD will show you every connected app), and your email inbox (search for 'invoice', 'receipt', 'renewal notice', and 'subscription'). Cross-reference all three. You will find tools in each list that the others missed.

02
Find the renewal dates

For each tool on your list: check the original confirmation or welcome email, log into the billing settings inside the product, or search your inbox for the vendor name alongside terms like 'invoice', 'agreement', or 'subscription'. If you can't find the date, call the vendor — they will tell you.

03
Calculate notice deadlines

For every contract with an auto-renew clause, calculate the notice deadline: expiry date minus notice period in days. This is the date that actually matters. If the contract doesn't auto-renew, note it — but keep tracking the expiry anyway.

04
Set up tiered alerts

Configure alerts at 60, 30, and 7 days before each notice deadline. 60 days: start the evaluation process. 30 days: make the go/no-go decision. 7 days: final check before the window closes. If you're using a spreadsheet, these are calendar reminders. If you're using a tool like Renewl, they're automatic.

05
Assign an owner for each contract

Every contract needs one person responsible for acting when an alert fires. Not a team. One person. If there's no owner, the alert goes to everyone and gets ignored by everyone.

06
Review monthly

Block 20 minutes on the first Monday of every month to check the tracker. Review anything expiring in the next 90 days, confirm the owner for each, and make sure no new contracts were signed without being added to the tracker.

Section 06

Download the free SaaS renewal tracker

The guide above covers the principles. The template puts them into practice. It's a pre-built spreadsheet compatible with Excel and Google Sheets, with all the columns, formulas, and conditional formatting already configured. Add your contracts, and it immediately shows you what's expiring, what's approaching its notice deadline, and what needs attention.

Free Download
SaaS Renewal Tracker Template

Excel & Google Sheets · Auto-calculating deadlines · Colour-coded urgency
No email required

Section FAQ

Frequently asked questions

What is a SaaS renewal tracker?

A SaaS renewal tracker is a system — spreadsheet or software — that records the key dates for each software subscription: expiry date, notice deadline, auto-renew status, and contract value. The goal is to make sure you never miss a window to cancel or renegotiate.

What is the difference between a renewal date and a notice deadline?

A renewal date is when the contract expires or auto-renews. A notice deadline is earlier — it's the last date by which you must notify the vendor to cancel or change terms. Most contracts require 30, 60, or 90 days of advance notice. Missing the notice deadline means you're locked in for another full term even if you catch the renewal date.

How do I stop SaaS contracts from auto-renewing?

Find the auto-renewal clause in the contract and note the required notice period. Calculate the notice deadline: expiry date minus notice period in days. Set a reminder at least 7 days before that deadline. If you want to cancel, send written notice before the deadline — usually a simple email to your account manager or billing contact.

Can I track SaaS renewals in a spreadsheet?

Yes, and it works well for teams with under 20 contracts. You need columns for expiry date, notice period, and a calculated notice deadline. The main limitation is that spreadsheets don't send alerts — you have to check them manually. The free template above has all the formulas pre-built.

How many SaaS contracts do I need before dedicated software makes sense?

Most teams find the manual overhead of spreadsheets and calendar reminders becomes unmanageable around 15–20 contracts. At that point, the time spent maintaining the system — plus the risk of missing a renewal — usually exceeds the cost of a dedicated tool.

Skip the spreadsheet

Stop tracking renewals manually

Renewl uploads your contract PDFs, extracts dates automatically using AI, and sends email alerts before every renewal. First 20 contracts free.

Try Renewl Free →

Renewl does this automatically — and keeps you ahead of every renewal deadline. Free for your first 20 contracts. See pricing →