Getting started

Use a three-month rolling average to see your real spending trend

Use a trailing three-month average, with one-offs taken out, to see your real monthly spending trend in Canadian dollars and plan next month with confidence.

Editorial illustration for Use a three-month rolling average to see your real spending trend

A single month is a noisy number. A rolling average of the last three months, with true one-offs taken out first, smooths the noise and shows where your spending is really heading. It needs one column of monthly totals and one formula you copy down.

Why not just look at last month?

Because last month may have had something unusual in it. A repair, a gift or a travel booking can double a category for a month and then vanish. If you set next month's plan from it, you plan around a month that will not repeat. Three months blend out most of the spikes, and the trend line still reacts when your habits actually change.

What does the raw version look like?

MonthRaw totalOne-off removedBaseline total
JulyC$3,010C$0C$3,010
AugustC$3,090C$0C$3,090
SeptemberC$4,935C$1,950C$2,985
OctoberC$3,120C$0C$3,120

September includes a C$1,950 payment you do not expect to repeat. The baseline for the month is 4,935 minus 1,950, which is C$2,985.

How do I build the rolling average?

  1. List the months in column A, the raw totals in B and the one-off amounts in C.
  2. In D, calculate the baseline with =B2-C2 and fill down.
  3. In E, starting at the third month, enter =AVERAGE(D2:D4) and copy down. The range slides by one row each time.
  4. Chart column E to see the trend.

For October, the three baseline months are August, September and October: 3,090 plus 2,985 plus 3,120 is 9,195, and 9,195 divided by 3 is C$3,065. Using the raw numbers instead gives 3,090 plus 4,935 plus 3,120, which is 11,145, divided by 3 for C$3,715. The one-off alone makes the raw average C$650 too high.

How many months should I average?

Three is a good starting point because it reacts quickly. Six is steadier but slower to notice a change, such as new rent. If your income and bills move with the seasons, twelve months compared with the same month last year can be a better guide. The formula is the same; only the range changes, for example =AVERAGE(D2:D7) for six months.

What if my spending really did rise?

Then the rolling average will show it slowly, which is useful. A single high month can be a blip. Three rising averages in a row mean a new normal, and the right response is to look at the categories, not to wait for the number to come down on its own.

Can I chart it?

Yes, and a picture helps. Plot the raw totals as columns and the rolling baseline as a line over them. The columns jump and fall; the line moves gently. If the line climbs for several months in a row, something has changed in your regular spending and it is worth a category-by-category look. If it stays flat while the columns jump, your plan is sound and the jumps are one-off or irregular costs.

What does a rolling figure miss?

It lags. If your rent goes up this month, a three-month average carries only a third of the change until the older months drop out of the window. It also treats every month equally, so a seasonal pattern, such as higher heating in winter, will pull the average up and down through the year. For that reason, note the months that have a known cause beside the number. A short comment such as "winter heating" saves you from reading a trend into something that happens every year.

How do I plan next month?

  • Use the latest rolling average as the starting estimate.
  • Add known irregular items due next month.
  • Keep the one-off total separate and decide each one on its own.
  • Revisit the figure after the month closes and see how far off you were.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports