To categorise HSBC India transactions, separate the card and foreign-currency lines from the everyday UPI, NEFT and IMPS lines, because they raise different questions. For domestic lines you match on the merchant or person. For foreign-currency lines you also need the original amount, the currency and the rate that turned it into rupees, so the rupee total stays explainable.
How do card swipes differ from UPI and transfers?
A card line usually carries the merchant name and sometimes a city. A UPI line carries a reference and a payee name. A transfer carries the other party's name and any note. For rules, all three work the same way: match on a distinctive part of the name. The difference is how reliable the name is. Card merchants often use trading names that differ from the shop's board, so an online store may show up as a company name. Check your own statement; the examples here are invented, not copied from HSBC India.
- Card, domestic: POS/URBAN BOOKSHOP DEL (made up).
- Card, online: ONLINE*STREAMCO SUBSCRIPTION (made up).
- UPI: UPI/221100998877/Dr Rao Clinic (made up).
- Transfer: IMPS/P2A/Kavita/cook advance (made up).
What happens to foreign-currency spending?
Say you pay a subscription of 12 US dollars. The statement shows a rupee amount, and the way the bank shows the original amount and rate can vary, so look at your own statement. Suppose the rate used was ₹83 to the dollar: 12 × 83 = ₹996. The rupee figure is what left your account; the 12 dollars is the context.
SpendixAI lets each expense carry its own currency and shows totals in a base currency using the rate saved with that transaction. You choose the base currency before importing, and it cannot be changed once transactions exist, so decide first. A Foreign-currency spend report then gathers those lines together.
Should charges on foreign transactions be a separate line?
If your statement shows a separate charge line next to a foreign purchase, keep it separate under Bank charges rather than folding it into the purchase. That way Travel or Subscriptions shows the true price of the thing, and Bank charges shows what banking cost you. If the cost is built into the rate instead, you will not see a separate line, and that is also worth knowing. Do not guess at the amount; ask the bank or read the notice it gave you.
How do you handle refunds and reversals?
A refund is a credit that cancels part of an earlier debit. Do not file it as Income. Link it to the original purchase category so the net spending is right. Say a ₹4,800 order is returned in full: Shopping is ₹4,800 out and ₹4,800 back, so net zero. If you leave the credit as Income, Shopping looks ₹4,800 higher than it really was.
Which rules save the most time?
- A rule for each subscription that shows up monthly, so it lands in Subscriptions without attention.
- A rule for domestic grocery, pharmacy and fuel merchants you use often.
- A rule for any recurring charges or fees line, pointing to Bank charges.
- A rule for interest credits, pointing to Income, Interest.
- A holding sub-category for person-to-person transfers you cannot explain from the note.
For an unfamiliar merchant name, SpendixAI can use an AI model only if you have it turned on, and then it works from the normalised merchant name and an amount band rather than your name, account numbers or balances. You can switch AI off for a feature or entirely, and unmatched rows are held for your review.
What should you do if something looks wrong?
If a charge looks unfamiliar, do not just categorise it away. Note the date and amount, check your card app or email for a receipt, and contact the bank through its official channels if it still makes no sense. Never share OTPs or card details with anyone who calls you about it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


