Bank reconciliation in Xero is the process of matching the transactions in your accounting records to those on your bank statement, so your books are accurate. Xero imports bank feeds automatically and suggests matches, making reconciliation quick, but it must be done regularly to keep your financial reports reliable.
Bank reconciliation is one of those tasks that every business owner knows they should do â and too many put off until the end of the financial year, when the mess is already deep. If your Xero books don’t match your actual bank account, you’re making decisions on numbers you can’t trust. Overstated income, missed expenses, GST errors, cash flow blind spots â these are the real consequences of letting reconciliation slide. The good news: when it’s set up properly in Xero, bank reconciliation takes minutes, not hours. This guide will show you exactly how it works, what goes wrong, and how to keep your books clean all year round.
What Is Bank Reconciliation in Xero?
Bank reconciliation is the process of matching the transactions in your accounting software against the transactions that actually cleared your bank account. In Xero, this happens inside the Bank Reconciliation screen, where Xero displays your imported bank transactions on one side and your coded accounting records on the other.
The goal is simple: every dollar that moved through your bank account should have a corresponding, correctly coded entry in Xero. When the two sides agree, your account is reconciled. When they don’t, something needs investigating.
In Xero specifically, bank reconciliation works through bank feeds â a live, secure connection between Xero and your bank that automatically imports transactions, usually within one business day. This removes the need to manually upload bank statements, which was a major pain point in older accounting systems. Most major Australian banks â including Commonwealth Bank, ANZ, Westpac, NAB, and many others â support direct bank feeds into Xero.
Once transactions are imported, Xero uses smart matching rules to suggest how each transaction should be coded. You review and confirm (or adjust) those suggestions, and once every transaction on the statement is matched, the account is reconciled.
Why Bank Reconciliation Matters for Your Business
Some business owners treat bank reconciliation as a compliance chore. It’s actually one of the most valuable financial controls you have â and here’s why.
Accurate financial reports depend on it. Your Profit and Loss statement and Balance Sheet are only as reliable as the data underneath them. If transactions are uncoded, duplicated, or miscategorised, every report you generate is wrong. When you’re making decisions about hiring, pricing, or investment based on your financials, wrong numbers are dangerous.
GST reporting requires it. If you’re registered for GST, the ATO expects your Business Activity Statements to reflect your actual income and expenses. Unreconciled transactions often mean GST has been coded incorrectly â or not coded at all â which creates BAS errors and potential penalties.
The ATO requires you to keep accurate records. Under the ATO’s record-keeping rules for businesses (ato.gov.au/businesses-and-organisations/record-keeping-for-business), you must retain financial records for five years and be able to demonstrate that your reported income and deductions are accurate. A clean bank reconciliation is the foundation of that compliance.
It catches fraud and errors early. Regular reconciliation means you’ll notice if a payment has been processed twice, if an unauthorised transaction has hit your account, or if a supplier has debited the wrong amount. The sooner you spot these, the easier they are to resolve.
Cash flow clarity. When your Xero account balance reflects your real bank balance, you always know where you stand. You can trust the cash flow figures you’re looking at â which matters when you’re deciding whether to pay a supplier early, take on a new contract, or draw a dividend.
How Bank Reconciliation Works in Xero: Step-by-Step
Here’s how a typical bank reconciliation session works in Xero. This assumes you have bank feeds connected â if you don’t, you’ll need to import statements manually using a CSV or OFX file, which follows the same process once the transactions are loaded.
Step 1: Navigate to the Reconcile Screen
From your Xero dashboard, go to Accounting > Bank Accounts. You’ll see each connected account listed with an indication of how many transactions are waiting to be reconciled. Click Reconcile [X] items next to the account you want to work on.
Step 2: Review Each Transaction
The reconciliation screen shows your bank transactions on the left. For each transaction, Xero will either suggest a match (green), suggest a rule-based code, or leave it blank for you to handle manually. Work through them one by one.
- Matches (green): Xero has found an invoice or bill in your system that matches the bank transaction amount and date. Review it to confirm it’s correct, then click OK.
- Rule-based suggestions: Xero has a bank rule set up for this payee (e.g., every transaction from “OFFICE WORKS” is coded to Stationery & Office Supplies). Confirm the code is still appropriate and click OK.
- New transactions: No suggestion exists. You’ll need to code the transaction manually â select the correct account code, contact, and GST treatment, then click OK.
Step 3: Handle Split Transactions
Sometimes a single bank transaction covers multiple expense categories â for example, a hardware store purchase that includes both tools (depreciable asset) and cleaning supplies (expense). In Xero, you can split a transaction across multiple account codes directly from the reconciliation screen using the Split option.
Step 4: Create or Match Transfers
If you transfer money between your own business accounts â say, from a business cheque account to a savings account â you need to code this as a Transfer in Xero, not as income or expense. Xero will flag it on both accounts and match them once both sides are coded.
Step 5: Confirm the Closing Balance
Once all transactions are matched, Xero will show a Statement Balance and a Balance in Xero. If they match, your reconciliation is complete and you’ll see a confirmation screen. If they don’t match, there’s a discrepancy to investigate before you proceed.
Step 6: Check the Reconciliation Report
Run the Bank Reconciliation Summary report (under Accounting > Reports) periodically to review your reconciliation history. This report shows the closing statement balance for each period alongside the Xero balance, making it easy to spot if something has changed in a previously reconciled period.
Common Bank Reconciliation Problems in Xero (and How to Fix Them)
Even with bank feeds running smoothly, things go wrong. Here are the issues we see most often with clients â and how to resolve them.
Unmatched Transactions
This happens when a transaction appears in your bank feed but Xero can’t find a matching invoice or bill in the system. Common causes include:
- An invoice was created in Xero but the payment wasn’t applied correctly
- A payment came in from a new customer who wasn’t linked to an existing invoice
- An expense was paid directly from the bank without a corresponding bill in Xero
Fix: Use the Find & Match function on the reconciliation screen to search for related invoices or bills manually. If none exists, create a new transaction. Never just skip an unmatched item â it will accumulate in your unreconciled backlog and distort your reports.
Bank Feeds Not Updating
Bank feeds occasionally stop refreshing, usually because the connection between Xero and your bank has timed out or your bank’s security settings have changed. Symptoms include a long gap in imported transactions or a feed that shows as disconnected in Xero.
Fix: Go to Accounting > Bank Accounts, click on the affected account, and look for a prompt to refresh or don’t match, there’s a discrepancy to investigate before you proceed. Many banks now require periodic re-authentication as a security measure. If the feed has been disconnected for a while, you may need to manually import the missing period using a bank statement CSV before reconnecting.
Opening Balance Discrepancies
If you switched to Xero from another system â or if your books weren’t set up correctly when you started â your Xero opening balance may not match your actual bank balance. This creates a permanent discrepancy that never reconciles away on its own.
Fix: This usually requires an accountant to adjust. The fix involves posting a correcting journal entry to bring the Xero opening balance in line with the actual bank statement balance on conversion date. It’s not something to guess at â an incorrect fix can cause more problems than the original discrepancy. If you’re in this situation, speak with a Xero accountant before attempting a manual correction.
Duplicated Transactions
Duplicates occur when a transaction is imported twice â# often because a bank statement was manually imported over an active bank feed, or because a transfer was coded as both income and a transfer. Duplicates inflate your income or expense figures and are a common source of GST errors.
Fix: In Xero, you can delete duplicate bank transactions from the Account Transactions screen (before they’re reconciled) or void incorrect entries. If duplicates have already been reconciled, you’ll need to adjust through a credit note or journal entry â another case where having an experienced bookkeeper on hand saves significant time.
How Often Should You Reconcile in Xero?
The honest answer: as often as possible. For most small to medium businesses, reconciling weekly is the practical minimum. For businesses with high transaction volumes â retail, hospitality, trades with multiple suppliers â daily reconciliation is realistic and worthwhile because bank feeds do most of the work automatically.
Here’s a practical framework by business type:
- Sole traders and freelancers with low volume: Fortnightly is acceptable, but monthly at the absolute latest. Anything less frequent than monthly means your BAS figures will often be estimated rather than accurate.
- Small businesses (1â10 staff): Weekly. This keeps your cash position current and means BAS preparation takes an hour, not a day.
- Businesses with payroll, multiple accounts, or high transaction volume: Daily or every two days. At this scale, letting reconciliation drift even a week creates a backlog that requires real time to clear.
The worst time to reconcile is the night before your BAS is due. By that point, you’re working under pressure, more likely to make coding errors, and there’s no buffer to investigate discrepancies properly. Businesses that reconcile regularly rarely have BAS surprises.
When to Get Your Accountant Involved
Xero’s reconciliation tools are genuinely user-friendly, and many business owners handle their day-to-day reconciliation themselves. But there are situations where trying to self-solve costs more time and money than it saves.
You should call your accountant when:
- Your Xero balance and bank statement balance don’t agree after reconciliation and you can’t find the cause
- You’ve just migrated to Xero and you’re not confident your opening balances are correct
- Your BAS figures look wrong compared to what you expected, and you’re not sure why
- You’ve gone months without reconciling and the backlog feels overwhelming
- You’re dealing with loans, directors’ loans, trust accounts, or inter-entity transactions â these have specific coding requirements that are easy to get wrong
- You’ve had a significant one-off transaction (asset purchase, lump-sum payment, insurance payout) and you’re unsure how to code it
At Pinnacle Accounting & Advisory, we work with clients across Melbourne who are at different stages â some just want help getting set up correctly so they can manage it themselves, others prefer to hand reconciliation over to us entirely. Either approach works; the important thing is that it gets done accurately and on time.
If you want a second opinion on your current Xero setup or need help clearing a reconciliation backlog, book a no-obligation consultation and we’ll take a look.
Frequently Asked Questions
Why does my Xero balance not match my bank balance after reconciling?
The most common reasons are: transactions in Xero that haven’t cleared the bank yet (like a cheque you’ve issued but the recipient hasn’t deposited), bank fees that were imported but not coded, or a historical entry error that created an incorrect opening balance. Run the Bank Reconciliation Summary report in Xero to compare your statement balance against your Xero balance period by period â this usually isolates where the discrepancy started.
What’s the difference between “reconciled” and “coded” in Xero?
These terms are often confused. Coded means a transaction has been assigned an account code (e.g., Advertising, Rent, Cost of Goods Sold). Reconciled means a bank feed transaction has been matched to a coded entry and confirmed as correct. You need both: coding without reconciling leaves transactions sitting in your unreconciled list, and reconciling without correct coding produces accurate bank balances but incorrect P&L reports. Every transaction needs to be both coded correctly and reconciled.
Can I reconcile multiple months at once in Xero?
Yes â Xero doesn’t force you to reconcile in strict chronological order, and bank feed transactions from multiple periods can all sit in your reconciliation queue at once. That said, it’s worth working through them in order where possible, because a coding error in an early period can create a chain of apparent discrepancies in later ones. If you’re catching up on several months of unreconciled transactions, work from oldest to newest.
Does bank reconciliation in Xero satisfy the ATO’s record-keeping requirements?
Xero’s bank reconciliation is a strong foundation for ATO compliance, but it’s not a complete substitute for proper record-keeping. The ATO still requires you to retain source documents â invoices, receipts, contracts â that support your transactions. Xero lets you attach these directly to each transaction, which is the most efficient way to satisfy both the reconciliation requirement and the supporting-document requirement. For more detail on what records the ATO requires, see ato.gov.au/businesses-and-organisations/record-keeping-for-business.
Get Your Xero Books in Order
Bank reconciliation in Xero is one of those things that seems complicated until you understand how it works â and then becomes a quick, routine part of running your business. The key habits are simple: connect your bank feeds, reconcile regularly, code transactions correctly, and investigate discrepancies before they compound.
If you’re not confident your Xero reconciliation is in good shape â or if you’re spending too much time on it and want it handled professionally â Pinnacle Accounting & Advisory can help. We’re a Melbourne-based Xero accounting firm led by Mina Baselyous, CPA and CTA, and we work with Australian businesses at every stage to get their books accurate, their BAS filed correctly, and their financial reporting actually useful.
The first step is a conversation. Book your no-obligation consultation here â no obligation, just a straightforward look at where your Xero setup stands and what, if anything, needs attention. Or if you’d prefer to get in touch directly, visit our contact page.
Is your Xero bank reconciliation up to date?
At Pinnacle Accounting & Advisory we help Melbourne business owners keep your books accurate so your numbers can be trusted. Book a consultation with Mina to find out where you stand.
Book a ConsultationFrequently Asked Questions
What is bank reconciliation in Xero?
Bank reconciliation is matching the transactions recorded in Xero against those on your bank statement, confirming your records are complete and accurate. Xero imports transactions via bank feeds and suggests matches, so you confirm or adjust each one.
How do I reconcile my bank account in Xero?
In Xero, go to the bank account’s Reconcile tab, review each imported transaction, and match it to an invoice or bill, or create a matching transaction with the correct account and GST code. Confirm the match, and repeat until everything is reconciled.
How often should I reconcile in Xero?
Ideally weekly, or at least monthly. Regular reconciliation keeps your reports accurate, catches errors and missing transactions early, and makes BAS and tax time far easier. Letting it build up leads to mistakes and unreliable numbers.
Why will my bank not reconcile in Xero?
Common causes include duplicate transactions, missing bank feed data, transactions coded to the wrong account, or timing differences. Check for duplicates, ensure your bank feed is complete, and review any unreconciled items. An accountant can help resolve persistent issues.
This article contains general advice only and does not take into account your specific circumstances. Please speak with a qualified accountant or tax adviser before making financial decisions.
Ready to do Business with Us?
Join countless small businesses and work with
Australia’s leading Small Businesses Accountants so you can
focus on growing your business – while we take care of the numbers.









