SubSweeper — Subscription Audit Tracker — product cover

Category: Spreadsheets · Tracking Dashboards

About this product

THE OUTCOME

SubSweeper turns a 20-minute audit into total clarity: every subscription in one list, your true monthly AND annual burn, your 5 most expensive plans ranked side by side, and an auto-generated cancel queue of the ones you're paying for but not using. Work the queue, cancel the waste, keep the ones you love — then re-run your audit monthly in minutes.

WHO IT'S FOR

Anyone with more subscriptions than they can name: streamers juggling 4+ services, freelancers with stacked software tools, families sharing plans nobody tracks, and anyone who's ever been surprised by a renewal charge.

THE PROBLEM

Your subscriptions are bleeding you dry — quietly. The average household pays for a dozen or more recurring services and can only name about half of them. The free trial that converted to a paid plan. The fitness app from last January. The cloud tier you outgrew. Each one looks harmless at $9.99 or $14.99 a month — but added up over a year, forgotten subscriptions can easily cost you over a thousand dollars you never consciously approved.

FEATURES → WHAT THEY DO FOR YOU

  • 100% live formulas — zero macros, zero add-ins, zero data leaving your device → your financial list stays private on your computer.
  • Stable Audit Date input (defaults to 2026-10-18) instead of volatile TODAY() → your "days since used" figures are repeatable; set it to today each audit and compare months honestly.
  • Auto-flagged cancel queue (unused 60+ days, or $30+/month with no recorded usage) → the waste finds you; work the queue top to bottom.
  • Flip Status to "Cancelled" and the queue and dashboard update themselves → watch your burn drop in real time as you cancel.
  • Dropdowns for category, billing cycle, and status + conditional formatting → clean reports, highlighted waste, greyed-out cancelled plans.
  • IFERROR guards throughout → blank cells and edge cases never produce error cells.

HOW IT WORKS

  • List every recurring charge from your statements (SubSweeper's guide shows you where to look).
  • Type them into the yellow input cells on the SUBSCRIPTIONS sheet.
  • Read your burn on the DASHBOARD; work the CANCEL QUEUE top to bottom.
  • Cancel with each provider, flip Status to "Cancelled," watch the queue and dashboard update.
  • Re-run monthly: set the Audit Date to today.

IDEAL CUSTOMER — PICTURE THIS

A freelancer with stacked software tools, three streaming services, and a gym app from last January spends 20 minutes entering everything from card statements. The dashboard shows $126.93/month in true burn; the cancel queue flags four subscriptions worth $1,019.64 a year. She cancels three before dinner.

WHO IT IS NOT FOR

  • People with two or three subscriptions they already track — there's nothing to audit.
  • Anyone wanting automatic discovery or bank sync — you enter every subscription yourself; SubSweeper can't connect to your bank or find charges for you.
  • Anyone expecting guaranteed savings — all savings figures are estimates from your own inputs, never guaranteed.
  • Businesses needing expense management — this is a personal/household organization tool (personal-use license).

FORMATS

XLSX spreadsheet — Microsoft Excel, Google Sheets (upload to Drive, open with Sheets), LibreOffice Calc. No macros; all standard formulas.

PREREQUISITES

A spreadsheet app (Excel, Google Sheets, or LibreOffice — all free options work). About 20 minutes for your first audit. Your bank/card statements or subscription settings pages to find every recurring charge.

LIMITATIONS

  • You enter the data yourself — SubSweeper can't discover subscriptions automatically or connect to your bank.
  • All savings figures are estimates from your own inputs, not guaranteed savings.
  • Cancellation terms, notice periods, and refund policies vary by provider; some make cancelling deliberately difficult. Check each provider's terms.
  • Not financial advice — it's a personal organization tool.
  • 30 subscription rows per workbook (covers the vast majority of households).

DELIVERY

Instant download: SubSweeper-v1.zip containing SubSweeper.xlsx, Quick-Start-Guide.pdf, and README-license.txt.

LICENSE

Personal use only — use for your own household's subscriptions. No redistribution, resale, or sharing of the files.

FAQ

  • Does it work in Google Sheets? Yes — upload the .xlsx to Google Drive and open with Google Sheets. All formulas are compatible with Excel, Sheets, and LibreOffice.
  • Is my financial data sent anywhere? No. It's a plain spreadsheet file with no macros, no external links, and no network calls. Everything stays on your device.
  • What if I don't know when I last used something? Estimate it — or leave it blank. Note: blank usage combined with $30+/month still flags the item for review.
  • Why an Audit Date instead of TODAY()? TODAY() changes daily, so your numbers would drift. The fixed Audit Date (default 2026-10-18) freezes the measurement — update it to today each time you audit.
  • What if I have more than 30 subscriptions? 30 rows covers the vast majority of households. If you truly have more, consolidate family/household plans or run a second copy for a second person.

SUPPORT & UPDATES

Questions? Contact us through the Gumroad product page. Free updates to v1.x.

What's included

  • START HERE sheet — purpose, 20-minute how-to, input-cell key, and our honest note: savings figures are estimates from your own inputs, never guaranteed.
  • SUBSCRIPTIONS sheet — the core tracker. 30 pre-formatted rows: service name, category dropdown (Streaming/Music/Gaming/Fitness/News/Software/Cloud/Shopping/Other), monthly cost OR annual cost + billing cycle (Monthly/Annual), next renewal date, last used date, days since used, monthly equivalent cost, annual cost, status (Active/Cancelled/Trial), and cancel URL/notes. Ships with 12 fictional sample subscriptions (7 active, 3 cancelled, 2 trials) demonstrating every formula — delete and enter your own.
  • DASHBOARD sheet — 100% computed: total monthly burn, total annual burn, active/trial/cancelled counts, unused-60+-days count, top 5 most expensive subscriptions, and potential annual + monthly savings if all flagged items are cancelled.
  • CANCEL QUEUE sheet — auto-flagged review list: any Active subscription unused 60+ days, or costing $30+/month with no recorded usage. Service, monthly/annual cost, days unused, and estimated annual savings per item. Flip Status to "Cancelled" on the main sheet and the queue updates itself.
  • Quick-Start-Guide.pdf — the subscription-creep problem, your first 20-minute audit walkthrough, reading the dashboard, the cancel queue workflow, renewal-date tactics (calendar reminders), FAQ, and disclaimer.
  • README-license.txt — contents, formats, and license.

Key features

  • 100% live formulas — zero macros, zero add-ins, zero data leaving your device → your financial list stays private on your computer
  • Stable Audit Date input instead of volatile TODAY() → your "days since used" figures are repeatable; set it to today each audit and compare months honestly
  • Auto-flagged cancel queue (unused 60+ days, or $30+/month with no recorded usage) → the waste finds you; work the queue top to bottom
  • Flip Status to "Cancelled" and the queue and dashboard update themselves → watch your burn drop in real time as you cancel
  • Dropdowns for category, billing cycle, and status + conditional formatting → clean reports, highlighted waste, greyed-out cancelled plans
  • IFERROR guards throughout → blank cells and edge cases never produce error cells

Frequently asked questions

Does it work in Google Sheets?

Yes — upload the .xlsx to Google Drive and open with Google Sheets. All formulas are compatible with Excel, Sheets, and LibreOffice.

Is my financial data sent anywhere?

No. It's a plain spreadsheet file with no macros, no external links, and no network calls. Everything stays on your device.

What if I don't know when I last used something?

Estimate it — or leave it blank. Note: blank usage combined with $30+/month still flags the item for review.

Why an Audit Date instead of TODAY()?

TODAY() changes daily, so your numbers would drift. The fixed Audit Date freezes the measurement — update it to today each time you audit.

What if I have more than 30 subscriptions?

30 rows covers the vast majority of households. If you truly have more, consolidate family/household plans or run a second copy for a second person.

What if I need help with the files?

Message the seller through the Gumroad product page contact form.

SubSweeper — Subscription Audit Tracker — product image

SubSweeper — Subscription Audit Tracker

A formula-driven spreadsheet that finds the subscriptions quietly draining your money. Track 30 subs, see your true monthly & annual burn, get an auto-flagged cancel queue, and estimate your savings. Excel, Google Sheets & LibreOffice.

$14

Buy Now on Gumroad

Related products

More Spreadsheets
Small Business KPI Dashboard — product image
Spreadsheets

Small Business KPI Dashboard

Know your numbers in 15 minutes a month. A formula-driven spreadsheet tracking the 9 KPIs that matter — revenue, margins, CAC, conversion, cash runway — with trend charts and a target scorecard. Sample data preloaded.