Subscription Tracker Spreadsheet | Recurring Expense & Renewal Planner for Google Sheets

See where your recurring money goes—and what’s coming next.

The Subscription & Recurring Expense Tracker helps you organize subscriptions, memberships, free trials, renewal dates, recurring costs, and potential savings in one connected spreadsheet system.

Enter each recurring expense once and the template automatically calculates its true monthly and annual cost, monitors upcoming renewals, flags free trials, tracks price changes, and updates your personal dashboard.

━━━━━━━━━━━━━━━━━━━━
WHAT’S INCLUDED
━━━━━━━━━━━━━━━━━━━━

✓ 1 PDF containing the link to your template
✓ 1 reusable Google Sheets subscription tracker
✓ 6 connected spreadsheet tabs
✓ 100 prepared subscription rows
✓ 9 generic sample entries
✓ Automatic monthly and annual cost calculations
✓ Renewal and free-trial warnings
✓ Price-change tracking
✓ Cancellation and savings tools
✓ Customizable categories and settings
✓ Personal spending dashboard
✓ 3 automatic charts
✓ Built-in setup instructions

The six included tabs are:

• START HERE
• SETTINGS
• SUBSCRIPTIONS
• RENEWALS
• SAVINGS
• DASHBOARD

━━━━━━━━━━━━━━━━━━━━
SUBSCRIPTION TRACKER
━━━━━━━━━━━━━━━━━━━━

Organize up to 100 recurring expenses in one filterable table.

Track information such as:

• Subscription or recurring expense
• Category
• Plan or tier
• Current status
• Keep, Review, or Cancel decision
• Billing cycle
• Current charge
• Previous charge
• Price-change amount and percentage
• Next renewal date
• Auto-renew status
• Free-trial ending date
• Payment-method type
• Start date
• Last review date
• Management or cancellation URL
• Notes

Optional account details are grouped separately to keep the main subscription table simple and easy to follow.

━━━━━━━━━━━━━━━━━━━━
TRUE MONTHLY & ANNUAL COSTS
━━━━━━━━━━━━━━━━━━━━

Different billing schedules can make recurring expenses difficult to compare.

The tracker automatically converts these billing frequencies into consistent monthly and annual equivalents:

• Weekly
• Monthly
• Quarterly
• Semiannual
• Annual

This makes it easier to compare every recurring expense—even when they renew on completely different schedules.

Automatic summary cards show:

✓ Current monthly recurring cost
✓ Annual recurring cost
✓ Renewals needing attention
✓ Free trials needing attention
✓ Number of ready-to-use rows

━━━━━━━━━━━━━━━━━━━━
RENEWAL & FREE-TRIAL WARNINGS
━━━━━━━━━━━━━━━━━━━━

Enter a renewal or trial-ending date and the spreadsheet automatically calculates how many days remain.

The RENEWALS tab includes:

• Renewals within your warning period
• Scheduled charges during the next 30 days
• Annual renewals during the next 12 months
• Upcoming renewals and date checks
• Upcoming free-trial deadlines
• 12-month next-renewal outlook
• Scheduled renewal charges by month
• Automatic renewal chart

Customize your renewal and free-trial warning periods in SETTINGS.

The monthly outlook uses the next renewal date currently stored for each subscription. Update that date after a charge occurs to keep your schedule current.

━━━━━━━━━━━━━━━━━━━━
PRICE-CHANGE TRACKING
━━━━━━━━━━━━━━━━━━━━

Record the previous charge and current charge to see:

• Price change in dollars
• Price change as a percentage
• Subscriptions with a recorded increase

Price-change percentages are displayed to a maximum of two decimal places for a cleaner, easier-to-read comparison.

━━━━━━━━━━━━━━━━━━━━
SUBSCRIPTION REVIEW SYSTEM
━━━━━━━━━━━━━━━━━━━━

Mark each recurring expense as:

• Keep
• Review
• Cancel

You can also categorize its current status as:

• Active
• Free Trial
• Paused
• Cancel Pending
• Cancelled

The SAVINGS tab automatically organizes subscriptions marked for review or cancellation, helping you identify which expenses deserve attention.

Current spending totals include Active and Cancel Pending subscriptions. Paused, Cancelled, and Free Trial items are excluded from current recurring-cost totals.

━━━━━━━━━━━━━━━━━━━━
CANCELLATION & SAVINGS TRACKER
━━━━━━━━━━━━━━━━━━━━

Turn subscription cleanup into a clear and motivating savings plan.

The SAVINGS tab includes:

✓ Potential monthly savings
✓ Potential annual savings
✓ Cancellation candidates
✓ Subscription review list
✓ Optional annual savings goal
✓ Savings-goal progress
✓ Completed cancellation log
✓ Annualized recurring spending removed
✓ Estimated savings since cancellation

Potential savings are kept separate from completed cancellations, so the spreadsheet does not present planned cancellations as money already saved.

When a cancellation is completed, record it in the cancellation log to preserve the recurring cost that was removed. Estimated savings since cancellation are then calculated using the saved annual equivalent.

━━━━━━━━━━━━━━━━━━━━
AUTOMATIC DASHBOARD
━━━━━━━━━━━━━━━━━━━━

Review your recurring spending at a glance without building formulas or charts.

The dashboard includes:

• Active subscriptions
• Monthly recurring cost
• Annual recurring cost
• Upcoming renewals
• Active free trials
• Potential annual savings
• Annualized spending removed
• Average cost per active subscription
• Monthly and annual budget checks
• Subscriptions marked Review
• Subscriptions marked Cancel
• Trials and renewals needing attention
• Largest recurring expenses
• Largest spending category
• Subscription-status summary
• Price increases logged
• Auto-renew items marked Unsure

The workbook includes three automatic charts:

• Annual Recurring Spend by Category
• Next Renewal Charges by Month
• Scheduled Next Charges by Month

━━━━━━━━━━━━━━━━━━━━
CUSTOMIZABLE SETTINGS
━━━━━━━━━━━━━━━━━━━━

Use SETTINGS to personalize:

• Optional monthly subscription budget
• Optional annual subscription budget
• Renewal warning period
• Free-trial warning period
• Expense categories
• Billing frequencies
• Subscription statuses
• Review decisions
• Auto-renew choices
• Payment-method types

All lists are editable. If a budget is left blank, the corresponding dashboard comparison will display “Not set.”

Currency formatting defaults to USD and can be changed manually using your spreadsheet’s number-format settings.

━━━━━━━━━━━━━━━━━━━━
EASY COLOR-CODED SYSTEM
━━━━━━━━━━━━━━━━━━━━

The built-in color key clearly separates:

• Information you enter
• Dropdown selections
• Automatic calculations
• Reference cells and instructions

The tracker also includes dropdown menus, filters, conditional formatting, frozen headers, and hidden optional columns to keep the main subscription list clean.

No formulas need to be built.

━━━━━━━━━━━━━━━━━━━━
PERFECT FOR
━━━━━━━━━━━━━━━━━━━━

• Individuals tracking recurring expenses
• Couples and households
• Anyone managing several subscriptions or memberships
• People trying to reduce unnecessary spending
• Anyone approaching multiple annual renewals
• People who frequently use free trials
• Anyone who wants a focused recurring-expense system without a full budgeting workbook

━━━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━

Purchase the listing.
Download the included PDF.
Click the template-access link inside the PDF.
Sign in to your Google account.
Select “Make a Copy” to save your personal version.
Review the START HERE instructions.
Replace or clear the generic sample entries.
Customize your categories, budgets, and warning periods.
Enter your subscriptions and recurring expenses.
Review upcoming renewals, savings opportunities, and dashboard insights.

Your copy is yours to edit and reuse.

━━━━━━━━━━━━━━━━━━━━
SAMPLE DATA
━━━━━━━━━━━━━━━━━━━━

Nine generic sample subscriptions are included so you can immediately see how the formulas, warnings, savings tools, and dashboard work.

The workbook includes clear instructions showing which cells can be safely cleared and which automatic formula cells should remain untouched.

Rows below the sample entries are already prepared with formulas and dropdown menus.

━━━━━━━━━━━━━━━━━━━━
FILES & COMPATIBILITY
━━━━━━━━━━━━━━━━━━━━

This purchase includes:

• 1 downloadable PDF with the Google Sheets template link
• 1 reusable Google Sheets template
• Generic sample data
• Built-in instructions

A free Google account is required to make and edit your copy. An internet connection is required when accessing the template for the first time.

The tracker is designed for Google Sheets and modern versions of Microsoft Excel. It uses standard spreadsheet formulas and does not require macros, VBA, Apps Script, external APIs, web scraping, or a paid subscription.

Minor differences in fonts, dropdowns, charts, conditional formatting, or layout may occur when using Microsoft Excel.

━━━━━━━━━━━━━━━━━━━━
PRIVACY & IMPORTANT NOTES
━━━━━━━━━━━━━━━━━━━━

• This is a DIGITAL PRODUCT. No physical item will be shipped.
• Subscription information must be entered and updated manually.
• The tracker does not connect to bank accounts, credit cards, subscription services, or payment providers.
• It does not send emails, notifications, or automatic cancellation requests.
• Never enter passwords, full card numbers, bank-account numbers, or other sensitive credentials.
• Payment-method fields are intended only for broad labels such as credit card or digital wallet.
• This product focuses on recurring expenses and is not a complete household budgeting or bookkeeping system.
• Savings figures are estimates based on the information entered.
• This template does not provide financial, accounting, tax, or legal advice.
• This purchase is for individual or household use. The template may not be resold, shared, reproduced, or redistributed.
• Due to the digital nature of this product, returns and exchanges are generally not accepted. Please contact me if you experience any trouble accessing your template.