Combine Two Draft Monthly Household Budgets
Bring two draft budgets for the same household and month into one worksheet, with source references, recorded row decisions and a separate unresolved list.
To combine two draft monthly household budgets, bring their entries into a working table, compare rows covering the same cost, and choose one treatment for each entry in the combined plan. Keep the original drafts and record unresolved differences separately. The task is to assemble one monthly plan from overlapping worksheets, with a record of the decisions you made.
The optional method below is for drafts covering the same household and month. You can use existing statements, bills and planned costs to review the entries without changing the underlying records.
Set the scope of the combined worksheet
A budget planner provides headings under which you enter income and spending figures. [1]
For this exercise, you could create a blank destination worksheet with separate income and cost sections. Add a short scope note stating the month, whose finances it covers and which two drafts you are combining. Give each original draft a recognisable name and retain it as a reference copy.
Before copying figures, compare the scope of the drafts. One might cover the whole household while the other contains only one person's costs. If their coverage differs, you could mark the extra rows for review rather than treating both draft totals as comparable. Choose the intended household scope before calculating a combined total.
You could also label the destination explicitly as a monthly plan. Keep actual payments in a separate column or supporting record if you need them for comparison. When choosing a planned amount, record that decision rather than silently replacing it with a payment found on a statement.
Bring both drafts into a staging table
An optional staging table lets you place the original entries together before deciding what belongs in the destination. Copy the row descriptions and amounts as written, including any notes about estimates or what a cost covers. Leave each row linked to its draft.
You could use these fields:
| Field | What to enter |
|---|---|
| Origin | Draft name and original row reference |
| Description | The wording used in that draft |
| Monthly amount | The amount proposed for the monthly plan |
| Coverage | What the entry includes |
| Supporting record | Relevant bill, statement or planning note |
| Decision | Retain, combine, exclude or unresolved |
| Destination | The corresponding row in the combined plan |
Treat this as a working list rather than a total to add up. You are collecting candidate entries; some might describe the same planned cost. Keep income candidates separate from cost candidates throughout the exercise.
If a draft contains only a broad subtotal, you could request its underlying rows or mark its coverage as unresolved. Avoid inserting both that subtotal and individual costs that it already includes. Record which treatment you choose beside the affected entries.
Choose one treatment for each planned cost
You could compare candidate rows by their coverage and supporting records, rather than their names alone. A row labelled ‘phone’ and another labelled ‘mobile’ deserve examination before you decide whether they represent the same planned commitment. Matching wording alone is also insufficient grounds for removing a row.
Where both drafts deliberately include the same cost, choose one destination row and link both original references to it. Mark the other candidate as represented by that destination. This is a decision about overlapping budget records; it does not establish that a provider charged twice.
Where one draft splits a cost into components and the other uses a combined amount, you could choose either presentation for the destination. Document which components the combined row covers, and include the cost once under your chosen presentation. Keep any supporting breakdown outside the rows being summed.
Apply the same review to income. If both drafts refer to the same income for the month, you could retain one destination entry with both references. Keep one-off or uncertain income separately identified rather than treating it as dependable income for the ongoing plan.
Resolve differences using the underlying records
A budget contains estimates of income and spending. Nidirect advises checking actual income and expenses against those estimates. [1]
For conflicting draft amounts, you could inspect the existing bill, statement or planning note associated with each row. Record which figure you select and why it belongs in this month's plan. Do not automatically choose the larger amount, the smaller amount or the figure in the most recently edited file.
If the records do not settle the difference, leave the entry on an unresolved list. Include the competing amounts, the question to answer and the record needed. Avoid inserting a zero merely to make the worksheet add up. Label a total containing only settled rows as a provisional subtotal, with the unresolved entries shown alongside it.
You could finish each settled row with a brief decision note, such as ‘retained the amount from the named bill’ or ‘combined these component rows’. Keep the note about the recordkeeping decision. There is no need to invent an explanation for a difference that the available records do not explain.
Read the combined monthly calculation
Subtracting spending from income for the same month shows whether the plan has a surplus or a shortfall. [1]
Once the combined plan's income and costs have been accounted for, you could calculate that difference using the destination rows. Do not add the original draft totals to the destination total. If material entries remain unresolved, retain the provisional label and postpone presenting a whole-household planning surplus.
The hypothetical example below illustrates the monthly calculation after the inputs have been settled. Its assumptions are separate from your own worksheet decisions.
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 | £2,600 |
| Total monthly planned costs | £2,350 |
| Monthly amount left: 2600 minus 2350 | £250 |
| Amount set aside after 6 months: 250 times 6 | £1,500 |
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 monthly difference is a planning surplus, not a dated bank balance. Establishing cash available on a particular date also requires the starting balance and the dates and amounts of incoming money and payments. Do not use the monthly result alone to decide what is available before a bill falls due.
StepChange recommends reviewing your budget regularly. [2]
As an optional reminder, you could add a review date beside the unresolved list. At that review, revisit the recorded questions and update the destination when the relevant records are available. Preserve the original drafts and decision notes as references.
FAQ
Can I just add the two draft totals together?
Use the underlying rows to decide what the combined plan includes. Where the drafts overlap, retain the chosen cost once and link the original entries to it. Keep broad subtotals separate from their included components.
What if I cannot decide which amount to use?
Keep the competing figures on the unresolved list and identify the record needed to settle them. Present settled costs as a provisional subtotal, without treating the unresolved amount as zero.
Should I delete the unused draft?
For this method, retain both originals as reference copies. You could label the destination as the working monthly plan and record there which original entries it represents.
This article is general information, not personal financial advice.
