Bills & Subscriptions Due-Date Tracker (Excel)
Electricity every month, broadband every quarter, the streaming app once a year, the car insurance on some date in March: list each bill once with how often it comes and when it was last paid, and the workbook works out the next due date, counts the days left and flags anything overdue or due soon. An Upcoming sheet lists the next bills in date order, and a 12-month calendar shows how much money each month needs. Mark subscriptions you want to review or cancel and see what they cost in a year.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
| # | Bill | Due date | Amount | Days left | Status |
| 1 | DTH recharge | 02-10-2026 | 350 | -31 | Overdue |
| 2 | Home broadband | 05-11-2026 | 2,997 | 3 | Due soon |
| 3 | Society maintenance | 10-11-2026 | 3,500 | 8 | OK |
| 4 | Electricity | 12-11-2026 | 2,400 | 10 | OK |
| 5 | Mobile postpaid (2 lines) | 18-11-2026 | 1,198 | 16 | OK |
| 6 | Video streaming | 22-11-2026 | 649 | 20 | OK |
| 7 | Gym membership | 01-12-2026 | 4,500 | 29 | OK |
| 8 | Music streaming | 03-12-2026 | 119 | 31 | OK |
| 9 | Car insurance | 20-12-2026 | 14,800 | 48 | OK |
What's inside
- Bills sheet: bill or subscription, category, provider, consumer or account number, amount, frequency (monthly, every 2 months, quarterly, every 4 months, half-yearly, yearly or one-time), first due date, last paid date, auto-pay and paid-from
- Next due date, days left and status (Overdue, Due today, Due soon, OK) calculated for every bill
- Yearly and monthly cost of every bill, and a Keep / Review / Cancel column for subscriptions
- Upcoming sheet: the next 30 bills in date order with amount, days left and auto-pay
- Calendar sheet: 12 months side by side showing which bills fall due in which month, with the total needed each month and a chart
- Summary: yearly cost of all bills, monthly average, overdue and due-soon counts, and the yearly cost of the subscriptions marked Review or Cancel
How to use it
- On the Settings sheet type your currency symbol and how many days ahead you want a "Due soon" warning (7 to start with). "As on" is today unless you type another date.
- On the Bills sheet replace the sample bills with your own: name, category, amount, how often it comes and the first due date you know of (any past due date works).
- Each time you pay a bill, type the payment date in "Last paid on". The next due date moves forward by itself.
- Open the Upcoming sheet every week or so to see what is due next.
- Use the Calendar sheet to plan months with several big bills, and the Keep / Review / Cancel column to decide which subscriptions are worth keeping.
Tips
- For bills whose amount changes (electricity, water), type the usual amount; update it when the bill arrives if you want the calendar to be exact.
- Auto-pay bills still deserve a glance: a failed debit can mean a late fee. Keep the "Pay from" column so you know which account must have money.
- Only note the last 4 digits of account or card numbers. Never store passwords, PINs or OTPs in this file.
- Bills due on the 29th, 30th or 31st move to the last day of shorter months, as most billers do.
Questions and answers
How does it work out the next due date?
It starts from the first due date and steps forward by the bill's frequency until it passes the date you last paid. If you have not paid yet, the first due date itself is the next due date, so an unpaid old bill shows as Overdue.
Does it send reminders?
No. Excel files cannot send messages. Open the Upcoming sheet regularly, or use the dates to set reminders in your phone calendar.
What about weekly payments?
This tracker works in months. For a weekly payment, such as a newspaper or a milk bill paid weekly, enter the monthly total as a monthly bill.
Can I use it for yearly renewals like insurance or the car service?
Yes. Choose Yearly as the frequency. For documents and insurance policies with more detail, the Family Documents & Policies Index in this toolkit is a better fit.