Bank statements

How to categorise Axis Bank transactions

Merge messy Axis Bank narrations into one clean merchant with aliases, then categorise UPI, NEFT, IMPS and card lines by rule, with a note on what AI sees.

Editorial illustration for How to categorise Axis Bank transactions

To categorise Axis Bank transactions reliably, first clean up the names, then assign categories. The same shop often appears under several spellings in a statement, so one shop becomes four merchants and four categories to fix. Merge the spellings into one name with an alias, set the category once, and the rest follows.

Why does one shop show up under many names?

Narration text depends on how the payment was made, so the same shop can look different on a UPI payment, a card swipe and an NEFT payment. The examples below are invented and not copied from any Axis Bank statement; check your own file for the real patterns.

Illustrative narrationPayment typeClean merchant name
UPI-FRESHMART GROCERS-payUPIFreshmart Grocers
POS-FRESHMART GRO MUMBAICard swipeFreshmart Grocers
UPI-FRESHMART-orderUPIFreshmart Grocers
NEFT-SUNRISE ELEC BOARDNEFTSunrise Electricity

How do I merge the spellings?

  1. Sort the narrations alphabetically so near-identical names sit together.
  2. Choose one clean name for each shop.
  3. Add the other spellings as aliases, so they all map to the clean name.
  4. Give the clean name a category and a rule.

After this, a rule works on the shop rather than on a particular string of text, and it keeps working when the bank changes how it writes narrations.

How are UPI, NEFT, IMPS and card lines different?

The payment type tells you how the money moved; it does not tell you what it was for. UPI and card lines carry a merchant name that you can use. NEFT and IMPS lines are often to a biller, a landlord or an individual, so check what the receiver is. A transfer to your own other account is not spending, whatever the channel. Label the type of movement first, then the purpose.

What does AI actually see?

If you turn AI on in SpendixAI, it is used only for what your rules and your history could not place, and it works from the normalised merchant name and an amount band. It does not receive your name, account numbers, the full statement text or balances. You can switch AI off for a feature, give it a monthly budget, or turn it off completely, in which case unmatched lines wait for your review. Optional features that read an unfamiliar statement layout do process the uploaded document, so use those only if you are comfortable with that.

What about lines to people rather than shops?

A UPI payment to a person carries a name but no purpose. Do not alias a person to a shop, and do not guess a category from the name alone. If you pay the same person the same amount each month, add a rule that names them, with the category that fits the reason, such as tuition or domestic help. For one-off payments to people, decide by hand and move on. Their category will be remembered if the same person turns up again.

What does the saving look like?

Say a statement has 66 lines and 18 of them are one shop under four spellings. With the alias in place, those 18 lines are sorted by one rule instead of four separate decisions. If another 20 lines are repeats of seven other merchants, a few more rules take care of 38 of the 66 lines, leaving 28 for you. The numbers are invented, but the arithmetic shows why cleaning names pays back quickly.

Aliases are worth the few minutes they take, especially for shops that appear under many spellings. Once an alias exists, a future statement with yet another spelling of the same shop only needs one more alias, not a new rule, and the history of your corrections stays attached to one clean merchant name rather than being scattered.

A short routine

  • Import the month and open the uncategorised lines.
  • Merge any new spellings into aliases.
  • Add rules for new merchants.
  • Fix wrong categories; the corrections are kept as history.
  • Look at the largest ten lines last.
SPENDIXAI JOURNAL

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

Explore your reports