Subscription Audit Tracker

The average American spends $219/month on subscriptions but thinks they spend $86. That gap is where your money disappears — streaming services on autopilot, apps you downloaded once, annual renewals that hit your card before you remember they exist. Most subscription trackers just list what you pay. This one tells you what to do about it.

What’s Included

One .xlsx file with 8 fully-built tabs:

• Start Here — setup guide, tab map, and 5 quick stats that update as you enter data
• Subscriptions — your single data entry point. Log up to 50 subscriptions with name, category, cost, billing cycle, renewal date, payment method, and cancel flag. Enter once, see everywhere
• Cost Dashboard — total monthly and annual cost, category breakdown donut chart, top 10 subscriptions ranked by cost, payment method summary
• Renewal Calendar — 90-day timeline sorted by soonest renewal, color-coded urgency tiers (urgent, soon, upcoming), countdown in days
• Cancel Simulator — toggle subscriptions to “cancel” and instantly see projected monthly and annual savings vs. remaining costs
• Cost Per Use — enter how often you use each service, see cost per use, value rating (Excellent to Poor), and a keep/review/cut recommendation
• YoY Tracker — 12-month trend tracking with month-over-month change analysis and line chart showing subscription spending over time
• Reference — customizable category names, billing cycle settings, and lookup tables

How It Works

1. Open the file in Google Sheets or Excel
2. Go to the Subscriptions tab and replace the sample data with your own (16 realistic sample subscriptions are included so you can see every feature in action)
3. Check the Cost Dashboard to see your total spending and category breakdown
4. Mark subscriptions you are considering cancelling — the Cancel Simulator shows your projected savings instantly
5. Optionally enter usage data to see cost-per-use value ratings
6. Review the Renewal Calendar so nothing sneaks up on you

Who It’s For

• Anyone who suspects they are overpaying on subscriptions but has never done a full audit
• People managing 8-20+ recurring charges across streaming, software, fitness, meal kits, and apps
• Couples or households combining subscription costs for the first time
• Anyone doing a spring financial reset or annual budget review

WHAT MAKES THIS DIFFERENT

Most subscription trackers are simple lists — enter your subscriptions, see a total. No analysis. No recommendations. No way to model what happens if you cancel three services. This template is an audit tool, not a passive tracker. The Cancel Simulator alone can save you $1,000+ per year by making the math visible before you decide. Add cost-per-use analysis and a 90-day renewal calendar, and you have a complete subscription management system in one spreadsheet.