How to categorize Amazon and big-box purchases that mix groceries with everything else

A purchase from a store that sells everything gets one default category, chosen by what that store usually is for you, and only the orders that are large or clearly mixed get split. Set the default once per store, choose a threshold above which an order is worth a look, and split those orders by the amounts of their parts from the order history or the receipt. A household that splits every $20 order stops categorizing within a month; one that defaults everything sees its grocery total drift by whatever the warehouse club sold it that was not food. The threshold is what makes the totals honest at a cost of a few minutes a month.

Why these merchants break category totals

A supermarket sells groceries and the transaction is groceries. An online retailer, a warehouse club, or a big-box store sells groceries, a phone charger, a birthday present, and a bag of dog food on the same receipt, and the transaction is one line at one amount with one merchant name. Whatever category it lands in absorbs the whole amount, and the totals for that category and the three others are wrong by the parts that belonged elsewhere.

The error is not random. It accumulates in whichever category the store defaults to, usually groceries or household, and it makes that category read high every month by an amount nobody can explain from the grocery list.

Set a default per store, then a threshold

1. Decide what each mixed store usually is for you. The warehouse club is groceries; the online retailer is household; the big-box store is household or shopping. That is the store's default category, applied to every transaction from it automatically.
2. Choose a threshold, an amount above which an order gets a look. For most households $75 or $100 is the right level: below it the parts are too small to move a total, above it a single order can be a fifth of a category.
3. Split the orders above the threshold into their parts, from the order history for online purchases or the receipt for in-store ones, with each part in its own category and the tax on the items it was charged on.
4. Split any order below the threshold that contains one obvious outlier, a $60 present in a $70 order, and leave the rest alone.
5. Review once a month. Ten orders above the threshold is ten minutes.

See How to split one purchase across categories for the mechanics of a split, including where the tax and the delivery fee go.

A worked month, eleven orders from one retailer

Default category: household. Threshold: $75.

Without the threshold, $706 would have landed in household. With it, the month reads $232 of household, $113 of groceries, $124 of gifts, $212 of home, $25 of shopping, and the two minutes per split were the whole cost. The seven default orders, $194 in all, are small enough that a wrong part in any of them moves no total by more than a few dollars.

Where the default should point

• The category the store is for you most often. A warehouse club that is mostly food defaults to groceries; an online retailer that is mostly supplies and gadgets defaults to household.
• Not to a catch-all called "shopping." A catch-all absorbs the defaults and the total means nothing; a specific default means the category is at least mostly right.
• Reviewed yearly. A store's role changes; the retailer that was household becomes groceries when the weekly delivery starts, and the default follows.

Common mistakes

• Splitting every order. The habit lasts three weeks and takes the rest of categorizing with it.
• Defaulting everything. The grocery total drifts by the vacuum cleaner and the birthday present, and no one can explain the month.
• A "shopping" catch-all as the default. It grows into the largest category with the least meaning.
• Splitting from memory. The order history and the receipt have the amounts; memory has the rounding.
• Forgetting the tax and delivery. They go on the items they were charged on, or in proportion, so the parts add back to the charge.
• Leaving the outliers under the threshold. A $60 present in a $70 order is the one small order worth a look.

Common questions

How do I categorize Amazon purchases? Give the retailer a default category that matches what you mostly buy from it, usually household, and split only the orders above a threshold you set, such as $75, or the small ones with a single obvious outlier. The order history has each item's price, which makes a split a two-minute task.

Should warehouse club purchases be groceries or household? Whichever they mostly are for you, as the default, with the large runs split into their food and non-food parts. A run that is $180 of food and $60 of paper goods is two lines; a $40 run of snacks is groceries by default.

What threshold should I use? High enough that only a handful of orders a month cross it, and low enough that a single crossing order could move a category by a noticeable amount. For most households that is $75 to $100. A household with a $300 grocery budget sets it lower than one with a $900 one.

What about an order that's one large item? Recategorize it whole; a split is only for a receipt with parts in different categories. The vacuum cleaner is home, not household, and it moves in one step.

Does it matter if a small order is in the wrong category? Not much, which is the point of the threshold. A $12 cable in groceries moves the month's total by $12, which is inside the noise; a $148 mixed order in groceries moves it by the $106 that was not food, which is not.

How Zypper handles this

Zypper applies the default and makes the split a click. A transaction rule that matches the merchant sets its category automatically as transactions sync, so every order from the retailer lands in household without a decision, and the rule can add a tag as well. An order above the threshold is split into parts, each with its own amount and category, with the parts always adding up to the original amount, and a split can be undone later; a single-item order is recategorized whole. The transactions page filters by merchant and by amount, so "this retailer, over $75, this month" is the review list, and bulk edits change several at once. See Transaction rules, Splitting and linking transactions, and Managing and reviewing transactions for the details, or get started with Zypper to set the default once.