Subscription tracker spreadsheet template
A spreadsheet is a good free way to track subscriptions, and you can build one in five minutes. Here is the layout to use, the formulas that matter, and the point where it starts to cost you more than it saves.
Updated 31 October 2026
At a glance
| Feature | Subscriptrack | Spreadsheet |
|---|---|---|
| Cost | Subscriptrack: 14-day free trial, then from £4.99 a month, or £39 a year | Spreadsheet: Free |
| Finds forgotten subscriptions | Subscriptrack: Yes, from receipts and statements | Spreadsheet: No |
| Keeps dates up to date | Subscriptrack: Yes | Spreadsheet: By hand |
| Renewal and trial alerts | Subscriptrack: Yes | Spreadsheet: No |
| Notices price rises | Subscriptrack: Yes | Spreadsheet: No |
| Full control of the layout | Subscriptrack: No, but you can export to CSV | Spreadsheet: Yes |
The columns to use
- A: Service, such as Netflix.
- B: Plan, such as Standard.
- C: Amount, the price you pay each time.
- D: Period, either monthly or yearly.
- E: Next charge, as a date.
- F: Monthly cost, using the formula below.
- G: Yearly cost, using the formula below.
- H: Paid through, such as card, PayPal, Apple or Google.
- I: Decision: keep, review or cancel.
The formulas
These work in Google Sheets and Excel. Put them in row 2 and copy them down.
Monthly cost in F2: =IF(D2="yearly",C2/12,C2)Yearly cost in G2: =F2*12Total per month: =SUM(F2:F100)Total per year: =SUM(G2:G100)Charges in the next 7 days: =COUNTIFS(E2:E100,">="&TODAY(),E2:E100,"<="&TODAY()+7)Where a spreadsheet falls short
- It only holds what you remember to enter, so forgotten subscriptions stay forgotten.
- Next charge dates do not move on by themselves, and they go stale within a month.
- It cannot warn you. Nothing tells you a renewal or trial end is coming.
- Price rises stay hidden until you compare a receipt with your sheet.
- Other currencies have to be converted by hand.
When to move on
A spreadsheet works if you have about ten subscriptions or fewer, they rarely change, and you enjoy keeping it up to date. It stops working when you keep finding charges that are not on it, or when you have missed a renewal.
Subscriptrack does the same job from your receipts: one list, monthly and yearly totals in your currency, and alerts before renewals. It costs from £4.99 a month, or £39 a year, and you can export the whole list to CSV at any time, so you can go back to a spreadsheet whenever you like.
See everything you pay for
Subscriptrack reads your receipts and builds one list of your subscriptions, with renewal reminders and no bank login.
Questions
- Is there a free subscription tracker?
- A spreadsheet is the simplest free option. Subscriptrack is paid after its free trial, because reading receipts with AI has a real running cost.
- Can I import my spreadsheet into Subscriptrack?
- Not as a list. You can add subscriptions by hand, or forward receipts so they are read for you. You can export your list to CSV at any time.
- Google Sheets or Excel?
- Either works. Google Sheets is easier if you share subscriptions with someone, because you both see the same sheet.