Money tips

The same merchant lands in a different category each time: why

Why the same merchant lands in a different category each time, from mixed-use shops to inconsistent matching, and how to lock it to one category.

Editorial illustration for The same merchant lands in a different category each time: why

A merchant lands in different categories when the tool is guessing from partial clues each time, or when you have corrected it inconsistently. Lock it down by setting a rule for that merchant's name, adding an alias for its spelling variants, and correcting past rows once so your history agrees.

Why does this happen?

Several things can pull one merchant in different directions. Look through the list and see which fits yours.

  • Spelling variants. The same shop appears as three narrations depending on the terminal or payment route, so each one is treated as a separate merchant.
  • Mixed-use merchants. A large store or marketplace really does sell groceries one day and a gadget the next, and a guess may follow the amount.
  • Conflicting history. You moved the same merchant to Food once and Shopping another time, so there is no clear pattern to follow.
  • Similar-name confusion. Two different businesses share part of a name, and the tool matches the wrong one.
  • Amount-based guesses. A ₹120 payment to a shop looks like a snack, while ₹2,400 to the same shop looks like groceries.

How do you find out which cause it is?

Search your transactions for the merchant and sort them by date. Write down each row's narration text and category. If the text differs between rows, it is a spelling problem. If the text is identical but categories differ, it is either mixed use or conflicting corrections. A two-minute look usually tells you.

How do you lock a merchant to one category?

  1. Choose the category you want. If the merchant is genuinely mixed, pick the one that holds most of the spend.
  2. Create a rule using the merchant's name text, pointing to that category.
  3. If the spellings differ, add an alias so that all variants map to one clean merchant name.
  4. Go back through older rows and correct the stragglers, so your history shows one consistent pattern.
  5. Check the next import to confirm that the rows land where you intended.

The order matters. A rule is the strongest instruction, so set it first. Cleaning history afterwards removes the contradictory signals that would otherwise confuse any later matching.

What if the merchant really is mixed use?

Some merchants cannot be pinned to one category without error. A hypermarket may account for monthly groceries of around ₹6,000 plus an occasional ₹1,500 appliance. Locking the rule to Groceries is right most of the time, and you can edit the odd exception by hand.

OptionGood whenTrade-off
One rule for the dominant categoryMost spend is of one typeEdit the exceptions by hand
Rule with an amount bandBig and small payments mean different thingsMore rules to maintain
Leave uncategorised for reviewThe merchant is rareNeeds a manual step each time

How does SpendixAI decide?

SpendixAI works in stages: your rules first, then your history and similar merchants, then an AI model only if AI is on, using the cleaned merchant name and an amount band. Because your own rules come first, a rule is the most reliable way to fix repeated inconsistency. Corrections you make become history, and merchant aliases can be added for variant names. If AI is off or has a budget cap, items it does not handle are held for review instead.

A quick maintenance routine

  • Once a month, sort your transactions by merchant and scan for any whose rows span several categories.
  • Fix the biggest offenders first; one or two merchants usually account for most of the mess.
  • Review your rules each quarter and remove any that no longer match how you spend.
  • When you correct a row by hand, ask yourself whether it should be a rule.

Consistency is worth more than precision here. Choosing a sensible category and sticking with it keeps your monthly comparisons honest.

SPENDIXAI JOURNAL

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

Explore your reports