Expense categories

Recategorising the same merchant monthly? A euro-based routine

Stop fixing the same direct debit or supermarket by hand. A euro-based routine for writing merchant rules that handle changing statement text.

Editorial illustration for Recategorising the same merchant monthly? A euro-based routine

Stop correcting the same merchant by hand by writing a small rule per merchant: when the statement text contains a certain name, assign a certain category. The corrections you make today then repeat themselves on every future import without you. The examples below use euros and describe only habits; local banking rules and prices differ across countries, so nothing here depends on them.

Statement text changes more than you think

In a region with many countries and languages, the same chain may appear with a country code, a language-specific word or a branch city. A gym debit might read as a membership with the studio's name one month and as a payment processor's name the next. A tracker that sees only the string will keep wondering.

What you want is a rule on the part that stays the same, and an alias for the spelling that drifted.

A monthly routine, as a table

StepWhat you doTime
1Import the month and open uncategorised rows2 min
2Fix each wrong row once3 min
3Turn repeat merchants into rules3 min
4Add aliases for merchants with two spellings1 min
5Check the three largest category totals1 min

That is ten minutes. After the first two months, step 2 should shrink, because most merchants now have a rule.

Worked example: a gym and two supermarkets

Say you pay €34.90 a month to a gym, and your tracker labels it Subscriptions one month and Health the next. Over twelve months that is 12 × €34.90 = €418.80 split across two categories, so neither looks like the real figure. You also shop at two supermarkets, one visit a week each, averaging €41.60 and €27.30. Over a four-week month that is 4 × €41.60 + 4 × €27.30 = €166.40 + €109.20 = €275.60.

  1. Write a rule on the gym's name, category Health, so all twelve payments agree.
  2. Write one rule per supermarket, category Groceries.
  3. Check that a petrol-station shop attached to one chain does not get swept into Groceries by accident.

Which merchants should get an alias instead of a rule?

An alias says that two spellings are the same merchant. Use one when the same business appears as, say, a brand name and a legal company name. Then your rule only has to be written once, against the clean name. This is especially helpful where processors rename payees without warning.

  • Alias: two spellings of one business.
  • Rule: one business that always belongs in one category.
  • Neither: a shop that sells everything; review those manually.

What about spending in more than one currency?

If you live in one euro country and travel to another with a different currency, each expense can carry its own currency, with totals shown in a base currency using a saved rate. SpendixAI offers that, but it is built around India and INR, so do not treat this as a claim of availability for euro users. The habit still applies in any tool that supports it: pick your base currency before you start importing, because changing it later may not be possible.

How many rules is too many?

Aim for rules on the twenty or so merchants that make up most of your rows, and no more. If you spend €1,850 in a month across 60 transactions and 18 merchants cover 45 of them, those 18 rules handle three quarters of the work. The remaining 15 rows are one-offs that are quicker to fix by hand than to automate.

Review your rules twice a year

Open the list, delete rules for merchants you have stopped using, and rename vague ones. If a rule has not matched anything for six months, it is probably dead weight. Fewer rules mean fewer surprises, and a smaller list is easier to read when a total looks odd.

Then pick one merchant you fixed last month and write its rule today.

SPENDIXAI JOURNAL

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

Explore your reports