Bank statements

How to categorise Indian Bank transactions

A line-by-line method to categorise Indian Bank transactions, with a worked fortnight, a balance check, and rules to speed up the next statement.

Editorial illustration for How to categorise Indian Bank transactions

To categorise Indian Bank transactions properly, read each narration in four parts (channel, reference, name, note), assign a category from the name, and then check that your categorised totals add up to the statement's credits and debits. The check is the part most people skip, and it is what tells you nothing was missed or counted twice.

How do you read a narration in four parts?

  1. Channel: UPI, NEFT, IMPS, ATM, card (often shown as POS), or a bank-generated entry such as interest or charges.
  2. Reference: a long number that is unique to the transaction. Ignore it when writing rules.
  3. Name: the shop, person or institution. This is what you match on.
  4. Note: any text you or the sender typed, such as "school fee" or "advance". This is the best clue for purpose.

Banks lay these out differently, and the examples in this article are made up, not copied from Indian Bank. Check your own statement.

What does one hypothetical fortnight look like?

DateMade-up narrationAmountCategory
2UPI/Sri Ganesh Tiffin₹180 outFood, Eating out
3UPI/Anand Kirana₹1,420 outGroceries
5NEFT-SALARY-EMPLOYER₹38,000 inIncome, Salary
6ATM WDL/MAIN ROAD₹4,000 outCash withdrawal
8POS/MEDPLUS PHARMA₹560 outHealth
9IMPS/P2A/Meena/book fees₹1,200 outEducation
12SI/ELECTRICITY BILL₹1,640 outUtilities, Electricity
14INT PD₹36 inIncome, Interest

Debits: 180 + 1,420 + 4,000 + 560 + 1,200 + 1,640 = ₹9,000. Credits: 38,000 + 36 = ₹38,036. If the account started the fortnight with ₹12,500, then 12,500 + 38,036 - 9,000 = ₹41,536 should be the closing balance on the statement. If your figure differs, a line is missing, doubled or mis-keyed, and it is far easier to find in two weeks of data than in a year.

Notice what the table does with two lines. The ATM withdrawal of ₹4,000 is not counted as spending, and the salary and interest are not counted as anything you spent. If you want a cash-in-hand figure, enter what the ₹4,000 bought as separate small expenses later, and the three buckets (spent, moved, received) will each add up on their own.

How do you check that nothing was missed?

  • Compare the sum of your categorised debits with the statement total for the same period.
  • Compare the sum of credits the same way.
  • Check the opening balance plus credits minus debits against the closing balance, as above.
  • Look for the same amount twice on the same day; it may be a genuine repeat purchase or a duplicate import.

Which lines should you leave uncategorised on purpose?

A few lines are better left in a clearly named holding place than forced into a category. Person-to-person IMPS with no note, a one-off NEFT to a name you do not recognise, and a card swipe at a merchant with a code-like name all fit here. Forcing them into Miscellaneous hides them; a holding category with a weekly look keeps them visible.

What rules are worth adding after the first month?

  • One rule per repeat merchant (the tiffin place, the kirana, the pharmacy).
  • A rule for the electricity standing instruction and any other fixed bill.
  • A rule for the interest credit as income.
  • Rules for ATM lines, pointing to Cash withdrawal so they never count as spending.

When you work in SpendixAI, pick the account before import so every row keeps it, then use the review screen before saving. Corrections you make there become history that later imports can use.

Questions to ask when the totals look wrong

Is the period the same on both sides? Did one statement include a line dated the 1st that the other counted in the previous month? Did a cash withdrawal get both categorised as an expense and then counted again when you entered the cash purchases? Work through these three first; they explain most mismatches.

SPENDIXAI JOURNAL

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

Explore your reports