A Xero file is only useful if the numbers in it are true. When the bank feed has hundreds of unreconciled lines, the suspense account has a balance nobody can explain and the payroll does not match what was sent to the ATO, every report built on it is wrong. We clean up messy Xero files for businesses across Brisbane and beyond. Here is how it works.
Owners usually know something is wrong before they can name it. The profit on the dashboard does not match the bank balance, the BAS feels like guesswork and the accountant asks the same questions every year. These are the specific signs we look for when we open a file.
Any one of these on its own is manageable. Several together mean the file cannot be relied on for a BAS, a tax return, a loan application or a decision.
Nobody sets out to make a mess. Xero makes it easy to reconcile quickly, and quick reconciliation by someone without accounting training produces most of what we see: transactions matched to the wrong account, rules created once and applied forever, and transfers between accounts coded as income or expenses. Add a change of bookkeeper, a year of growth and a second entity sharing the same bank account, and the file drifts further from reality each quarter.
Payroll problems tend to come from set-up rather than processing: wrong pay items, leave not accruing, super calculated on the wrong base, or STP finalisation done against figures that were later changed. GST problems come from default tax codes on the chart of accounts that were never reviewed. The common thread is that the file was set up fast and never checked by someone who knew what the output should look like.
The cost of leaving it is real. A BAS lodged from a file with wrong GST codes either overpays or underpays the ATO. A tax return built on an unreconciled balance sheet carries errors forward year after year. A lender or a buyer reading the reports will either discount what they see or walk away. Fixing the file is cheaper than any of those outcomes.
A proper cleanup is systematic. We do not start by reconciling the bank feed, because that locks in whatever coding is already there. We start by understanding what the business is and what the file should show, then work through it in order.
If prior BAS or tax returns were lodged from the wrong figures, we tell you what the differences are and whether amendments are needed. Often a correction can be made in the next BAS rather than reopening old ones, but the ATO rules on this depend on the amount and the period, and we check before deciding.
Sometimes repairing the file costs more than replacing it. If the history is several years of unreliable data, if two or more entities have been run through the one file, if the conversion balances were never right, or if the payroll has been wrong from the first pay run, a fresh file with accurate opening balances is usually cleaner and cheaper.
The old file is kept for reference and the new one starts at a sensible date, usually the beginning of a financial year or quarter, with opening balances drawn from the last lodged financial statements and reconciled bank balances. Unlodged periods are then processed properly in the new file. We make this call with you after the initial review, with the cost of each option alongside.
A fresh file is not an excuse to abandon unlodged periods. Anything that still needs a BAS or a tax return is processed properly, either in the old file to the cut-off date or in the new file from it. The point is to stop carrying errors forward, not to lose history.
Many of the files we clean up are not Xero files at all yet. Businesses on MYOB, Reckon, QuickBooks or a spreadsheet come to us wanting to move. The conversion itself is well supported and we have done it many times, but conversion carries the old problems into the new system unless they are fixed first. Our approach is to clean before we convert, or to convert at a clean cut-off date with reconciled opening balances.
For spreadsheet businesses the move is usually a rebuild rather than a conversion: set up the chart of accounts and tax codes, connect the bank feeds, import contacts and open invoices, configure payroll for STP, and reconcile from the chosen start date. It is the moment to get the set-up right, because every future problem is cheaper to prevent here than to fix later.
A healthy Xero file has a rhythm. Bank feeds are reconciled at least weekly and the Xero bank balance agrees with the statement at every month end. The suspense account is empty. Payroll is filed through STP each pay run and super is paid before the due date. GST liabilities on the balance sheet match the BAS that was lodged. Lock dates move forward after each BAS.
With that in place, the month-end reports mean something. Profit and loss by month, aged receivables and payables, and the balance sheet can be read and acted on. This is the foundation for our BAS and bookkeeping service and for the management reporting our virtual CFO clients rely on. A clean file also makes year-end tax faster and cheaper, because we are not spending your fees finding problems.
We set this rhythm up with you and then either run it as your bookkeeping team or review it periodically if you prefer to do the day-to-day work in-house. Either way, someone with an accounting eye looks at the file each month, so small errors are caught before they become a cleanup.
Acquire Strategic Accounting is a Xero Platinum Partner, which reflects the number of clients we support on Xero and the depth of certification across the team. In practice it means the people cleaning up your file do this every week, know the common failure points, and know which Xero add-ons for jobs, inventory, projects or payments suit different industries.
We clean up files for businesses in Brisbane from our Victoria Point office, for Logan and the Scenic Rim from Jimboomba, and for clients across Australia by sharing the file online. The first step is a short review of your file, after which we give you a clear picture of what is wrong, what it will take to fix and whether a fresh start makes more sense.
Check whether the bank balance in Xero matches your actual bank statement, whether there are unreconciled transactions older than a month, and whether the suspense or clearing account has a balance. Look at the GST on a few bills and invoices, and compare the payroll summary to your STP reports. If any of those do not line up, the reports built on the file cannot be trusted and a review is worth doing.
It depends on how many periods are affected, how many bank accounts and entities are involved, and whether payroll needs reconstructing. We start with a short review of the file, then quote a fixed scope so you know the cost before any work begins. In some cases a fresh file is cheaper than repairing the old one, and we will tell you which applies.
Yes. We reconcile the wages, PAYG withholding and super in Xero to what was reported to the ATO through Single Touch Payroll and to the super clearing house, identify where the differences arose, correct pay items and leave set-up, and lodge an STP update event where the reported figures need to change. Employees' income statements then reflect the right figures at finalisation.
Fix the old file when the problems are contained to a few periods or a few accounts. Start fresh when there are years of unreliable data, multiple entities mixed in one file, incorrect conversion balances or payroll that has been wrong from the start. A new file begins at a clean date with reconciled opening balances, and the old one is kept for reference. We make the call with you after a review.
Yes. The cleanest approach is to convert at the start of a quarter or financial year with reconciled opening balances, but a mid-year conversion works if the MYOB file is tidy up to the cut-off date. We clean the old file first or draw a line at a date where the balances are reliable, then bring across contacts, open invoices and bills, and set up payroll for STP in Xero.
Not always. Many GST errors can be corrected on a later activity statement rather than by amending the original, provided the amounts fall within the ATO's correction limits and time periods. Larger or older errors need an amendment or revision of the original statement. We quantify the differences during the cleanup and tell you which approach applies before anything is lodged.
