Split Mixed Purchases Across Monthly Budget Categories
Use existing receipts and statements to allocate mixed purchases across your monthly household budget, with separate notes for missing details and refunds.
To split a mixed purchase across monthly budget categories, record the purchase total once, then allocate its items to the categories already used in your plan. Check that those allocations add back to the full receipt total. For a New Zealand household, this might mean separating food, cleaning supplies and personal items bought together, while retaining a single record of the payment.
The worksheet approach below is optional. Use it for purchases that cross category boundaries, drawing on existing receipts, bank statements and your planned monthly costs. Keep your current category names unless you deliberately decide to revise them.
Set the monthly boundaries
Work and Income recommends making or revisiting a budget to develop your understanding of managing money and check that the plan continues to serve its purpose. [1]
Start your worksheet by writing the month it covers. Choose a date rule for assigning purchases to that month, such as the purchase date shown on the receipt, and record that rule at the top. Where a statement shows a different date, retain it in a separate field rather than silently changing the purchase date.
Next, copy the relevant category definitions from your monthly plan. If your groceries plan covers food only, allocate cleaning products and toiletries elsewhere. If your existing plan explicitly combines those items, use that same combined definition when organising actual purchases. Keep the planned amount and the recorded spending on the same basis.
Choose the household scope as well. For this worksheet, you could include purchases paid from household money and leave separately funded personal purchases outside it. Write down your choice before allocating a mixed receipt. If a purchase includes an amount outside that scope, retain a separate allocation for it so the full receipt still reconciles.
Record each purchase total once
Create one main row for each purchase transaction. A receipt and its matching bank entry are two records of that purchase; enter the expense total once. Put references to both records beside that total.
You could use these fields in the main purchase record:
| Field | What to enter |
|---|---|
| Purchase reference | Your own label linking the records |
| Purchase date | Date used under your monthly rule |
| Purchase total | Full supported transaction amount |
| Payment method | Card, cash or another recorded method |
| Evidence reference | Receipt, statement or cash-log reference |
| Matching status | Matched, unresolved or not applicable |
Keep the category allocations in a separate section linked by the purchase reference. Do not repeat the full bank transaction amount as the expense for every category appearing on the receipt.
For cash purchases, use a receipt or cash-spending log and mark the payment method as cash. Keep cash withdrawals separate from purchase spending. A withdrawal alone does not identify what was bought, and adding both the withdrawal and the resulting purchases would count that spending twice.
Allocate the receipt across existing categories
Working through the receipt, assign each item to an existing category. You may group items belonging to the same category into a single allocation, provided you retain the receipt reference. Use the amounts supported by the receipt rather than estimating item prices from memory.
Add the allocations and compare their sum with the single purchase total. Include any out-of-scope personal portion in this check, even though you will exclude it from household category totals. Finish the reconciliation before carrying supported allocations into the monthly worksheet.
If the sums differ, leave the allocation unfinished and inspect the records. Do not force the difference into groceries or another convenient category. Record what remains unexplained and which receipt or statement needs checking.
Once reconciled, carry only the relevant allocation into each category. For a groceries-only comparison, add the food allocations across the month's purchases. Do not compare every supermarket transaction, including non-food items, with a food-only planned amount.
Keep missing details and refunds visible
Keep evidence status separate from matching status. A verified receipt or cash log can establish an expense even when its bank match remains unresolved. Record that supported purchase once and leave a note about the outstanding match.
Where the purchase itself or its amount is uncertain, put it on a separate unresolved list. Describe the missing evidence without inventing an explanation. An unmatched bank entry should remain unresolved while you check the records; do not relabel it as a cash purchase. Identical entries also call for investigation rather than an automatic conclusion that a charge was duplicated.
For a known purchase total with an incomplete category split, retain the total and mark the allocation as unresolved. Do not treat the unallocated portion as zero. Until the relevant records and allocations are accounted for, label the sum of verified category purchases as a provisional subtotal and state what remains unresolved.
If a verified refund affects the worksheet, keep the original purchase and add a linked adjustment. One optional date rule is to assign the adjustment to the month of its recorded refund date. State that rule. Under it, actual category spending means purchase allocations assigned to the month minus verified refunded category portions assigned to that month. Subtract each portion once; leave an expected but unverified refund unresolved.
Carry allocations into the household budget
After accounting for the relevant purchases and adjustments, compare each category's actual spending with its planned amount. The difference is a category variance. It is not another expense to add to the household budget. If records remain unresolved, report the provisional subtotal and outstanding items instead of a final variance.
Use the full household plan when considering monthly income minus costs. The example below illustrates that whole-budget calculation; splitting a receipt only determines where its cost is recorded.
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,300 |
| Monthly amount left: 4800 minus 4300 | NZ$500 |
| Amount set aside after 6 months: 500 times 6 | NZ$3,000 |
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.
Treat the calculated difference as a planning surplus. It does not establish money available on a particular date. That would also require the starting balance and the dates and amounts of income and payments. A category underspend alone does not establish an amount available to spend or save without checking the whole household budget, existing commitments, current balance and payment dates.
If you meet with a financial mentor, Govt.nz recommends taking bank statements, bills and details of money you owe. It also says that information you share is confidential. [2]
You could keep your allocation worksheet alongside those records, with unresolved items clearly marked. This is an optional addition to your records, rather than a checklist prescribed by the source.
Frequently asked questions
Must I split every receipt?
You can reserve this worksheet for purchases crossing your existing category boundaries. Where a supported purchase belongs entirely to one category, assign its total there once.
What if I cannot identify an item?
Leave its category allocation unresolved and retain the receipt reference. Carry forward the supported details, but do not present the affected category subtotal as final while the item remains unallocated.
Should I change the planned amount to match spending?
For the comparison you are preparing, retain the original planned amount. If you choose to revise a future month's plan, record that separately rather than replacing the plan used for this month's comparison.
This article is general information, not personal financial advice.
