The subscription tracker spreadsheet, done properly
Download the free CSV below, then in Google Sheets choose File → Import to load it. Eight columns cover every subscription you own: service, amount, currency, cycle, next renewal, category, payment method and notes. Only the renewal date needs a formula.
Download the template and import it into Google Sheets
This subscription tracker spreadsheet is one plain CSV file: eight columns, three filled-in example rows so you can see the shape, and blank rows underneath. It opens in Google Sheets, Excel, Numbers, LibreOffice or anything else that reads a comma-separated file. No sign-up, no email wall.
- Download subby-subscription-tracker-template.csv.
- In Google Sheets, open a spreadsheet and choose File → Import.
- Select the downloaded file, then pick an import location. Create new spreadsheet gives you a clean copy. Replace spreadsheet overwrites whatever is open.
- Leave the separator on Detect automatically. If every row lands in one column, run it again and choose Comma.
- In Excel, Numbers or LibreOffice, open the file. There is no import step.
Then delete the three example rows and start with the subscription you are most annoyed about. When memory runs out, find subscriptions on your bank statement and work down from there.
What each of the eight columns is for
Subby keeps the same eight fields, which is not a coincidence. Between them they answer “what is charging me, when, and can I stop it”. Drop one and the sheet stops answering part of the question.
- Service. The name on your statement, not the name in your head. “Amazon Digital” is what you’ll be searching for later, even if you think of it as a video subscription.
- Amount. The number that leaves your account, tax included, on one line per plan. Split a family plan into rows only if separate charges appear.
- Currency. The ISO code (USD, EUR, GBP, RON). Skip this and your total is fiction the first time something bills in a second currency.
- Billing cycle. Monthly, yearly, weekly, quarterly, or something odd like every 45 days. People forget the ones that are not monthly.
- Next renewal. The most valuable cell in the sheet, because it answers “can I still cancel before it charges?”
- Category. Entertainment, work, health, home. Categories turn a list into a decision. Four streaming rows next to each other make their own argument.
- Payment method. Card ending, PayPal, direct debit, or which app store bills it. When you go to cancel, this tells you where to look. App-store subscriptions cancel in the store, not on the provider’s website.
- Notes. The contract end date, the price you were paying before the increase, who else in the house uses it, whether it is a trial. Write down why you signed up, because by renewal day that is the part you will have forgotten.
Making the renewal date calculate itself
Typing dates by hand is how a sheet rots. Two Google Sheets formulas handle almost every billing cycle.
- Monthly and yearly cycles. Google Sheets’ EDATE function “returns a date a specified number of months before or after another date”, with the syntax EDATE(start_date, months). A monthly subscription is EDATE of the last payment plus 1, a yearly one plus 12, a quarterly one plus 3.
- Weekly and day-based cycles. Plain addition. The last payment plus 7 for weekly, plus 14 for biweekly, plus 28 for a four-weekly cycle, plus 45 for the odd one.
The formula matters less than what it counts from. Always calculate the next date from the previous due date, never from today. Anchor on today and every skipped week nudges the series forward until the sheet is wrong about every date in it. Subby uses the same rule internally. A sheet that counts from today is the one nobody trusts by March.
Date math at the end of the month. A subscription that first charged on the 31st cannot renew on the 31st of every month. Whatever your spreadsheet does with January 31 plus one month, check that first February renewal by hand before you rely on it. Keep a “charged on the 31st” note in the Notes column and you will know why the date looks odd six months from now.
The habits that keep it current
- Update the day you’re charged. Move the Next renewal cell forward the moment your bank notification lands. Thirty seconds now beats an hour of archaeology in three months.
- Convert before you total. Put every row into one currency in a spare column and total that, or type the same rows into the subscription cost calculator. A mixed-currency sum is the most common way a subscription sheet ends up understating what you pay.
Where a subscription tracker spreadsheet stops working
Most subscription spreadsheets are abandoned within two months. This is why.
- It cannot remind you. A cell holding tomorrow’s renewal date is worth nothing if nobody opens the file. Every trial you have ever been charged for was, technically, written down somewhere.
- It only knows what you last told it. A price rise, a plan change or a card swap reaches the sheet when you type it in, and not before.
- It is not in your pocket. You want it when you are standing in a queue, wondering whether the thing you signed up for last month has already charged you.
None of that makes a spreadsheet useless. It is the right tool when you want to share a household budget with someone who lives in Sheets, or to keep a year of history you can point at when a price goes up. Use it for the 30-minute subscription audit. Don’t ask it to be the alarm clock. You find that out the third time you get charged for something you had already written down.
Forgot to update the sheet again?
Subby works out the next renewal date from the last one and reminds you before it arrives. There is no cell to update.
Free · No account · No bank login