To clear unmatched merchants quickly, give each merchant one default category and fix only the exceptions. Rank the unmatched names by C$ total, decide a default for each of the biggest, and accept that a few rows will be wrong in exchange for finishing the job.
The trap most people fall into is perfectionism. A store that sells food, cleaning products and a kettle makes you want to split every receipt. For a monthly spending picture, a sensible default does the work.
What is a default category, and why use one?
A default is the category you assign to every row from a merchant unless you say otherwise. It turns the job from thousands of row decisions into a few dozen merchant decisions. You then review exceptions, which are far fewer than the rows themselves.
How do you choose the default?
Look at the last three months of rows for that merchant and ask which purchase you made most often, by count and by dollars. If they disagree, choose by dollars, because that is what reports total.
| Merchant (made up) | Visits | Groceries | Household items | Default |
|---|---|---|---|---|
| Maple Market | 18 | C$612 | C$74 | Groceries |
| Lakeview Depot | 7 | C$96 | C$388 | Household |
| Corner Pharmacy | 11 | C$54 | C$129 | Health |
Lakeview Depot is the instructive case. It was mostly bought for household items, C$388 against C$96, so the default is Household even though groceries appear. Maple Market's rows total C$686 and Groceries is 89 percent of that (612 divided by 686), so one default covers it.
Corner Pharmacy shows the opposite problem: it mixes medicine and toiletries, but both are things you would be happy to see under one Health heading. When the two sides of a merchant are close in meaning, do not agonise. Pick one, note it, and move on. Reserve your attention for merchants whose two sides would change a decision, such as a store where half your spending is food and half is something you are trying to cut back on.
What order should the pass follow?
- Sort unmatched names by C$ total, largest first.
- Assign a default to each of the top 15 names.
- Scan each name's rows for exceptions and fix them by hand.
- Move on to the next 15, but stop if the remainder is under your small-amount limit.
- Record the number of unmatched rows left.
How are shared household accounts different?
If two people spend from one account, a default can be wrong in a systematic way: one person buys groceries at the depot store, the other buys hardware. In that case, add a note or a tag to your rows for who spent it, rather than making the category carry that information as well.
How do you handle rows that fit no default?
Create a category named To sort and give yourself one rule: nothing stays there for more than a month. A recurring review of that one category is easier to keep up than a general promise to tidy things. Rows that are payments to people, e-transfers for example, can go to a People category until you decide how to treat them.
Make the next pass easier
- Save the merchant-to-default list somewhere you can paste it back, such as a second tab.
- Add a merchant the first time it shows up unmatched, while you still remember what it was.
- Record the unmatched count in a cell each month so you can see it trend downward.
- Keep notes on rows you split by hand, so you can reverse your decisions later.
This is a bookkeeping exercise only. If you need to separate business and personal spending for tax reasons, ask a Canadian accountant how to document it rather than relying on default categories.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


