Subscription Tracker Spreadsheet: Free Template Layout

Quick answer
A subscription tracker spreadsheet needs eight columns, two formulas, and one total. Copy the layout below into a blank Google Sheet or Excel file and you have a working template in about ten minutes. There is no file to download, so nothing to sign up for. You fill the rows from your statements, your email, and your phone's subscription list.
The template layout
Put these headers in row 1.
| Column | Header | What goes in it |
|---|---|---|
| A | Service | Name of the subscription |
| B | Category | Streaming, software, fitness, news, other |
| C | Price | What each charge costs, in dollars |
| D | Billing cycle | Monthly or Yearly |
| E | Monthly cost | Formula, see below |
| F | Next charge | Date of the next billing |
| G | Paid with | Card name, PayPal, Apple, or Google Play |
| H | Cancel link | The page where you cancel |
Add an optional ninth column, Trial ends, for free trials. A trial is a subscription that has not started billing yet, and it is the easiest kind to lose track of.
Formula 1: Monthly cost
Annual plans need converting so you can compare them with monthly ones. In cell E2, type:
=IF(D2="Yearly", C2/12, C2)
Google's function list describes IF as returning one value if a logical expression is TRUE and another if it is FALSE. Here, a yearly plan is divided by twelve and a monthly plan stays as is. Copy the formula down the column.
Google's formula help page explains that you start a formula by typing an equal sign in a cell and that Sheets shows a help box with each function's syntax and an example.
Formula 2: Monthly total
Under the last row of your data, in the Monthly cost column, type:
=SUM(E2:E50)
Google lists SUM as returning the sum of a series of numbers or cells. Using a range that runs past your last row means new rows count automatically. Multiply the result by twelve in a nearby cell to see what the list costs per year. That number is often the one that gets people to cancel something.
Formula 3: Days until the next charge
Add a column I, Days left, and type in I2:
=F2-TODAY()
TODAY returns the current date as a date value, according to Google's function list, and subtracting dates gives a count of days. If the cell shows a date instead of a number, change its format to number. A reading of 3 or less means the charge is close.
Optional: Repeat the date forward
If your next charge date is in the past, the subscription has renewed. Google's EDATE function returns a date a specified number of months before or after another date. In F2 you can replace a typed date with a formula built on EDATE, but updating the date by hand once a month is simpler and keeps the sheet readable.
A sample of what filled rows look like
These rows use made-up numbers for illustration.
| Service | Category | Price | Billing cycle | Monthly cost |
|---|---|---|---|---|
| Video streaming | Streaming | 15.00 | Monthly | 15.00 |
| Photo storage | Software | 36.00 | Yearly | 3.00 |
| Gym | Fitness | 25.00 | Monthly | 25.00 |
The monthly total here is 43.00 and the yearly total is 516.00. Notice that the yearly photo storage plan costs only 3.00 per month on this sheet, which is why converting matters. Without that column, a 36.00 charge looks like a big one-time event and a 15.00 charge looks small.
How to fill it the first time
Filling the sheet is the slow part. Use these four sources.
- Your phone's subscription list. On iPhone, open Settings, tap your name, and tap Subscriptions, per Apple. On Android, open your subscriptions page in Google Play.
- Three months of statements from every card and bank account. Look for the same merchant at the same amount more than once.
- Your email. Search for receipt, renewal, free trial, and will renew.
- Your password manager or browser saved logins. Old sign-ups show up there.
For annual plans, go back twelve months on your main card, since a yearly charge appears once.
Keeping it useful
- Add a row the day you sign up for anything, including free trials.
- Delete the row the day you cancel, and note the date in a spare column if you want a record.
- Sort by next charge date so the nearest renewals sit on top.
- Review the sheet on the same day each month.
A spreadsheet works while you maintain it. Its weak point is that nothing tells you when a charge is coming unless you build the reminder, so pair it with a calendar event for large renewals.
A monthly five-minute check
Open the sheet on a fixed day. Scan the Days left column for anything at 7 or less. For each of those, decide to keep, change, or cancel, and act that day using the link in the Cancel link column. Then update the Next charge date for anything that renewed. This habit is what makes the sheet work. The formulas are only arithmetic.
Where SubSweeper fits
If the first fill is the part you dread, SubSweeper scans your email receipts (read-only) and shows active subscriptions, free trials, and upcoming renewals in one dashboard, with reminders before charges and a monthly total. You can use its list to fill the spreadsheet in minutes, or keep the dashboard instead.