How do I do a bank reconciliation in Xero or MYOB and fix unreconciled transactions?

If your Xero or MYOB file isn’t reconciling properly, it usually means the software balance and the bank’s actual transactions have drifted apart somewhere. That matters because unreconciled items can flow through to BAS, cash flow reporting and what your accountant sees at EOFY, so it’s worth getti

Skill level
General guidance
Time
Varies
Trade
Bookkeeping & Cashflow
Updated
3 November 2026

Why is a bank reconciliation important for Australian tradies?

If your Xero or MYOB file isn’t reconciling properly, it usually means the software balance and the bank’s actual transactions have drifted apart somewhere. That matters because unreconciled items can flow through to BAS, cash flow reporting and what your accountant sees at EOFY, so it’s worth getting the process right before small issues turn into bigger clean-up work.

What key concepts should Australian tradies understand about bank reconciliation?

A bank reconciliation is simply matching the transactions in your accounting software to the transactions that have actually cleared your bank account. In Xero and MYOB, this usually relies on a bank feed or imported statement data being coded correctly and matched to the right invoices, bills, payroll entries or spend-money transactions.
An unreconciled transaction does not always mean something is “missing”. It can also mean a duplicate bank feed line, an incorrectly dated transaction, a payment matched to the wrong invoice, GST coded incorrectly, or a transfer posted as income or expense instead of between accounts.
Timing matters. Some items appear on your bank statement before the related bookkeeping entry is created, while others are entered in the software before they clear the bank. That is why a proper review looks at statement dates, transaction dates and whether the item is genuinely outstanding or simply in transit.
The right fix depends on the cause. In practice, clean-up may involve re-matching a payment, removing duplicates, correcting the chart of accounts coding, reviewing suspense or clearing accounts, or checking whether a payroll or loan transaction was posted properly. It is generally better to identify the source issue than to force a manual reconciliation adjustment.
Before BAS or EOFY, a bookkeeper will usually want the bank reconciliation to agree to the bank statement, with any old unreconciled items explained. This helps support more reliable reporting and gives your accountant cleaner numbers to work from. For BAS-related corrections, a registered BAS agent should confirm the treatment, and the ATO and Tax Practitioners Board set the relevant rules around that work.

What A Specialist Would Review For Your Situation

Whether the problem is coming from bank feeds, opening balances, duplicated imports, deleted transactions or prior-period changes that have knocked the reconciliation out.
How transactions have been coded for GST, owner drawings, loans, payroll, superannuation, merchant fees and transfers between business accounts.
Whether old outstanding items are legitimate timing differences or signs that invoices, bills, payroll journals or payment allocations were handled incorrectly.
Whether BAS periods have already been lodged, and if so, what can be corrected now versus what needs a more careful review by a registered BAS agent or bookkeeper.
Whether your Xero or MYOB file needs a broader tidy-up, including bank rules, chart of accounts structure, debtor and creditor balances, and month-end reconciliation processes going forward.

Common Costly Mistakes

Forcing transactions through as “reconciled” without checking what they relate to.
Deleting or redoing old entries in a lodged BAS period without understanding the GST impact.
Treating transfers, loan movements or owner contributions as normal sales or expenses.
Ignoring old unreconciled items month after month until EOFY clean-up becomes more expensive and time-consuming.

When To Get Professional Help

If your reconciliation difference keeps reappearing, you have old unreconciled items you can’t explain, or payroll, GST or multiple bank accounts are involved, DIY usually stops being efficient. It is also sensible to get help before lodging BAS, before EOFY, or before sending the file to your accountant, especially where corrections may affect ATO reporting or payroll obligations under STP and Fair Work requirements.

Talk To A Specialist

If your Xero or MYOB file feels messier than it should, a bookkeeping health check can usually identify where the reconciliation issues are coming from and what needs to be cleaned up first. If you’d like a second set of eyes before BAS, EOFY or accountant review, you can speak with a bookkeeping specialist here: /finance/enquire?service=bookkeeping

Frequently Asked Questions

Why won’t my bank account reconcile in Xero or MYOB?

Usually, it comes down to one of a few common causes: duplicate bank feed lines, incorrect coding, a transaction dated in the wrong period, or a payment matched to the wrong invoice or bill. In some cases, the issue started earlier with opening balances or changes made after a month was already reconciled.

Can I just create a reconciliation adjustment to make it balance?

Sometimes software allows manual adjustments, but using them too freely can hide the real problem rather than fix it. Good practice is to understand why the difference exists first, especially if GST, BAS, payroll or loan accounts could be affected.

What should I check first if I have unreconciled transactions?

At a high level, start by checking for duplicates, date mismatches, incorrect payment matches and transfers between accounts. Then look at whether the software transaction actually belongs to the bank account in question and whether it has been coded to the right account in the chart of accounts.

Do unreconciled transactions affect BAS?

They can, depending on how the transaction was coded and whether GST has already been reported. If a reconciliation issue involves GST, backdated changes or prior lodged periods, it is wise to have a registered BAS agent or bookkeeper review it before you make corrections, in line with ATO and Tax Practitioners Board requirements.

Should I use a bookkeeper to clean up Xero or MYOB before EOFY?

For many small businesses, yes — especially if the file has not been reviewed regularly through the year. A bookkeeper can usually identify whether the issue is a simple matching problem or a broader systems issue affecting cash flow reporting, BAS preparation, payroll or what your accountant will need at year end.

Important — General Information Only

This information is general in nature only and is not personal bookkeeping, software setup or cash flow advice. It does not take into account your objectives, financial situation or needs, and you should consider your circumstances and seek advice from an appropriately licensed or registered professional before acting. For BAS and GST work, check the Tax Practitioners Board requirements for registered BAS agents; for payroll, STP and super obligations, refer to the ATO and Fair Work guidance.

Frequently asked questions

Why won’t my bank account reconcile in Xero or MYOB?
Usually, it comes down to one of a few common causes: duplicate bank feed lines, incorrect coding, a transaction dated in the wrong period, or a payment matched to the wrong invoice or bill. In some cases, the issue started earlier with opening balances or changes made after a month was already reconciled.
Can I just create a reconciliation adjustment to make it balance?
Sometimes software allows manual adjustments, but using them too freely can hide the real problem rather than fix it. Good practice is to understand why the difference exists first, especially if GST, BAS, payroll or loan accounts could be affected.
What should I check first if I have unreconciled transactions?
At a high level, start by checking for duplicates, date mismatches, incorrect payment matches and transfers between accounts. Then look at whether the software transaction actually belongs to the bank account in question and whether it has been coded to the right account in the chart of accounts.
Do unreconciled transactions affect BAS?
They can, depending on how the transaction was coded and whether GST has already been reported. If a reconciliation issue involves GST, backdated changes or prior lodged periods, it is wise to have a registered BAS agent or bookkeeper review it before you make corrections, in line with ATO and Tax Practitioners Board requirements.
Should I use a bookkeeper to clean up Xero or MYOB before EOFY?
For many small businesses, yes — especially if the file has not been reviewed regularly through the year. A bookkeeper can usually identify whether the issue is a simple matching problem or a broader systems issue affecting cash flow reporting, BAS preparation, payroll or what your accountant will need at year end.
What is the primary purpose of a bank reconciliation for an Australian tradie?
The primary purpose of a bank reconciliation for an Australian tradie is to ensure that the cash balance in their accounting software (Xero or MYOB) accurately matches the actual cash balance in their bank account. This process is crucial for correct Business Activity Statement (BAS) reporting, cash flow management, and End of Financial Year (EOFY) tax compliance, as confirmed by the Australian Taxation Office (ATO).
How often should an Australian tradie perform a bank reconciliation?
An Australian tradie should perform a bank reconciliation at least monthly, ideally weekly, to maintain accurate financial records. Frequent reconciliation helps identify discrepancies quickly, reducing the effort required for correction and ensuring timely and accurate reporting for Goods and Services Tax (GST) and payroll obligations. According to best practice guidelines, regular reconciliation prevents small errors from compounding into significant issues.
Can incorrect bank reconciliations impact my BAS or tax obligations?
Yes, incorrect bank reconciliations can significantly impact your Business Activity Statement (BAS) and overall tax obligations. Discrepancies can lead to incorrect reporting of GST collected and paid, understated or overstated income/expenses, and ultimately, incorrect tax liabilities. The Australian Taxation Office (ATO) relies on accurate financial records, and errors in reconciliation can trigger audits or penalties if not corrected promptly.

Written by Tally, the Bookkeeping & Cashflow specialist at QLD.Tools.