Bank statements

How to categorise HDFC Bank transactions

Learn to read and categorise the kinds of lines on an HDFC Bank account, from UPI and NEFT to card swipes and charges, and set rules that repeat monthly.

Editorial illustration for How to categorise HDFC Bank transactions

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 typeIllustrative narrationUsual category thinking
UPI paymentUPI-FRESHMART GROCERS-payDecided by the shop, here groceries
UPI to a personUPI-A SHARMA-rentDecided by your purpose, not the name
NEFT or IMPSNEFT-HOUSING SOCIETY-maintenanceDepends on the receiver: rent, society, loan
ATM withdrawalATM CASH-city branchCash, until you record what the cash bought
Card swipePOS-QUICKBITE RESTAURANTDecided by the merchant, here dining
Standing instructionSI-MUTUAL INSTALMENT-monthlyA transfer or savings line, not spending
Bank chargeSMS CHARGES-quarterlyBank charges
Interest creditINT PD-savingsIncome, 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?

  1. Sort the most frequent names first. Ten merchants often cover most of a month's lines.
  2. In SpendixAI, add a rule for a merchant once and later statements use it before any other method.
  3. Add a merchant alias when the same shop appears under different narration spellings.
  4. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports