XBert Type: Standard
Accounting Software: Xero, MYOB, QuickBooks Online
Country Restriction: Australia only
Risk Type: Financial Reporting Risk
Business Function: Compliance
Overview
This XBert checks whether a suspense or uncoded account is still holding a meaningful balance month after month. A suspense account is meant to be a temporary parking spot for transactions you are not yet sure how to code. When money sits there and is never cleared, your reports, GST and balance sheet can all be wrong, so this XBert points you to the parked balance to sort out.
What it does
It looks at your trial balance and finds accounts that act as a "deal with it later" pile, recognised by their name, such as Suspense, Ask My Accountant, Uncategorised, Unallocated, Uncoded, To Be Coded, To Be Allocated or Miscoded. For each one, it tracks the balance back through your recent month-end figures to see whether the same meaningful amount has stayed parked over time, rather than clearing away quickly.
How it works
The XBert fires when a genuine suspense or uncoded account is still carrying a meaningful balance at the most recent month-end, and that balance has stayed meaningful across at least the last two consecutive month-ends. In other words, the money has not just landed there mid-month and been sorted out a few days later. It has aged.
To avoid false alarms, it deliberately ignores:
Accounts with a zero or very small balance, because simply having a suspense account is normal.
Balances that were parked and then cleared within the month, so only genuinely aged balances are flagged.
Accounts whose name marks them as a clearing account, such as a payment-processor clearing account for Stripe, Square or Shopify, which clear themselves as part of normal trading.
Withholding, payable and rounding accounts, which are meant to carry an ongoing balance and are not a coding backlog.
Example/Use Case
Priya runs a small landscaping business in Brisbane. Over the quarter she parked several bank transactions she was unsure about into the Suspense account, totalling $4,250. She meant to get back to them, so they were never coded to their correct expense accounts. Three month-ends later, the $4,250 is still sitting in Suspense, so this XBert flags the aged balance. Priya reviews the parked transactions and codes them to fuel, equipment hire and repairs, and her profit figures and the GST on her next BAS are finally correct.
Accounting software
This XBert runs for businesses connected through Xero, MYOB and QuickBooks Online.
Which countries it supports
This XBert is available for Australian businesses only.
Processes
Business area: Compliance. To resolve this XBert:
Open the suspense or uncoded account named in the XBert and review the transactions still sitting in it.
For each parked transaction, find the source document, such as the supplier bill, receipt or bank payment, to work out what it really relates to.
Recode each transaction to its correct income or expense account, applying the right GST treatment so your BAS and reports are accurate.
Confirm the suspense or uncoded account balance returns to nil, or close to it, once everything is coded.
Make it a habit to clear suspense and uncoded accounts as part of your regular period-end review so balances do not build up again.
Once corrected, mark the XBert as resolved.