If you earn well but save nothing, the money is almost always going into many mid-sized spends that never feel big enough to question. A one-evening check of three months of statements, looking at top merchants, weekdays and recurring charges, will usually show where it goes.
What do I need before I start?
Download three months of statements for every account and card you use. Most banks let you export a statement as PDF, CSV or Excel from their website or app; look in your own app for the exact route. Include credit cards, since spending often moves there. Put every payment into one list, with date, merchant and amount. Use a sheet, or an app that does it for you.
Step one: who are your top ten merchants?
Group the payments by merchant and total each. In Excel or Google Sheets, a PivotTable with the merchant as rows and the sum of amount as values does it in a minute. Sort from largest to smallest and look at the first ten. You will recognise rent and EMIs; the surprise is usually what is at positions four to ten.
Step two: what does each weekday cost?
Add a column with the day name. The formula =TEXT(A2, "dddd") returns the weekday of the date in A2 in both Excel and Google Sheets. Then pivot or total by weekday. A weekday with two or three times the others tells you where to look: Friday evenings, Saturday shopping, Sunday meals out.
Step three: which charges repeat?
Sort by amount, then merchant, and look for the same amount appearing every month. Subscriptions, memberships, insurance, and small autopay mandates all hide here. Add them up; you may be surprised how large the total is when counted together.
What did one hypothetical person find?
Say someone takes home ₹85,000 a month, pays ₹25,000 rent, and saves nothing. The biggest single item is the rent. The next biggest non-rent single payment is a ₹12,000 trip. Nothing else looks alarming.
But in three months there are 96 payments between ₹300 and ₹900, averaging about ₹560. That is 96 x 560 = ₹53,760 in three months, or ₹17,920 a month. These are food orders, cabs, small shopping and coffee. Compare that with the ₹12,000 trip: the cluster of mid-sized spends is more than four times as large (53,760 / 12,000 = 4.48).
| Item | Three-month total (₹) | Per month (₹) |
|---|---|---|
| Rent | 75,000 | 25,000 |
| The single trip | 12,000 | 4,000 |
| 96 mid-sized payments (₹300 to ₹900) | 53,760 | 17,920 |
Seeing a pile of identical-looking small payments in one place changes the question. It is not how to stop one big mistake. It is which of those 96 payments mattered to you, and which you cannot remember.
What do I do with the answer?
- Pick the one or two clusters that cost most and set a monthly limit on them.
- Move a fixed amount to savings on salary day, before the cluster starts, so what is left is what you spend.
- Cancel any recurring charge you cannot name.
- Repeat the review every quarter.
If you want the sorting done for you, SpendixAI takes uploaded statements as PDF, CSV or Excel, lets you review rows before saving, and groups them by category and merchant, with reports to see the totals. Features like these just shorten the evening; the questions remain yours to answer.
Tonight's short list
- Download three months of statements from every account and card.
- Combine them into one list.
- Find the top ten merchants, the weekday totals and the repeating charges.
- Pick one cluster to limit.
- Set up a savings transfer on salary day.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


