A rolling three-month average takes your income for the latest three months, adds it up and divides by three, then moves one month forward each time a new month closes. It smooths out one great or terrible month so your budget does not lurch. For irregular income it is a sensible planning figure, though not a forecast.
How do I calculate it step by step?
- List monthly income in order, one row per month, counting only money that actually reached your account.
- Include months with zero income as zero. Leaving them blank flatters the result.
- For the latest month, add that month and the two before it.
- Divide the total by 3.
- When the next month closes, drop the oldest month, add the new one and divide by 3 again.
What does the arithmetic look like?
Hypothetical monthly income: April ₹52,000, May ₹38,000, June ₹71,000, July ₹29,000, August ₹60,000.
| Month | Income (₹) | Rolling three-month average (₹) |
|---|---|---|
| April | 52,000 | Not enough months yet |
| May | 38,000 | Not enough months yet |
| June | 71,000 | 53,667 (1,61,000 divided by 3) |
| July | 29,000 | 46,000 (1,38,000 divided by 3) |
| August | 60,000 | 53,333 (1,60,000 divided by 3) |
Notice that July's weak month pulled the average down by about ₹7,700, but the figure did not collapse. That is the purpose.
Compare that with budgeting on the last month alone. July would have forced a budget of ₹29,000, and August would have invited ₹60,000 of spending. The rolling figure keeps both within a range you can plan around.
What is the sheet formula?
Put months in column A and income in column B, with the first month in row 2. In D4 enter the formula below and fill it down:
=AVERAGE(B2:B4)
In D5 the same pattern gives =AVERAGE(B3:B5), because the range moves down one row as you fill. This works in Excel and Google Sheets. To format the result without decimals, round it: =ROUND(AVERAGE(B2:B4),0).
How do I set next month's budget from it?
Take the latest rolling average, ₹53,333 in the example, and decide how much of it to plan with. A careful approach is to build the budget on the figure, or a little under it, and treat anything above as extra that goes to the buffer first. Fix the order: essentials, minimum saving, then flexible spending.
Say you plan on ₹46,000, the lowest recent average. Essentials ₹34,000, savings ₹6,000, flexible spending ₹6,000. That adds to ₹46,000. If a month brings ₹60,000, the extra ₹14,000 has a destination before you spend it.
Should I use three months or six?
Three months reacts quickly to a change, which is useful if your income is shifting. Six months is steadier and suits work that comes in bursts. For six months with income in B2:B7, use =AVERAGE(B2:B7) and move the range down each month. If your income is seasonal, a twelve-month view, such as the one in a year chart, shows the pattern better than any rolling figure.
Whichever window you choose, keep it for a while. Switching between three and six months depending on which number looks better defeats the purpose of having a rule.
Where do the monthly income figures come from?
From the bank statement credits, grouped by month. If a sheet starts to feel heavy, SpendixAI can import statements and give monthly totals by category, and you can download the figures as CSV to paste into your sheet. Check that transfers between your own accounts are not counted as income.
A short monthly routine
- Close the month by listing every credit that is actual income.
- Add the new figure to the sheet and read the rolling average.
- Set next month's budget order: essentials, saving, flexible.
- Send any amount above the average to the buffer first.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


