← All articles

Subscription Tracker Template (Excel & Sheets)

Guides · The Subgrove Team · · Updated · 5 min read

This free subscription tracker template is a ready-made spreadsheet for Excel and Google Sheets, with a plain CSV version for Notion: download it, replace the examples with your own subscriptions, and it works out each one's monthly cost and flags anything renewing in the next seven days. To track monthly subscriptions with or without it, keep one list with each subscription's cost, billing cycle, monthly-equivalent cost and next renewal date, and look at it before each renewal. A spreadsheet does that for free in six columns; an app does the same and also reminds you before each charge. Below are the download, how to build the same sheet yourself in about ten minutes, the formulas for weekly, yearly and odd billing cycles, and the two things a spreadsheet can't do.

Two ways to track monthly subscriptions

  • A spreadsheet is free, private and completely flexible. You update it by hand, and it only helps when you open it.
  • An app with reminders does the date math and tells you before each renewal. You still enter the subscriptions, but you don't have to remember to check.

Either way, start by finding everything you pay for. Our guide to finding all your subscriptions covers statements, email and app stores. If you just want a one-off total without building anything, the free subscription cost calculator adds up monthly and yearly cost across mixed billing cycles.

The template

Download it free, no signup:

  • Excel / Google Sheets template (.xlsx): formulas already filled in for 100 rows, a Cycle drop-down (monthly, yearly, quarterly, weekly, custom), a "Days until renewal" column that turns rows yellow within seven days, and a Totals tab that adds up monthly and yearly cost per currency. Open it in Excel, or in Google Sheets choose File → Import and upload it.
  • Notion / plain CSV (.csv): the same columns without formulas, because Notion doesn't run spreadsheet formulas. In Notion, go to Settings → Import and choose CSV to turn it into a database.

The example rows use US list prices; delete them once your own subscriptions are in. If you'd rather build it yourself, copy this structure into row 1 of a fresh sheet:

Name Cost Cycle Monthly Cost Next Renewal Category
Netflix 19.99 monthly 19.99 2026-11-03 Streaming
iCloud+ 50 GB 0.99 monthly 0.99 2026-11-12 Storage
Amazon Prime 139.00 yearly 11.58 2027-02-18 Shopping
Contact lenses 24.00 every 28 days 26.07 2026-11-09 Health

The example prices are current US list prices: Netflix Standard and iCloud+ 50 GB from our price history, and Amazon Prime from Amazon's Prime help page. Replace them with what your statement actually shows.

Six columns, one row per subscription. Here's what each does and how to fill it.

Name, Cost, Cycle

Cost is what you're actually charged per billing period — the number on your statement, not the advertised price. Cycle is the billing frequency: monthly, yearly, weekly, or a custom interval like "every 28 days" (common for contact lenses, supplements, and some meal plans). Keep cycle values consistent, because the monthly-cost formula depends on them.

Monthly Cost — the formula that matters most

This column is the whole point of the sheet: it converts every cycle to a true monthly figure so the totals are honest. In D2, use:

=IF(C2="monthly", B2,
 IF(C2="yearly", B2/12,
 IF(C2="weekly", B2*52/12,
 B2*365/12/28)))

Adjust that final 28 per row if you have other custom intervals (or add a "days" column and divide by it). The conversion factors are worth understanding:

  • Yearly: divide by 12. A $139/year plan is $11.58/month.
  • Weekly: multiply by 52, divide by 12 — that's ×4.33, not ×4. A $5.99/week app is $25.96/month, not $23.96. The missing "extra" weeks are why weekly pricing looks cheaper than it is.
  • Every N days: cost × 365 ÷ 12 ÷ N. A $24 charge every 28 days is $26.07/month.

Then put a total somewhere visible: =SUM(D2:D50). If you pay in more than one currency, keep a separate total per currency rather than adding them together. Brace yourself: in a 2022 C+R Research survey, US consumers guessed they spent $86 a month on subscriptions, then itemized $219. This cell is where you find out how far off your own guess was.

Next Renewal

Store real dates (2026-11-03, not "the 3rd") so you can sort by column E and see what's charging soonest. To flag renewals in the next 7 days, add conditional formatting with a custom formula:

=AND(E2-TODAY()>=0, E2-TODAY()<=7)

The maintenance catch: after each renewal, you must update the date. The sheet won't roll it forward. For monthly subs, =EDATE(E2,1) computes the next date, but someone still has to paste it in every cycle.

Category

Streaming, Software, Fitness, Storage, News — whatever fits your life. Its value shows up when you total by category (=SUMIF(F:F,"Streaming",D:D)) and discover, say, that streaming alone is $67/month. Category subtotals are where cancellation decisions get easy.

What the spreadsheet does well

A sheet like this delivers three things: a true monthly total, honest cycle conversion, and category subtotals. That's a real upgrade from guessing. Once the list is built, the subscription audit checklist helps you decide which rows to cancel.

The honest limits of a spreadsheet

Two problems don't have formula solutions:

1. It can't remind you of anything. The renewal column is only useful if you open the sheet before the charge — and nobody opens a spreadsheet daily. The expensive failure mode is always the same: the annual renewal you built the sheet to catch arrives on a Tuesday you didn't check it. A tracker that sends push notifications flips this: instead of you checking the data, the data interrupts you, with lead time you choose.

2. All date math is manual. Every renewal that passes leaves a stale date until you update it by hand. Miss a few updates and the "Next Renewal" column quietly becomes fiction, sorted plausibly enough that you trust it anyway. A stale tracker is arguably worse than none, because it feels like control.

Spreadsheet, app, or both?

If you enjoy spreadsheets and will keep one up to date, the template above works. If you'd rather skip the maintenance, Subgrove covers the same columns (weekly, monthly, yearly and custom cycles, monthly cost, next renewal) and rolls renewal dates forward on its own. It adds what the sheet can't: a push and email reminder before each renewal, set per subscription from the day of the charge to two weeks ahead, and a calendar of what's charging when. It installs to the home screen on iPhone, Android and desktop, and the free plan tracks up to 5 subscriptions. Pro adds CSV export if you want your data back in a sheet. Keep whichever one you'll still be using in six months.

Free checklist

The Subscription Audit Checklist

Find every forgotten charge and cancel it before the next renewal. Unlocks instantly.

Get the checklist →

Stop paying for forgotten subscriptions

Track everything in one dashboard and get notified before every renewal. Free for up to 5 subscriptions.

Try Subgrove free