A seasonality index compares one month's spending with your average month. Divide the month's spend by the average monthly spend and multiply by 100. An index of 100 means an average month, 130 means a month 30% above average, and anything above about 120 is worth planning for ahead of time.
How do you calculate the index?
- Add up twelve months of spending, ideally a full financial year from April to March.
- Divide by twelve to get the average month.
- For each month, divide its spend by the average month and multiply by 100.
- Mark every month above 120 as a pre-funding month, and note why.
In Excel or Google Sheets, with the twelve months in B2:B13, put this in C2 and drag it down: =B2/AVERAGE($B$2:$B$13)*100. The dollar signs lock the average range so it does not move as you copy the formula down.
What does a made-up household's year look like?
Say the twelve months add up to ₹5,10,000, so the average month is 5,10,000 divided by 12, which is ₹42,500. All figures are hypothetical.
| Month | Spend | Index |
|---|---|---|
| Apr | ₹38,000 | 89.4 |
| May | ₹40,000 | 94.1 |
| Jun | ₹41,000 | 96.5 |
| Jul | ₹39,000 | 91.8 |
| Aug | ₹40,000 | 94.1 |
| Sep | ₹42,000 | 98.8 |
| Oct | ₹56,000 | 131.8 |
| Nov | ₹52,000 | 122.4 |
| Dec | ₹48,000 | 112.9 |
| Jan | ₹36,000 | 84.7 |
| Feb | ₹37,000 | 87.1 |
| Mar | ₹41,000 | 96.5 |
For October, 56,000 divided by 42,500 is 1.318, so the index is 131.8. For January, 36,000 divided by 42,500 is 0.847, so the index is 84.7.
Which months deserve attention?
Two months cross the 120 line: October at 131.8 and November at 122.4. In this household, that is the festival season, with gifts, clothes, travel and extra groceries. December, at 112.9, is higher than average but below the line.
The months after the festivals, January and February, run below the average. That is normal. Spending often dips after a busy period, though not always. They are the quietest months, which makes them the natural time to catch up on any pre-funding you missed. If a low month is not low in your own sheet, check whether a bill from the festival months has slipped into it.
How do you pre-fund the high months?
Take each flagged month's spend above the average. October is 56,000 minus 42,500, which is ₹13,500 extra. November is 52,000 minus 42,500, which is ₹9,500 extra. Together that is ₹23,000. If you set the amount aside over the six months from April to September, that is 23,000 divided by 6, or roughly ₹3,833 a month.
This is a habit, not a rule. If setting aside ₹3,833 a month is hard, begin with half the amount and see how the season goes. Keep the money where you cannot spend it by accident, such as a separate account or a savings goal.
How reliable is one year of data?
One year is a start, not a law. A single trip, a wedding or a hospital bill can create a spike that is not seasonal at all. Check the reason for each month above 120. If it was a once-in-a-lifetime event, take it out of the average before you calculate. If you have two or three years, average the index for each month across the years to see what really repeats.
Can your tracker supply the monthly totals?
Yes, if your statements are imported. In SpendixAI the Report builder can group your spending by month, and a CSV download gives you the twelve numbers to paste into the sheet above. The index is then a one-line formula.
What next?
- Calculate the index for your last twelve months.
- Write the reason beside every month above 120.
- Work out the extra over average for those months, and divide by the months you have before them.
- Open a separate savings pot and move that monthly amount on salary day.
- Repeat after the season and see how close you were.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


