Expense categories

Same merchant, same fix, every month? A pounds-and-pence method

Tired of correcting the same supermarket or subscription each month? A UK-flavoured method in pounds for turning repeat fixes into a one-time rule.

Editorial illustration for Same merchant, same fix, every month? A pounds-and-pence method

The reason you keep recategorising the same merchant is that your tracker treats each month's statement line as a fresh guess, and you have only ever corrected the guess, not the cause. The cure is to give it a standing instruction, a rule that says what the merchant is. This edition uses pounds throughout and sticks to method; it does not touch any bank, tax or regulatory specifics.

Why does the same shop keep coming back wrong?

Statement text for a shop varies: a branch name, a town, a till number, the word "payment" or "card purchase" before the name. Your tracker reads that text, compares it with what it has seen, and sometimes lands on the wrong category. If you edit only the single transaction, you have fixed the symptom for that row alone.

Think of it as telling a new colleague who a customer is. If you correct them once on one invoice but never write it down, they will ask again next month.

A pounds example, line by line

Say you buy from the same corner shop and the local greengrocer. The shop shows as an Express branch with a different town each time, and the tracker files half of those visits under Household and half under Groceries.

MonthVisitsSpendFiled under GroceriesFiled under Household
March11£94.60£52.30£42.30
April9£78.25£31.00£47.25
May12£103.40£68.15£35.25

Over three months the real grocery spend was £94.60 + £78.25 + £103.40 = £276.25. Because the labels wobbled, the Groceries line reported only £52.30 + £31.00 + £68.15 = £151.45. That is £124.80 missing from the category you were watching. No wonder the budget felt unreliable.

Build the rule in five moves

  1. Find the repeated merchant in last month's list and open one transaction.
  2. Read the statement text and note the part that never changes, such as the shop's name before the branch town.
  3. Create a rule: text contains that fragment, category Groceries.
  4. Check that your fragment will not accidentally match an unrelated shop with a similar first word.
  5. Apply the rule to past months so your trend lines are consistent.

What should I do when a merchant is genuinely mixed?

A department-style shop may sell food one week and a lamp the next. Do not force a single category. Leave the merchant without a rule and review each purchase, or keep a rule that sets a default and accept that you will override it when needed. A default that is right 80 percent of the time is still worth having, provided you check the exceptions.

Where a tool's own learning helps

Many trackers learn from corrections, and that is useful for the small, occasional merchants you will never write a rule for. SpendixAI works in stages, with your own rules first and your history after, and its corrections become history. It is built around India and INR, so it is not something to claim for pounds; the habit applies in any tracker that lets you write rules.

When the rule seems to stop working

A rule that worked for a year can go quiet. The usual cause is a change in how the shop appears on your statement, for example after a rebrand. If a merchant you have a rule for turns up uncategorised, open the row, compare its text with your rule, and widen the fragment or add the new spelling.

A short list for month end

  • Filter to uncategorised items and clear them first.
  • Note every merchant you fixed more than once.
  • Write a rule for each; use the fragment, not the whole string.
  • Re-run last month to confirm the totals now agree with your own sense of the month.

If a rule produces a surprising total, trust the surprise enough to investigate. Nine times out of ten it is a too-broad fragment, and a quick look at which rows it caught will tell you.

SPENDIXAI JOURNAL

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

Explore your reports