Tax and GST

Why your accountant charges extra for a pile of unlabelled transactions

Unlabelled transactions are the slow part of any accountant's job. See what a mystery list costs in Australian dollars and how a simple tagging system trims it.

Editorial illustration for Why your accountant charges extra for a pile of unlabelled transactions

An unlabelled transaction is one that nobody can place without asking you. Each one costs the accountant a few minutes, and a statement with dozens of them quickly adds a full working day to the invoice. The cure is to tag as you go, using three simple labels, so that only the truly puzzling lines reach your accountant.

What counts as a mystery transaction?

It is any line where the statement text gives no clue. Short supplier codes, payments through a card terminal with the shop's legal name rather than its trading name, cash withdrawals, and transfers between your own accounts all qualify. Your accountant sees only the text and the amount. You may know instantly that 'SQ *M42' is the coffee cart where you buy a client's morning coffee, but the file does not tell them.

How much do they cost?

With invented numbers: an accountant bills A$95 an hour and your file has 36 mystery lines. Each takes about ten minutes to raise, wait on and record, so 36 x 10 is 360 minutes, 6 hours, or A$570. If you had tagged them yourself in 90 seconds each, that is 36 x 1.5 = 54 minutes, which is less than an hour of your own time, and the accountant's share falls to near zero for those lines.

Who tags the lineTime per lineTotal for 36 linesCost if billed at A$95/h
Accountant, via questions10 minutes6 hoursA$570
You, up front1.5 minutes54 minutesYour own time

What is the three-label system?

It is a short column added next to the amount, so you can finish a statement fast.

  • B for business: money spent for the business or earned by it
  • P for personal: anything that belongs to your private life
  • Q for question: you honestly do not know, and a note says what you looked at

Then add one more column for category, filled in for B lines only. Personal lines stay out of the accountant's way, and Q lines carry a note, so the accountant knows you tried. Nothing stays blank.

Which kinds of line cause the most trouble?

  1. Cash withdrawals. Note what the cash was for, or label the whole withdrawal personal if you cannot trace it.
  2. Transfers between your own accounts. Label them 'transfer' so they are not counted as income or spending.
  3. Card payments with cryptic names. Search your email for the receipt and note the real name.
  4. Payments to individuals. Add a short reason.
  5. Refunds. Link them to the original purchase in a note.

How do you tag faster the next time?

Keep a lookup table of payee text and the label it gets. If a payee appears again, copy the label. In a spreadsheet you can use a lookup function to fill the label automatically, such as =IFERROR(VLOOKUP(B2,Lookup!$A$2:$B$200,2,FALSE),"Q"), which returns Q when the payee is not yet in the table. The lookup table grows each month, and the Q lines shrink.

What to send your accountant

Send the list with the three labels, categories on the B lines, the Q notes and the receipts for large items. Add a covering line that tells them how many Q rows remain. Before sending, run a quick check that the total of all rows matches the statement's closing balance. SpendixAI is built around India and rupees, so it is not offered for Australian accounts, though its idea of reviewing each imported row before saving matches the habit above.

SPENDIXAI JOURNAL

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

Explore your reports