KOLLAZ
Menu

Everyday money

Subscription Tracker Spreadsheet: Cancel the Waste

by Valentin Iosif · Published September 29, 2026 · Updated October 30, 2026

A brown leather wallet with glass tubes rising out of it, draining gold coins away in small recurring charges

The short answer

Subscriptions average $111 a month, and $21 of that pays for services nobody uses: $252 a year burned. Audit every recurring charge, rank it by waste score, and cancel the drainers: in the worked example, five subscriptions cost $1,175.51 a year and canceling the two worst keeps $659.87.

The average American adult now spends $111 a month on subscriptions (more than $1,300 a year), and $21 of that goes to services nobody even uses. That is $252 a year, burned in increments too small to notice.

Updated September 2026. This article is for educational purposes only and is not financial advice.

A subscription audit calculator exists for exactly this problem. One page where every recurring charge gets listed, converted to a yearly cost, and ranked by waste, so the cancel decision takes an evening instead of a vague plan to “look into it someday.”

How does a subscription audit calculator work?

The idea is almost insultingly simple. You enter each subscription: name, cost, billing frequency, the last time you used it, and a 1-to-5 value score. The sheet does the rest.

First, it annualizes everything: $4.99 a month is $59.88 a year; $49.99 a quarter is $199.96. Monthly numbers feel small; yearly numbers tell the truth.

Then it scores each one on three things: how much it costs per year (the biggest factor, because it is real money leaving your account), how much value you actually get, and how long it has sat unused. Rank everything worst-first and you get a hit list instead of guilt, which two to cancel to keep $660 of a $1,100 total, not just the total itself.

What is the real cost of subscription creep?

CNET runs a subscription survey every year, and the 2026 results are rough. The average adult spends $111 a month on subscriptions, up from $90 the year before, a 23 percent jump in twelve months. Streaming is still the biggest slice, but the money now spreads across retail memberships, music, cloud storage, fitness apps, gaming, and AI subscriptions.

Two things make it worse than the headline number. Prices rise after you sign up: Apple Music raised its price in July 2026, following Spotify, Paramount Plus, and Netflix. And free trials convert silently: nearly half of consumers sign up for a trial just to test something, then forget to cancel.

This is why the yearly view matters. Nobody panics over $12.99 a month. Almost everyone reacts to $155.88 a year for a service they opened twice.

What does a worked example show: five subscriptions, $1,175 a year?

Five subscriptions, each scored 0 to 100 on cost, value, and days since last use:

Total damage: $1,175.51 a year. Cancel just the two CANCELs and you keep $659.87. Cancel everything below KEEP and you keep $1,055.63.

The magazine app is the cheapest subscription here, yet it is the second to go, because price alone is a bad guide. What matters is price relative to use.

I built the Subscription Audit Calculator to run this ranking: up to 25 subscriptions, a 0–100 waste score on each, and a ranked scoreboard with both savings totals. Excel, no macros.

How do you audit your subscriptions in 4 steps?

  1. Pull every recurring charge from the last 12 months. Use bank and card statements, not memory, memory misses the annual renewals, and those hurt most.
  2. Convert each to a yearly cost. Monthly times 12, quarterly times 4, weekly times 52. Add them up for the real total.
  3. Score each on cost, value, and last use. Be honest about the value score: a 5 means you would re-subscribe tomorrow at full price. Anything untouched for 90 days gets a hard look no matter how cheap it is.
  4. Cancel from the top of the waste ranking down. Start where each cancellation saves the most money for the least regret. Then set a calendar reminder to re-run the audit every six months, subscriptions creep back.

Why is canceling so hard, by design?

None of this is an accident. The FTC calls these “negative option” programs: your silence counts as consent, and the subscription renews until you affirmatively stop it. In October 2024, the FTC finalized a “click-to-cancel” rule that would have forced companies to make canceling as easy as signing up. In July 2025, a federal appeals court struck it down days before it took effect.

That does not leave consumers empty-handed. Around 20 states now have their own automatic-renewal laws (California’s came first), and the CFPB has said since its 2023 circular that burying cancellation behind unreasonable barriers can violate federal law against unfair and deceptive practices, including the dark patterns that steer you into keeping subscriptions you do not want.

Still, the law moves slowly and your bank account does not. The practical move is the audit: find the waste yourself and cancel it yourself, instead of waiting for a regulation to do it for you.

After you cancel: which 3 things do people forget?

  1. Screenshot the cancellation confirmation. If a charge appears next month, you want proof, not a memory of a chatbot conversation.
  2. Ask about the annual-plan refund. Many services prorate canceled annual plans, but only if you ask.
  3. Watch the next two statements. Zombie charges are real: a canceled subscription can keep billing through a different payment method or an old account. Two clean months means it is actually dead.

One more connection: canceled subscription money is found money. It becomes savings, or it plugs a hole somewhere else. If your hole is a thin cash cushion, figuring out how many months you could survive without income is the natural next calculation. The audit itself also ships inside the Essential Money Toolkit, beside the emergency fund, budget, and debt tools.

About Kollaz, Kollaz makes smart financial tools for modern money. This article’s companion is the Subscription Audit Calculator spreadsheet: rank up to 25 subscriptions by waste score, see exactly what canceling saves you, and get the cancel playbook with retention-offer scripts.

FAQ

How does a subscription audit calculator work? Enter each subscription, name, cost, billing frequency, last time you used it, and a 1-to-5 value score. The sheet annualizes everything ($4.99 a month is $59.88 a year), then scores each on cost, value, and days since last use, producing a Waste Score from 0 to 100 that ranks subscriptions worst-first.

How much do subscriptions really cost per year? CNET's 2026 survey found the average adult spends $111 a month on subscriptions, up 23 percent in twelve months, and wastes about $252 a year on unused services. Monthly numbers feel small; yearly numbers tell the truth.

How do I audit my subscriptions in 4 steps? Pull every recurring charge from the last 12 months of bank and card statements (not memory, memory misses annual renewals), convert each to a yearly cost, score each on cost, value, and last use, then cancel worst-first.

Why is canceling subscriptions so hard? It is by design. The FTC calls these 'negative option' programs: your silence counts as consent and the subscription renews until you affirmatively stop it. The FTC's 2024 click-to-cancel rule would have forced easy cancellation, but a federal appeals court struck it down in July 2025.

What should I do after canceling a subscription? Three things: screenshot the cancellation confirmation (proof beats memory if a charge reappears), ask about an annual-plan refund (many services prorate, but only if you ask), and watch the next two statements, canceled subscriptions can keep billing through a different payment method.

Sources

Next guide Essential Money Toolkit: 7 Spreadsheets, One Set Seven tools, one download: one workflow from subscription audit to quarterly tax. In the worked example, canceling three subscriptions finds US$371.64 a year.