Roll Your Household Budget Forward to a New Month
Create a new monthly household budget from your previous worksheet, review carried-forward figures against existing records, and keep unresolved costs visible.
To roll your household budget forward to a new month, preserve the previous worksheet, create a fresh planning copy, and review each income and cost entry against your existing statements and bills. Carry forward the categories you still need, but mark every retained amount as a planning figure until you have reviewed its basis. Keep unresolved amounts visible alongside the new plan.
Govt.nz describes a budget as something that can support your control over money and how you use it. [1]
The optional process below focuses on one administrative task: preparing the next monthly worksheet from the one you already have. Use it with paper records, a spreadsheet or your existing budgeting document.
Preserve the previous month's worksheet
You could begin by saving the previous month's worksheet under its month and year. Keep that version separate from the document you will edit. If you use paper, put the previous worksheet behind a clearly labelled monthly divider before starting another sheet.
Retain the status of the old figures. For example, leave an estimated cost labelled as estimated, and keep any unresolved note attached to its entry. Treat this saved version as a record of what you had documented at that point. Saving it does not establish that every expense has been accounted for.
Optionally, place the supporting statements and bills with that version, or retain references to where you already store them. Avoid moving the only copy of a document into the new month's folder if you still need it to explain a previous entry. A reference can point to the existing record without creating another budget expense.
Create a new monthly planning copy
Make a separate copy headed with the month you are planning. You could retain the category names and notes that describe what each category includes. Clear previous actual-spending totals and previous calculated differences from the new planning fields; preserve them in the archived worksheet instead.
A compact rollover checklist could use these fields:
| Field | What you could record |
|---|---|
| Entry | The income source or cost category |
| Previous planned amount | The figure from the old worksheet |
| New planned amount | The figure proposed for the coming month |
| Basis | The statement, bill or planning assumption used |
| Review note | What you checked or still need to check |
Keep previous and new planned amounts in separate columns during the review if that suits your document. Label the columns explicitly so that an old figure is not presented as evidence of the coming month's cost.
Choose one monthly planning basis for the whole worksheet. Where an existing entry represents a monthly allocation towards a less frequent bill, you could retain that description beside it. Keep the allocation distinct from the bill's full amount and due date; a monthly planning average is not money available before payment is due.
Review each carried-forward figure
Work and Income says a household budget should reflect new income and costs, with goals reconsidered where needed for the household's circumstances. [2]
For your own rollover review, you could read each income entry alongside the existing record supporting it. Write whether the new planned amount is unchanged, revised or still uncertain. Keep one-off or uncertain income separately labelled rather than carrying it into the dependable monthly total without qualification.
Next, review each cost entry against the relevant existing bill, statement or planned-cost note. Record the basis for retaining or changing the amount. If your available document relates to an earlier period, keep that period visible in the reference rather than describing it as a bill for the new month.
Keep category definitions consistent during this review. If you decide to change what a category includes, write the new scope beside its planned amount. For instance, a groceries category and a category covering groceries plus household supplies have different boundaries. Avoid carrying the old amount into the renamed category without noting the changed scope.
You could mark a previous one-off cost as excluded from the new plan after reviewing it. Retain its history in the old worksheet. For a cost that remains uncertain, use the unresolved list rather than deleting the entry simply because you lack a new amount.
Keep unresolved amounts visible
Create a short unresolved list beside the new worksheet. For each item, you could record the missing information, the document you intend to check and the entry affected. Optional labels include “amount awaiting review”, “period unclear” and “supporting record missing”.
If you choose to use an estimate while waiting, label it and record its basis. If you leave an amount blank, state explicitly that the cost has not been included. An unknown amount is not a zero-cost entry. Describe a total that excludes unresolved costs as a provisional subtotal, rather than the complete household cost total.
Optionally, add a reminder to revisit each unresolved item when you expect to review your records. Choose a review date that suits your household. Keep the reminder separate from the financial amount: a note to check a bill is not another expense.
Read the monthly planning surplus
Once you have assembled the monthly income and cost inputs, the worked example below illustrates income minus costs. It uses hypothetical fixed figures and assumes that all surplus is set aside each month under the stated conditions.
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$4,800 |
| Total monthly planned costs | NZ$4,350 |
| Monthly amount left: 4800 minus 4350 | NZ$450 |
| Amount set aside after 6 months: 450 times 6 | NZ$2,700 |
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.
The result is a planning surplus. It does not establish the money available in a bank account on a particular day. A dated balance also needs the starting balance and the dates and amounts of income and payments.
For your worksheet, you could place any uncertainty note immediately beside the result. If costs remain outside the total, do not label the calculation as a complete household surplus. Keep any existing commitments and payment dates available for a separate check before treating money as available to spend or set aside.
Finish the monthly handover
Before filing the new plan, you could check that its month is labelled, its figures have stated bases, and its unresolved list remains attached. Leave the previous version available for reference. If another household member uses the worksheet, add a short note identifying which version is the current plan and where its supporting records sit.
Frequently asked questions
Can I copy an unchanged amount into the new month?
You can choose to retain it as a planning assumption. Record what you reviewed and keep the supporting document's period visible. Do not describe the copied figure as a newly verified cost without the relevant record.
Does saving the old worksheet mean the month is complete?
No. Preserve any missing-record notes and provisional labels. An archived worksheet records its documented position; unresolved entries still need attention.
Should the previous month's surplus become new income?
Keep it separate from new income in this process. A planning surplus alone does not establish an opening bank balance. Carry forward a dated balance only with the records needed to support that balance.
This article is general information, not personal financial advice.
