How To Tell If Your Xero File Needs a Cleanup

The warning signs are usually visible months before the numbers stop making sense.

Xero files rarely break all at once. They drift. A few bank lines get coded to the wrong account during a busy week. A duplicate contact sneaks in. A supplier bill gets entered twice and paid once. None of it looks serious on its own, but six months later the reports no longer tell you the truth about your business, and BAS time turns into detective work.

We take over Xero files from Perth businesses every month, and the pattern is remarkably consistent. Here are the signs we look for first, so you can run the same check on your own file this week.

Your Bank Reconciliation Never Quite Finishes

Open the reconciliation screen for each bank account and look at two things: how many statement lines are sitting unreconciled, and how old the oldest one is. A healthy file has every account reconciled to within a few days. A file that needs a cleanup has lines going back months, often because someone hit reconcile on transactions that did not really match, or created manual transactions to force the screen to zero.

The more reliable test is the bank statement balance itself. Run the reconciliation report and compare Xero’s statement balance with your actual internet banking balance on the same date. If they disagree, something upstream is wrong, usually a broken bank feed, a deleted statement line or a manually adjusted balance. That gap never fixes itself, and every report built on that account inherits the error.

There Is a Balance Sitting in Suspense or Ask My Accountant

Suspense accounts exist to park transactions temporarily while you work out where they belong. In a drifting file, temporary becomes permanent. If your balance sheet shows a persistent balance in suspense, historical adjustments or an account literally named something like Ask My Accountant, your profit figures are provisional whether you realise it or not.

The same problem hides inside ordinary accounts. Scan the general ledger for accounts with names that no longer match their contents, sundry expenses doing the work of five real categories, or income coded straight to a bank account. Miscoding does not just muddy the reports. It changes your GST position, because a transaction coded to the wrong account often carries the wrong tax rate with it.

Your GST Reports Do Not Match What Was Lodged

Run the GST reconciliation report and compare it with your lodged BAS figures. In a clean file they agree. In a file that needs attention there are unfiled amounts accumulating in earlier periods, usually because transactions were added, edited or deleted after the BAS was lodged. Each one of those changes quietly shifts a period that has already been reported to the ATO.

This is the sign we treat most seriously, because it has compliance consequences rather than just reporting ones. Left alone it compounds each quarter, and correcting it later means unpicking every period back to the last point where the file and the lodgements agreed. It is also the area where a registered agent matters most, since fixing it properly usually involves adjustments on a future activity statement. Our BAS and IAS services include this reconciliation as a standard step every quarter, precisely so unfiled amounts never build up.

Aged Receivables and Payables You Know Are Not Real

Print your aged receivables report and read it honestly. If it lists invoices from a year ago that you know were paid, the payments were probably reconciled somewhere else, often straight to a revenue account, leaving the invoice open forever. The mirror image happens with payables, where bills marked awaiting payment were actually paid weeks ago from a card that is not connected to Xero.

Phantom receivables are more damaging than they look. They overstate your income position, make genuine debtor follow up impossible because the list is full of noise, and they distort any cashflow forecast built from the file. When a client tells us they have stopped trusting their receivables report, that is a cleanup conversation, not a reporting one.

Payroll Figures That Disagree With Your Reports

Compare the payroll activity summary with the wages and superannuation lines in your profit and loss for the same period. They should match to the cent. Differences usually mean manual journals have been posted over the top of payroll, or pay items are mapped to the wrong accounts. With payday super now live and super payable within seven business days of every pay run, unmapped or mismapped pay items are no longer a tidy up job for year end. They create shortfalls the ATO can see pay run by pay run.

What a Professional Cleanup Actually Involves

A proper cleanup is methodical rather than heroic. We reconcile every bank and card account to source statements, clear suspense balances to their true accounts, rebuild the chart of accounts where categories have blurred, verify GST coding against the lodged BAS history, and correct receivables and payables so the aged reports reflect reality. The file is then documented so it stays clean, which is where ongoing Xero bookkeeping and monthly financial reporting earn their keep. A cleanup restores trust in the numbers. A rhythm keeps it.

Book a Xero File Review With My Bookkeeper Perth

If two or more of these signs sound familiar, your file is telling you something. My Bookkeeper Perth is a TPB registered BAS agent practice in Southern River with more than 19 years of experience rescuing and maintaining Xero files for Perth businesses. Call (08) 9490 9555 or reach us through our contact page for a free, confidential file review and a clear, fixed scope for getting your numbers back.