To categorise HDFC Bank transactions, sort every statement line into one of a few types first (UPI, NEFT or IMPS transfer, ATM, card swipe, standing instruction, charge, interest) and then decide the spending category from the name of the person or business in the narration. Set a rule for each repeat name, and next month most of the list sorts itself.
What kinds of lines appear in the account?
The narration text differs by bank, product and year, so use the shapes below only as a guide. The examples are invented to show the idea and are not copied from any HDFC Bank statement. Read your own statement before building rules.
| Line type | Illustrative narration | Usual category thinking |
|---|---|---|
| UPI payment | UPI-FRESHMART GROCERS-pay | Decided by the shop, here groceries |
| UPI to a person | UPI-A SHARMA-rent | Decided by your purpose, not the name |
| NEFT or IMPS | NEFT-HOUSING SOCIETY-maintenance | Depends on the receiver: rent, society, loan |
| ATM withdrawal | ATM CASH-city branch | Cash, until you record what the cash bought |
| Card swipe | POS-QUICKBITE RESTAURANT | Decided by the merchant, here dining |
| Standing instruction | SI-MUTUAL INSTALMENT-monthly | A transfer or savings line, not spending |
| Bank charge | SMS CHARGES-quarterly | Bank charges |
| Interest credit | INT PD-savings | Income, not a refund |
Which lines are the hardest to categorise?
UPI payments to a named person are the toughest, because A Sharma could be rent, a tutor or a friend. Do not guess from the name. Think about what the payment was for and choose a category once. If the same person gets the same amount on the same date every month, that is a strong hint about purpose.
How do I tell spending from movement of money?
Three kinds of lines are not spending at all. A transfer to your own other account moves money, a credit card bill payment settles spending already recorded on the card, and a standing instruction into savings is a saving. Give them their own category, or a transfer label, so they stay out of your monthly spending total.
What do I do with ATM cash and card lines?
An ATM withdrawal tells you that cash left the account, not what the cash bought. Record it as cash, then add the small cash expenses you remember (the vegetable seller, the auto fare, the tip) by hand, several at once if you like. If you never record the cash spending, the withdrawal stays as one lump and your categories look lighter than your real life. Card swipes are easier, because the merchant name carries the clue. Treat a swipe at a restaurant as dining and a swipe at a chemist as health, and let one rule per name do the repeating work.
How do I set rules so next month is easier?
- Sort the most frequent names first. Ten merchants often cover most of a month's lines.
- In SpendixAI, add a rule for a merchant once and later statements use it before any other method.
- Add a merchant alias when the same shop appears under different narration spellings.
- Correct a wrong category once; the correction is kept as history that helps similar lines.
The tracker categorises in stages: your own rules, then your history and similar merchants, then, only if AI is switched on, a model for what is left. You can keep AI off and review the unmatched items yourself.
A quick worked month
Say a month has 60 lines. After you set rules for the 12 names that repeat, say 41 lines sort themselves, leaving 19 to decide by hand. Next month, after rules for three or four new names, you may be down to 12 or so. The numbers are made up, but the pattern is what matters: the manual part shrinks quickly.
Where should I start today?
- Export or download one month of your statement.
- Mark every line as spending, transfer, saving, income or charge.
- Create rules for the ten most repeated names.
- Review the rest and note the people whose payments need a purpose.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
