Bill Payment Tracker

Every household bill with its due day, what is still to pay this month, and what the year costs.

Free

Download .xlsx

No signup, no email. Yours to edit and use commercially.

47: live formulas, each one recalculated and checked
8: columns: Bill, Provider, Due day, Amount, Paid?, Still to pay, Status, Annual cost
8: figures worked out for you

A household managing due dates — usually looking for this when a bill was missed and a late fee arrived.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.

About this Bill Payment Tracker template

Missing a bill payment usually costs more than the bill. This free Excel bill payment tracker lists every household bill with its provider, due day and amount, lets you mark each one paid, and flags any that are overdue against today's date.

The monthly summary shows the total due, what has been paid, what is still to pay, overdue bills and their value, and what your bills cost over a year.

Good for

→Keeping on top of monthly household bills
→Seeing the real yearly cost of regular payments
→Sharing bill responsibilities with a partner or housemates

What it works out for you

This month

→Bills due
→Monthly total
→Paid so far
→Still to pay
→Overdue bills
→Overdue value
→Cost per year
→Largest bill

What is inside the Bill Payment Tracker template

The table has 8 columns. Calculated columns fill themselves in; the rest are yours to type over.

→Bill
→Provider
→Due day
→Amount
→Paid?
→Still to pay
→Status
→Annual cost

How to use the Bill Payment Tracker in Excel

Mark a bill Yes once paid. Status compares the due day against today, so overdue bills flag themselves.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.