Expense categories

Set a tolerance for uncategorised spending and clear the rest monthly

Decide how much uncategorised spending you can live with in Australian dollars, then clear only the rows needed to get under that line each month.

Editorial illustration for Set a tolerance for uncategorised spending and clear the rest monthly

You do not have to reach zero uncategorised rows to trust your reports. Decide a tolerance, such as under 5 percent of the month's spending, and clear only as many of the largest rows as it takes to get below it. Everything under the line can wait.

A tolerance turns an endless chore into a short, finishable one with a clear end.

How do you set a sensible tolerance?

Think about what decisions your reports support. If you only want to know whether groceries, rent and transport are on track, an unsorted 5 percent will not change the answer. If you are trying to track a small discretionary category, you may want 2 percent. Pick a figure and write it somewhere you will see it.

How much must you clear, in dollars?

Say a month's spending is A$5,000 and the tolerance is 5 percent, which is A$250 (5,000 multiplied by 0.05). The uncategorised total is A$1,380. You need to clear at least A$1,130 (1,380 minus 250).

Uncategorised rowAmountRunning total cleared
Car serviceA$640A$640
Transfer to a friendA$310A$950
Online orderA$225A$1,175

Three rows take you past A$1,130, leaving A$205 uncategorised, which is under your A$250 line. You stop there. If a fourth row worth A$18 is sitting in the list, you leave it.

What is the monthly sequence?

  1. Add up uncategorised spending and compare it with your tolerance.
  2. If you are over, sort by amount and clear the largest rows until you are under.
  3. Look at the remaining rows only to see whether any merchant repeats; if so, add a rule.
  4. Write down the final uncategorised amount and share.

What if there are many mid-sized rows?

Sometimes the pile is flat: fifty rows between A$20 and A$60 and nothing big. Then clear by merchant instead of by row. Group the rows, find the merchants that account for most, and categorise those in bulk. Four or five merchants may cover 60 percent of the flat pile.

It also helps to separate rows you cannot identify from rows you simply have not got round to. The first kind needs a bit of detective work: compare the date with your calendar, search your email for a receipt, ask whoever shares the account. The second kind needs only a category. Handle the second kind first; it is quick, and it often leaves you under your line before the detective work begins.

How does pay frequency affect it?

If you are paid fortnightly, you may find it natural to do the check twice a month rather than once. The tolerance applies to a calendar month either way, but a half-month check keeps the pile small enough that a single sitting handles it.

A short example of the flat-pile approach: suppose 50 mid-sized rows add up to A$1,600. Grouping them reveals a bottle shop with 11 rows (A$420), a pet supplier with 8 rows (A$360) and a pharmacy with 9 rows (A$290). Three bulk decisions clear 28 rows and A$1,070 (420 + 360 + 290), which is two thirds of the flat pile. The remaining 22 rows are mostly single visits and can wait for next month.

A quick monthly close list

  • Uncategorised dollars compared with the tolerance line.
  • Largest rows cleared until you are under it.
  • Any repeat merchant turned into a rule.
  • Final share written down for next month's comparison.

Your tolerance is a personal quality bar for your records and has no bearing on any official reporting. For work-related or tax questions, ask your own adviser.

SPENDIXAI JOURNAL

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

Explore your reports