The Subscription Audit Worksheet: How to Find the $500/Month Hiding in Your Bank Statement

The last time I guessed what I spent on subscriptions, I said $90. A week later I sat down with 90 days of statements and the real number was $312. I was off by a factor of three and a half.

That gap is not a personal failing. C+R Research ran the same experiment on 1,000 US consumers and found the average quick estimate was $86 a month while the itemized reality was $219 — a $133 hole most people had no idea existed. Nearly a third were off by $100-199. Another quarter were off by more than $200. That study is three years old. With the AI subscriptions, the dozen streaming apps, and the steady creep of “premium tiers” on apps that used to be free, the gap is wider now, not smaller.

This is not a post about canceling everything. I love my subscriptions. I have opinions about which streaming service has the best dub of which prestige drama, and I’m not giving any of that up. What I’m advocating for is seeing the whole picture once, clearly, so the subscriptions you keep are the ones you’d pick again if someone handed you the list fresh. In my own audit a two-adult household can usually cut from $500/month to $250 without losing anything they use more than weekly. That’s $3,000 a year, after tax, for roughly ninety minutes of work.

Why your gut number is always wrong

Subscriptions are engineered to be forgettable. The price is small. The charge is automatic. The cadence is monthly or annual, neither of which maps to how you think about your budget. An $8.99 line item doesn’t register as a decision. Twelve of them do.

Four specific traps inflate the gap between guess and reality:

1. Annual renewals. A $119 Amazon Prime charge in March doesn’t feel like $9.92/month, because you don’t amortize it in your head.
2. App store billing. Subscriptions routed through Apple or Google collapse into a single “iTunes” or “Google” line that hides what’s inside.
3. Family plan ghosts. You paid for a Spotify family plan in 2023. Two slots are still occupied by someone who no longer lives in your house.
4. Price creep. The $9.99 service you signed up for is now $17.99, and the email announcing the change was filed under “Updates” and never opened.

The fix for all four is the same. Look.

The 90-minute audit I run twice a year

You need three things: ninety minutes, a spreadsheet, and read-only access to every account that can charge you. Block the time. Do it in one sitting. A half-done audit is the same as no audit — I tried the “I’ll finish it this weekend” version twice and in both cases “this weekend” arrived six months later with my money already spent.

Step 1: Pull 90 days of statements

Log in to every bank account and credit card and download the last 90 days as CSV. Ninety days catches quarterly charges. For annuals you’ll want 12 months eventually, but 90 is enough for the first pass. Dump all the CSVs into one spreadsheet with a source column so you can tell the accounts apart.

Step 2: Sort by merchant and flag the repeats

Sort by merchant name and scan for anything appearing more than once at similar dollar amounts. Those are your recurring charges. Add a subscription? column and mark yes or no. Doing this by hand takes twenty minutes. It is the single most clarifying exercise in personal finance I know.

If you want automation as a supplement, Rocket Money (formerly Truebill) and Monarch categorize recurring charges reasonably well. One warning. Rocket Money’s free tier pushes you hard into a $6-12/month premium tier that promises to cancel subscriptions on your behalf. You don’t need it. You can cancel anything they find, for free, in about two minutes per service. Paying a subscription service to cancel your subscriptions is the plot of a satire.

Step 3: Cross-check the app stores

Bank statements miss anything bundled through Apple or Google. Open each of these and screenshot the list:

• iPhone: Settings > [Your Name] > Subscriptions
• Android: Google Play Store > Profile icon > Payments & subscriptions > Subscriptions
• Amazon: Your Account > Memberships and Subscriptions
• PayPal: Settings > Payments > Manage automatic payments
• Roku / Apple TV / Fire TV: check the subscription list on each device

Add anything you find to the spreadsheet. This step alone usually surfaces two or three forgotten charges. In my own audit last October I found a $4.99 Calm charge from a 2022 free trial I’d never canceled. Three and a half years of $4.99 is $210. That one line paid for the audit.

Step 4: Check the categories that never show up in memory

These hide easily:

• Cloud storage overflow: iCloud, Google One, Dropbox, OneDrive
• Home security: Ring Protect, SimpliSafe, ADT, Nest Aware
• Antivirus auto-renewal (often 3-5x the intro price)
• Digital papers: WSJ, NYT, The Athletic, local paper
• Creator platforms: Patreon, Substack, OnlyFans, Ko-fi
• Dating app premium tiers: Hinge+, Tinder Gold, Bumble Premium
• Meditation and fitness: Calm, Headspace, Strava, MyFitnessPal Premium
• Language learning: Duolingo Super, Babbel, Rosetta Stone

Add them all. Everything goes in, even things you “know” you still want. The point of the spreadsheet isn’t judgment. It’s visibility.

What a two-adult US household typically spends, by category

Once the spreadsheet is full, group your subscriptions into these buckets and compare your totals to the ranges below. These reflect what I see in 2026.

Streaming video ($40-90/mo typical). Netflix, Max, Disney+, Hulu, Peacock, Paramount+, Apple TV+. The typical household carries four, actively watches two, forgets the rest. My controversial take: rotate instead of hoard. Keep two at a time, cancel the rest, re-subscribe when a specific show drops. The streaming companies hate this, which is how I know it works.

Music ($0-17). Spotify, Apple Music, Amazon, YouTube Music, Pandora. Almost nobody uses more than one. A second is usually vestigial from a phone switch or a bundled trial.

Cloud storage ($0-30). iCloud, Google One, Dropbox, Microsoft 365’s bundled OneDrive. Lots of people pay for two overlapping plans. Consolidate onto the one attached to the device you take photos with.

Fitness ($10-200). Gym, Peloton, Apple Fitness+, Strava, MyFitnessPal. Honest test: pull up your gym’s check-in history. Fewer than 4 visits last month? The math is against you, and the guilt of keeping the membership doesn’t count as cardio.

News ($20-80). WSJ, NYT, Bloomberg, WaPo, a local paper. Pick two. Most publishers discount hard if you ask retention — more on that below.

Software ($20-80). Microsoft 365, Google Workspace, Adobe Creative Cloud, Zoom, Canva, a password manager, Notion. Audit for actual use. Canva’s free tier is strong. Bitwarden’s free tier replaces most paid password managers.

VPN and antivirus ($0-20). The worst auto-renewal category on earth. Intro prices roll into full prices 3-5x higher. Windows Defender is enough for most users. If you want a VPN, shop the price every single year.

Delivery and membership ($30-80). Amazon Prime, Walmart+, Instacart+, DoorDash DashPass, Uber One, Costco, Sam’s Club. Heavy overlap. We walked through the overlap math in our cashback app showdown. One grocery membership and one restaurant membership is usually enough. Two of each is paying twice.

AI tools ($0-80, new category in 2026). ChatGPT Plus, Claude Pro, Midjourney, Perplexity Pro, GitHub Copilot, ElevenLabs. Easy to stack to $60-80/month without noticing. Pick the one you use daily, downgrade the rest to free tiers until you miss them.

Telecom ($80-250). Mobile, home internet, landline, cable. A whole separate audit, but include the total here. Most households have at least one line or service nobody uses.

The “do I use it” test

For every row on the spreadsheet, add a uses/month column and fill it in. Not a vibe. A number. Where to find it:

• Streaming: “Continue Watching” and viewing history. Last watch over 30 days ago = cancel candidate.
• Music: Spotify Wrapped and Apple Replay show total hours.
• Gym: check-in history in the app or at the front desk.
• Apps: iOS and Android screen-time reports show minutes per app per week.
• Cloud storage: actual usage vs. tier. Sitting at 12 GB on a 2 TB plan? Downgrade.
• News: account dashboard shows login frequency. Some show article counts.

Rule I use: if cost-per-use is higher than what I’d cheerfully pay for one use, I cancel. $17/month used once is $17 a use. $17/month used fifteen times is a buck a use. One of those is a bargain.

Pause beats cancel more often than I expected

I used to cancel everything. I’ve changed my mind on that. Several services let you pause instead of cancel, preserving your profile, your watch history, your playlists. If you’re going to come back, pausing keeps the door open and costs nothing.

• Hulu: pause up to 12 weeks
• Peacock, Paramount+: pause in account settings
• Gyms: most allow 1-3 months of pause per year for medical or travel reasons
• Meal kits (HelloFresh, Blue Apron): pause indefinitely

Pause when you expect to return within 90 days. Cancel otherwise. A “pause” on something you’re never returning to is just a deferred charge with extra steps.

The retention department script

Many services offer real discounts if you try to cancel. They would rather keep you at a discount than lose you. Services known for generous save-desk offers:

• Hulu / Disney+: 50% off for three months is common
• Sirius XM: never pay rack rate, call once a year
• Peloton: 20-30% off monthly
• Cable and internet (Cox, Spectrum, Xfinity): matchable when you name a competitor
• The New York Times: usually matches your promo rate when it expires
• Audible: 3 months at $7.95 is a standard offer
• Adobe Creative Cloud: 2 months free appears when you click “cancel” online

The script I use every time is the same. Start the cancel flow. Say: “I’m canceling because it’s too expensive for how often I use it. Is there anything you can do?” Then wait. Do not fill the silence. If the first offer isn’t enough: “I appreciate that, but it’s still more than I want to spend.” The second offer is almost always better than the first. I called Sirius XM in January, got a shrug, waited, and landed $5/month for twelve months on a line that had been $22.

Free replacements worth knowing about

What you pay for vs. what’s free:

• Music: Spotify free (ad-supported) is fine for casual listening.
• Streaming: your library card unlocks Libby (audiobooks + ebooks), Hoopla (movies, music, books), and Kanopy (arthouse and documentary streaming). My library card replaced roughly half a streaming service for me.
• Antivirus: Windows Defender is enough for most users.
• Office software: Google Docs / Sheets / Slides covers 90% of Microsoft Office use cases.
• Password manager: Bitwarden’s free tier is excellent.
• Fitness: YouTube has more high-quality free workout content than any paid fitness app.
• News: many paywalled articles are free through library database access.

The outlier is YouTube Premium. There’s no free equivalent — the “free” version is the ad-supported one, and the ads have gotten measurably worse in the last year, specifically to drive upgrades. Whether that’s worth $14/month is your call. I pay it. I’m not proud of it.

The one-in-one-out rule that keeps the audit from slipping

The audit is the easy part. Keeping the total flat is the hard part. Subscriptions accumulate the way clutter does: one at a time, each one reasonable on its own. The habit that works for me is one-in-one-out. Every new subscription I add, I cancel an existing one. The trade is explicit. The total stays flat, and a small moment of friction enters every signup — which is exactly the moment the subscription economy is built to steal from you.

Related: if you find yourself signing up to get a single sale price, read our guide to reading coupon codes before you do. There’s often a stackable path that doesn’t require the membership.

When to keep everything you have

Auditing isn’t arguing for asceticism. A $17/month meditation app used four times a week is $1.06 a session — a good deal. A $40 gym visited three times a week is a great one. A streaming service that keeps a household of four entertained for 90 minutes a night is one of the cheapest forms of entertainment ever invented. If the answer to “do I use this” is yes, keep it, guilt-free.

The audit isn’t asking you to become a person who doesn’t spend money. It’s separating the subscriptions you’d choose again from the ones you forgot you had. The first set stays. The second set is where the $500/month is hiding.

Worked example: $508 to $167

Two-adult household, starting monthly recurring total: $508.

$4,092 a year. Nobody in that example stopped entertaining themselves, stopped working out, or stopped reading the news. They stopped paying twice for the same thing, and they stopped paying for services they’d forgotten existed.

Run the audit once. Put a reminder on your calendar to run it again in six months. Then don’t think about it in between. The subscriptions that survive an audit earn the quiet place in your budget. The ones that don’t were never yours to keep.