How to categorize transactions so the totals mean something

Totals mean something when the same kind of purchase lands in the same category every month, so that a change in a total is a change in what you did. Categorize by what was bought, not where; give each merchant one home; and turn every repeated correction into a rule that applies it for you from then on. Ten minutes a week reviewing the new transactions keeps it true. The goal is not a perfect filing system. It is a groceries total you can compare with last month's and believe.

Why totals lie

The same coffee shop lands in dining out in March and in coffee in April, and both categories move by $60 with nothing having changed. A superstore run that is half groceries and half household goes to whichever category came to mind, so groceries swings by $150 a month on filing alone. A pile of uncategorized transactions holds a tenth of the month's spending, and every total is understated by a share nobody can see.

None of these is a spending problem. They are bookkeeping, and they make the totals useless for the one job they have, which is showing whether this month was different from last month.

Three rules for categories that stay consistent

1. What, not where. The category is what the money bought. A pharmacy sells medicine, snacks, and gifts; the receipt decides, not the sign.
2. One merchant, one home. Each merchant gets a default category, and it lands there every time unless a receipt says otherwise. The exceptions are the few stores that sell everything, which get split or get one dominant category applied consistently.
3. When in doubt, the category you would check first. If a purchase could be groceries or household, ask which total you would look at to find it, and put it there every time.

A short list of categories makes all three rules easier. See Which categories a budget should have for sizing it.

Set it up once, step by step

1. Sort three months of transactions by merchant. A few dozen merchants account for most of the transactions, and they are the ones worth deciding about.
2. Assign each frequent merchant a category once, and write it down as a rule: merchant contains this name, category is that.
3. Handle the split merchants. For the superstores and online marketplaces, either split the purchase by what the receipt shows or pick the dominant category and apply it every time.
4. Rename the cryptic ones so the list reads the way you think of it, and so the rule matches the real name rather than a processor's code. See Why merchant names look strange on your statement for decoding them.
5. Schedule the weekly review: filter to new and uncategorized transactions, categorize them, and write a rule for anything that repeats.

A worked example

Three months of one household's transactions, sorted by merchant. Six merchants covered 115 of the 168 transactions, and six rules put them where they belong.

Before the rules, the household's groceries total read $520, $710, and $490 over the three months, and the swing looked like a habit. Recategorized consistently, the same months read $590, $605, and $585. The $220 swing was filing, and the real groceries number turned out to be steady enough to budget.

The marketplace merchant is the one that needs a human. It gets a default of shopping and a flag, and the weekly review moves the household-supply orders where they belong.

Keep it true with a weekly review

Ten minutes, once a week. Open the new transactions, categorize the uncategorized ones, check anything flagged, and write a rule for any correction you have now made twice. Done weekly, the pile never exceeds a couple of dozen transactions and the month-end totals are already right.

Put specific rules before general ones. A rule for one coffee shop should run before a rule for anything containing "COFFEE", or the general one wins.

Re-read the rules every quarter. Merchants change how they appear on statements, and a rule that stopped matching leaves its merchant uncategorized without a sound.

Common mistakes

• Categorizing by store. The category is the receipt, not the sign.
• Categorizing by mood, so that a cheap takeout order is groceries and an expensive grocery run is dining out.
• Too many categories, which multiplies the chances of inconsistency.
• Leaving uncategorized transactions for month end, when there are two hundred of them and no memory of any.
• Rules that are too broad. A rule for anything containing "MARKET" catches the farmers market, the stock brokerage, and a bar.
• Never renaming cryptic merchants, so the review stays a puzzle every week.

Common questions

How precise does categorization need to be? Consistent matters more than precise. Whether a pharmacy run is health or shopping matters less than whether it lands in the same place every month, because the totals are only ever compared with themselves.

What about a purchase that is half groceries and half household? Split it into two parts with their own amounts and categories when the receipt is at hand, and apply one consistent default when it isn't. Either is fine; switching between them is what breaks the totals.

Should refunds be categorized? Yes, in the category of the original purchase, so that the category's total reflects what you kept. A refund categorized as income makes the month look richer and the category look poorer.

What do I do with cash withdrawals? Give them a cash category and count the withdrawal as the spending. Itemizing the cash afterward double counts it, unless the withdrawal is excluded and the items are tracked instead.

How many rules is too many? As many as you have repeated corrections. One rule per merchant you see monthly is normal, and a few dozen rules is a household that has stopped doing the same fix by hand.

How Zypper handles this

Zypper categorizes each transaction automatically as it arrives, and your edits always win over the automatic choice. A rule turns a correction into a standing one: it can match on any combination of merchant, category, account, amount, and keyword, such as a merchant name containing "Netflix" or an amount of exactly $9.99 in one checking account, and it can set the category, rename the merchant, add tags, set the budget impact, or mark the review status for every matching transaction that arrives after it. Rules run in order from top to bottom, and you drag them to decide which wins when two could match. The transactions page filters by account, amount, category, date range, merchant, tag, review status, or recurring group, and the filters combine, so the weekly review is a saved question such as uncategorized transactions over $100 this month. Bulk edits change many transactions at once and can be undone right after, and transactions can be flagged as needing review and marked reviewed as you go. See Transaction rules and Managing and reviewing transactions for the details, or get started with Zypper to set the rules once.