Bank statements

How to categorise ICICI Bank transactions

How to categorise ICICI Bank transactions: read UPI, NEFT, IMPS, ATM, card and standing-instruction lines, then set rules so next month sorts itself.

Editorial illustration for How to categorise ICICI Bank transactions

To categorise ICICI Bank transactions, read each narration for two things: the channel (UPI, NEFT, IMPS, ATM, card, standing instruction) and the name on the other side. The channel tells you what kind of movement it was, and the name tells you what the money was probably for. Once a name keeps coming back, turn it into a rule and you will not have to decide it again.

What do the lines in an ICICI Bank account look like?

Narration wording differs between banks, between channels and even between years, so the lines below are made-up examples in a general shape, not copied from ICICI Bank. Open your own statement and use its exact wording when you build rules.

ChannelMade-up narrationWhat it usually meansStarting category
UPIUPI/301122334455/Sharma MedicalsPayment to a shop or businessHealth, or by merchant
NEFTNEFT-R K PROPERTIES-NOV RENTBank transfer to a landlordHousing, Rent
IMPSIMPS/P2A/Ravi K/dinnerInstant transfer to a personNeeds a look
ATMATM WDL/MG ROADCash taken outCash withdrawal
CardPOS/FRESHMART BLRCard swipe at a storeGroceries, by merchant
Standing instructionSI/SOCIETY MAINTFixed payment set up in advanceHousing, Maintenance
ChargesSMS ALERT CHGSBank chargeBank charges
InterestINT PDInterest creditedInterest income

Which lines cannot be sorted from the narration alone?

Most UPI and IMPS lines that go to a person are the hard ones, because a name like Ravi K tells you nothing about purpose. Handle them in this order:

  • Check the UPI note or remark if your statement shows it; people often type "milk", "rent" or "chai".
  • Check the same date in your UPI app history, where the note you typed is usually visible.
  • If it is still unclear, put it under a holding sub-category such as Person payments, to review, and settle it at the end of the week while you still remember.
  • For people you pay every month for the same reason (a cook, a driver, a tutor), make a rule once and the holding step disappears.

How should you treat UPI to a shop versus UPI to a friend?

Shop payments carry the merchant name, so one rule per merchant usually does the job: Sharma Medicals goes to Health, Freshmart goes to Groceries. Payments to friends are often one of three things: a share of a bill you split, a loan you will get back, or a gift. Do not push them all into Food. Keep a sub-category for money you expect back, and clear it when the friend pays you.

What rules should you set up so next month sorts itself?

  1. List the ten names that appear most often on your statement; they usually cover most of the lines.
  2. Write one rule per name, matching a distinctive part of the narration rather than the full reference number, which changes every time.
  3. Add rules for the fixed items: standing instruction for society maintenance, interest credit, SMS and alert charges.
  4. Leave person-to-person transfers without a rule unless the purpose never changes.
  5. Review what is left each week and fix the category once; that correction should be reused for the same merchant later.

If you use SpendixAI, you pick the ICICI account first, upload the statement as PDF, CSV or Excel, and review the rows before saving. Your own rules run first, then your past choices and similar merchants. An AI model only sees what is left if you have switched AI on, and you can switch it off.

A worked example: one hypothetical week

Say these are the debits in a week: UPI to Sharma Medicals ₹640, card at Freshmart ₹2,350, UPI to Ravi K ₹800, ATM withdrawal ₹3,000, standing instruction for society maintenance ₹1,800 and SMS charges ₹15. Totals: Health ₹640, Groceries ₹2,350, Person payments to review ₹800, Cash withdrawal ₹3,000, Housing ₹1,800, Bank charges ₹15. Add them: 640 + 2,350 + 800 + 3,000 + 1,800 + 15 = ₹8,605, which should match the total debits for the week on your statement.

The ₹3,000 of cash is not yet spending. If you note ₹1,200 on vegetables and ₹900 on an auto, ₹900 is still cash in hand, which is a number worth knowing.

What should you check before closing the month?

  • Total debits and credits match the statement.
  • Nothing is left in the review holding category.
  • Every ATM withdrawal has been followed by at least a rough note on where the cash went.
  • New merchants that appeared this month now have rules.
SPENDIXAI JOURNAL

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

Explore your reports