The reliable way to categorise AU Small Finance Bank transactions is with keyword rules: a short word from the narration, such as a shop name, mapped to a category. A handful of well-chosen keywords covers most UPI, card and standing instruction lines, and merchant aliases fold the different spellings of one shop into a single rule.
What does a keyword rule look like?
A rule says that if the narration contains a certain word, the category is such-and-such. The narration texts below are invented in a typical style and are not copied from any AU Small Finance Bank statement.
| Illustrative narration | Keyword to use | Category |
|---|---|---|
| UPI/DR/GREEN LEAF GROCERS/okhdfc | GREEN LEAF | Groceries |
| POS/METRO PHARMACY/JAIPUR | PHARMACY | Health |
| SI/PIPED GAS/MONTHLY | PIPED GAS | Utilities |
| UPI/DR/RAJU AUTO | RAJU AUTO | Transport |
| ATM WDL | ATM WDL | Cash |
How do you choose the keyword?
Pick the part of the narration that stays the same each time. Shop names and biller names are good. Reference numbers, dates, branch codes and the name of the UPI app are poor, because they change or appear on unrelated lines. Keep the keyword short enough to catch variants and long enough not to hit the wrong thing. PHARMACY will catch many chemists, but GREEN LEAF is safer than GREEN.
How do aliases help?
One shop can appear as GREEN LEAF GROCERS, GREENLEAF GROCERS BLR and GL GROCERS. Make a single rule and add the other two as aliases of the same merchant. Every future row with any of the three names then lands in Groceries. SpendixAI supports merchant aliases, and your corrections are kept as history, so a second sighting of an odd spelling is often matched by itself.
What order should rules run in?
Specific before general. If you have a rule for a named pharmacy under Health and a general rule for the word STORE under Shopping, the narration POS/CITY MEDICAL STORE could fit both. Order your rules so the more specific one wins, and review the first month's matches to catch surprises.
Can you do the same in a spreadsheet?
Yes, with a small lookup table. Put keywords in H2:H20 and categories in I2:I20, with narration in B2. Then in C2:
- =IFERROR(LOOKUP(2^15, SEARCH($H$2:$H$20, B2), $I$2:$I$20), "Review")
- SEARCH finds each keyword inside the narration and ignores case.
- LOOKUP returns the category of the last keyword that matched, so list general keywords first and specific ones last.
- Rows with no match show Review so that you can add a keyword.
Fill it down. It works in Excel and in Google Sheets. When the keyword list grows long or you start importing several accounts, a tool with rules, history and optional AI does the bookkeeping for you.
What do the other lines need?
Standing instructions are bills that repeat, so a rule per biller catches them forever. Charges and interest are small but frequent, so give them categories of their own. NEFT and IMPS credits are usually income or money from a person, which you can label by the sender's name. Transfers to your own accounts and card bill payments belong in a Transfer label rather than spending.
How many rules is enough?
Fewer than you think. Rank the month's merchants by how many rows each has, write rules for the top fifteen or so, and count what is left. If a hundred lines shrink to twenty, the remaining rules are not worth chasing yet. Revisit after a second month, when a new pattern will have appeared. A rule that never matches is clutter, so delete it.
A rule-writing checklist
- One rule per repeat payee, using the stable part of the name.
- Aliases for each spelling you have seen twice.
- Specific rules above general ones.
- A glance at what each new rule matched.
- A Review bucket that you clear monthly.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


