A category deep dive has five steps: find the total, look at the trend, rank the merchants, check the size of payments, and finish with one decision. Applied to a hypothetical Transport category of ₹7,800 a month, it takes about twenty minutes and ends with a specific change instead of a vague resolution.
Step 1: what is the total, and how big is it?
Write the monthly total and its share of all spending. If your total spending is ₹52,000, then Transport at ₹7,800 is 7,800 ÷ 52,000 = 15%. That is big enough to be worth the time. If a category is 1% of spending, the time is better spent elsewhere.
Step 2: which way is it heading?
Look at six months. Say Transport went ₹7,100, ₹7,300, ₹7,500, ₹7,200, ₹7,600 and ₹7,800. That is a rise of ₹700 from the first month to the last, which is about 10%. A one-month spike and a slow climb need different responses, so only a trend can tell you which one you have.
Step 3: who gets the money?
| Merchant group | Payments | Total | Average payment |
|---|---|---|---|
| Fuel | 3 | ₹3,000 | ₹1,000 |
| Cab rides | 24 | ₹2,400 | ₹100 |
| FASTag recharges | 2 | ₹1,500 | ₹750 |
| Metro and bus | 18 | ₹900 | ₹50 |
| Total | 47 | ₹7,800 | ₹166 |
3,000 + 2,400 + 1,500 + 900 = ₹7,800. Fuel is the largest block, but cab rides account for 24 of the 47 payments, so they are where habits live.
Step 4: how big are the individual payments?
Group payments by size. Here, 42 of the 47 payments are ₹100 or less, and five are ₹750 or more. Small, frequent payments are about routine, and a few big payments are about planning. Different problems need different tools: routine can be changed by a rule, planning by a budget line.
Step 5: what is the one decision?
End with a single change you can test. For example: replace 8 of the 24 cab rides with metro, at ₹50 instead of ₹100. The saving would be 8 × (100 − 50) = ₹400 a month, or ₹4,800 over twelve months. That is a made-up illustration, not a forecast, and you would adjust it to your own fares and routes.
Can I use this on other categories?
Yes. Swap the merchants and the decision. Groceries might end with a weekly list, dining out with a cap on delivery orders, and utilities with checking a bill for an unusual unit reading. The steps do not change.
How will you know the decision worked?
- Next month, rerun steps one and three only: total and merchants.
- Check the cab count. The target was 16 rides, with about ₹7,400 for the category.
- If the total is unchanged, look at which merchant grew to absorb the saving.
- Keep the change for two months before judging it, since one month is noisy.
What if one merchant dominates the category?
If a single merchant accounts for most of the total, step three is quick and step four matters more. Look at the individual payments to that merchant: are they regular, or does one large payment sit behind the figure? A ₹3,000 fuel total of three fill-ups of ₹1,000 is steady. The same ₹3,000 as one long-distance trip is a different story.
Doing it in a spreadsheet
With dates in A, merchants in B, categories in C and amounts in D, these formulas work in Excel and Google Sheets. Put the merchant name in F2.
- Category total: =SUMIFS($D$2:$D$500,$C$2:$C$500,"Transport")
- Merchant total: =SUMIFS($D$2:$D$500,$C$2:$C$500,"Transport",$B$2:$B$500,F2)
- Merchant payments: =COUNTIFS($C$2:$C$500,"Transport",$B$2:$B$500,F2)
- Average payment: divide the total by the count in the next column.
If you import statements into SpendixAI, you can filter by category and group by merchant in the Report builder, which covers steps one to three, and the rest is your own judgement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


