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?
What A Specialist Would Review For Your Situation
Common Costly Mistakes
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.