If your income moves around, build the budget on your lowest month of the last three, not the average. Total each spending category over the same three months, divide by three, and check that the result fits inside the low month; anything you earn above it is a bonus to allocate, not money already spoken for.
Why the lowest month, not the average?
Say a contract worker earned CA$3,100, CA$2,450 and CA$3,350 in three months. The average is (3,100 + 2,450 + 3,350) divided by 3, which is 8,900 divided by 3, about CA$2,967. A budget built on CA$2,967 fails in a CA$2,450 month. A budget built on CA$2,450 works in all three, and the extra in good months can go somewhere deliberate.
How do you total spending when the months are uneven?
Use the same method as with steady pay: label every transaction, then sum each category per month. In a spreadsheet with dates in A, categories in B and amounts in C, this totals one category for a month starting in F1:
=SUMIFS($C$2:$C$500, $B$2:$B$500, "Groceries", $A$2:$A$500, ">="&$F$1, $A$2:$A$500, "<="&$G$1)
Put the first day of the month in F1 and the last day in G1. The less formula-minded can do the same with a filter and the status bar total.
What does the budget look like against the low month?
| Line | Three monthly amounts | Budget |
|---|---|---|
| Rent | CA$1,250 each month | CA$1,250 |
| Phone and internet | CA$105 each month | CA$105 |
| Groceries | CA$480, CA$455, CA$510 | CA$485 |
| Transport | CA$160 each month | CA$160 |
| Eating out | CA$130 average | CA$130 |
| Other | CA$100 average | CA$100 |
Groceries: 480 + 455 + 510 = 1,445, divided by 3 is about 482, rounded up to 485. Add the budget: 1,250 + 105 + 485 + 160 + 130 + 100 = CA$2,230. Against the low month of CA$2,450 that leaves CA$220.
What do you do with the good months?
In the first month the pay was CA$3,100, which is CA$650 above the CA$2,450 base; in the third, CA$3,350 is CA$900 above. Decide the order in advance: first fill a buffer equal to one low month of costs, then savings, then spending you enjoy. Writing the order down stops the extra from disappearing into groceries and takeaway.
What if the lowest month looks unusually bad?
Check whether the low month was an outlier, such as a gap between contracts. If so, run the same sums with the second-lowest month as a second scenario and see which lines would flex. Rent and phone will not move; eating out and other will.
How do you plan for irregular income months?
A simple rule is to pay yourself a steady amount. Keep your earnings in one account and move the same sum, say CA$2,300, to your spending account each month. The first account fills in good months and drains in thin ones. The budget then looks like a salary job's budget, which is much easier to follow than one that rises and falls with every invoice.
- Set the steady amount at or below your lowest month.
- Review it every quarter, not every month.
- If the holding account stays above one month of costs, raise your steady pay slightly.
Next steps
- Set the budget on the low month and write the order for surplus.
- Review after each pay arrives rather than on a fixed date.
- SpendixAI, which is built around India and INR, has reports that show category history for this kind of planning, but it is not described here as available for Canadian dollars.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


