ELSE COURT

Home › Personal Finance › Subscription Tracker Spreadsheet & Bill Calendar

The Subscription and Bill Tracker, a spreadsheet for Excel and Google Sheets. The Dashboard shows monthly and yearly cost, what is due in the next 30 days, payments not logged, free trials about to charge and what you save by cancelling, with charts by category and by month. Tabs: Start Here, Dashboard, Subscriptions and Bills, Payments, Calendar.

Subscription Tracker Spreadsheet & Bill Calendar

Most people know roughly what they pay for streaming and apps, and much less about the annual renewals, the free trial that is about to charge and the bills that fall due the same week. The Subscription and Bill Tracker puts everything you pay again and again in one list.

For each item you enter the amount, how often it is billed and one billing date. The sheet works out the monthly and yearly cost, moves the date forward by itself to the next due date, flags what is coming up and adds up what you would save by cancelling the items you marked.

It is a digital download for Excel and Google Sheets, for households, freelancers and small businesses. It does not connect to a bank, so the list stays in your own file.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Who it's for

How it works

  1. Fill in Start Here: a currency label and how many days ahead to look.
  2. List your subscriptions and bills with amount, cycle and one billing date.
  3. Set the status, mark auto-pay and choose Keep, Review or Cancel.
  4. Optionally log payments, then read the Dashboard and the Calendar.

See it in action

See inside

Subscriptions and Bills tab: one row per subscription or bill with type, category, amount, billing cycle from weekly to yearly, a billing date, status, auto-pay and a Keep, Review or Cancel decision. Monthly cost, yearly cost, next due date, days left, last paid and an alert such as Due in 6 days or Payment not logged calculate themselves.Dashboard with 8 tiles (monthly cost, yearly cost, active items, due in the next days, due by month-end, paid this month, free trials, what the cancel list saves), a watch list, a chart of monthly cost by category, a chart of what is due each month, a coming up list, a needs attention list, a category summary and the top 5 by yearly cost.Calendar tab: the next 12 months, one line for each active subscription or bill, showing the amount due in every month and a total for each month. Weekly, every 2 and 4 weeks, monthly, every 2 months, quarterly, every 6 months and yearly cycles are all handled. Months with a payment are shaded.The Dashboard watch list and the lists of what is coming up and what needs attention: bills due in the next days with the amount, free trials about to turn into a charge, and bills you pay by hand with no payment logged, shown in red.Mark each subscription or bill as Keep, Review or Cancel. The Dashboard shows the number of items, the monthly and yearly cost for each decision, the top 5 by yearly cost, the cost by category and a plain sentence with how much the items marked Cancel would save in a year.Payments tab: log the date, the item and the amount you paid. The sheet shows the expected amount and the difference, in red when a bill came out higher and in green when lower, and checks every row. Logged payments clear the Payment not logged alert on bills you pay by hand.The 5 tabs of the Subscription and Bill Tracker (Start Here, Dashboard, Subscriptions and Bills, Payments, Calendar) and what is included: a blank Excel workbook, an Excel file with a sample household of 30 subscriptions and bills and 11 payments, a PDF Quick Start Guide and a Google Sheets Make a copy link. No macros.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get an Excel workbook and a PDF guide with a link to make your own copy in Google Sheets. The two versions are separate files and do not sync.

Does it connect to my bank or send reminders?

No. It does not connect to any account and sends no emails or notifications. Open the file to check what is due.

Do I have to update the dates?

No. Enter any one billing date, past or future, and the sheet moves it forward to the next due date.

Does it cancel subscriptions for me?

No. It only records your decision and adds up what cancelling would save.

Is there an example file?

Yes. A second Excel file is filled with example data (a household with 30 subscriptions and bills and 11 payments), so you can see how everything works before using your own numbers.

Read the guide

A clean white desk with a notebook and pen next to an open laptop showing a monthly budget dashboard with charts and spending categories.
How to Make a Monthly Budget in a Spreadsheet (Step by Step)A seven-step way to plan your month, with an example budget table and the formulas that compare planned and actual spending.

More in Personal Finance

The Paycheck Budget, a spreadsheet for Excel and Google Sheets. Plan every paycheck, know what remains. The Dashboard shows Safe to Spend, left after this paycheck, projected balance, next payday and the lowest point ahead, with charts for the next 12 months. Tabs: Start Here, Dashboard, Paychecks, Bills, One-time.
Paycheck Budget Spreadsheet for Excel & Google SheetsSee which bills each paycheck covers, what is left after it and how much you can safely spend.
The Savings Tracker spreadsheet for Excel and Google Sheets, for sinking funds and savings goals. A preview shows the dashboard with total saved, progress, the amount needed per month, rings for your funds and charts by month.
Savings Tracker & Sinking Funds SpreadsheetFollow your savings goals and sinking funds with a simple dashboard.
The Budget Planner spreadsheet for Excel and Google Sheets, with monthly budget vs actual, bills and an expense tracker. A preview shows the dashboard with income, spent, saved and left over, bills to pay, charts and categories over budget.
Monthly Budget Spreadsheet for Excel & Google SheetsPlan income, bills and spending, and compare budget with actual each month.
The Debt Payoff Planner debt snowball and avalanche spreadsheet for Excel and Google Sheets, with room for 50 debts. A dashboard preview shows total debt, debt-free date, total interest and interest saved, with labels for Snowball, Avalanche, Custom order, Interest saved and Debt-free date.
Debt Payoff Tracker Spreadsheet (Snowball & Avalanche)Plan debt payoff with snowball and avalanche calculators.

Ready to get organized?

View on Etsy