Set a Monthly Cut-Off for Household Budget Records
Choose which month each household budget record belongs to, document your date rule, and carry unresolved items forward using existing statements and receipts.
To set a monthly cut-off for your household budget records, choose the month's start and end, write down which date determines where an entry belongs, and retain other dates as references. You can then assign records using that written rule and keep uncertain entries on an unresolved list. The task is to document which month each record belongs to, while keeping monthly planning arithmetic separate from a dated bank balance.
Choose the monthly boundary
As an optional starting point, use a calendar month and write its name at the top of your worksheet. Record the opening and closing dates beside it. If you prefer another monthly period, state its exact boundaries and use those boundaries throughout that worksheet.
Keep the period covered by each supporting statement beside its reference. For this worksheet, assign individual entries using your chosen monthly rule rather than assigning the entire statement to the month printed on its cover. Leave records outside your chosen period available for the neighbouring month's worksheet.
The Reserve Bank of Australia describes money as having taken physical forms throughout history, alongside its present form in digital bank records. [1]
For your own records, you could apply the same monthly boundary to purchases documented by receipts, a cash-spending log or bank records. Keep the payment method in a separate field rather than creating different monthly boundaries for cash and electronic purchases.
Write a date rule for each record
An optional purchase rule is to use the purchase date shown on a verified receipt. Retain the date shown on the matching bank entry in another field. Write the rule above the worksheet so that the basis for assigning the purchase remains visible when you revisit it.
For a bank entry without a receipt, you could provisionally use the transaction date shown on the statement. Label that date basis explicitly. If available records disagree about the purchase date or amount, put the question on your unresolved list before changing the monthly assignment or total.
For planned bills, you could assign the planned cost to the month containing the due date recorded on the existing bill. Label this as a planning rule. Keep the bill amount, due date and document reference together; do not reconstruct the amount from prices or usage information.
If you choose to spread a longer-period planned cost across monthly worksheets, keep that allocation in a separate planning field. Preserve the original bill total and due date beside it. Choose whether the planning total uses the allocation or the full bill amount, and document that choice without adding both for the same cost.
Record income under a stated monthly rule too. Keep uncertain or one-off income separately labelled rather than silently including it as a dependable amount in every month's plan.
Keep one monthly entry for each purchase
You could use these fields for each purchase entry:
- Purchase reference and brief description.
- Amount, with an explicit A$ label for Australian-dollar records.
- Purchase date and any separate bank-record date.
- Assigned budget month and the date rule used.
- Payment method and supporting document references.
- Verification status and any unresolved question.
Use one row per purchase transaction. Attach the receipt reference and matching bank-entry reference to that row, and record the purchase total once. When documents place the same purchase on different dates, retain both dates without creating another expense row.
For cash purchases, use a verified receipt or cash-spending log and identify cash in the payment-method field. Keep cash withdrawals outside the purchase-spending total. A withdrawal alone does not identify what was bought; adding both the withdrawal and the documented cash purchases would count that spending twice.
Keep purchase verification separate from bank matching. A verified receipt or cash log can establish an expense while its bank match remains unresolved. An unexplained bank entry should remain unresolved until you verify its records; do not label it a cash purchase merely to close the question.
The Reserve Bank explains that different forms of money are connected by people's trust in their use for paying and receiving payment, expressing prices and retaining value over time. [1]
For this worksheet, you could express Australian-dollar amounts consistently in A$ and preserve the amount shown on each supporting record. Keep document references alongside the amounts so that any later change has an identifiable basis.
Close the month with unresolved items visible
At your chosen monthly review, check entries near the boundary against the written date rule. For each entry you move, leave a short note naming the supporting record and the reason for its new monthly assignment. Update the affected monthly worksheets together.
Keep an unresolved list beside the monthly worksheet. Record the available amount, relevant dates, document reference and the question still to answer. Where the amount itself is uncertain, state that uncertainty rather than entering zero as though no cost exists.
If spending records remain incomplete, label the sum of verified purchases a provisional subtotal. State what remains unresolved. Keep the planned household cost total separately labelled, and avoid presenting the provisional purchase subtotal as complete actual monthly spending.
You could also mark the worksheet with its review date and retain the earlier version when making subsequent corrections. Choose any reminder schedule yourself; the purpose here is simply to record when you intend to revisit open questions.
Read the monthly planning example
The example below uses fixed hypothetical monthly income and costs. It illustrates the monthly planning calculation after those inputs have been assigned to the monthly plan.
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 | A$4,800 |
| Total monthly planned costs | A$3,900 |
| Monthly amount left: 4800 minus 3900 | A$900 |
| Amount set aside after 6 months: 900 times 6 | A$5,400 |
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.
Monthly income minus monthly costs is a planning surplus. Under the example's stated assumptions, all of that surplus is set aside each month. Keep this illustration separate from unresolved actual records, and retain its assumptions when reading the result.
The calculation does not establish money available on a particular date. A dated balance also needs the starting balance and the dates and amounts of income and payments. Likewise, a monthly allocation towards a later bill does not establish that the bill's full amount is available before its due date.
Frequently asked questions
Which date should I use when a receipt and statement differ?
For the optional method above, use the verified receipt's purchase date to assign the purchase month and retain the bank date as a reference. If the evidence conflicts, record the question as unresolved before changing the entry.
Can I close the worksheet with missing records?
You can mark it as reviewed while retaining an unresolved list. Label verified purchase totals as provisional when relevant records are incomplete, and state which questions remain open.
Should I change the rule when a month looks expensive?
Keep the documented rule for that worksheet. If you choose a different rule for future monthly records, write down when it starts. Reassigning an entry should follow the recorded basis and supporting evidence, rather than a preferred monthly result.
This article is general information, not personal financial advice.
