Bank statements

How to categorise Canara Bank transactions

How to categorise Canara Bank transactions, from UPI and NEFT to ATM cash and cheques, with rules that make the next statement faster to sort.

Editorial illustration for How to categorise Canara Bank transactions

To categorise Canara Bank transactions, start by splitting the statement into money that was spent, money that only moved, and money that came in. UPI, card and bill payments are usually spent; ATM withdrawals and transfers between your own accounts only moved; salary, interest and refunds came in. Once those three buckets are separate, the category for each line is mostly a matter of reading the name in the narration.

Which kinds of lines should you expect?

The examples here are invented to show the general shape and are not copied from Canara Bank. Your own statement is the source of truth for exact wording.

  • A UPI line with a long reference number and a shop or person name, such as UPI/DR/508877665544/Lakshmi Stores (made up).
  • An NEFT or IMPS line with the sender or receiver name and a short note, such as NEFT-PRABHU TEXTILES-SALARY ADV (made up).
  • An ATM withdrawal line with a location, such as ATM WDL/TOWN BUS STAND (made up).
  • A cheque line that shows only a cheque number, such as CHQ PAID 004512 (made up).
  • A card swipe line with a store name.
  • Small charges and an interest credit, which are easy to miss because the amounts are small.

How should you handle ATM withdrawals?

If most of your household spending is in cash, the ATM line is where the real categorising happens. Treat the withdrawal as a transfer to Cash in hand, then record what the cash bought as separate expenses. Say you withdraw ₹10,000 in the first week. Over the next days you spend ₹2,400 on vegetables and fruit, ₹3,100 at the kirana and ₹1,500 on autos and bus fares. That is 2,400 + 3,100 + 1,500 = ₹7,000, leaving ₹3,000 you should still be holding or be able to explain.

If the gap is bigger than you expected, that is useful information, not a failure. Create a sub-category called Cash, unaccounted and put the difference there so the total stays honest.

What do you do with cheque lines?

A cheque line tells you the number and the amount, but not the reason. The reason lives on the counterfoil. Write the payee and purpose on the stub when you issue the cheque, and photograph the stub if you can. When the statement arrives, match the cheque number to your note and categorise it then. A school fee cheque and a cheque to a plumber look identical on the statement.

Can UPI, NEFT and IMPS be sorted by the same rules?

Mostly yes, because rules look at the name in the narration, not the channel. But the three behave differently in practice:

  • UPI is usually small, frequent and to shops; rules by merchant work best.
  • NEFT is often larger and less frequent: rent, school fees, a vendor. Write the rule on the receiver name.
  • IMPS is often person to person and urgent. Review these by hand until a pattern is clear.

How do you set up rules so next month is faster?

  1. Sort the statement by amount and categorise the ten biggest lines first; they decide most of your totals.
  2. Group repeating names (milk, kirana, pharmacy) and write one rule per name.
  3. Add rules for the charges lines and the interest credit so they never need attention.
  4. Leave cheques and ATM lines manual, because their purpose changes.
  5. At month end, look at what stayed uncategorised and add rules only for items that repeat.

SpendixAI works the same way: you choose the account before uploading, review the rows before saving, and each correction you make is remembered as history for next time. You can also add merchant aliases and enter cash expenses by hand, one at a time or several together.

Which charges and credits deserve a second look?

Small recurring debits are the ones that slip through. If a charges line appears every month, note the amount and compare it with what the bank told you when you opened the account or with its current notice, because fees change. Interest credits should be recorded as income, not netted against spending. If a refund appears, tie it back to the original purchase so the category total is not overstated.

SPENDIXAI JOURNAL

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

Explore your reports