Bank statements

How to categorise Union Bank of India transactions

Categorise Union Bank of India transactions without counting transfers, card bill payments and cash as spending, using a worked month of debits and spend.

Editorial illustration for How to categorise Union Bank of India transactions

The biggest mistake when you categorise Union Bank of India transactions is treating every debit as spending. Transfers to your own accounts, credit card bill payments and cash withdrawals are movements, not expenses. Label them separately and your real spending drops into view. The example lines are invented for illustration and are not copied from Union Bank of India.

Which debits are not spending?

  • A transfer to another account you own, such as a savings account or a recurring deposit.
  • A credit card bill payment, because the purchases on the card are the real spending.
  • An ATM withdrawal, which is cash until it is used.
  • A loan principal repayment, depending on how you want to track it; many people give EMIs their own category.

What does the difference look like in numbers?

Say that in a month the account shows these debits (hypothetical): rent ₹18,000, groceries ₹6,200, card bill payment ₹12,400, transfer to savings ₹15,000, a small bank charge ₹30 and electricity ₹1,850.

DebitAmountTreated as
Rent₹18,000Spending
Groceries₹6,200Spending
Card bill payment₹12,400Payment, not spending
Transfer to savings₹15,000Transfer
Bank charge₹30Spending
Electricity₹1,850Spending

Total debits are 18,000 + 6,200 + 12,400 + 15,000 + 30 + 1,850 = ₹53,480. Take away the card payment and the transfer, 12,400 + 15,000 = ₹27,400, and spending from this account is ₹26,080. A report built on raw debits would overstate spending by that ₹27,400.

How do I recognise transfers and card payments?

Transfers carry your own name or an account reference, and the same amount shows up as a credit in the other account. Card payments name the card issuer or a bill-payment service. When unsure, look for a matching entry on the other statement on the same day or the day after.

What if I lend money or a friend repays me?

Not every UPI line is a purchase. Suppose you pay ₹1,500 for a group dinner and friends send back ₹1,200 later. If you file the full ₹1,500 under Dining, and the ₹1,200 as income, your dining cost looks too high and your income too large. Either file the returned ₹1,200 under Dining as a refund-like credit, so that the category nets to ₹300, or give it a category such as Money lent or owed and clear it when it is settled.

The first is simpler and leaves a true picture of what the meal cost you.

How do I make this automatic?

  1. Create categories named Transfer, Card payment and Cash.
  2. Add a rule for each recurring line, such as the monthly move to savings or the card payment.
  3. Check at least once whether the reports exclude those categories from spending.

In SpendixAI you can create your own categories and sub-categories and write rules that run before anything else. Check the report you use, so that you know whether it counts transfers.

What about interest and refunds?

Interest credited by the bank is income. A refund from a shop is money back against an earlier expense, so it belongs in the same category as the original purchase if you want that category's total to be true. If it is mixed into Salary or Other Income, your spending will look higher than it was.

A short checklist

  • Mark transfers, card payments and cash first.
  • Categorise the rest by merchant.
  • Compare spending with total debits minus the movements.

When a category total surprises you, work backwards. Open the category, sort by amount and read the top five lines. A surprise is nearly always one big line: an annual insurance payment, a deposit paid for a rental, a gadget bought in a sale. If it will not repeat, note it in the line and do not let it distort how you judge the month.

If it will repeat, such as a yearly premium, divide it by twelve in your head and keep a little aside every month, so the next payment does not feel like an emergency.

SPENDIXAI JOURNAL

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

Explore your reports