Getting started

Merchant aliases: turning five spellings of one shop into one

See how a merchant alias turns five spellings of one shop from bank and card statements into one name, and what that fixes in rules, history and reports.

Editorial illustration for Merchant aliases: turning five spellings of one shop into one

A merchant alias tells your tracker that several different spellings are really one shop, so five messy strings from your bank account and credit card become one clean name. Once they are merged, your rules, history and reports treat them as a single merchant instead of five.

What does five spellings of one merchant look like?

Take a quick-grocery delivery service that you use often. It is a made-up example, but the pattern is real: the same merchant is written differently depending on whether you paid by UPI, debit card or credit card, and on how each bank prints it.

As it appearsPaid throughAccount
UPI/7120349/FRESHKART/okaxisUPISavings account
FRESHKART BANGALORE INDebit cardSavings account
FRESH KART TECHNOLOGIES PVTCredit cardCard account
PG*FRESHKARTCredit cardCard account
FRSHKART ORDER 8812Credit cardCard account

To a person they are clearly the same shop. To a tracker matching on text, they are five separate merchants, each with a separate history and its own chance of landing in the wrong category.

What happens when I add an alias?

  1. You choose one clean name for the merchant, for example Freshkart.
  2. You tell the tracker that each of the five strings should map to it.
  3. Rows with those strings now carry the same merchant name.
  4. A rule or a past correction made for one of the spellings now works for all of them.

SpendixAI lets you add merchant aliases, and it normalises names as part of categorising. The alias is your override for the cases that automatic clean-up does not join up.

What does it fix?

  • Rules: one rule on Freshkart covers the lot, instead of five rules to maintain.
  • History: when you correct the category once, similar rows follow, because they share a name.
  • Reports: a merchant report shows one line with the true total, not five small ones.
  • Review time: fewer uncategorised rows turn up from the same shop.

Should I merge everything that looks similar?

No. Merge only what is genuinely the same seller. A merchant with a food arm and a grocery arm may belong in two categories, and merging them would hide that. Two shops with similar names, such as a local pharmacy and a pharmacy chain, are different payees. When in doubt, leave them apart and check the narration of one row for a clue.

What about aliases for payees who are people?

Aliases are for businesses that print their name in several ways. A person you pay by UPI, such as a tutor or a domestic helper, usually shows up under the name on their payment handle, which can differ slightly between months or between banks. If the same person appears with two spellings, an alias works the same way, and a rule on the clean name then keeps their payments in one category. Look at the narration first, though, because two people with similar names are two different payees, and merging them would mix up their payments.

Do I need an alias for every merchant?

No, only for the ones that recur and have been split. The merchants worth your effort are those that appear many times a month: delivery apps, fuel, groceries, mobile and broadband bills, and subscriptions. For the rest, normalisation and history do the work quietly.

How do I find the split merchants?

  1. Open your transactions for the month and sort or search by merchant name.
  2. Look for names that start the same or sound alike.
  3. Open one row from each and compare the original narration.
  4. Add an alias for the ones that are the same shop.
  5. Check the next import to see that new rows pick up the merged name.

Treat it as a small, one-off tune-up of your twenty most frequent merchants. After that, an alias is something you add when a new spelling appears, not a regular chore.

SPENDIXAI JOURNAL

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

Explore your reports