Bank statements

How to categorise State Bank of India transactions

A three-pass method to categorise State Bank of India transactions: exact names first, then keywords, then people, with rules for next month.

Editorial illustration for How to categorise State Bank of India transactions

To categorise State Bank of India transactions quickly, work in three passes rather than line by line: first name the exact shops and billers that repeat, then group the leftovers by keyword, and last decide the lines that involve individual people. Each pass turns into a rule, so the next statement starts mostly sorted.

What is the first pass?

Sort the statement by narration so that identical names sit together. Create a category for each name that appears three or more times and write the rule once. The narrations below are invented to show the idea and are not copied from any State Bank of India statement.

Illustrative narrationRuleCategory
UPI-FRESHMART GROCERSName contains FRESHMARTGroceries
NEFT-SUNRISE POWER COName contains SUNRISE POWERElectricity
POS-CITY PHARMACYName contains CITY PHARMACYHealth
IMPS-WATER BOARDName contains WATER BOARDUtilities

What is the second pass?

Keywords catch the shops you only visit now and then. Words such as PETROL, PHARMACY, SWEETS, TRAVELS or STORES in a narration often point to a category. Use them as a first guess and look at the amount: a ₹90 payment to a place with SWEETS in its name and a ₹2,400 payment to the same place may be different things, a snack and a festival gift box for example.

Why are people left for the third pass?

A UPI payment to a named person tells you nothing about its purpose. The same person may be your domestic help one week and the repair man the next. Leave these lines until the end, and use what you know: the amount, the date and the day of the month. If a person is paid the same amount around the first of each month, that is a monthly commitment and a single rule covers it. Others you will classify by hand.

How do I turn this into rules?

  1. Write a rule for each name from the first pass.
  2. Add keyword rules from the second pass only for words you trust.
  3. For one person with a regular amount, add a rule that names them.
  4. Add an alias if one shop appears under several spellings.

SpendixAI applies your own rules first, then your history and similar merchants, and only then an AI model if you have turned that on. You can turn AI off for a feature, set a monthly AI budget, or switch it off completely; unmatched items are then held for your review.

How long does the first month take?

Say a month has 70 lines. The first pass, with rules for about 12 names, covers perhaps 38 lines. The keyword pass takes another 14, leaving 18 with people and odd items. At about ten seconds a line, that is a few minutes for the final pass. The figures are invented, but the pattern holds: the effort is front-loaded, and the second month is much lighter.

What do I do with the lines that do not fit?

Some lines will not fit any pass: a cash deposit with no narration, a reversal, an odd round figure. Park them in a category called To check rather than forcing a guess. Then use the calendar, your other statements and any receipts you kept to work out what each was. A reversal usually mirrors an earlier debit of the same amount, so look a few days back. Clearing the To check list once a month keeps your totals honest and stops mystery lines from piling up for a year.

Which lines are not spending?

  • Transfers to your own other accounts.
  • Card bill payments, since the card purchases are the spending.
  • Interest credited, which is income.
  • Bank charges, which are spending but belong in their own category.

Settle these early so that they never swell your monthly totals.

SPENDIXAI JOURNAL

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

Explore your reports