You can keep uncategorised transactions under control with ten minutes a week: sort the list by merchant, clear the merchants that repeat, write a rule the third time you see the same one, and let genuine one-offs sit. A short, regular pass beats a big monthly clean-up because the pile never gets large enough to feel like a chore.
Why weekly instead of monthly?
Memory fades. A week after paying a person or a shop you still remember what it was for. Four weeks later, a row reading UPI and a long number is a puzzle. A weekly pass also spreads the work: five rows on a Sunday is easier than a hundred and forty at month end. If you import statements monthly, the same routine works on the day of each import, and a weekly sitting is only needed for rows you add by hand.
What does the ten minutes look like?
- Minute 0 to 1: open the uncategorised list and sort by merchant, so repeats sit together.
- Minute 1 to 5: take the merchants that appear most often and categorise them first. One merchant cleared can remove five rows.
- Minute 5 to 7: for any merchant you have now fixed for the third time, write a rule so it never comes back.
- Minute 7 to 9: add an alias if the same shop appears under two or three names.
- Minute 9 to 10: look at what is left and decide which are one-offs.
When is it time to write a rule?
A handy test is the rule of three. The first time you see a merchant, categorise it by hand. The second time, notice it. The third time, write the rule. That keeps you from building rules for shops you will never visit again, and it ensures that anything that shows up regularly is handled once and for all.
| How often it appears | What to do | Why |
|---|---|---|
| Once, an odd shop | Categorise by hand and move on | A rule would never fire again |
| Twice in a month | Categorise by hand, keep an eye on it | Might be a pattern, might not |
| Three times, or every month | Write a rule | It will keep recurring |
| Several spellings of one shop | Add an alias, then a rule | Clean name makes the rule stick |
What about the rows I cannot place?
Every list has a few. A payment to an unfamiliar name, a charge whose merchant text is only a reference. Check the amount and date against your calendar, your messages with the person, or the receipt if you kept one. SpendixAI keeps receipts with their transactions, so the proof can sit right beside the row. If you truly cannot work it out, put it in a general category, add a short note and move on. Do not let one mystery row hold the whole queue hostage.
How do I know the routine is working?
- The uncategorised list is shorter after each month's import than after the one before.
- Fewer of your corrections are for merchants you have corrected before.
- Your rules list is a short set of recurring merchants, not a long list of one-offs.
- The weekly pass drops from ten minutes to five.
Corrections you make become history, and history feeds the later matching of similar merchants, so the effort accumulates.
A tidy-up for the end of the month
Once a month, after your statements are in, do a slightly longer sweep. Look at the uncategorised list sorted by amount rather than merchant, so any large unclear item gets attention. Then glance at your rules and remove any that never fired. Leave the list in a state where the next month's import starts nearly empty, which is a pleasant feeling.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


