Bank statements

How to categorise IndusInd Bank transactions

Categorise IndusInd Bank transactions with keyword rules: a sheet formula that matches narration text, plus how to treat ATM cash and standing instructions.

Editorial illustration for How to categorise IndusInd Bank transactions

To categorise IndusInd Bank transactions with rules, build a small keyword table: a piece of narration text on one side, a category on the other, and a formula that looks each line up. Cash withdrawals and standing instructions need their own treatment because the narration does not say what the money was for. The narration styles used here are invented examples, not copied from IndusInd Bank.

How do I build the keyword table?

In a second tab or in columns F and G, list keywords and categories. Imagine this hypothetical table in F2:G6:

Keyword (column F)Category (column G)
swiggyDining
grocerGroceries
petrolFuel
electricityUtilities
ATMCash

Use a few characters that always occur in the narration, not a whole name. Short keywords catch more variants, but a keyword like PAY would match half your lines, so be careful.

What formula looks the keyword up?

If the narration is in B2 and the table is in F2:G12, put this in C2 and copy it down:

=IFERROR(LOOKUP(2,1/SEARCH($F$2:$F$12,B2),$G$2:$G$12),"Review")

SEARCH finds each keyword inside the narration ignoring upper and lower case. LOOKUP returns the category of the last keyword that matched, and IFERROR shows Review when none did. Because the last match wins, put your specific keywords lower in the table than the general ones. This works in Excel and Google Sheets.

How should I treat ATM cash?

A withdrawal is not an expense. Give it a Cash category and exclude it from spending, then record the cash you actually spend, even in rough groups: vegetables, auto fares, tips. If the cash withdrawn is ₹6,000 and you can account for ₹4,500, call the remaining ₹1,500 Cash not tracked so it stays visible rather than disappearing.

What about standing instructions and EMIs?

A standing instruction line repeats on the same date with the same amount, which makes it easy to spot. The narration usually points to a reference rather than a purpose, so decide once what it is: loan EMI, insurance premium, a monthly transfer into savings. Then add a rule on the reference text. Keep the monthly amounts in your notes; if the amount changes, you will notice.

How do I test the keyword table?

Run the formula over a whole month and look at the damage. First count the unmatched lines with:

=COUNTIF($C$2:$C$500,"Review")

Then total a category, say Dining, with amounts in D:

=SUMIFS($D$2:$D$500,$C$2:$C$500,"Dining")

Repeat for each category. The category totals plus the Review total should equal =SUM($D$2:$D$500). Say Dining ₹3,100, Groceries ₹7,400, Fuel ₹2,500, Cash ₹6,000 and Review ₹4,200 add up to ₹23,200. If the grand total is ₹23,200 the table is classifying every line exactly once.

When does the sheet stop being enough?

Keyword tables work for a few months. Past that, SpendixAI offers rules, history from your corrections and similar-merchant matching in one place; AI can be added for what is left, or switched off if you prefer.

A monthly routine

  1. Paste or import the month's lines.
  2. Check every line marked Review.
  3. Add a keyword for each repeat.
  4. Total by category and compare with total debits minus cash and transfers.

Keep the keyword table short and honest. Thirty well-chosen keywords usually cover the bulk of a household's repeat payments; hundreds of keywords become a chore to maintain and start clashing with each other.

When two keywords can match the same line, remember that the lower one in the table wins. If a petrol pump also sells snacks and you want every visit to read Fuel, put the Fuel keyword below any Dining keyword that might also match. Test the order by pasting a few real narrations into a scratch column and watching which category appears.

SPENDIXAI JOURNAL

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

Explore your reports