Bank statements

How to categorise IDBI Bank transactions

How to categorise IDBI Bank transactions: read UPI, NEFT, IMPS, ATM, card and charge lines, then set rules so next month's entries categorise themselves.

Editorial illustration for How to categorise IDBI Bank transactions

To categorise IDBI Bank transactions, first work out what kind of line each one is, such as a UPI payment, a NEFT or IMPS transfer, an ATM withdrawal, a card swipe, a standing instruction or a bank charge. The kind tells you what extra detail to look for. Then create a rule for each merchant or person that repeats, so next month's lines are sorted for you.

What kinds of lines will you see?

The examples below are invented to show the general style of narration. They are not copied from any IDBI Bank statement, and your own statement will read differently, so use them as a way of thinking rather than a template.

Illustrative narrationWhat it usually isLikely category
UPI payment to a sweet shop with a reference numberUPI purchaseFood and eating out
NEFT credit from an employer nameSalary or payment inIncome
IMPS transfer to a person's nameMoney sent to someoneDepends on why
ATM cash withdrawal at a named locationCash taken outCash, then split later
Card swipe at a fuel stationCard spendingFuel and travel
Standing instruction to an insurer or societyRecurring paymentInsurance or housing
SMS charges or annual feeBank chargeBank charges

Which lines need a decision from you?

A shop on a UPI line is easy to place. The trouble comes from lines that name a person. A UPI or IMPS payment of ₹2,500 to an individual could be the vegetable vendor, a friend's share of a dinner or your child's tuition teacher. The statement cannot tell you, so you decide once and write a rule if that person always means the same thing.

ATM withdrawals are similar. Put them in a Cash category first. If you want to know where the cash went, add a few hand entries for the larger purchases later.

How do you set rules that last?

  1. Sort the largest and most frequent merchants first.
  2. For each, note a short, stable part of the narration, such as the shop name, rather than a reference number that changes every time.
  3. Create a rule tying that text to a category.
  4. Add an alias if the same merchant appears under several spellings.
  5. Correct any wrong guess when it appears, so the correction becomes history.

SpendixAI sorts in stages. Your own rules come first, then your history and similar merchants, and only if AI is switched on does an AI model handle what is left, using the cleaned merchant name and an amount band rather than your name, account numbers or balances. You can switch AI off, give it a monthly budget, or turn it off entirely, in which case unmatched lines wait for your review.

Do charges and interest need their own category?

Yes, give them one. A small line for charges looks harmless, but twelve months of them add up. Suppose a quarterly charge is ₹59 and four appear in the year; that is 4 × 59 = ₹236, which is worth seeing on its own. Interest credits belong in Income or a separate Interest category, so they do not make your salary look larger.

What about reversals and refunds?

A refund from a shop comes back as a credit, often a few days after the purchase. Put it in the same category as the original purchase, with the sign reversed, so your food or shopping total falls rather than your income rising. A failed payment that is returned shows up as a debit and a credit of the same amount; leave both in the Transfers or Reversal category and they cancel out.

A short routine

  • Import the month and review the rows.
  • Sort the unknowns, largest first.
  • Write or adjust rules for repeats.
  • Check the charges category and the cash category.
  • Compare the total with your statement's closing balance.
SPENDIXAI JOURNAL

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

Explore your reports