You do not have to wait a month to see where your money goes. Take last month's bank statement, bring it into a tracker or spreadsheet, categorise the fifteen merchants you paid most, and read the summary. Those fifteen usually explain most of your spending, so one sitting gives you a first real picture.
Step one: get the statement and bring it in
Download last month's statement from your bank's website or app as a PDF, CSV or Excel file. Check your own bank for where it keeps statements, since the route differs. In SpendixAI, choose the account first, then upload the file and review the rows before they are saved. Any bank statement in those formats can be uploaded, though some layouts may not read perfectly, so check the rows. In a spreadsheet, paste the rows under columns for date, description, debit and credit.
Step two: remove what is not spending
Your statement includes money that is not spending: transfers to your own other accounts, card bill payments, and credits. Mark those separately.
Say the debits on your statement add up to ₹48,200. Of that, ₹6,000 was moved to your own savings account. Your actual spending is 48,200 minus 6,000, which is ₹42,200.
Step three: find the top fifteen merchants
- Group the spending lines by merchant or payee.
- Total each group.
- Sort from largest to smallest and take the top fifteen.
- Give each of those a category.
Many lines will have messy descriptions, such as long references. Use the name part, and open your payment app if you cannot tell who the payee was. With SpendixAI, the first pass uses your own rules, then your history and similar merchants, and only if AI is turned on, an AI model for what is left, using the cleaned merchant name and an amount band. You can switch AI off, and unmatched items are then held for your review.
Step four: read the first summary
| Category | Amount | Share of spending |
|---|---|---|
| Rent | ₹14,000 | 33% |
| Groceries | ₹5,200 | 12% |
| Food delivery | ₹2,900 | 7% |
| Transport | ₹2,400 | 6% |
| Electricity and phone | ₹2,100 | 5% |
| Shopping | ₹2,900 | 7% |
| Everything else | ₹12,700 | 30% |
| Total spending | ₹42,200 | 100% |
The top fifteen merchants add up to 14,000 plus 5,200 plus 2,900 plus 2,400 plus 2,100 plus 2,900, which is ₹29,500. That is about 70 percent of the ₹42,200. The remaining ₹12,700 is the long tail of small payments. The shares are rounded.
What do you look for in the summary?
- The largest category and whether it is the one you expected
- Categories that are bigger than you assumed
- Repeat merchants that add up, such as delivery apps or cabs
- The size of Everything else, which tells you how much work is left
- Any payment you do not recognise
What if the categories look wrong?
Early categorisation is rarely perfect. A merchant may land in Shopping when you think of it as Household, or a person's name may sit in Other. Correct the ones in the top fifteen, since they matter most, and leave the rest. In the app, your corrections become history for the next import, and you can add a merchant alias when the same shop appears under different names. In a sheet, a lookup table of merchant to category does the same job.
It also helps to write down your questions as you go, such as why a certain month looks heavy. The summary will answer some, and the rest can wait for the next statement.
What do you do next?
Pick one finding and act on it. It might be a category to watch, a subscription to review or an unknown payment to trace. Then bring in the next month's statement and see how the picture changes. If you find that GST or tax matters for any of these payments, treat the figures as estimates and confirm with your CA.
A first-picture checklist
- Download last month's statement for one account
- Mark transfers and bill payments as not spending
- Categorise the top fifteen merchants
- Read the category totals and shares
- Choose one thing to act on this week
Useful ideas start with a clearer picture of your own spending.
Explore your reports


