To categorise a Punjab National Bank statement quickly, do not go line by line from the top. Sort the work into five passes: own-account transfers, recurring bills, the biggest payees, cash withdrawals and finally the leftovers. Each pass clears a large share of rows, and you finish with a short list that deserves a real decision.
Pass one: take out your own transfers
Money moving between your own accounts is not spending. Mark those rows first, whether they are to a savings account, a fixed deposit or a family account you also hold. Left in, they inflate both income and expenses. If your tracker lets you assign each transaction to an account, move or tag them so they cancel out.
Pass two: recurring items
Rent, EMIs, SIP debits, insurance premiums, broadband, society maintenance and subscriptions repeat with similar amounts on similar dates. Search the narration for each, set a rule once, and every future statement will categorise them on its own. Many trackers apply your own rules first, so this pass pays off every month.
Pass three: the ten largest payees
Sort by amount, descending, and look at the top rows. Most statements have a handful of payees that account for most of the money. Say a month has 64 debit rows totalling ₹71,000. The top ten rows might total ₹52,000, which is 52,000 / 71,000, about 73 per cent of the spending, with only ten decisions. Categorise those carefully and the rest matters far less.
| Pass | What you handle | Typical rows cleared |
|---|---|---|
| 1 | Transfers between own accounts | A few |
| 2 | Recurring bills and instalments | Five to ten |
| 3 | Largest ten payees | Ten |
| 4 | Cash withdrawals | A few |
| 5 | Everything left | The remainder |
Pass four: cash withdrawals
An ATM withdrawal is a single number that hides many small expenses. Either categorise it as Cash and keep a separate note of what you spent it on, or add the individual cash expenses by hand and mark the withdrawal as a transfer to your wallet so it does not count twice. Pick one method and stay with it.
Pass five: the leftovers and UPI names
UPI narrations carry names, handles and reference numbers, so the same shop can appear under different strings. Group rows by payee name, decide the category once and apply it to the whole group. Where the person is not a business, such as a friend you repay, use a category like Personal transfers. Tools that normalise merchant names and remember corrections, as SpendixAI does through history and merchant aliases, shorten this pass over time.
How long should this take?
The first statement is the slow one: perhaps half an hour for a typical month, since you are creating the rules. From the second month on, most recurring rows categorise themselves and you only meet the new payees. If a statement still takes thirty minutes every month, you are probably deciding the same payees repeatedly, so set a rule instead of fixing rows one at a time. Check your own statement's layout once to see which part of the narration is the stable payee name, because that is the text to build your rules on.
How do you check your work?
- Add up the category totals and compare with total debits.
- Look at the largest uncategorised row. If it is over a few thousand rupees, decide it now.
- Scan the Others category. If it holds more than a few per cent of spending, split it.
- Read the layout of your own statement once so you know where narration and reference numbers sit.
The first statement takes the longest. After the rules exist, each month is a quick review of the few new payees.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


