Free subscription tracker spreadsheet
A ready-made template to list every subscription, see what each one costs per month and per year, and spot renewals and trials before they charge. Works in Excel, Google Sheets and Numbers.
What the template looks like
| Service | Amount | Currency | Billing cycle | Next renewal | Status | Per month | Per year |
|---|---|---|---|---|---|---|---|
| Claude Pro | 20.00 | USD | Monthly | 2026-11-09 | Active | 20.00 | 240.00 |
| 1Password | 36.00 | USD | Yearly | 2027-03-01 | Active | 3.00 | 36.00 |
| Spotify | 11.99 | EUR | Monthly | 2026-11-18 | Active | 11.99 | 143.88 |
| Video editing app | 9.99 | USD | Monthly | 2026-11-02 | Trial | 9.99 | 119.88 |
Example rows. Replace them with your own.
What's inside
- Drop-downs for category, currency, billing cycle and status.
- Per-month and per-year columns for weekly, monthly, quarterly and yearly plans.
- Days to renewal, counted from today.
- Rows turn amber a week before they renew, and trials 3 days before they end.
- A summary sheet with totals for each currency and how many renewals are due in 30 days.
- A short how-to sheet, and example rows to replace with your own.
Opening it
- Excel
- Open the .xlsx file. The formulas and highlights work as they are.
- Google Sheets
- Upload the .xlsx to Google Drive and open it with Google Sheets, or use File, then Import in a blank sheet.
- Numbers
- Open the .xlsx file. Some highlighting may look different from Excel.
- Anything else
- The CSV has the same columns without formulas, for any app that imports CSV.
When a spreadsheet stops being enough
A sheet needs you to move every renewal date forward by hand and to convert currencies yourself. Subskim rolls dates forward, puts every charge on a calendar and totals all currencies in one, for free. Subskim vs a spreadsheet compares the two.
See every renewal before it charges.
Put your subscriptions on one calendar, flag trials before they convert and total everything in one currency. Free, no bank login.
Get started free