Expense, bill and debt trackersMonthly
Monthly bill tracker
A one-month bill sheet. Each bill has a paid checkbox, a due date, the amount due, the date it was paid, how it was paid and a confirmation number. Boxes at the bottom are for the month's bill total, what is paid so far and what is left.
- Type your details or print blank
- Print or PDF, Letter or A4
- Free, no sign-up
On this page
What prints
At the top is Monthly Bill Tracker with a write-in line for the month. The table has seven columns: a Paid checkbox, Bill, Due, Amount due, Date paid, Paid with and Confirmation. Under the table, a Reminders box on the left has room for notes, and three totals boxes on the right are labeled Total bills, Paid so far and Still to pay.
The totals boxes are blank. The sheet adds nothing up, so you write each figure in yourself.
The settings
- Heading. Type a custom title or leave it blank.
- Layout. This page is the one-month layout with amounts. The bill payment checklist is the whole-year version.
- Bills. From 8 to 24 lines. Count your regular bills, then add a couple of spare lines for surprises.
Setting up the month
Start by copying your bills onto the sheet in order of due date, earliest first. That way you can read down the page the way the month will unfold. Put the amount in as soon as the bill arrives. For fixed bills like rent it can go in on day one.
The confirmation column is the one people skip, and then wish they hadn't. When you pay online, a confirmation number is your proof that the payment went through on a certain day. Copy it down. If a bill is on autopay, still check that it actually came out of your account, since the CFPB advises watching the amount and timing of automatic payments.
Worked example: five bills in November
You list rent due on the 1st at $1,250.00, electric on the 12th at $96.40, internet on the 14th at $65.00, phone on the 20th at $82.60 and car insurance on the 25th at $143.00.
Total bills: 1,250.00 + 96.40 + 65.00 + 82.60 + 143.00 = $1,637.00. By the 15th you have paid rent, electric and internet, so Paid so far is 1,250.00 + 96.40 + 65.00 = $1,411.40, and you tick those three boxes. Still to pay is 1,637.00 - 1,411.40 = $225.60, which matches the phone and insurance bills together: 82.60 + 143.00 = 225.60.
Use the Reminders box for things like "call about the phone charge" or "insurance renews in January."
A last thought
Keep each month's sheet for a year or so. If a late fee or a billing mistake turns up, the date paid and confirmation number are what you will want in hand.
Using the Reminders box
The notes area is useful for anything that will not fit a table cell: a promo price that ends soon, a card that expires before the next payment, or a reminder to ask for a lower rate. Look back at it each time you start a new sheet, and carry over whatever is still open.
Sources
- CFPB: What is autopay? consumerfinance.gov