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

Ask anyone how much they spend on subscriptions each month and they will give a number that feels right. Then ask them to itemize it, line by line, and the number roughly triples. C+R Research ran this exact experiment on 1,000 US consumers: the average quick estimate was $86 a month, the itemized reality was $219, a $133 gap most people had no idea existed. Nearly a third were off by $100-199. Another quarter were off by more than $200. Three years later, with AI subscriptions, a dozen streaming services, and the steady creep of “premium tiers” on apps that used to be free, that gap is bigger, not smaller.

This is not a post about canceling everything. It is about seeing everything clearly, once, so the subscriptions you keep are the ones you actually want. The goal is intentionality, not deprivation. A two-adult household starting at $500/month in recurring charges can almost always cut to $250 without losing anything they use more than weekly. That is $3,000 a year, after tax, for about ninety minutes of work.

Why Self-Estimates Are So Wrong

Subscriptions are designed to be forgettable. The pricing is small, the charge is automatic, and the cadence is monthly or annual, neither of which maps to how you think about your budget. An $8.99 charge does not register as a decision. Twelve of them do.

Four specific traps inflate the gap:

1. Annual renewals. A $119 Amazon Prime charge in March does not feel like $9.92/month because you do not amortize it in your head.
2. App store billing. Subscriptions through Apple or Google show up as a single “iTunes” or “Google” line that obscures what is inside.
3. Family plan confusion. You paid for a Spotify family plan two years ago. Two slots are still used 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: actually look.

The 90-Minute Audit Method

You need three things: 90 minutes, a spreadsheet, and read-only access to every account that could charge you. Block the time. Do it in one sitting. A half-done audit is the same as no audit.

Step 1: Export 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 annual bills you want 12 months, but 90 is enough for the first pass. Dump all the CSVs into one spreadsheet with a source column so you can tell accounts apart.

Step 2: Sort and Flag Recurring Merchants

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

If you want automation as a supplement, Rocket Money (formerly Truebill) and Monarch categorize recurring charges reasonably well. Warning: Rocket Money’s free tier upsells aggressively into a $6-12/month premium tier that cancels on your behalf. You do not need it. You can cancel anything they find, for free, in about two minutes.

Step 3: Cross-Reference the App Stores

Bank statements miss subscriptions that are 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 channel store’s subscription list on each device

Add anything you find to the spreadsheet. This step alone typically surfaces two or three forgotten charges.

Step 4: Check the Often-Missed Categories

These never show up in memory and are easy to miss:

• 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 the spreadsheet, even things you “know” you still want.

The Categories and What Typical Households Spend

Once everything is listed, group your subscriptions into these buckets. Compare your totals to the typical ranges below, which reflect what a two-adult US household tends to spend in each category in 2026.

Streaming video ($40-90/mo typical). Netflix, Max, Disney+, Hulu, Peacock, Paramount+, Apple TV+. Typical household carries four, actively watches two, forgets the rest. Rotate instead of hoard: keep two at a time, cancel and re-subscribe when a specific show drops.

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. Many people pay for two overlapping plans. Consolidate onto the one attached to the device you actually photograph with.

Fitness ($10-200). Gym, Peloton, Apple Fitness+, Strava, MyFitnessPal. Honest test: pull up your gym’s check-in history. Fewer than 4 times last month? The math is against you.

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

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

VPN and antivirus ($0-20). The aggressive auto-renewal category. Intro prices roll into full prices 3-5x higher. Windows Defender replaces most third-party antivirus. If you want a VPN, shop the price every year.

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

AI tools ($0-80, new in 2026). ChatGPT Plus, Claude Pro, Midjourney, Perplexity Pro, GitHub Copilot, ElevenLabs. Easy to stack to $60-80/month. 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 separate audit in itself, but include the total here. Most households have one line or service nobody uses.

The “Do I Actually Use It” Test

For every line on the spreadsheet, add a uses/month column and fill it in honestly. You want a number, not a vibe. 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 gym’s 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. At 12 GB on a 2 TB plan? Downgrade.
• News: Account dashboard shows login frequency; some show article counts.

Rule of thumb: if cost-per-use is higher than what you would cheerfully pay for one use, cancel. $17/month used once is $17 a use. $17/month used fifteen times is a dollar a use — a bargain.

Pause vs Cancel

Not everything needs to be canceled. Several services let you pause, preserving your profile and history.

• 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 are not returning to is just a deferred charge.

The Retention Department Playbook

Many services offer significant retention 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 mention 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 when you click “cancel” online

The script is the same every time. Start the cancel flow and say: “I am canceling because it is 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 is not enough: “I appreciate that, but it is still more than I want to spend.” The second offer is almost always better.

Free and Cheaper Alternatives

Worth auditing what you pay for against what is free:

• Music: Spotify free (ad-supported) is usable for casual listening.
• Streaming: Your library card unlocks Libby (audiobooks + ebooks), Hoopla (movies + music + books), and Kanopy (arthouse and documentary streaming). Realistically replaces half a streaming service.
• 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 app.
• News: Many paywalled articles are free through library database access.

YouTube Premium is the one subscription with no real free equivalent — the “free” version is the ad-supported one, and the ads have gotten worse specifically to drive upgrades. Whether that is worth $14/month is your call.

The One-In-One-Out Rule

Once you finish the audit, the hardest part is keeping it clean. Subscriptions accumulate the same way clutter does: one at a time, each one reasonable on its own. The habit that works: for every new subscription you add, cancel an existing one. You decide it is worth trading. This keeps the total flat and forces a small moment of friction before every signup, which is exactly the moment the subscription economy is designed to steal from you.

Related: if you find yourself signing up to get a single sale price, read our guide on reading coupon codes before you do — there is often a stackable path that does not require the membership.

When to Keep Everything You Have

An audit is not an argument 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 entertains a household of four for 90 minutes a night is one of the cheapest forms of entertainment ever invented. If the answer to “do I actually use this” is yes, keep it, guilt-free.

The audit’s purpose is to separate the subscriptions you would choose again from the ones you forgot you had. The first set stays. The second set is where the $500/month hiding in your bank statement lives.

Worked Example: $500 to $250 Without Feeling Deprived

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

That is $4,092 a year. Nobody in the example had to stop entertaining themselves, stop working out, or stop reading the news. They just stopped paying twice for the same thing and stopped paying for services they had forgotten existed.

Run the audit once. Put a reminder on your calendar to run it again in six months. Then never think about it in between — because the subscriptions that survive an audit are the ones that earn the quiet place in your budget.