Subscription Tracker Spreadsheet for Google Sheets and Excel
SUBSCRIPTION TRACKER SPREADSHEET FOR GOOGLE SHEETS AND EXCEL
A subscription tracker spreadsheet for anyone who wants to know what every subscription is actually worth. It logs each time you use a subscription, so you see the real cost per use, not just the price on the receipt.
Works for trials, monthly plans and yearly plans, and for a household sharing subscriptions.
📊 WHAT IT DOES
✓ Subscriptions: one line per subscription; the monthly cost, next renewal date and days until it fill in by themselves.
✓ Charges: log what actually hit your card, and the file compares it with the listed price to catch price rises.
✓ Uses: log each time you use a subscription; after 90 days, every one has a cost per use.
✓ Worth it: ranks every subscription by its cost per use, most expensive first.
✓ Trials: shows each free trial's end date, cancel-by date, and what it costs if you forget.
✓ Price hikes: compares each subscription's first charge with its latest, and totals what the rises cost a year.
✓ Rotation: compares keeping every streaming service on all year against switching between them month to month.
✓ Cards: shows which card each subscription is on and which renewals could fail when a card expires.
📂 WHAT'S INSIDE: 28 TABS AND 62 CHARTS
✓ Start with these: Home, Start here, Setup, Subscriptions, Charges, Uses
✓ Coming up: This month, Renewals, Trials, Calendar
✓ Decide what to keep: Worth it, Cancel list, Price hikes, Yearly vs monthly
✓ Categories, cards, people: Overlap, Rotation, Cards, Household
✓ The year: Months, Year, Categories, Creep
✓ Routine and help: Audit, Check-in, Notes, Catch-up, Read me, Free gift
📝 HOW IT WORKS
- Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
- On Start here, fill in the shaded cells: your name, your take-home pay, the people in your household and how many uses count as rarely used.
- List each subscription once on Subscriptions, then log charges from your statement on Charges and a use each time you open one on Uses.
- Everything else fills in by itself. Home shows what's due soon, which trials are ending, and what subscriptions cost per month.
📥 WHAT YOU GET
✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel on Windows or Mac
✓ A filled example to look around, and a blank copy for your own data
✓ A PDF with the links and the first steps
✓ A video guide for this planner (the link is in the PDF)
💻 GOOD TO KNOW
✓ Works with a free Google account. No add-ons, no subscription, no bank connection.
✓ Type only in the shaded cells. Formulas are protected, so you can't break them by accident.
✓ Best on a computer. The Google Sheets app works for quick entries on your phone.
✓ Amounts show in dollars. The formulas work the same in any currency.
✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.
✓ English only. Not made for Apple Numbers.
✓ Free updates for life.
This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.
This planner is a tool for your own records, not financial advice.