To categorise Yes Bank transactions, read every line for two things: how the money moved (UPI, NEFT, IMPS, card, ATM or a standing instruction) and who or what it went to. Then turn each repeat payee into a rule, so the same line is never decided by hand twice. In most accounts a month's lines fall into five or six repeating types.
What kinds of lines will you see in a Yes Bank account?
A savings account statement is a mix of the same few movements at any bank. The wording of the narration differs from bank to bank and changes over time, so the lines below are invented in a typical style and are not copied from any Yes Bank statement. Open your own statement and see how yours reads.
| Line type | Illustrative narration | What to decide |
|---|---|---|
| UPI payment | UPI/DR/412345678901/GREEN LEAF GROCERS | What was bought, judged from the payee |
| NEFT credit | NEFT CR-ACME WORKS-MONTHLY PAY | Income, so it is not spending |
| IMPS transfer | IMPS/P2A/RAHUL M/FLAT SHARE | Rent, a gift or a loan to a friend |
| ATM withdrawal | ATM WDL 5000 | Cash taken out; the spending happens later |
| Card swipe | POS/CAFE MOCHA/BENGALURU | Eating out, going by the shop |
| Standing instruction | SI/BROADBAND/MONTHLY | A bill that repeats on the same date |
| Bank charge or interest | SMS ALERT CHG / INT CREDIT | Bank charges or interest earned |
How should you handle UPI lines, the biggest group?
UPI usually produces the most rows, and each carries a payee name. Sort them into three buckets and the pile shrinks quickly.
- Shop or business names: categorise by what that place sells. A grocer is Groceries, a cafe is Eating out, a chemist is Health.
- Person names: these tell you nothing on their own. Ask what the payment was for, and remember that one friend may be both rent and the occasional dinner share.
- Repeat payees: any name that appears three or more times a month deserves a rule, whatever its bucket.
Which lines are not spending at all?
Three kinds of rows inflate your totals if you call them expenses. A transfer to your own other account is just money moving. A payment of your credit card bill is also a transfer, because the purchases already sit on the card's own statement. And a cash withdrawal is cash in your wallet, not a purchase. Put these in a Transfers or Cash category so that your Food or Shopping totals stay honest.
How do you set rules so next month sorts itself?
- Scan the month for names that repeat and list the top ten by count.
- Write each rule on the stable part of the narration, such as the shop name, never the long reference number that changes every time.
- Attach the category, then re-run and count how many lines are still uncategorised.
- Where one shop appears under two spellings, add the second spelling as an alias so both land in one place.
- Do the rest by hand once, because a hand correction is worth more when it is saved as a rule.
In SpendixAI the order is your own rules first, then your past corrections and similar merchants, and only then, if you have switched AI on, an AI model for what is left. Switch AI off and unmatched lines are simply held for review instead.
What about charges, interest and cash?
Small bank charges are easy to ignore and easy to total. Give them their own category and you will see in one number what the account costs you over a year. Interest credits belong under Income or Interest, not under a refund. For ATM cash, either leave a Cash category and enter the real purchases by hand when you remember them, or accept that cash is a blind spot and track only the withdrawal.
A short monthly routine
- Import the month, or paste the rows into your sheet.
- Scan the uncategorised rows for names that repeat.
- Fix those first, then clear the one-offs.
- Mark transfers and card bill payments so they stay out of spending.
- Look at the top three categories and ask whether they match how the month felt.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


