Expense categories

Auto-categorise UPI rows on an India account you run from abroad

NRIs whose India account is used by family can sort UPI rows with merchant rules, so parents' spending is categorised without them filling anything in.

Editorial illustration for Auto-categorise UPI rows on an India account you run from abroad

If your India account is used by parents or a sibling for daily payments, you can sort its UPI rows without asking them to log anything. Download the statement yourself, write rules for the shops they use again and again, and use the few leftover rows as your list of questions for the next call home.

Why is this statement harder to read from abroad?

You do not know the local grocer, the pharmacy near the house or the plumber your father pays. A UPI line shows a handle and a reference, and you cannot walk down the road to check. Reading it blind takes much longer than a statement of your own spending.

How do you learn the merchants?

Use the family. Ask your mother or father to name the five places they pay most, and match each with a fragment of text in the statement. After one call you will have rules for the bulk of rows.

Place they paySeen on statement asCategory
Provisions storeShop handle with a short nameHousehold
PharmacyMedical shop handleMedical
Milk and newspaper vendorVendor handleHousehold
Society officeSociety nameProperty and society charges
Auto standPerson's name, small amountsLocal travel

How does SpendixAI help here?

Rules come first, then merchant defaults and your own history, then AI if you have it on. You choose the account before each import, so the India account stays separate from any account you hold abroad. Choose the base currency before the first import, because it cannot be changed after transactions exist, and each expense can carry its own currency if you record foreign payments too.

Two cautions. SpendixAI reads statements you upload, as PDF, CSV or Excel; it does not connect to your bank and never needs your net-banking login, so do not ask the family for theirs. And review the rows before saving, because layouts differ and not every statement will parse perfectly.

A worked example in rupees

Say a month shows 90 UPI rows on your parents' account, with ₹54,000 of debits in all. After your rules, 62 rows are placed: ₹21,500 Household, ₹9,800 Medical, ₹4,200 Property and society charges. That is ₹35,500 across 62 rows. The remaining 28 rows come to ₹54,000 − ₹35,500 = ₹18,500. On your next call you read out the five biggest and ask what each was.

Ground rules for the family

  • They never share OTPs, PINs or logins with you or anyone else; a statement download is enough.
  • They keep a photo of any large bill, so you can match it later.
  • They tell you before a big planned payment, like a repair, so it does not look like a mystery.
  • You agree on one name for each category, so the report reads clearly.

What about the first month?

Expect the first import to leave a lot of rows for review; that is normal. Spend an hour on it once, writing rules as you go, and keep a short note of anything your parents explain. The second month is lighter, and by the fourth you should only be reviewing new payees, such as a repair person or a one-time fee. If the family adds a new regular, such as a tuition teacher, write the rule the same day so it never joins the pile.

If a payment is genuinely unknown, mark it for review and ask. Guessing a category is how errors settle in.

SPENDIXAI JOURNAL

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

Explore your reports