To categorise a Kotak Mahindra statement, sort the rows by narration, group repeating merchants first, and set aside the rows that are not spending at all: card bill payments, transfers to your own accounts and cash withdrawals. Then write a rule for each repeating merchant so next month goes faster. Narration text differs by payment type, so use the examples here as shapes, not exact strings.
What do the narrations look like?
A bank narration usually strings together a payment mode, a counterparty and some reference digits. Your statement will show its own style, so open it and look at three or four rows for UPI, card swipes, NEFT or IMPS and cash. The merchant name is the part you want, and the reference digits are noise you can ignore. A rule should match the stable word, such as a shop or biller name, not the changing numbers.
Which rows should I keep out of spending?
Some debits are money moving, not money spent. If you count them, your total will be too high.
| Row type | What it is | Treat as |
|---|---|---|
| Credit card bill payment | Settles spends already counted on the card | Transfer, not spending |
| Transfer to your own savings | Moves money between your accounts | Transfer, not spending |
| EMI debit | Loan repayment | Its own category, such as EMI |
| Cash withdrawal | Spending happens later in cash | Cash, then split if you can |
| UPI to a person | Could be rent, a loan or a gift | Review one by one |
Say a month's debits come to ₹58,400. A card bill payment of ₹21,500 and a ₹10,000 transfer to your savings are in there. Real spending on this account is ₹58,400 minus ₹21,500 minus ₹10,000, which is ₹26,900. The card's own statement carries the ₹21,500 detail.
How do I build rules that last?
- Sort the statement by narration so repeats sit together.
- Start with the five or six merchants you see most, such as your milk vendor, a grocery store and a fuel station.
- For each one, write down the matching word and the category.
- Name a few sub-categories only where you will act on them, for example Groceries and Dining out.
- Re-run the sheet or the app on last month to see what is still unsorted, then add two more rules.
What do I do with payments to people?
UPI payments to a named person are the hardest rows. The same person may be your landlord one month and a friend repaying dinner another. Write the purpose in a note on the first time, and give recurring ones a rule with their name, such as rent. For one-off ones, decide per row rather than forcing a rule.
How does SpendixAI handle this?
In SpendixAI you pick the Kotak account, upload the statement as PDF, CSV or Excel, and review the rows before saving. Categorising runs in stages: your own rules first, then your history and similar merchants, and AI only if you have it switched on, using the normalised merchant name and an amount band rather than your name or account numbers. Corrections become history, and you can add merchant aliases for names that keep changing.
Monthly routine
- Download the month's statement as soon as it is generated.
- Mark transfers and card bill payments first.
- Apply rules, then categorise what is left by hand.
- Add rules for any merchant you categorised twice.
- Compare the total with the statement before filing it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

