Track Paid and Unpaid Bills in a Monthly Budget Checklist
Create a monthly household bill checklist using existing bills and statements, with separate fields for planned costs, payment evidence and unresolved items.
To track paid and unpaid household bills, you can create a monthly checklist that links each bill to its budget entry, then record payment status separately using existing statements or payment records. Keep the planned cost in the budget once. Changing a bill’s status to paid should update its record, rather than add another expense.
Govt.nz describes budgeting as a way to support control over your money and make use of what you have. [1]
The checklist below is an optional recordkeeping method for a New Zealand household. Use it for a defined set of household bills alongside your wider monthly budget. Its purpose is to organise the documents and payment notes associated with those bills.
Choose the bills covered by the monthly checklist
Start by naming the month and writing a short scope note. You might choose to cover rent, power, internet and insurance payments already listed in your household budget. Keep the same scope when reviewing the checklist so that a blank row has a clear meaning.
Choose a monthly assignment rule and write it at the top. For this checklist, an optional rule is to place a bill in the month containing its stated payment due date. Record any service period separately. Apply your chosen rule consistently, and keep an overdue bill linked to its original month when following it up later.
Gather the existing bills, relevant statement entries and your planned budget amounts. Use the amounts shown in those records; do not rebuild a bill from usage figures or pricing information. Where a document is missing, add an unresolved note describing what you still need to check.
If your budget already assigns these costs to months differently, retain that basis and label the difference on the checklist. Avoid silently moving a cost between months just to make the payment record line up.
Create separate cost and payment fields
You can use a spreadsheet or a paper sheet. Give each bill a reference that connects its checklist row to the corresponding budget entry and document. Keep the planned cost, billed amount and payment evidence in separate fields rather than replacing one with another.
| Field | Optional entry |
|---|---|
| Bill reference | A label linked to the existing budget entry |
| Budget month | The month under your stated assignment rule |
| Planned cost | The amount already allowed for in the budget |
| Billed amount | The amount shown on the existing bill |
| Due date | The date stated on the bill |
| Payment record | Confirmed amount, date and record reference |
| Status and next check | Payment status and any unresolved question |
Leave an unavailable billed amount marked as unknown rather than entering zero. Retain the planned amount in its own field, labelled as planned. If you sum only bills with verified amounts, call that result a verified-bill subtotal and state which amounts remain unresolved.
For a bill with several payment records, you can keep those details beneath the main row. Retain a single bill total, with the supporting payment amounts listed separately. Do not repeat the full bill amount as an expense for each payment entry.
Update payment status from existing records
Choose a small set of status labels with written meanings. For example, use “payment not confirmed”, “scheduled”, “part paid”, “paid” and “unresolved”. These are optional worksheet labels; define them according to the evidence you intend to record.
Reserve “scheduled” for a payment instruction you have recorded but have not yet confirmed as completed. Keep “paid” for a bill whose supporting payment record has been checked against that bill. Include the record reference so you can return to the evidence behind the status.
Where the records support a partial payment, record the confirmed amount and leave the bill marked “part paid”. Only calculate a remaining amount when the bill total and the payments assigned to it are established. Leave unexplained differences unresolved rather than supplying a guessed explanation.
Treat payment matching and the bill amount as separate questions. You can have a verified bill amount while still needing to establish which payment relates to it. Keep that cost visible and describe the missing payment link in the notes.
Keep the checklist separate from whole-household totals
Use the checklist to record the status of the bills within its scope. Keep the whole-household monthly calculation in the main budget, including costs outside the checklist. Avoid adding the checklist total to a budget total that already contains those same costs.
The worked example below illustrates monthly income minus all included monthly costs. It does not calculate a surplus from paid bills alone or from the selected bills on your checklist.
Hypothetical cash-flow example
These invented figures demonstrate arithmetic, not typical incomes or recommended spending amounts. Assume take-home income and all planned costs stay the same each month. Costs include essentials, required debt payments and other planned spending. Start with no money set aside for this example; assume no interest, fees, withdrawals or unexpected costs.
| Item | Amount |
|---|---|
| Monthly take-home income | NZ$5,200 |
| Total monthly planned costs | NZ$4,650 |
| Monthly amount left: 5200 minus 4650 | NZ$550 |
| Amount set aside after 6 months: 550 times 6 | NZ$3,300 |
This total is possible only if the full amount left is set aside each month under these assumptions. It is not a forecast. If income falls or costs rise, recalculate before choosing an amount to set aside.
A monthly planning surplus does not show the cash available today or before a bill is due. Check the current balance and the dates and amounts of expected income and payments before setting money aside; keep money needed for bills available.
Read the example’s remainder as a planning surplus under its stated assumptions. A bill becoming paid changes its payment status; it does not create another cost to subtract from that same monthly plan.
Keep dated cash questions separate from monthly arithmetic. To establish a balance on a particular date, you also need an opening balance and the dates and amounts of income and payments. Neither a positive monthly remainder nor a list of unpaid bills supplies those details on its own.
Close the monthly checklist with unresolved items visible
Work and Income recommends revisiting an existing budget to consider whether it is still serving its purpose. [2]
As an optional monthly review, compare each checklist row with its linked budget entry. Record any proposed cost revision separately from the payment-status update. If you replace a planned amount with a verified amount in the main budget, retain a note of the amount used and the supporting document.
Before filing the month, list unresolved bill amounts, payment links and document requests together. Give each item a next action, such as checking a statement or locating a bill. Choose a reminder date if useful, without treating that reminder as a payment date.
If an unpaid bill needs attention in the following month, carry forward a reference to the original row. Mark it as an earlier-month item and retain its history. Under the assignment rule described above, the follow-up reference is not a new bill expense.
Frequently asked questions
Does a scheduled payment mean the bill is paid?
Keep those statuses separate in this optional checklist. Record the scheduling instruction, then update the status when you have checked the completed payment record against the bill.
What should I do when a statement entry does not match a bill?
Record the entry as unresolved and check the underlying documents before assigning it. Keep any independently verified bill amount visible. Do not invent a reason for the difference or silently change the monthly total.
What records should I take to a financial mentor?
Govt.nz says bank statements, bills and details of money you owe are useful to bring when meeting a financial mentor. [1]
This article is general information, not personal financial advice.
