Household Bills Tracker

Who this is for

Every bill for the month, ticked off as it is paid. Bill, provider, due day, amount and date paid on each row, with what is still outstanding kept count of.

Anyone who has ever paid a late fee because a bill was in a drawer, and households where more than one person pays bills and neither is sure what the other has done.

What this helps you track

• Which bills are due this month and on what day
• Which have been paid, when, and by what reference
• The amount still to go out before the month ends
• The month's total for bills, to carry into a budget

How to use it

1. Write the month at the top. Enter every regular bill with the provider and the day of the month it is due — the day number is enough.
2. Fill in the amount as soon as the bill arrives; for a fixed direct debit, fill it in at the start of the month.
3. When a bill is paid, tick the box and write the date and any payment reference.
4. The still-due column clears itself when the box is ticked; the browser and spreadsheet versions total what is paid, what is outstanding and how many bills remain.
5. At the end of the month copy the unpaid rows to next month's sheet — the bill and provider columns rarely change, so the online version can be duplicated and the ticks cleared.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Is this the same as the bill payment calendar?

They share a purpose but not a shape. This tracker is a list ordered however you like, with provider and reference details. The calendar is arranged by due date across the month, for seeing what falls when.

How does the still-due column work?

It shows the amount until the paid box is ticked, then shows nothing. The total at the foot and the outstanding figure in the summary are the sum of that column.

What if a bill amount changes every month?

Leave the amount blank until the bill arrives, then fill it in. The outstanding total only counts rows with an amount, so a blank row does not distort it.

Can two people use it at once?

On paper, yes — it lives on the fridge for that reason. The browser version saves in one browser, so each person's copy is separate; print it or share the downloaded PDF if both need to see the same sheet.