Take your last six months of grocery spending and use the median, not the average, as your budget. A single holiday month or a large stock-up can drag an average upward and make a perfectly normal month look like a failure. The median ignores the odd one and shows what a typical month costs your household.
Average versus median
The average adds every month and divides by the count, so one expensive month pulls it up. The median is the middle value once the months are sorted. Say your last six months were C$470, C$480, C$495, C$505, C$530 and C$610, the last being a month with a family gathering.
| Measure | Calculation | Result (C$) |
|---|---|---|
| Average | 3,090 divided by 6 | 515 |
| Median | (495 + 505) divided by 2 | 500 |
| Highest month | Seen in the sample | 610 |
The gap looks small here, but it grows as one-off months get bigger. Use the median as the base budget and handle the spike separately.
How do you handle the big months?
Add a small sinking fund. If your gathering months cost C$110 above the median, as the 610 does in this example, and you expect two a year, that is C$220 a year or about C$18 a month. Put C$18 aside every month into a separate pot, and spend it only when such a month arrives.
Stock-up trips and freezer shopping
If you buy half a month of meat and pantry items in one trip, your monthly totals will bounce. Compare spending over two months, or track the stock-up as one line and weekly top-ups as another. Say a stock-up of C$140 plus four weekly shops of C$85 gives C$480. If you skip the stock-up next month, a drop to C$340 is not savings but timing, since the freezer is simply being used.
What should be in the grocery line?
- Food and drink bought to eat at home.
- Pet food, if you want it in the same line, but decide once and stay consistent.
- Not household items such as cleaning products or paper goods unless you intentionally merge them.
- Not restaurants, takeout or office coffee.
Does winter change the number?
For many households it does, since cold months mean more cooking at home and different produce prices. If you have twelve months of data, compare your three highest months with your three lowest. If the gap is wide, consider two budgets, a winter one and a summer one, set from the median of the relevant months.
How often should you refresh the median?
Every month, drop the oldest value and add the newest, so the window always covers the latest six months. After each update, sort the figures again and take the middle pair. A rolling median moves slowly, which is exactly what you want: it reflects your real habits without jumping when one month goes wrong.
If your median rises for three updates in a row, look at what changed: a new household member, a different store, or a steady drift towards convenience foods. If it falls, check that you are not under-recording. A suspiciously cheap month usually means a receipt went missing, and a missing receipt gives a missing cost, not a saving.
A final tip: keep the raw monthly figures, not only the median. When you later want to know whether a bad month was really bad, the history is what lets you answer.
- Keep the six numbers in a sheet or a note.
- Write the date you last updated the median.
- Note any month that had an event, such as a visit or a party.
How to use the number next month
- Set the median as your base for the month.
- Add the sinking-fund contribution as a separate line.
- Check progress every Friday against the base.
- At month end write down the total and what drove it.
After six more months, redo the median. The figure should settle and your budget will track your real life instead of a guess.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

