Prepare a Monthly Budget Input Sheet After Moving
Organise existing bills, statements and planned costs after a household move, with a monthly input sheet that keeps confirmed amounts and unresolved items separate.
To prepare monthly budget inputs after moving, choose a specific calendar month and give each household cost a documented treatment for that month. Use existing bills, statements and planned costs to record what belongs in the plan, what you have excluded and what remains unresolved. The optional worksheet below focuses on that recordkeeping task, including how to carry its totals into a monthly income-minus-costs calculation. All amounts are in Canadian dollars.
Changes in your household, personal circumstances or work can affect your budget. The Financial Consumer Agency of Canada recommends revisiting financial goals as those circumstances change. [1]
Choose the month the sheet will describe
Start your optional worksheet with the month and year you intend to plan. You could choose the moving month or the first full month in the new home. Keep that choice visible at the top of the sheet, and use the same month for income and costs throughout.
Write a short scope note beneath it. For example, describe whether the sheet covers your own costs or the whole household's costs. If another person maintains part of the household plan, identify which amounts you are including from their records. Avoid leaving that boundary implicit.
For this worksheet, you could use amounts expected to be paid during the selected calendar month. Record the service period separately when a bill covers different dates. If you already use another monthly convention, describe it explicitly and apply it throughout the sheet. Do not switch conventions between rows without explaining the treatment.
Gather records for the selected month
The Financial Consumer Agency of Canada advises reviewing budget entries for missing items and checking that the amounts reflect your present situation. [2]
For your own optional review, gather the existing bills and statements you intend to use, along with any written planned costs for the selected month. Include relevant records from both addresses. A record from the previous home can remain on the working sheet while you determine its treatment.
You could use the following columns. They concern the budget inputs themselves; they are separate from a document filing system or a purchase reconciliation register.
| Field | What to enter |
|---|---|
| Cost description | The obligation or purchase being planned |
| Address or context | Previous home, new home or household-wide |
| Record reference | The bill, statement or written plan used |
| Service period | Dates shown on the record, if relevant |
| Monthly treatment | Include, exclude or unresolved, with a reason |
| Included amount | The amount assigned to the selected month |
| Follow-up note | The missing detail or record to check |
Use a separate income area with the same planning month. List the income included in the plan and its supporting record. Keep uncertain or one-off income visible in a separate note rather than treating it as dependable income for repeated monthly calculations.
Give each cost one monthly treatment
For each cost, choose an optional treatment: include it in the selected month, exclude it with an explanation, or leave its treatment unresolved. Base that choice on the record and the monthly convention you wrote down. Retain the explanation beside the amount so another review does not depend on memory.
For an old-address cost, note which document supports its inclusion or exclusion. If you have no record establishing its treatment for the selected month, leave the question open. Do not use the address alone as your reason for dropping the cost from the working sheet.
For a new-address cost, enter the amount shown by the relevant bill or your written plan. If you are using a planned amount, label it as planned beside the figure.
Where a statement and a bill describe the same obligation, you could attach both references to the same cost row. Enter the included amount once. Where the records describe separate obligations, retain separate rows, even if their descriptions look similar. Investigate uncertainty before changing the total.
You can also give a known one-off moving cost its own row when it belongs in the selected month. Mark it as one-off so that carrying the worksheet forward does not silently turn that entry into a recurring monthly assumption.
Keep unresolved amounts visible
Create a separate unresolved list for costs whose amounts or monthly treatment you cannot yet establish. Record what is uncertain and which existing record you need to check. Leave an unknown amount marked as unknown; do not silently enter zero.
If unresolved items could change the cost total, label the sum of the included rows as a provisional planning subtotal. State what remains outside it. Avoid presenting that subtotal as the complete household cost figure while those questions remain open.
When you resolve an item, update its treatment and supporting reference before revising the subtotal. You could retain a brief note explaining the decision. If an item still cannot be resolved, carry its note into the next review rather than making up an explanation.
Read the monthly planning calculation
A budget is a plan for bringing together income, spending and saving. It helps you balance those elements and direct spending towards your financial goals. [2]
Once you have reviewed your inputs, you can use them in a monthly calculation. The hypothetical example below illustrates that arithmetic. It assumes fixed monthly inputs across the illustrated period; your moving-month worksheet should retain its own one-off and unresolved labels.
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 | C$4,800 |
| Total monthly planned costs | C$4,200 |
| Monthly amount left: 4800 minus 4200 | C$600 |
| Amount set aside after 4 months: 600 times 4 | C$2,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.
Read the monthly difference as a planning surplus. It does not establish how much money is available on a particular date. A dated balance also requires the starting balance and the dates and amounts of income and payments, alongside existing commitments.
Before reusing the sheet for another month, you could review each included row again. Keep the new month's assumptions explicit rather than carrying forward every amount automatically. Choose a review date or reminder if that suits your recordkeeping routine.
FAQ
Should I include costs from both homes?
Under this optional method, include each cost that belongs in the selected month under your stated convention. Keep relevant records from both homes available while making that decision. An unresolved old-address cost should remain visible until its treatment is established.
What if I have a planned amount but no bill?
You can enter the written planned amount with a clear planned label and a reference to where it came from. If you have no supported amount, mark it unknown and explain the gap beside the provisional subtotal.
Can I treat the monthly surplus as money available today?
No. Monthly income minus costs is a planning calculation. To assess a particular day's available balance, you also need the starting balance, existing commitments and the dates and amounts of incoming and outgoing payments.
This article is general information, not personal financial advice.
