Expense categories

A 30-minute pass to clear unmatched merchants (Australian dollars)

Clear unmatched merchants from Australian dollar statements in one 30-minute session with a timer, a ranked list and a clear stopping rule.

Editorial illustration for A 30-minute pass to clear unmatched merchants (Australian dollars)

You can clear most unmatched merchants in about 30 minutes if you treat it as a timed session with a clear stopping point. Rank the unmatched names by A$ spend, work down the list until the timer ends, and count what is left instead of trying to finish.

Open-ended tidy-ups rarely get done. A fixed session with a number to beat gets done, and a number to beat is easy to produce.

What should you write down before the timer starts?

  • How many unmatched rows you have.
  • How many distinct unmatched merchant names that is.
  • The A$ total of the unmatched rows.
  • The small-amount limit below which you will not bother, such as A$12 per merchant per quarter.

Say you start with 173 unmatched rows, 49 distinct names and A$5,320 in total.

How should the 30 minutes be split?

MinutesTaskExpected result
0 to 5Sort the unmatched names by A$ totalA ranked list
5 to 20Assign categories to the top namesLargest names settled
20 to 25Add rules or aliases for repeat namesNext month starts cleaner
25 to 30Recount and write the new numbersProof of progress

In the middle block you are not researching anything. If a name is unfamiliar, search the amount and date in your own email or receipts folder once, and if nothing turns up, move on and flag it.

What if you cannot tell what a merchant is?

Look at the amounts. A charge of A$9.99 on the same day each month is a subscription. A charge in the A$300 to A$400 range every fortnight may be a trade or a service visit. If it is still unclear, give it a temporary Check category and carry on. At the end of the session, review only the Check list; it is usually under ten names.

It helps to keep a scrap list while you work. Whenever you hit a name you want to look into properly, write it down with its amount and keep going. The scrap list is where the 15-minute follow-up slot gets its material, and it stops one stubborn merchant from eating half your session.

What does a good result look like?

After the session, say you have 61 rows and A$890 left unmatched. That is a drop of 112 rows (173 minus 61) and A$4,430 (5,320 minus 890). Put another way, you resolved about 83 percent of the dollars (4,430 divided by 5,320) and about 65 percent of the rows. Those figures are hypothetical, but the ratio is common: the dollars clear faster than the rows because large merchants repeat.

How do you stop the pile coming back?

  1. After the session, turn the repeat names into rules or aliases so that tomorrow's rows are handled automatically.
  2. Add a standing 15-minute slot at month end for new unmatched names only.
  3. Review the Check category in that slot too.
  4. Once a quarter, run the full 30 minutes again to reconsider your small-amount limit.

Last things to do before you close the sheet

  • Save the before and after numbers somewhere visible.
  • Make sure your totals by category still match total spend.
  • Note any merchant you categorised on a guess so you can correct it when the receipt turns up.
  • Back up the file or export, whichever your tool allows.

The method works with any tool that lets you filter by category and sort by amount. Keep tax or business questions for your own adviser.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports