Getting started

Categorising a Standard Chartered statement: rules that stick

A practical way to categorise Standard Chartered India statement lines: decide categories first, write merchant rules, and handle UPI and card lines.

Editorial illustration for Categorising a Standard Chartered statement: rules that stick

Sorting a Standard Chartered India statement goes quickly once a short category list is settled before reading any line, then the statement is sorted by merchant name and categories are assigned in groups. Ten minutes of setup means next month's statement needs only a handful of decisions.

How many categories do I really need?

Fewer than you think. Start with eight to twelve, such as Groceries, Eating out, Transport, Utilities, Rent or home, Health, Shopping, Travel, Subscriptions and Other. Splitting too early creates arguments with yourself about whether a coffee is Eating out or Treats. You can always split a big category later, but merging dozens of tiny ones is painful.

Which lines are easy and which are hard?

Statement line (made up)AmountCategoryHow sure
Supermarket POS 1442₹3,240GroceriesSure
Electricity board online₹1,880UtilitiesSure
UPI to a person's name₹500Needs your memoryNot sure
Cash withdrawal at ATM₹5,000Cash, then split laterNot sure
Card payment to an airline₹9,600TravelSure
Annual fee on card₹1,000Bank and card chargesSure
Transfer to own savings account₹10,000Transfer, not spendingSure

The two traps are person-to-person UPI payments and cash withdrawals. A name tells you nothing about why you paid. Either note the reason straight away from your phone's payment history, or park them in a Needs review category and settle them once a week.

How do I write merchant rules that save time?

  1. Sort the month by description so identical merchants sit together.
  2. Pick the merchant text that stays the same, for example the supermarket name without its store code or date.
  3. Assign one category to that text. In a spreadsheet, keep a two-column lookup list of merchant text and category, and use =IFERROR(VLOOKUP(...),"Review") so unknown merchants fall into a review bucket automatically.
  4. Work down the Review bucket, add each new merchant to the lookup list, and recalculate.
  5. Never create a rule for text that appears under different purposes, such as a payment gateway name that covers dozens of shops.

What does the first pass look like with real arithmetic?

Say a month has 60 lines totalling ₹58,400. After the rule list handles the repeat merchants, 44 lines are categorised, worth ₹49,900. That leaves 16 lines worth ₹8,500 in Review. Those sixteen lines are about a quarter of the rows, so they are where the remaining decisions live, and ten minutes on them finishes the month. Check afterwards that categorised plus review equals ₹58,400.

Can an app do the sorting for me?

SpendixAI categorises uploaded statement rows in stages: your own rules first, then your past corrections and similar merchants, and only if AI is switched on, a model for whatever is still unmatched. It uses a cleaned merchant name and an amount band for that step, not your name or account numbers, and you can turn AI off, so unmatched rows simply wait for your review. Your corrections become history for next month. Check the first month against your own statement before you trust the totals, so any mismatch is caught early.

A short monthly routine

  • Import or paste the statement, choose the account, and set aside transfers first.
  • Apply merchant rules, then clear the review bucket.
  • Compare category totals to the statement total.
  • Add any new merchant to your rules so it never needs deciding again.
SPENDIXAI JOURNAL

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

Explore your reports