How to Build a Google Sheets Subscription Tracker to Stop Wasting Money

The average person pays for somewhere between 10 and 20 subscriptions at any given time. A streaming service they have not opened since last year. A productivity app they switched away from six months ago but forgot to cancel. A software trial that auto-converted to a paid plan. Research consistently shows that people underestimate their monthly subscription spend by more than 100% — they think they pay half of what they actually do.

That money adds up fast. A well-structured Google Sheets subscription tracker will surface the waste and give you a system for staying on top of renewals before they quietly hit your account. Here is how to build one from scratch.

---

Tab 1: Subscriptions

The core tab is a master list of everything you pay for. Set up these nine columns:

| Column | Header | Notes | |---|---|---| | A | Service Name | Netflix, Figma, Notion, Spotify, Adobe, etc. | | B | Category | Software / Entertainment / Productivity / Finance / Health | | C | Monthly Cost | Actual monthly charge (convert annual plans to monthly equivalent) | | D | Annual Cost | Formula: =C2*12 | | E | Billing Cycle | Monthly / Annual / Weekly | | F | Renewal Date | Next billing date | | G | Payment Method | Which card or account it charges | | H | Status | Active / Cancelled / Paused | | I | Notes | Free trial end date, discount expiry, login email, etc. |

For annual subscriptions, enter the true monthly equivalent in column C — a $120/year plan is $10/month. This keeps your monthly total accurate even when the actual charge hits once a year. The formula in column D (=C2*12) then calculates the annual cost automatically for each row.

Status is the most important column. Nearly every useful formula filters by it. Keep it consistent: Active, Cancelled, or Paused — no variations.

---

Key Formulas

Three formulas do the heavy lifting across your entire tracker.

Total monthly spend:

=SUMIF(H:H,"Active",C:C)

Adds up column C (monthly cost) only where column H (Status) equals "Active." Cancelled and paused subscriptions are excluded. This is your real burn rate.

Annual burn:

=SUMIF(H:H,"Active",D:D)

Same logic on the Annual Cost column. Shows your full yearly commitment at a glance — the number that usually surprises people most.

Subscriptions renewing this month:

=COUNTIFS(F:F,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1),F:F,"<="&EOMONTH(TODAY(),0),H:H,"Active")

Counts active subscriptions where the renewal date falls within the current calendar month. Put this on your Dashboard tab so you always know how many charges are coming before they land.

---

Tab 2: Dashboard

Create a second tab called Dashboard with a summary section at the top. Reference the Subscriptions tab using full column paths:

• Total monthly spend: =SUMIF(Subscriptions!H:H,"Active",Subscriptions!C:C)
• Total annual burn: =SUMIF(Subscriptions!H:H,"Active",Subscriptions!D:D)
• Active subscription count: =COUNTIF(Subscriptions!H:H,"Active")

Below that, build a category breakdown table. In column A list each category (Software, Entertainment, Productivity, Finance, Health). In column B, calculate monthly spend per category:

=SUMIF(Subscriptions!B:B,"Software",Subscriptions!C:C)

Repeat for each category label. This breakdown usually reveals where the waste is hiding — most people are surprised by how much productivity software they pay for that they rarely open.

Add a Renewing This Month list using a FILTER formula:

=FILTER(Subscriptions!A:A,(Subscriptions!H:H="Active")*(Subscriptions!F:F>=DATE(YEAR(TODAY()),MONTH(TODAY()),1))*(Subscriptions!F:F<=EOMONTH(TODAY(),0)))

This pulls service names for active subscriptions with a renewal date this month. Add an adjacent column with the same FILTER applied to column F to show the renewal date next to each name.

---

Prefer a fully built system? The Personal Finance Tracker (Google Sheets) ($19) → includes a complete income and expense tracking system that pairs directly with this subscription tracker — one connected spreadsheet for your full financial picture.

---

Tab 3: Cancellation Log

Every time you cancel a subscription, log it here instead of deleting the row from the Subscriptions tab. Four columns:

| Column | Header | |---|---| | A | Cancelled Date | | B | Service | | C | Monthly Saving (cost at time of cancellation) | | D | Running Total Saved |

For the Running Total Saved, use a cumulative sum formula in column D:

=SUM($C$2:C2)

Drag this formula down as you add rows. Each entry shows the compounding total you have saved since you started tracking cancellations. Seeing $400 saved over 12 months makes the monthly audit feel worthwhile — it turns a chore into a win.

---

Workflow Tips

Review monthly, not annually. Put a 10-minute recurring calendar event on the first of each month: "Review subscriptions." Open the Subscriptions tab, filter by Status = Active, and scan for anything you have not used this month. Inertia is the subscription industry's business model. A monthly check-in breaks it before charges compound.

Set calendar reminders 7 days before renewal dates. Annual subscriptions are the ones that sneak up on you. For any subscription billed annually and costing over $50, add a calendar reminder 7 days before the renewal date. That gives you enough time to cancel before the charge processes — most services require 24–48 hours notice at minimum.

Use conditional formatting to flag upcoming renewals. Select column F (Renewal Date) on the Subscriptions tab → Format → Conditional formatting. Add a rule: if the date is on or after TODAY() and on or before TODAY()+14, apply a red background fill. Renewals within the next 14 days turn red automatically. You see them the moment you open the spreadsheet — no scanning required.

Duplicate the tab annually for historical records. At the start of each year, right-click the Subscriptions tab → Duplicate → rename it "Subscriptions 2025" (or the year just ending). This preserves a historical record of what you were paying without losing your running tracker. Over time you build a complete picture of how your subscription spending has changed year over year.

A subscription tracker is not a one-time project. The value compounds the longer you use it: you build a history of what you have cancelled, a clear view of what you are actually spending, and a habit of reviewing before charges hit instead of after. Set it up once, review it monthly, and it will save you more than it costs to maintain.