To measure how much of your spending is impulse, tag each non-essential purchase in a month as Planned or Unplanned, then divide the unplanned count, and the unplanned rupees, by the totals. A purchase is planned if it was written down before the day you bought it. Two formulas do the rest, and the answer is two ratios: by number of purchases and by rupees.
How do you decide what is planned?
Use a test you can apply honestly in five seconds: was this on a list, a wishlist or a conversation before I opened the shop or app? If yes, it is planned, even if you waited a week. If you saw it, wanted it and bought it within the same session, it is unplanned. Essentials such as rent, bills, groceries for the month and medicines are left out, since this ratio is about discretionary buying.
How do you set up the sheet?
Use three columns. Column A holds the date, column B the amount in rupees and column C the tag, either Planned or Unplanned. Say you have 30 purchases in rows 2 to 31.
- Share by count: =COUNTIF($C$2:$C$31, "Unplanned") / COUNTA($C$2:$C$31)
- Share by rupees: =SUMIFS($B$2:$B$31, $C$2:$C$31, "Unplanned") / SUM($B$2:$B$31)
- Unplanned average: =AVERAGEIFS($B$2:$B$31, $C$2:$C$31, "Unplanned")
Format the first two cells as percentages. These work the same way in Excel and Google Sheets. If your range grows through the month, extend 31 to a larger row number such as 200, and COUNTA will still count only the filled cells in column C.
What does a made-up month of 30 purchases show?
The numbers below are invented to demonstrate the working. Purchases are grouped by type.
| Type | Planned (count) | Planned (₹) | Unplanned (count) | Unplanned (₹) |
|---|---|---|---|---|
| Clothing | 4 | 6,200 | 3 | 1,900 |
| Kitchen and home | 5 | 3,800 | 2 | 1,150 |
| Gadgets and accessories | 3 | 2,900 | 2 | 1,350 |
| Personal care | 4 | 1,200 | 1 | 350 |
| Books and hobbies | 3 | 1,100 | 3 | 450 |
| Total | 19 | 15,200 | 11 | 5,200 |
Total purchases: 19 + 11 = 30. Total rupees: 15,200 + 5,200 = ₹20,400. By count, unplanned is 11 ÷ 30 = about 36.7 per cent. By rupees, it is 5,200 ÷ 20,400 = about 25.5 per cent. The two differ because unplanned purchases here are smaller: an average of 5,200 ÷ 11 = about ₹473, against 15,200 ÷ 19 = ₹800 for planned ones.
Which ratio should you watch?
Both, for different reasons. The count tells you how often you act on impulse, which is about habit. The rupee share tells you how much it cost, which is about budget. A high count with a low rupee share, like the example, means many small impulses, such as accessories and snacks. A low count with a high rupee share is rarer and more important: a few large unplanned buys, like a phone upgrade.
What if your honest ratio is high?
- Look at the type with the most unplanned rupees first. In the example it is clothing, with ₹1,900.
- Add a small buffer line to next month's plan, such as ₹1,500, so some impulse has a legal place and does not wreck the plan.
- Try the 24-hour pause on only the one type that leaks the most, instead of everything at once.
- Recheck after a month. A drop of a few points is progress.
Can an app do the tagging?
The tag is a judgement only you can make, so a spreadsheet is a fine home for it. When the list gets long, SpendixAI keeps statement imports and hand-entered expenses together, and its Report builder can filter and group them, so you can see unplanned types in one place if you keep a sub-category for them.
One-minute monthly routine
- Paste or enter the month's discretionary purchases.
- Tag each one before you look at the total.
- Read both ratios and the biggest unplanned type.
- Write one sentence about what you will try next month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

