Guide

Subscription Tracker Spreadsheet: Free Template Layout

Updated 2026-10-24 · by the SubSweeper team
SubSweeper list of active subscriptions with a monthly total

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.

  1. 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.
  2. Three months of statements from every card and bank account. Look for the same merchant at the same amount more than once.
  3. Your email. Search for receipt, renewal, free trial, and will renew.
  4. 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

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.

Official sources