Bill Tracker

What it does

• Bills list: bill name, category, due day, how often (monthly, every 2 months, quarterly, twice a year or yearly), first due month, usual amount, autopay, the account you pay from and notes
• Works out each bill's cost per year and per month, its next due date and the days until then
• 12-month bill checklist: type the amount when you pay. Green = paid, yellow = due this month, red = overdue, grey = not due that month
• Bills that change every month (power, gas, water): type the real amount you paid
• Dashboard: this month's bills in due-date order with a status for each (Paid, Due today, Due in 4 days, Overdue), due, paid and left to pay this month, overdue bills and amount, paid so far this year, bills on autopay
• Month table and two charts: due and paid by month, and bills per year by category
• Status date is =TODAY() by default, so overdue and due-this-month update by themselves
• Room for 50 bills, 15 categories and 8 accounts. Works in any currency
• Want a full paycheck budget too? Our 2027 Paycheck Budget Planner is the budget version; this one is just for bills

What you get

• XLSXBill-Tracker.xlsx (blank)
• XLSXBill-Tracker-with-Sample-Data.xlsx (a filled-in example: 18 bills, paid January to September and part of October)
• PDFQuick-start guide (PDF)

Good for

Anyone who wants every monthly, quarterly and yearly bill in one place, with a simple monthly check that nothing was missed.