AI and MCP

Rename messy merchant names in your statement with AI

Prompts that turn cryptic bank narrations into plain merchant names, keep a reusable mapping table and mark guesses, with a worked list of twelve lines.

Editorial illustration for Rename messy merchant names in your statement with AI

To clean merchant names with an AI assistant, paste your narrations and ask it to return two columns: the plain merchant name and a confidence label, with Guess written next to anything it is not sure of. Then save the mapping as a table you can reuse next month, so the same narration is renamed the same way every time.

Why are the narrations so messy?

A debit shows a code, a reference number, a handle, sometimes a city, and only a few letters of the merchant. The same shop can appear in three forms depending on whether you paid by card, UPI or NEFT. If every variant becomes its own row in your reports, one merchant looks like several, and your totals per merchant are wrong.

What does the cleanup look like on twelve lines?

The narrations below are invented for the example. The third column is what a careful assistant should return.

Messy narrationPlain nameConfidence
UPI-SWIGGY INSTAMART-PAYMENTSwiggy InstamartSure
UPI-RAMESH GENERAL STORE-PAYRamesh General StoreSure
IMPS/P2A/301245/SHARMA RSharma R (a person)Sure it is a person; purpose unknown
POS 5432XX FUEL STN NH48Fuel stationGuess: no brand shown
ATM-WDL-XXXX-ANDHERI WATM cash withdrawalSure
FASTAG RECHARGE 7821FASTag rechargeSure
NACH-DR-INS PREM 8841Insurance premiumGuess: insurer not named
BIL/BPAY/ELEC BOARD 2210Electricity billSure
NEFT-SOCIETY MAINT-A WINGSociety maintenanceSure
UPI-9XXXX XXXX1@oksbiUnknown payeeCannot tell
POS 7788 CAFE MOCHA 2Cafe MochaGuess: partial name
UPI-ZOMATO ORDER 4421ZomatoSure

Which prompts do the work?

  1. 'Below are bank narrations, one per line. For each one return a table with the plain merchant name and a confidence label: Sure, Guess or Cannot tell. Never invent a merchant. If a person seems to be the payee, say so and leave the purpose blank.'
  2. 'Now merge variants of the same merchant into one name and list the original narrations underneath each name, so I can see what you merged.'
  3. 'Give me the mapping as a two-column table: text to look for, and the name to use. Use the shortest piece of text that is still unique.'
  4. 'List every line you marked Guess or Cannot tell, with the reason, so I can answer them myself.'

How do you keep the mapping for next month?

Save the two-column table in a spreadsheet tab or a note. Next month, paste the table first and say: 'Use this mapping for any narration containing these words, and only suggest new names for the rest.' That way the assistant stays consistent, and only genuinely new narrations need your attention.

Where can this cleanup live permanently?

SpendixAI lets you add merchant aliases and keeps your corrections as history for later imports, so a renamed merchant stays renamed. Its AI categorisation uses the normalised merchant name, which is one more reason to fix the names early. For a single bank, a spreadsheet mapping is a fine start; an alias list saves effort once several accounts feed one view.

What if the assistant renames something wrongly?

It will, now and then, especially with short fragments such as a three-letter shop code or a name shared by two businesses. The mapping table is your safeguard: because every renamed line points back to its original narration, you can see at a glance what the assistant relied on. When one is wrong, correct the table rather than the single line, then paste the table again next month so the correction sticks.

Two habits help. Keep the original narration in a separate column and never overwrite it, since you may need it for a bank query. And add the city or branch to the mapping when two shops share a name but not a category.

Quick review before you finish

  • Every Guess has an answer or an open question beside it.
  • The count of lines in equals the count of lines out.
  • Two names for the same merchant have been merged into one.
SPENDIXAI JOURNAL

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

Explore your reports