Subscription Audit: Find and Reduce Recurring Costs
Find forgotten subscriptions in 15 minutes, convert every charge to a monthly cost, and use a simple spreadsheet to estimate what cancelling could save.
Find Every Subscription You're Paying For in 15 Minutes
A subscription audit sounds like a spreadsheet problem. Most of the time, it isn't. The annoying part is finding the charges in the first place: they're scattered across bank accounts, cards, app stores, PayPal, and email receipts. Some renew every month; others show up only once a year. One quick look at a single statement can easily miss both.
You don't need a budgeting app or a complicated financial model. Set aside 15 minutes, scan the places where recurring charges tend to hide, and then list each one in a simple Google Sheet or Excel file. Converting everything into a monthly cost makes comparisons way easier - and makes the "wait, why am I paying for this?" ones stand out.
This guide walks you through a timed search process, the spreadsheet columns to use, and a straightforward way to decide what to keep or cancel. The numbers you end up with are an estimate (not a promise), plus a clear checklist for follow-up actions if you want to make savings real.
Why subscription audits miss charges
A subscription audit fails when you assume every recurring charge is obvious. In reality, the merchant name on your statement might not match the app or service you remember signing up for. Sometimes the payment shows up under a payment processor, a parent company, or an app-store billing account you rarely think about. And yes - free trials can quietly roll into paid plans without you making a new decision.
Timing causes trouble too. A monthly payment is usually easy to spot, but a yearly renewal might not show up until weeks outside your usual glance window. Quarterly and weekly plans can get missed as well. If you look at only one statement, you're basically looking at a small slice of the pattern - not a dependable inventory.
The practical fix: audit from more than one source. Your bank and card statements show what was actually charged. Apple, Google Play, and PayPal can reveal subscriptions billed through those platforms. And email receipts can help you connect a weird merchant description to the real product - and can surface trials you forgot about.
Treat discovery and analysis as separate jobs
A lot of people start by trying to total what they spend before they have the full list. That can create false confidence. A neat total isn't useful if it accidentally excludes the annual software plan - or the app-store charge hiding under an umbrella name.
Use two passes instead:
- Find and record likely recurring charges. Don't judge whether each one is worth it while you're still gathering data.
- Normalize and review the list. Convert different billing cycles into a comparable monthly number, then decide what to keep, cancel, or review.
This separation matters because recognition isn't perfect. Add a questionable merchant to the sheet with a note or "Review," then investigate later. Deleting anything you don't recognize right away is one of the fastest ways to keep real subscriptions invisible.
What the 15-minute target can - and can't - do
Fifteen minutes is enough for a focused first pass if you can access your accounts. It's not a guarantee that you'll identify and cancel every single charge in that time. If you use multiple cards, share accounts with family, or have a long transaction history, plan on going longer.
Think of the timer as a way to keep the task manageable - not as a reason to skip sources. A short, repeatable audit is more useful than an ambitious one you never finish. If you hit an unclear charge, mark it and come back to it after your first pass instead of getting stuck on one transaction.
How to find subscriptions in 15 minutes
Before you start, open your online banking or card accounts. If possible, pull statements for every account and card you use - including "active but rarely used" cards. Two or three recent months are a good starting point: one month can miss weekly patterns, quarterly charges, and services billed on irregular dates.
If you have time, scan up to 12 months for annual renewals. You don't need to read every line. Search for likely terms, then check repeated merchant names and amounts.
Minutes 0-3: gather statements
Open or download the last two to three months of statements for each bank account and credit/debit card. Include household or business accounts if you're auditing those too. Just keep the scope clear - don't quietly mix in business expenses unless you mean to review them together.
For yearly plans, you may need a longer history - only your bank can tell you how far back it's easy to search. Look for the same merchant, a larger one-off payment, or a charge that shows up around the same time each year. One annual charge isn't automatically a subscription, though - verify it before marking it recurring.
Minutes 3-8: search for recurring merchants
Use the search in your online banking app or in a statement PDF. Try terms that might show up in descriptions, like "subscription," "membership," "monthly," "annual," "renew," "digital," "premium," "plus," and "pro." Merchant descriptions vary a lot, so treat these as clues, not a perfect search strategy.
Also look for the same merchant name showing up in multiple months. Matching amounts can be a strong sign, but it isn't proof - taxes, usage-based pricing, and currency conversion can all change the total. Record the merchant, the exact charge, the apparent billing cycle, and which account it came from. If you can't identify it quickly, write "check merchant" instead of guessing.
Minutes 8-12: check billing platforms and email
Some charges show up under a platform rather than the actual service name. Check the subscription screens for accounts you use:
- Apple: Settings, your name, then Subscriptions.
- Google Play: Play Store, profile, Payments & subscriptions, then Subscriptions.
- PayPal: Settings, Payments, then Manage automatic payments.
Menu names can change between device versions, so follow the subscription or automatic-payment settings for your account if the path looks different. Don't assume a subscription is active just because you once installed an app - check current status and renewal details.
Next, search your email for "receipt," "renewal," "invoice," "free trial," and "subscription." This is especially useful for trial-to-paid transitions and services billed under unfamiliar names. Add confirmed recurring charges to your sheet - but don't treat a receipt as an "active subscription" until you verify it's still running.
Minutes 12-15: record what you found
Create your sheet and enter each confirmed or likely recurring charge. Keep the original billing amount and billing cycle as separate fields - don't overwrite them with a monthly estimate. For items you can't verify yet, use a Review status. The goal of the first pass is a usable inventory, not a perfect financial archive.
How to calculate subscription costs in a spreadsheet
A useful audit sheet doesn't need a ton of columns. In row 1, set up:
| Column | Header | What to enter |
|---|---|---|
| A | Name | Service or statement merchant |
| B | Amount | Amount charged each billing cycle |
| C | Cycle | Weekly, Monthly or Yearly |
| D | Monthly cost | Normalized monthly estimate |
| E | Keep/Cancel/Review | Your current decision |
The formulas below work for weekly, monthly, and yearly billing. If you have quarterly or six-month charges, either add those cycles into the formula or calculate their monthly equivalent separately. Don't label a six-month charge as yearly just to make the math easier - the audit should stay traceable.
Convert each charge to a monthly amount
In cell D2, enter this Google Sheets or Excel formula, then fill it down for each subscription:
=IF(C2="Yearly",B2/12,IF(C2="Weekly",B2*52/12,B2))This divides yearly charges by 12, converts weekly charges using 52 weeks per year, and treats anything else as monthly. That last part keeps the formula simple, but it also means you need to enter the Cycle consistently. A typo like "Year" will be treated as monthly. If you can, use a dropdown for cycle values to reduce mistakes.
For example, a weekly fitness app billed at $4.99 costs about $21.62 per month on average: $4.99 × 52 ÷ 12. A yearly cloud-storage plan billed at $29.99 works out to about $2.50 per month. Either way, comparing monthly costs is more informative than comparing invoice amounts directly.
Calculate current cost and potential savings
If your subscriptions occupy rows 2 through 7, use these formulas:
- Total monthly cost:
=SUM(D2:D7) - Monthly cost marked Cancel:
=SUMIF(E2:E7,"Cancel",D2:D7) - Estimated yearly savings:
=SUMIF(E2:E7,"Cancel",D2:D7)*12
The first total is the normalized monthly cost of everything you entered. The second and third totals cover only items marked Cancel. These estimates don't account for contract end dates, partial refunds, taxes, or charges that might continue after you cancel. Treat the yearly figure as planning - money you haven't actually saved yet.
If you use a Review status, leave those charges out of the cancellation estimate until you decide. You can also add a separate total for Review items, which keeps uncertain charges visible without inflating savings you might not achieve.
Example: why the billing cycle matters
Imagine a list with a $15.49 monthly streaming plan, a $10.99 monthly music app, $29.99 yearly cloud storage, a $4.99 weekly fitness app, a $79 yearly news subscription, and a $12 monthly meal-kit plan. Their normalized monthly costs are approximately $15.49, $10.99, $2.50, $21.62, $6.58, and $12.00.
The total is about $69.19 per month. If the fitness app, news site, and meal kit are marked Cancel, those normalized costs add up to about $40.21 per month, or roughly $482.48 per year. These are illustrative numbers - not predictions of what you personally will save. The point is the weekly charge: a small amount per billing event can still turn into a meaningful monthly cost.
Key takeaways: Search multiple accounts and billing platforms; keep the original amount and billing cycle; convert charges to monthly costs before comparing them; and treat cancellation totals as estimates until payments actually stop.
How to decide what to keep or cancel
A spreadsheet can show you cost. It can't tell you whether something is worth paying for. That depends on real-world use, alternatives, contract terms, and what happens if you lose access. A low price isn't automatically good value, and a high price isn't automatically waste - especially if the service genuinely supports your work or household.
Go through each row using the same set of questions: Have you used it recently? Would you notice if access ended? Is it duplicated by another subscription? Is this plan still the right fit? What's the renewal date, and does cancellation take effect immediately or at the end of a paid period?
Use Keep, Cancel, and Review deliberately
- Keep: You use it, you understand what it provides, and the price feels fair.
- Cancel: You've decided the service no longer earns its place in your budget.
- Review: You need to confirm the merchant, usage, renewal terms, or whether someone else on a shared plan relies on it.
"Review" shouldn't be a way to dodge decisions forever. Give it a next step, like "check with partner," "confirm annual renewal date," or "compare team plan." A status without an action just leaves uncertainty sitting there.
Also check for overlap before canceling randomly. For example, you might be paying for overlapping cloud storage, music plans, or video services. Often, you'll get the best outcome by keeping the option that matches your devices and actual usage - rather than canceling everything and creating a new mess.
Cancel through the billing source and verify
Cancel through the place that actually controls the subscription. If you subscribed through an app store, use that account's subscription settings. If PayPal handles automatic payments, review the relevant billing agreement. If the merchant bills you directly, use its account or billing page. Deleting an app from your phone doesn't necessarily cancel the paid plan.
Save a confirmation email or note the cancellation date and the stated end date. Then check the next relevant statement. If a payment appears again, verify whether it's a final charge, a different plan, or a cancellation that didn't complete. If you're stuck, contact the billing provider.
Timing matters. Cancelling a plan may stop the next renewal without refunding the current period. Annual plans might therefore show no immediate cash-flow reduction even if the cancellation worked. For a realistic budget, separate the monthly equivalent of a plan from the date the next payment will actually disappear.
If you want to keep your audit useful, add a renewal date and review the sheet every few months. A simple list works well for a small number of subscriptions. Once you have lots of services (or multiple billing cycles), add fields like billing source, next renewal date, and cancellation confirmation. More columns only help if you keep them updated.
Conclusion
A good subscription audit is a short discovery step followed by a clear decision - not a complicated finance project. Check statements across multiple months, inspect the billing platforms you use, and search email for trials and renewals. Then normalize each charge to a monthly cost so you can compare subscriptions on equal footing.
Mark uncertain items for review, cancel through the correct billing source, and verify what happens on the next statement. Start simple. Add renewal tracking only if it solves a real problem. The goal isn't to eliminate every recurring payment - it's to understand what you're paying for and make each subscription a deliberate choice.