A SaaS subscription audit spreadsheet helps a small team answer an expensive question: which tools are we still paying for, who owns them, and when can we make a change? The problem is rarely one dramatic purchase. It is a dozen modest renewals spread across different cards, inboxes, and team members. A useful audit collects those commitments in one place, makes renewals visible, and gives every tool an explicit decision. You do not need specialist software to begin. A carefully designed Google Sheet or Excel workbook is enough for a first pass.
This guide walks through a practical 30-minute setup, shows which columns to include, provides formulas you can adapt, and explains how to make cancellation decisions without losing access to important work. It is meant for freelancers, agencies, and small operations that already use several online services.
Table of Contents
What a subscription audit should tell you
A complete list of tools is helpful, but a list alone does not change spending. At the end of the review, every subscription should have a named owner, a documented business purpose, an estimated annual cost, a renewal date, and a next action. These fields let you distinguish a necessary tool from a forgotten trial and a redundant service from a genuine backup.
The word “audit” can sound formal. For a tiny team it simply means checking invoices against actual use and recording evidence before acting. It is different from a general budget: a budget groups spending into categories, while a subscription register tracks an individual contract or account that somebody can renew, downgrade, consolidate, or cancel.
The 12 spreadsheet columns to create
Create one row per paid account or contract, not merely one row per software brand. Two departments may use the same app under separate billing accounts, and combining them too early can hide duplication. Use these columns in the order shown so the example formulas work without modification.
| Column | Field | What to record |
|---|---|---|
| A | Tool / plan | Product name and current paid tier |
| B | Business purpose | What work depends on it |
| C | Account owner | Person who can manage billing |
| D | Seats | Number of paid users |
| E | Billing frequency | Monthly or Annual |
| F | Invoice total | Amount charged per billing cycle |
| G | Next renewal | Actual renewal date |
| H | Payment reference | Card label or last four digits only |
| I | Review flag | Formula for approaching renewal |
| J | Annualized cost | Comparable yearly estimate |
| K | Decision | Keep, Downgrade, Merge, Cancel, Investigate |
| L | Evidence / next step | Usage source, contact, and action date |
Keep currency consistent within each cost calculation. If some services bill in different currencies, add a separate currency column and report totals by currency until you have a documented exchange-rate method. Otherwise the sum may look precise while being meaningless. The invoice total in column F is the amount for the whole account, so do not multiply it by the seat count again.
Step 1: Find the subscriptions before changing anything
Begin with the last three to six months of card statements, business bank entries, and the billing inbox. Search for invoice, receipt, renewal, membership, plan, and the names of services your team recognizes. Ask team leads which paid tools they use weekly. Record the vendor, billing account, amount, billing cycle, and next renewal, even when the value is small.
Check yearly invoices separately: an annual charge may fall outside a three-month statement window. Review company app marketplaces, domain registrars, cloud dashboards, and individual employee expense reimbursements too. If a transaction is ambiguous, mark it Investigate. Do not guess which department owns it or cancel something simply because nobody recognizes the merchant descriptor.
Step 2: Normalize monthly and annual prices
Once rows are filled, convert each recurring amount to an annualized estimate in column J. In J2, use the following formula when E contains exactly Monthly or Annual and F contains the full invoice amount. Copy it down the column.
=IF(E2="Monthly",F2*12,IF(E2="Annual",F2,""))This is a planning estimate, not a prediction of what you will definitely pay. It excludes price changes, tax differences, temporary discounts, usage-based charges, and exchange-rate effects. If the charge varies, record a recent average and label it as an estimate in column L. For an annual charge, do not multiply by twelve. For monthly billing, use the full invoice rather than the public list price.
Example: a hypothetical design tool charges $24 per month for the account, so the comparable annualized amount is $288. A different service paid at $180 once per year remains $180. The combined planning figure is $468 per year in the same currency. This comparison makes tradeoffs clearer, but the actual renewal date still determines when a decision must be made.
Step 3: Flag renewals 90 days ahead
A simple renewal alert is more useful than an annual review performed the day after a contract renews. Format column G as real dates, then enter this formula in I2 and copy it down. It marks renewals occurring between today and 90 days from now.
=IF(AND(ISNUMBER(G2),G2>=TODAY(),G2<=TODAY()+90),"Review soon","")Set a calendar reminder for contracts with mandatory notice periods, not just the renewal date. Some accounts require an action weeks in advance, while others can be changed any day. Put the actual notice deadline in column L or add a dedicated column M if you manage many annual contracts. The spreadsheet flag is a prompt to investigate; it does not cancel or alter a subscription.
Step 4: Check usage, overlap, and ownership
For every renewal, ask the account owner three questions: What recurring task does this tool support? Who used it during the past month or quarter? What breaks if the service disappears? A vendor dashboard, billing portal, or documented workflow is better evidence than a vague impression that the product is useful.
Look for multiple paid note apps, two meeting tools with similar features, unused premium seats, old add-ons, and accounts owned by people who left the team. These are candidates for a decision, not automatic cancellations. Two similar tools may serve different clients or have different data-retention needs. Note the distinction in column L before calling them duplicates.
You can use a simple evidence rule: Keep if the owner names a current workflow and the plan fits; Downgrade if the service is still essential but the tier or seat count is excessive; Merge if another approved tool covers the same requirement; Cancel only after exporting necessary work and confirming the cancellation terms; Investigate when ownership or usage remains unclear.
Step 5: Protect your data during cancellations
The most expensive mistake in a cost review may be losing a client archive, invoices, or access to a shared integration. Before any cancellation, identify the files, automations, API connections, and administrator permissions that depend on the account. Export data in a usable format, test whether it opens elsewhere, and verify that somebody else can manage the replacement. An inactive account might still host a live form, business email, or website integration.
Avoid storing passwords, full card numbers, recovery codes, or private customer data in the audit sheet. A billing reference such as “Company card ending 1234” is enough to reconcile statements. Share editing access with only the people who manage expenses, and consider a read-only view for team leads. The sheet is an ownership register, not a place for credentials.
A realistic 30-minute first audit
For the first ten minutes, collect the charges you can identify quickly and enter the vendor, amount, frequency, and renewal. Use the next ten minutes to assign owners, enter the formulas, and mark missing dates. Spend the final ten minutes selecting a short list of renewals that deserve review this week. This is a first pass, not a promise to reconcile every account in half an hour.
Schedule a follow-up with the relevant owners. A monthly 15-minute review usually catches newly added tools, while a fuller quarterly review is a good time to evaluate usage and overlap. Update rows when a plan changes instead of deleting the history. A small change log with decision date, approver, and new cost helps you explain savings later without inflating them.
How to record savings honestly
Do not report a cancelled $25 monthly subscription as $300 saved if the business immediately bought a $20 replacement. Compare the previous annualized cost with the new recurring cost, and record one-off migration expenses separately. If the cancellation takes effect three months from now, show the future expected difference rather than claiming cash already retained.
For a small agency, a narrow result may still be worthwhile: two unused seats removed, an upcoming renewal discussed in time, and one risky account reassigned to a current administrator. A transparent decision record makes the next audit faster and is more valuable than a dramatic savings figure without evidence.
Connect this register to your wider workflow
If you track contractor spending, pair this sheet with the freelance business expenses checklist rather than mixing every receipt into the subscriptions register. For an organized access review, use the digital declutter checklist. If you need to compare whether an accounting app serves your business, start with the financial software comparison for freelancers and check current plan details directly with vendors before paying.
Frequently asked questions
Should I list free software in the spreadsheet?
You can keep free tools on a separate tab if they hold important data or permissions, but the paid subscription tab should focus on charges and renewal decisions. That keeps cost totals useful.
How do I handle usage-based cloud services?
Create a separate Usage-based billing category, record actual monthly invoices, and describe the estimate used for comparisons. Do not treat a variable bill as a guaranteed fixed subscription.
What if a subscription has no known owner?
Mark it Investigate, check billing and administrator records, then assign an accountable person before renewal. Avoid cancelling until you understand the dependency and data-retention implications.
Can this template work in Google Sheets and Excel?
Yes. The simple IF, AND, ISNUMBER, and TODAY formulas are supported by both. Check your locale’s argument separator and date formatting if the pasted formula gives an error.
How often should a small team update its register?
Add new purchases as they occur, scan upcoming renewals monthly, and review usage and overlapping tools quarterly. Contracts with long notice periods deserve an earlier alert.
Start with the next renewal, not the biggest guess
The best subscription audit is the one your team will keep current. Open a new sheet, enter ten real charges, identify their owners, and flag the next renewal that needs a decision. Once those basics work, improve the register with filters, charts, or approval notes. A modest spreadsheet maintained each month will usually tell you more than a beautiful dashboard that nobody updates.