Free Subscription Tracker Spreadsheet Template for Google Sheets & Excel
Sixteen rows, a service on each, with a category and a billing column recording how the charge actually arrives. The Free Subscription Tracker spreadsheet template derives the annual figure at twelve times the monthly one and closes the sheet with monthly and annual totals. One working sheet, a How to Use tab beside it. Google Sheets or Excel. No macros, no VBA.
The FinancialAha Free Subscription Tracker Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Subscription Tracker Excel template and a Free Subscription Tracker Google Sheets template from the same download. A row per service, each with a category, how it is billed and what it costs a month, with the yearly figure worked out and both totalled. This Free Subscription Tracker spreadsheet template exists to answer one question: what all of it comes to. No macros, no VBA.
Inside the workbook
What's inside the FinancialAha Free Subscription Tracker spreadsheet template
The FinancialAha Free Subscription Tracker Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Subscription Tracker spreadsheet holds.
01of 01
Subscriptions
A row per service. Each carries what it is, the category it falls under, how it is billed and what it costs a month. The annual figure works itself out at twelve times the monthly one, and the foot of the sheet totals both.
The annual column is the point of the exercise. Streaming at fifteen a month and a cloud plan at three read as small numbers individually and as something else entirely once they are annualised and stacked - which is the arithmetic almost nobody does in their head, and the reason a list like this tends to be surprising the first time it is filled in.
Services billed once a year go in at their monthly equivalent, with the Billing column recording how the charge actually arrives. That keeps every row on the same footing, so the monthly total means what it says rather than mixing two different periods.
Subscriptions
Included guide
How to Use
A step-by-step guide on its own tab, covering how to replace the sample values and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.
Works in both Google Sheets and Excel
Free Subscription Tracker Spreadsheet template for Google Sheets
Upload the Free Subscription Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Subscription Tracker Google Sheets template needs no conversion step and nothing gets rewritten on the way in - the totals recalculate exactly as they do in Excel. It opens on a phone, which is where most of these charges get noticed.
Free Subscription Tracker Google Sheets template setup
A shared copy of the Free Subscription Tracker Google Sheets template is how a household finds the duplicates - two music services, two cloud plans, a streaming service nobody has opened since spring. Those rarely surface until the list is in one place.
Running the Free Subscription Tracker Google Sheet
The Free Subscription Tracker Google Sheet is not a daily file. It gets built once from a bank statement and revisited when something changes - a price rise, or a trial converting.
Free Subscription Tracker Spreadsheet template for Excel
The Free Subscription Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Free Subscription Tracker Excel template directly, with no import step and no compatibility prompt, and both totals update the moment a cost changes. There are no macros and no VBA in the file, so it opens without a security warning.
Free Subscription Tracker Excel template setup
The same Free Subscription Tracker Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Subscription Tracker spreadsheet download to choose between.
Free Subscription Tracker spreadsheet Excel notes
The Free Subscription Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt.
Opening the Free Subscription Tracker spreadsheet Excel file
Nothing in the Free Subscription Tracker Excel template is version-specific, so this Free Subscription Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
The FinancialAha Free Subscription Tracker Spreadsheet Template lists your services and tells you what they come to. It has no way to mark one as cancelled - the totals cover every row, so a service you drop has to be deleted. The Essentials Subscription Tracker Spreadsheet Template for Google Sheets and Excel adds exactly that: a status on every row, totals that count only the active ones, a renewal date, notes, and a dashboard reporting the largest subscription, the average per service and what the cancellations have saved. The Ultimate Subscription Tracker Spreadsheet Template adds a category sheet with each one's share of the total, a log of price rises with the increase worked out, a twelve-month grid by category, and a sheet for what has been cancelled.
Notes on working in the Free Subscription Tracker spreadsheet template
Both columns are entered, and the two headline figures total them separately.
Services billed once a year go in at their monthly equivalent, so every row sits on the same footing.
The Billing column records how a charge arrives, and nothing groups or filters on it.
Category is free text, and nothing totals by it.
The dropdown beside the title relabels the cost columns. It changes the label and nothing else.
How the Subscription Tracker template works
The Free Subscription Tracker Spreadsheet Template puts every recurring service on one sheet with a category, how each is billed and what it costs a month, and works out the annual figure at twelve times the monthly one. The annual column is the point of the exercise: streaming at fifteen a month and a cloud plan at three read as small numbers individually and as something else entirely once they are annualised and stacked. Services billed once a year go in at their monthly equivalent, with the Billing column recording how the charge actually arrives, so every row sits on the same footing. There is no status column on this build - the total covers every row, so a service you cancel has to be deleted rather than marked.
When this template helps
01
You want one list of everything charging you every month.
02
You suspect there are duplicates and forgotten trials in there.
03
You want the annual figure rather than a set of small monthly ones.
04
You are about to go through a bank statement and want somewhere to put it.
Tips to get the most out of it
The annual column is the one that changes minds - individually these are small numbers, annualised and stacked they are not.
The Billing column tells you whether a cancellation takes effect next month or next year.
A service kept at zero rather than deleted leaves the row as a reminder it was considered.
Common mistakes to avoid
Entering an annual charge as though it were monthly, which multiplies it by twelve in the total.
Building the list from memory. The forgotten ones are exactly the ones a statement finds.
Deleting a cancelled row and losing the record of what it was costing.
Counting a free trial at zero when it converts next month at full price.
How to Use the Free Subscription Tracker Spreadsheet Template
1
List the services
One row each, built from a statement rather than memory.
2
Set the categories
Streaming, cloud, software, or headings of your own.
3
Enter the monthly cost
Annually-billed services at their monthly equivalent.
4
Read the annual total
The figure the monthly ones add up to across a year.
Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.
Excel
Sheets
Privacy by default
Your numbers stay in your own file
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away
Frequently Asked Questions
What is the difference between the free, Essentials, and Ultimate Free Subscription Tracker spreadsheet template?
Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build, with more worked out for you rather than typed. Ultimate ($29) goes further again, splitting the template across more working sheets and adding deeper reporting on top. What each tier holds differs by template - the comparison table on every template page lists it exactly.
Which Free Subscription Tracker spreadsheet template should I download?
Essentials is the fuller build of this template for ongoing use, and the comparison table on this page lists exactly what it adds. The Free version is a good fit for one-off planning or trying out the layout.
Can I upgrade the Free Subscription Tracker spreadsheet template later?
Yes. Essentials is a one-time $19 purchase with no subscription. What it adds depends on the template: some builds gain capacity and a dashboard, others richer detail in the same layout. The comparison table on this page lists the differences exactly.
Is the FinancialAha Free Subscription Tracker Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Subscription Tracker Google Sheets template, and it opens on a phone, which is where most of these charges get noticed.
Is the FinancialAha Free Subscription Tracker Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Subscription Tracker Excel template opens directly in Excel with no import step. There are no macros and no VBA.
Will the FinancialAha Free Subscription Tracker spreadsheet Excel file open in older versions of Excel?
Yes. The Free Subscription Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
How do I enter a service billed once a year in the Free Subscription Tracker spreadsheet?
At its monthly equivalent, with the Billing column recording that the charge arrives annually. That keeps every row on the same footing, so the monthly total means what it says.
Can I mark a subscription as cancelled in the Free Subscription Tracker spreadsheet?
Not on this build. The total covers every row, so a service you drop has to be deleted. A status column, totals that count active services only, and a record of what the cancellations saved are on the Essentials build.
Why does the annual figure in the Free Subscription Tracker spreadsheet work itself out?
Because two columns typed separately can disagree, and a total that reports both as though one followed from the other would be wrong without saying so. The annual figure is twelve times the monthly one.
Is the Free Subscription Tracker spreadsheet template safe to download?
Yes. No macros, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.
How do I open the Free Subscription Tracker spreadsheet template in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
Can I use the Free Subscription Tracker spreadsheet template for commercial work?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
