To clean up UPI history with an AI assistant, paste a masked list of payments and ask it to group them by payee and ask you questions about every unclear name, instead of assigning categories on its own. UPI lists are full of personal names, and a name tells you who received the money, not what you bought. Your answers, not the assistant's guesses, should decide the category.
Why UPI lists confuse automatic sorting
A payment to "Suresh Kumar" could be vegetables, an auto ride, a tutor or a friend repaying a loan. A shop with a brand name is easy; a person is not. The name shown may be what the receiving account is registered as or what you saved the contact as, so it often says little about the purpose.
Whichever way you get the list, whether copied from your payment app's history screen, read from your bank statement, or typed in, check what your own app and bank offer. Do not paste anything beyond date, payee text and amount.
Mask before you paste
- Delete mobile numbers and full UPI addresses; keep the name part only.
- Remove reference or transaction IDs, which add length and no meaning.
- Replace your own name and any family names with a label.
- Keep date, payee name, amount, and whether it was a payment or a receipt.
The prompt that asks instead of guessing
Prompt: "Here is a masked list of my UPI payments with Date, Payee and Amount. First, group the rows by payee and give me the count and total for each. Do not assign any category when the payee looks like a person's name; write ASK instead and give one short question I can answer in a few words, such as whether it was rent, a loan repayment or a shared meal. Assign a category only when the payee name clearly names a business. At the end, list the ASK payees from the largest total to the smallest."
Grouping first is the trick. If you paid one person four times, you answer once.
What does a good answer look like?
| Payee (masked) | Count | Total | Assistant should write |
|---|---|---|---|
| Suresh Kumar | 4 | ₹250 | ASK: Is this a regular vendor, driver or helper? |
| Lakshmi | 1 | ₹18,000 | ASK: Rent, a loan repayment or something else? |
| Sunrise Pharmacy | 3 | ₹1,140 | Health, since the payee names a business |
| Metro Fresh Mart | 6 | ₹2,380 | Groceries, since the payee names a business |
Suresh Kumar's four payments of ₹60, ₹60, ₹70 and ₹60 make ₹250. Check that before trusting the rest. If the total looks off by a few rupees, one row was probably dropped when you pasted.
How do I teach the next round?
After you answer, ask: "Make me a two-column list of each payee and the category I gave, so I can reuse it next month." Keep it in a notes file and paste it at the top of next month's prompt. The assistant then sorts known payees automatically and only asks about new ones.
Can an app remember this for me?
Yes, that is the job of a tracker. In SpendixAI, your corrections become history for later imports, and you can add a merchant alias when the same shop appears under different names. Items it cannot match with confidence stay open for your review.
A cleanup checklist
- Mask numbers and IDs, keep names, dates and amounts.
- Ask the assistant to group by payee and write ASK for people.
- Answer each question once, per payee.
- Save the payee-to-category list for the next run.
- Re-add the totals and compare them with your statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

