Budgeting

Merchant analysis when UPI payees are people, not shops

UPI payments often go to people, not shops. Tag each payee name with a purpose so your merchant analysis and spending by UPI payee report make sense.

Editorial illustration for Merchant analysis when UPI payees are people, not shops

When most of your UPI payments go to individuals, a merchant report shows a list of personal names and tells you nothing. The fix is a small payee-to-purpose table: for each name you pay more than once, write what the payment is for, and group by that instead of the name.

Why UPI payee names are a problem

Your statement shows what the payee called themselves on UPI, which for a vegetable seller, a tuition teacher or a house help is usually a person's name. A report that ranks by payee will put "Ramesh K" and "Sunita D" above your biggest bills, with no hint of why. Names can also vary: a truncated version in one month and a full name in the next.

Build a payee-to-purpose table

  1. Export or copy the last three months of UPI payments with the payee name and amount.
  2. List each payee name that appears two or more times; ignore one-off names for now.
  3. Next to each, write a purpose in two or three words, and a category.
  4. Add a row for each spelling variant of the same person.
  5. Use the table to label every row of the transaction list.
Payee as on statementPurposeCategory
Ramesh KVegetable vendorGroceries
Sunita DHouse help, monthlyHousehold help
Anil SMaths tuitionEducation
Landlord nameRentHousing
Friend's nameRepaying a dinner splitRepayment, not spending

How do you apply it in a spreadsheet?

Put the table on a second sheet called Payees, in columns A to C, with payee names in column A. On your transaction sheet, if the payee is in column B, the purpose in column E is =IFERROR(VLOOKUP(B2,Payees!$A$2:$C$100,2,FALSE),"Untagged") and the category in column F is =IFERROR(VLOOKUP(B2,Payees!$A$2:$C$100,3,FALSE),"Untagged"). Anything that comes out as Untagged is a new payee to add. VLOOKUP works in Excel and Google Sheets alike; XLOOKUP is a newer alternative in Excel 365 and 2021.

What about money you pay to friends?

Repayments are the tricky ones. If you pay a friend ₹1,200 for your share of a trip, that is spending; if you pay back ₹1,200 you borrowed last week, it may only be a repayment of a loan you recorded when the money came in. Decide a rule, tag these separately, and keep them out of your category totals unless they were really a cost of yours.

Does this work without spreadsheets?

Yes. In SpendixAI you can add your own categorisation rules, so a payee name always lands in the category you chose, and you can correct a row once and have that correction become history for similar payments. Merchant aliases help when one person appears under two spellings. Review imported rows before saving, because payee names are where mistakes cluster.

Keeping it up

  • Once a month, filter for Untagged rows and tag any payee that appears twice.
  • Leave one-off names untagged until they recur; tagging every stranger is wasted effort.
  • When someone changes role, such as a house help who starts doing tuition, add a note with the date.
  • If you share the sheet with family, keep the table to initials and purposes, not full personal details.

Expect the first pass to take longer than later ones. A typical person pays a handful of individuals regularly and dozens once or twice. Cover the regular handful and the report is already useful; the rest can wait until they recur.

What the report looks like afterwards

Group by purpose and the earlier list of names turns into something you can act on: vegetable vendor ₹4,200, house help ₹6,000, tuition ₹3,500. Now a merchant report answers the question you had, which is where the money goes, not who received it.

SPENDIXAI JOURNAL

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

Explore your reports