Compare Current and Proposed Monthly Household Costs
Create a side-by-side monthly worksheet using existing bills, statements and proposed costs, with separate notes for assumptions and unresolved amounts.
To compare your current monthly budget with a proposed household change, create a worksheet with separate columns for current and proposed income and costs. Use existing statements and bills for the current column, and label each proposed amount by its basis. Keep unknown amounts visible. Compare the whole household totals only after identifying what each version includes.
The Financial Consumer Agency of Canada explains that changes in family life, personal circumstances or work can affect a budget, making a review of financial goals relevant. [1]
The worksheet below is an optional way to organise that review. Choose one proposed change, such as a different work arrangement, and keep its assumptions together. The task is to prepare a monthly comparison you can inspect before deciding whether to adopt it.
Define the monthly comparison
Start by naming both versions. You might use “current monthly plan” and “proposed monthly plan”. Add a note describing the proposed change and which household members are included. Use the same household boundary in both columns: if the current plan includes shared food and transport costs, include those costs in the proposed version too.
Choose a monthly basis for the comparison. If you use a monthly planning average for an occasional bill, label it as an average and retain the bill amount and due date in a separate note. Apply the same treatment in both versions. A monthly average does not establish that the payment amount will be available before the bill is due.
You can use this layout in a spreadsheet or notebook:
| Worksheet field | What to record |
|---|---|
| Budget item | The income or cost being compared |
| Current monthly amount | The amount used in your current plan |
| Current record | The supporting bill, statement or planning note |
| Proposed monthly amount | The amount under the proposed arrangement |
| Proposed basis | A document reference or explicit assumption |
| Unresolved question | What still needs checking |
Keep savings allocations in a separate part of the worksheet if your current budget includes them. For the income-minus-costs calculation, define costs as household expenses and commitments before allocating the remaining amount to savings. Do not subtract the same savings allocation again later.
Enter the current monthly plan
The Financial Consumer Agency of Canada advises checking entered budget amounts for missing items and ensuring that they reflect your present circumstances. [2]
For this worksheet, you can gather the statements, bills and existing planning notes behind your current budget. Enter each planned monthly amount with a reference to its record. Where a statement shows spending for a particular month, label it as that month's recorded spending; if you choose to use it as a planning assumption, say so separately.
Keep the comparison at the level of your existing budget lines. You do not need to create a second purchase register. Where you already have a verified spending total, reference that record rather than entering its underlying purchases again as additional costs.
Leave a visible unresolved note beside any missing amount. Avoid putting zero in a cell merely because you have not found its supporting record. If the current column remains incomplete, label its total as a provisional subtotal and list the outstanding items beside it.
Record proposed monthly amounts separately
Copy the current budget lines into the proposed column as a starting layout. Then review each line against the specific change you are considering. Mark an amount as “carried forward for comparison” when you have chosen to retain it as an assumption. That label does not establish that the cost will stay unchanged.
For a proposed amount supported by a document, note the document and its stated scope. For an amount you have chosen yourself, label it “planning assumption” and explain the basis briefly. Use the amount shown on an existing bill or document where applicable.
Keep proposed income separate from current income. If its amount or continuation is uncertain, record that uncertainty beside the entry. Leave one-off income outside the recurring monthly income assumption, with a separate note if you want to retain the record.
For costs that would be added or removed, write the proposed monthly amount beside the existing line and explain the reason in a note. Use zero only where the proposed version explicitly assumes no cost for that item. Keep an unknown replacement cost unresolved rather than presenting it as an eliminated expense.
Compare whole-household totals
A budget connects money received, spending and saving within a plan for financial goals, according to the Financial Consumer Agency of Canada. [2]
For your optional comparison, total monthly income and monthly costs separately in each column. Subtract costs from income within the same version. Label the result “monthly planning surplus” when positive, or “monthly planning shortfall” when negative. If an amount remains unresolved, keep any calculation visibly provisional rather than presenting it as the finished household result.
The hypothetical calculation below illustrates the income-minus-costs step. Its fixed inputs and assumptions belong to the example; they are not estimates for your household or a forecast.
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,100 |
| Monthly amount left: 4800 minus 4100 | C$700 |
| Amount set aside after 6 months: 700 times 6 | C$4,200 |
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.
You can also add a “proposed minus current” column for individual costs. A positive difference means the proposed cost is higher; a negative difference means it is lower. This difference is a comparison between versions, not another expense to add to either total.
A lower proposed cost in one row does not establish a whole-household surplus. Review all included income, costs and existing commitments before interpreting the overall result. To assess money available on a particular date, you would also need the starting balance and the dates and amounts of income and payments. Monthly subtraction alone does not provide that dated balance.
Keep the proposed version for review
Save the comparison with a descriptive name and a preparation date. Keep supporting documents or references alongside it, and retain the current version separately. You can add an optional reminder to revisit unresolved amounts when you obtain the relevant records.
Before adopting the proposed column as your working budget, review its assumptions line by line. Mark which amounts are now documented, which remain estimates and which still need an answer. If you revise an assumption, retain a short note explaining the change so that the saved comparison remains understandable.
Frequently asked questions
Can I compare only the costs affected by the change?
You can prepare a smaller comparison, but label it as a comparison of selected costs. Do not describe its result as the household's monthly surplus. That calculation requires the household income and costs included in the full plan.
What should I do with an unknown proposed cost?
Keep the budget line and mark the amount unresolved. Record the document or information you need. Any total that excludes it should remain a provisional subtotal, with the omission stated beside it.
Does a positive monthly result mean I can make a payment today?
No. It is a planning result for the month. A dated cash assessment also requires the starting balance, payment dates, income dates and existing commitments.
This article is general information, not personal financial advice.
