Bill Calendar & Subscription Tracker
Every bill and subscription on one printable month calendar, with due-date alerts, an annual overview and a cancel list that shows what you would save
Instant download · personal-use license · lifetime updates
Pay with PayPal or any card
- 8 sheets
- Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 123 KB
Set it up, use it for at least a week, and if it genuinely isn't right for you, send us a message within 14 days with a screenshot of your setup and we'll refund you in full.
Type a bill in once — amount, due day, how often it repeats and the next date it is due — and the tracker does the rest. It works out the monthly equivalent (a 720 semi-annual insurance bill is 120 a month), the annual cost, how many days you have left and whether the bill is Paid this period, Due soon, Overdue or Scheduled. Sixty bills fit, at any of six frequencies: weekly, biweekly, monthly, quarterly, semi-annual and annual.
The Calendar tab draws a real month grid — pick the month and the week start in Settings and it redraws itself, with the total due and the number of bills on each day, today highlighted, and a month total, daily average and busiest day underneath. It is built to print, so it can live on the fridge.
The Subscriptions tab is where the money hides. List up to 50 services, mark whether you actually used each one in the last 30 days, and decide Keep, Cancel or Undecided. The Dashboard adds up the annual cost of everything you never open and exactly what cancelling your "Cancel" list would save you in a year — plus free-trial dates that count down before they turn into a paid subscription.
The Payment Log gives you twelve months of tick boxes with the value paid and what is still outstanding this month, and the Annual Overview spreads every bill across the year so the expensive months stop being a surprise. Built for Excel 2016+ and Google Sheets with classic, compatible formulas only — no macros, nothing locked. Sample data for a real household is filled in so nothing looks empty on first open.
What you get
- 8 sheets: Start Here, Settings, Dashboard, Bills, Calendar, Subscriptions, Payment Log, Annual Overview
- 60 bills × 6 frequencies (weekly, biweekly, monthly, quarterly, semi-annual, annual) with automatic monthly and annual cost
- Printable month calendar that redraws for any month and either week start, with the amount and number of bills on each day
- Status per bill — Paid this period, Due soon, Overdue, Scheduled — from your reminder days and last-paid date
- 50 subscriptions with used-in-the-last-30-days flag, Keep / Cancel / Undecided decisions and the yearly saving from cancelling
- Free-trial end dates with a countdown alert before they turn into a paid subscription
- Dashboard with 12 KPIs (monthly bills, monthly and annual subscriptions, potential saving, due in 7 days, overdue, autopay %, unused services, live trials) and 4 charts
- 12-month payment log with counts, value paid, value still outstanding and a flag for every bill you have not ticked
- Annual Overview: every bill across all 12 months with running totals and a built-in check that the year adds up
- Works in Excel 2016+ and Google Sheets · no macros · instant download (.xlsx + PDF guide)
Preview every page
Click any page to zoom.
What's inside
Questions
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, open it and choose File → Save as Google Sheets. Every formula, dropdown, chart and conditional format is Sheets-compatible. A short PDF walks you through it.
Can I print the calendar?
Yes — the Calendar tab is set up to print on one landscape page with the working columns kept off the printable area, so you get a clean month grid. Change the month in Settings and print the next one.
How does it handle bills that are not monthly?
Pick the frequency and the tracker converts it: weekly × 52 ÷ 12, biweekly × 26 ÷ 12, quarterly ÷ 3, semi-annual ÷ 6, annual ÷ 12. The calendar puts weekly bills on every matching weekday, biweekly bills every fourteen days from the next due date, and everything else on its due day in the months it actually falls due.
Do the due-date alerts update by themselves?
Yes. Days until due and the statuses are based on today's date, so they are correct every time you open the file. You choose how many days of warning each bill gets.
What do I do after I pay a bill?
Put the date in "last paid" and move the next due date forward one cycle. The status changes to "Paid this period" straight away, and you can tick the month on the Payment Log.
Can I change the currency and the categories?
Yes. The currency symbol, the 12 categories and the 8 payment accounts all live on the Settings sheet and can be renamed — every dropdown and chart follows.
Is anything locked or macro-based?
No. No macros, no protected sheets, no external links. Blue-on-yellow cells are inputs; black cells are formulas.
Reviews
No reviews yet — this product is new. Every review here comes from a verified purchase.
Personal-use license for one household. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.
