How to Track & Cut Subscriptions in Google Sheets (2026 Guide)

The average American household pays for 12 subscriptions — and actively uses fewer than half of them. That's hundreds of dollars quietly draining from your account every month. Here's how to build a subscription tracker in Google Sheets that shows exactly what you're paying, what's worth keeping, and what to cancel today.

Why You Have More Subscriptions Than You Think

Subscription spending sneaks up on you. It starts with Netflix. Then Spotify. Then that productivity app you used once, the gym you stopped going to, the meal kit you paused but never cancelled, the cloud storage for photos you haven't looked at since 2021.

The problem isn't any single subscription — it's the accumulation. Each one feels small. $9.99 here, $14.99 there. But added up, they're often $80–$150 a month. That's a car payment. That's a vacation fund. That's $1,000+ per year on stuff you may not even be using.

The worst part: most people underestimate their subscription spending by 40–60%. When asked to guess, they lowball it — because subscriptions are designed to be invisible. Auto-renew. Buried in bank statements. Easy to forget.

What You Need to Track

A good subscription tracker captures more than just the name and price. To make real decisions about what to keep, you need:

• Service name — what it is
• Category — Entertainment, Productivity, Health, etc.
• Monthly cost — normalize everything to monthly even if billed annually
• Billing cycle — monthly, annual, quarterly
• Next renewal date — so you can cancel before you're charged again
• Usage rating — do you actually use this? (1–5 scale works great)
• Action — Keep, Review, Cancel, Pause
• Notes — login email, account notes, cancellation difficulty

With these columns, your tracker becomes a decision tool — not just a list.

Building Your Subscription Tracker in Google Sheets

Step 1: Set Up Your Columns

Create a new Google Sheet and name the first tab "All Subscriptions." Add these headers in row 1:

Format column C as currency. Format column E as a date. For columns G (Action), use Data Validation with a dropdown: Keep, Review, Cancel, Pause — so you can filter later.

Step 2: Normalize Annual Subscriptions to Monthly

Annual subscriptions trick you into forgetting the real cost. Amazon Prime is "just $139 a year" — but that's $11.58/month. Use a formula to normalize everything:

Create a "Monthly Equivalent" column using this formula. Now you can see your true monthly subscription spend — often shocking when you see it all at once.

Step 3: The Usage Scoring System

The most powerful part of this tracker is the usage column. Rate each subscription on a 1–5 scale:

Filter the sheet by Usage = 1 or 2 and you'll instantly see your cancel list. This alone can find $50–$100 in monthly savings in most households.

Step 4: Build a Summary Dashboard

Create a second tab called "Dashboard." This is where you track the big picture:

Use SUMIF to break down spending by category — you'll often find that "Entertainment" or "Productivity" is far larger than expected when you see it isolated.

Step 5: Renewal Date Alerts

The most expensive subscriptions are the ones that auto-renew before you realize it. Add a column that calculates days until next renewal:

Then use conditional formatting to highlight cells where the result is less than 14 (two weeks away). Set those cells to turn red or orange. You'll never get auto-renewed by surprise again.

Category Breakdown: Where the Money Actually Goes

Once you've catalogued everything, most households find their spending concentrated in a few buckets:

Seeing it by category often reveals duplication — three streaming services you're paying for but only actively using one, or two cloud storage plans that overlap.

The Subscription Audit Process

Do a full subscription audit once per year (January is a great time — tax documents will show every charge from the prior year). Here's the process:

1. Pull Your Bank + Credit Card Statements

Go back 3 months. Search for charges that repeat. Anything recurring is a subscription. Don't forget annual charges — filter the last 13 months to catch the yearly ones.

2. Add Everything to Your Tracker

Don't judge yet. Just add it all. The goal is a complete picture before you make any decisions.

3. Score Each Subscription

Go through each one and assign a usage score (1–5). Be honest. The gym you pay $40/month but haven't visited since October? That's a 1.

4. Set an Action for Everything

For every subscription, pick: Keep, Review, Cancel, or Pause. Don't leave anything blank. Indecision is how subscriptions survive.

5. Execute the Cancellations

Sort by Action = "Cancel" and work through the list. Set aside 20 minutes — most cancellations take 2–5 minutes each. Some will try to retain you with discounts; take them if the service is worth half the price.

6. Schedule the Reviews

For anything in the "Review" bucket, set a reminder to revisit in 30 days. Ask yourself: did I miss it? If no — cancel it.

How Much Can You Save?

Real examples from people who've done this exercise:

• A family of four cut entertainment from $75/month to $30/month by picking one streaming service per quarter instead of running four simultaneously
• A freelancer eliminated 6 productivity apps they'd signed up for and forgotten — saving $43/month
• A homeowner cancelled duplicate cloud storage plans (iCloud + Google One + Dropbox) — saving $22/month
• A couple found three gym/fitness subscriptions: one app, one studio membership, one Peloton subscription — and kept only the one they actually used

The common theme: most people save $50–$150/month on first audit. That's $600–$1,800 per year. Not life-changing, but it's real money — and it's money you were paying for nothing.

Maintaining the Tracker Going Forward

A subscription audit is most powerful when it's a living document. After the initial setup:

• Add new subscriptions immediately when you sign up — before you forget them
• Review the tracker monthly — takes 5 minutes once it's set up
• Check renewal dates weekly — the conditional formatting will flag anything coming up
• Do a full re-score quarterly — your usage patterns change, and so does what's worth keeping

The goal is to make every subscription a conscious choice — something you're actively keeping because it earns its place, not just something that keeps renewing because you haven't gotten around to cancelling it.

Free vs. Paid Tracker

You can absolutely build a basic subscription tracker yourself using the instructions above. But if you want something pre-built with formulas, dashboard, usage scoring, category breakdowns, and renewal alerts already set up — our Subscription Expense Manager template saves you about 2 hours of setup.

It includes:

• Pre-built subscription log with all columns ready
• Dashboard with total monthly spend, potential savings, and category breakdown
• Renewal date alert system (conditional formatting pre-applied)
• Cancel list view — filtered automatically by Action = Cancel
• Monthly vs. annual normalization formula built in