Uncategorised transactions make your reports lie because every dollar sitting in that pile is missing from the category totals you are reading. The fastest fix is to sort the pile by amount, deal with the largest rows first, and create rules for repeat merchants so the small ones sort themselves.
Editing 300 rows one at a time is what makes people abandon a tracker. You almost never need to. A few rows carry most of the money.
How do uncategorised rows distort a month?
Say your accounts show $3,900 going out in a month. The report says this:
| Category | Reported | Comment |
|---|---|---|
| Groceries | $620 | Looks reasonable |
| Dining out | $310 | Looks reasonable |
| Transport | $280 | Looks reasonable |
| Utilities | $410 | Looks reasonable |
| Subscriptions | $95 | Looks reasonable |
| Uncategorised | $2,185 | 56 percent of the month |
The listed categories add to $1,715, and with $2,185 uncategorised the total is $3,900. More than half the month is a blank. The numbers above it look fine, which is exactly why the report misleads: nobody questions a tidy-looking grocery figure.
Which rows are worth fixing first?
Suppose the $2,185 breaks down as rent of $1,450, a car repair of $320 and 41 small rows worth $415 (1,450 + 320 + 415 = 2,185). Two rows account for $1,770, which is 81 percent of the pile. Fixing them takes under a minute and turns a report that says nothing about housing into one that shows it.
- Sort the uncategorised rows by amount, largest first.
- Categorise every row above a threshold you choose, say $100.
- Look at what is left and group it by merchant name.
- Write a rule for any merchant that appears more than twice.
- Apply the rules, then look again at what remains.
What about the 41 small rows?
Group them by merchant. If a coffee shop appears 12 times, one rule clears 12 rows. If a parking app appears 9 times, another rule clears 9. After two or three rules the remaining rows number perhaps a dozen, each under $20. A rule is worth more than any single correction because it keeps working next month.
A useful test of whether a rule is worth writing: would you be happy for it to categorise the next ten rows from that merchant without looking? If the answer is yes, write it. If the merchant sells a mix of things, say a warehouse club or a general retailer, accept a default and correct the exceptions, because a rule that is right 80 percent of the time still saves you 80 percent of the typing. Keep a note of which merchants you treat this way so a surprising number in a report can be traced to its cause.
How do you keep the pile from refilling?
- Set a weekly slot of ten minutes, not a monthly marathon.
- Check the uncategorised total, not just the row count; $40 across ten rows matters less than one $400 row.
- Add a rule whenever you correct the same merchant twice.
- Review rules each quarter and delete ones that misfire.
What is a reasonable amount to leave unsorted?
That is your own call. Some people accept a few dollars of leftovers each month; others want the figure at zero before they close the month. Whichever you pick, write the number down so you can tell whether the pile is shrinking or only moving around.
A finishing checklist
- Write down the uncategorised total before you start and after you finish.
- Check that all categories plus uncategorised still add up to your total outgoings.
- Save any rules you built.
- Note any row you categorised by guess so you can revisit it.
This approach deals only with records. For anything involving taxes, ask a qualified adviser in your own area.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


