Use calendar months when you are checking a budget or matching bills, and a rolling average when you want to see the direction of your spending without noise. Neither view is more honest than the other. They answer different questions, and a spike such as a December holiday will look very different in each.
What is the difference between the two views?
A calendar month total simply adds up spending from the 1st to the last day of the month. A rolling average takes the last three, or six, months and averages them, so each new month pushes the oldest one out. Calendar totals are exact and easy to tie to statements. Rolling averages are smoother, which makes them better for trend lines and worse for any single month.
How do they behave on a real-looking year?
Say a household's monthly spending last year was as below, with a ₹70,000 December because of a family trip. All figures are made up.
| Month | Calendar total | 3-month rolling average |
|---|---|---|
| Jan | ₹40,000 | - |
| Feb | ₹38,000 | - |
| Mar | ₹42,000 | ₹40,000 |
| Apr | ₹41,000 | ₹40,333 |
| May | ₹39,000 | ₹40,667 |
| Jun | ₹40,000 | ₹40,000 |
| Jul | ₹41,000 | ₹40,000 |
| Aug | ₹40,000 | ₹40,333 |
| Sep | ₹42,000 | ₹41,000 |
| Oct | ₹45,000 | ₹42,333 |
| Nov | ₹40,000 | ₹42,333 |
| Dec | ₹70,000 | ₹51,667 |
| Jan (next year) | ₹40,000 | ₹50,000 |
| Feb (next year) | ₹40,000 | ₹50,000 |
| Mar (next year) | ₹40,000 | ₹40,000 |
The arithmetic: for December, 45,000 plus 40,000 plus 70,000 is 155,000, and divided by three is ₹51,667. For the next January, 40,000 plus 70,000 plus 40,000 is 150,000, which gives ₹50,000. The rolling line stays high for three months after a spike that lasted one month, then drops sharply when December leaves the window.
Which view should you trust for what?
- Budget checks: calendar month. Rent, EMIs, SIP debits and school fees fall on set dates, so calendar totals match them.
- Matching a bank or card statement: calendar month, because statements are cut at month boundaries or card billing dates.
- Seeing if your spending is drifting up or down: rolling average, because it irons out festivals and travel.
- Planning an average month for next year: a twelve-month average, because it includes the spikes.
- Explaining a single odd month: calendar month, then read the transactions.
A calendar view tells you December was ₹25,000 above a normal ₹45,000 budget, which is exactly the thing you want to know in December. A rolling average would tell you that spending is trending higher, which is partly misleading, because it was one trip.
What goes wrong with each view?
Calendar months can mislead when a bill that belongs to one month happens to be paid in another. A credit card payment made on the 3rd looks like spending in the new month, although the purchases were earlier. Rolling averages can mislead by dragging a spike across several months, so it looks as if January and February were expensive when they were not.
How do you calculate a rolling average in a sheet?
With monthly totals in column B from row 2, put this in D4 and drag it down: =AVERAGE(B2:B4). It averages the current month and the two before it, so the first value appears in the third row. For a six-month window use =AVERAGE(B2:B7) in D7. This works the same in Excel and Google Sheets.
When does a tracker help?
Once a sheet needs monthly totals typed in by hand, it starts to lag. SpendixAI can group your imported transactions by category and month in the Report builder, and a CSV download lets you drop the totals into the same sheet, so you still choose the view.
What should you do next?
- Put your last twelve calendar totals into a column.
- Add a three-month rolling average beside them.
- Mark any month more than 20% above the average and write the reason.
- Use calendar totals for your budget and the rolling line for your trend check.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


