Quick answer
Download the free subscription tracker template for Excel or Google Sheets. You fill in nine columns — service name, price, currency, billing cycle, next payment date, payment method, cancel link, status, and category — and the sheet auto-calculates each subscription's monthly cost and the days until its next renewal. A Summary tab totals your spend by currency and by category, conditional formatting flags renewals due within 7 days (red) and trials (yellow), and the date column is a built-in date picker. No email required. Open the link, save a copy, start tracking.
Download the template
Download for Excel / Google Sheets (.xlsx)
To use in Google Sheets: open Google Sheets → File → Import → Upload → select the downloaded file → choose "Replace spreadsheet". Or right-click the download and select "Open with Google Sheets" if you have it set as default.
To use in Excel: open the file directly. All formulas, dropdowns, and conditional formatting work in Excel 2016 and later.
What's in the template
The workbook has three sheets. Tracker is where you log subscriptions. Summary is an auto-updating dashboard — active and trial counts, renewals due this week, and your spend broken down by currency and by category. How to use explains every column if you get stuck.
You fill in nine columns; the sheet calculates two more for you.
A — Service name. Be specific: "Netflix (4K)" is more useful than "Netflix" when you have multiple plans in a household.
B — Price. The amount charged per billing cycle. Enter the actual charge, not what you think you pay.
C — Currency. Select from the dropdown: USD, EUR, GBP, UAH, PLN, CAD, AUD. The Summary tab totals each currency separately — it does not auto-convert between them. If you pay in multiple currencies, the section below explains why that is the first wall most spreadsheet trackers hit.
D — Billing cycle. Monthly, Annual, Weekly, or Quarterly. This drives the Monthly cost column, which normalizes every plan to a comparable monthly figure — so an annual subscription and a weekly one line up against each other honestly.
E — Next payment date. The exact date your card gets charged. The cell is a real date picker — double-click for a calendar in Google Sheets, and Excel rejects anything that isn't a date. This is the most important column: when a date falls within 7 days of today, the entire row turns red as a prompt to decide, keep or cancel.
F — Payment method. Which card, wallet, or account pays this subscription. Useful when a card expires — you immediately know which subscriptions need updating.
G — Cancel link. The direct URL to the cancellation or account settings page. The ten minutes you spend filling this column saves twenty minutes of hunting every time you want to cancel something.
H — Status. Active, Trial, Paused, or Cancelled. This column drives the automatic formatting: Trial rows turn yellow, Cancelled and Paused rows grey out, and every total counts only Active subscriptions.
I — Category. Group each subscription — Streaming, Software, Music, Cloud, and so on. The Summary tab uses it to show where your money actually goes.
J — Monthly cost (automatic). Calculated for you from price and billing cycle. Leave it alone; it fills in the moment you complete a row.
K — Days left (automatic). Days until the next payment date, counted from today — an at-a-glance read of what is coming up.
How to set it up in 10 minutes
-
Download and open the file. Google Sheets or Excel — either works. The first three rows are filled-in examples that show the colour-coding in action — overwrite or delete them when you start.
-
Start with subscriptions you currently pay for. Get the list accurate first. Add every recurring charge you can think of: streaming, software, cloud storage, gym, news, mobile data. Check your bank statement and email receipts for anything you missed.
-
Fill the five non-optional columns first. Service name (A), Price (B), Currency (C), Billing cycle (D), Next payment date (E). You can add payment method and cancel link later — but get these five right.
-
Set the Status. Most subscriptions will be Active. Mark anything you signed up for but haven't paid yet as Trial. Mark anything you are no longer using as Cancelled.
-
Set a monthly calendar reminder. Open Google Calendar, create a repeating event on the 1st of each month called "Review subscriptions." When it fires, open the sheet, look for red rows — renewals in the next 7 days — and decide whether to keep or cancel each one.
Everything else — the conditional formatting, the totals, the monthly equivalent math — runs automatically.
When the spreadsheet stops working
A spreadsheet is the right tool for 5 to 10 stable subscriptions in one currency. It breaks in four predictable ways:
More than 10 subscriptions. Once your list grows past 10 rows, maintaining the spreadsheet starts taking more time than the subscriptions are worth. You have to remember to update rows when prices change, when trials convert, when you pause something. The tracker becomes a second job.
Multiple currencies. The Summary tab totals each currency on its own line, which is honest but not the whole picture: it still can't combine them into your true monthly burden in one home currency without manual conversion. The currency column is a label, not a converter, and exchange rates change — a spreadsheet cannot update them automatically.
Mobile access. Google Sheets works on mobile in theory. In practice, editing formulas, dropdowns, and conditional formatting on a phone is frustrating enough that most people simply stop updating the sheet.
Price changes. Services raise prices without prominent notice. If you don't update the row when the email arrives, the totals are wrong. The longer the list, the faster it drifts from reality.
If you've hit any of these walls, the tracker is no longer saving you money — it's costing you time. Subnesio handles all of these: multi-currency with live rates, mobile-first design, automatic reminders before each renewal, and a live total that stays accurate as prices change.
The spreadsheet template is the right starting point. Subnesio is where you go when the spreadsheet is no longer enough.
