Do not categorise a month of IDFC FIRST Bank transactions row by row. Sort by merchant, label the ten or so names that repeat most, and set rules so they file themselves from next month. Then deal separately with payments to individuals, which need a decision from you because the bank statement cannot tell a landlord from a friend.
Why start with the repeat names?
In most months a handful of merchants account for most of the rows: a grocery store, a fuel station, a food delivery service, a pharmacy, a few subscriptions. Labelling those first clears the bulk of the work in a few minutes. The long tail of one-off purchases can wait or be left in a Review category.
A worked example: ten rows to sort
Say a statement includes these merchants, with made-up amounts:
| Merchant | Rows | Total | Category |
|---|---|---|---|
| Neighbourhood grocery | 9 | ₹6,420 | Groceries |
| Fuel station | 4 | ₹3,200 | Transport |
| Food delivery | 6 | ₹2,640 | Eating out |
| Pharmacy | 3 | ₹1,150 | Health |
| Streaming subscription | 1 | ₹499 | Subscriptions |
| Total labelled | 23 | ₹13,909 | - |
₹6,420 + ₹3,200 + ₹2,640 + ₹1,150 + ₹499 comes to ₹13,909 across 23 rows. If the month had 60 rows, labelling these five names cleared more than a third of them. That is why the order matters: sort by number of rows or by amount, and work down.
How do you handle UPI payments to people?
A UPI payment to an individual shows a name, not a business. The same name could be rent, a friend repaying dinner or a domestic helper. Decide once and record it:
- If the amount is fixed and monthly, it is likely rent or salary for help. Make a rule for that exact name.
- If amounts vary, add a note for the first few times so you remember what they were.
- If it is a repayment or a shared bill, mark it as a transfer or reimbursement rather than your own spending.
- If you truly do not know, leave it in Review for a week and ask the person.
What do you do about names that look different?
The same merchant can appear with a branch code or a slightly different spelling. Pick one clean name and add the variants as aliases or rules. In SpendixAI, rules come first, then your history and similar merchants, and an AI model only handles what is left, if you have it switched on. You can switch AI off, and then unmatched items wait for your review. Corrections you make become history, and you can add merchant aliases.
How do you keep rules from going wrong?
A rule that is too broad files the wrong things. A keyword such as 'STORE' would catch groceries, electronics and clothes alike. Choose the most specific recurring part of the name, test the rule on last month's rows and look at what it touches. If it catches something wrong, narrow it. Check rules again every quarter, since businesses change names and you may have changed shops. A few precise rules beat dozens of loose ones.
A review routine that takes ten minutes
- Import the month, then sort by merchant name.
- Label the top merchants and create rules.
- Handle UPI payments to people with the steps above.
- Scan Review items and decide or defer.
- Compare category totals with last month for anything odd.
If you prefer a spreadsheet, the same approach works: filter by merchant, fill the category once and copy it down. What matters is the order, biggest and most repeated first. I make no claim about how IDFC FIRST Bank formats its narrations, so look at your own rows before you choose rule keywords.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

