The most reliable way to split business from personal automatically is to use three layers: which account the money came from, which category the transaction belongs to, and which merchant rule fired. When all three agree, the tag is almost certainly right, and when they disagree you know exactly which row to look at. This article uses pounds and sticks to record-keeping habits rather than any tax rule.
Layer one: the account
If you have a separate account or card for work, everything from it starts out as business, and everything from your household account starts out as personal. That alone gets you most of the way. Pick the account before you import a statement so each transaction keeps it.
Layer two: the category
Give every category a side. Van fuel, Tools and Materials are business. Groceries, Mortgage and Children are personal. A category is a promise about what a transaction is, so the tag follows without extra clicks.
Layer three: the merchant rule
Rules pull recurring merchants into the right category: a builders' merchant into Materials, a lunch spot into Eating out, a fuel station into Van fuel. These rules catch the rows that account alone would miss.
| Layer | Question it answers | Failure it prevents |
|---|---|---|
| Account | Which money was this? | Work spending on a home card, and vice versa |
| Category | What kind of cost is it? | Fuel counted as groceries |
| Merchant rule | Who was paid? | Repeat fixing of the same payee |
A tradesperson's week in pounds
Say a self-employed electrician spends £46.20 on van fuel, £128.90 on cable and fittings, £9.40 on lunch, and £63.55 on the weekly family shop, then £22 on the child's swimming lesson. Business: £46.20 + £128.90 = £175.10. Personal: £9.40 + £63.55 + £22.00 = £94.95. The week's total is £270.05. If the lunch is paid from the work card, the layers disagree: the account says business, the category says personal. That mismatch is the signal to check.
What happens when the layers disagree?
- Look at the receipt or your memory of the purchase.
- Decide which layer was wrong: the account used, the category chosen or the rule applied.
- Fix the row and, if the rule was wrong, edit the rule.
- If it keeps happening, change the habit: stop paying for lunch from the work card.
Keep proof, not just labels
- Attach the receipt or invoice to the transaction.
- Note the job or client where it matters.
- Keep the statement the row came from.
Rules and limits for what counts as a business cost differ and change, so confirm how to treat any item with an accountant or the official source. Your tracker's job is to have the facts ready.
A note on shared household bills
If you work from home, some household bills have a work element. Do not try to tag those line by line. Pick a simple, documented way of splitting them, record it in a note, and apply it consistently. A reasonable method written down is more useful than a clever one you cannot explain.
Where does a tool fit?
SpendixAI is built around India and INR, so this is a method, not a promise about pounds. Its stages, for what it is worth: your own rules first, then your history and similar merchants, then an AI model only for the leftovers and only if you have it on. Categories can carry settings and corrections become history. Look for the same layering in whatever you use, and make sure you can see which layer made each decision.
Then do one thing today: pick your most-used work merchant and write its rule.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
