Fictional worked example

Check a shared monthly budget by utility

A household splits its sample combined allowance into 110 for electricity and 45 for water. It wants to see whether underspending on one can offset an overrun on the other.

Open Tracker

Inputs and calculation

Original simulated records, all in USD
MonthUtilityUsageBillBudgetVarianceMonth change
2025-04electricity420 kWh105110-5—
2025-04water14 m³49454—
2025-05electricity480 kWh1201101015 (14.2857%)
2025-05water10 m³3545-10-14 (-28.5714%)

April total is 105 + 49 = 154 against 155. May totals 120 + 35 = 155. May variances of +10 and −10 cancel.

What the comparison shows

May meets the combined budget even though the electricity row is over. If the budget categories are kept separate, the electricity overrun is still relevant.

Assumptions and limits

Record both budgets separately. Combine the variance by hand for bills in the same currency.

Related guides and examples