To find your busy and slow months, list twelve months of sales, work out the average month, and compare each month with it. Mark months well above the average as high, those near it as normal and those well below it as low. The three bands then tell you when to hold more stock and staff and when to hold less. A made-up April to March year is worked below.
What data do I need?
Twelve months of total sales, in order from April to March if you follow the financial year. Use bank deposits plus cash taken if you do not keep a sales register. Be consistent: every month uses the same method. One year is a weak guide, so if you have two years, average each month across both.
How do I turn twelve months into three bands?
Add all twelve, divide by twelve to get the average month, and then divide each month by that average. A month with an index of 100 is exactly average; 134 means a third above. Say the made-up year totals ₹26,80,000, so the average month is ₹2,23,333.
| Month | Sales | Index (average = 100) | Band |
|---|---|---|---|
| April | ₹2,20,000 | 98.5 | Normal |
| May | ₹2,40,000 | 107.5 | Normal |
| June | ₹1,95,000 | 87.3 | Normal |
| July | ₹1,70,000 | 76.1 | Low |
| August | ₹2,00,000 | 89.6 | Normal |
| September | ₹2,10,000 | 94.0 | Normal |
| October | ₹3,00,000 | 134.3 | High |
| November | ₹2,80,000 | 125.4 | High |
| December | ₹2,30,000 | 103.0 | Normal |
| January | ₹2,00,000 | 89.6 | Normal |
| February | ₹1,85,000 | 82.8 | Low |
| March | ₹2,50,000 | 111.9 | Normal |
I used a rule of thumb: an index of 115 or more is High and 85 or less is Low. The cut-offs are not a law. Move them if your business swings more or less.
What is the spreadsheet formula?
Put months in A2 to A13 and sales in B2 to B13. Then:
- C2: =B2/AVERAGE($B$2:$B$13)*100 (copy down to C13)
- D2: =IF(C2>=115,"High",IF(C2<=85,"Low","Normal")) (copy down)
- Highest month: =INDEX($A$2:$A$13, MATCH(MAX($B$2:$B$13), $B$2:$B$13, 0))
- Lowest month: =INDEX($A$2:$A$13, MATCH(MIN($B$2:$B$13), $B$2:$B$13, 0))
All of these work in Excel and Google Sheets.
What should I do differently in each band?
| Band | Stock | Staff | Cash |
|---|---|---|---|
| High | Order earlier and in stages, as in the festival months | Add helpers or hours before the month starts | Set cash aside for stock before the sales arrive |
| Normal | Keep usual levels | Usual team | Usual forecast |
| Low | Order small, clear old stock | Plan leave, repairs and training now | Hold back optional costs and keep a reserve |
Put rupees on a high month. October sold ₹3,00,000 against an average month of ₹2,23,333, which is about ₹76,667 more. If goods cost you 80 percent of sales (a 20 percent margin), October needs ₹2,40,000 of stock against ₹1,78,667 in an average month. That is roughly ₹61,333 of extra stock to pay for before the festival customers arrive, which is why the cash column matters as much as the shelves.
Can I trust one year of data?
Treat it as a first guess. Festival dates move: the same festival can fall in October one year and November the next, so a spike can slide from one month to another. A road repair, a nearby new shop or a school holiday change can also distort a month. Note any unusual event beside each month in a comments column.
Where can I get the numbers if I do not note sales daily?
Your bank statement shows deposits month by month. Use card and UPI credits and add cash deposits. If you upload statements to SpendixAI, each row keeps its account, and a report with a CSV download makes the monthly credits easier to total. It will not show cash you never banked.
What to do with the bands
- Mark high and low months on a wall calendar.
- Two months before each high month, write the stock and cash you will need.
- One month before each low month, decide what costs to hold back.
- After the year, update the table with the new twelve months.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


