Bank reconciliation in Xero means matching every line from your bank feed to a real transaction in your books, then checking that Xero's balance agrees with your actual bank balance. Do it weekly if you can, and always before you prepare a BAS. Clean reconciliations are what make your GST figures, profit report and tax time trustworthy.
If that sounds simple, it is. The tricky part is knowing which button to press when a line doesn't look obvious, and how to prove the account is genuinely reconciled rather than just "empty". This guide walks you through both, in plain English, with the mistakes we see most often when we pick up a new Xero file.
What is a bank reconciliation? A bank reconciliation is a check that the money your business records say went in and out matches what your bank says went in and out, for the same period. In Xero, your bank feed supplies the bank's side (statement lines) and your invoices, bills and spend or receive money transactions supply your side.
Why bank reconciliation matters (especially for your BAS)
Xero pulls your GST figures from the transactions in your file. If a bank line is coded to the wrong account or the wrong tax rate, or if it's missing or doubled up, that error flows straight into your BAS. Reconciling is the moment you catch those problems, while they're still small and fresh in your memory.
It matters for three other reasons too:
- You know your real cash position. An unreconciled file can show money you don't have, or hide bills you've already paid.
- Your profit report means something. Wrong coding on bank lines quietly distorts income and expenses, and that affects decisions as well as tax.
- Your records stay in order. The ATO expects businesses to keep accurate, complete records to meet their tax, super and employer obligations (ATO: record keeping for business). A reconciled ledger backed by invoices and receipts is the backbone of that.
If you want the wider picture of preparing your quarterly statement, our guide on how to prepare and lodge your BAS in Xero picks up where this one finishes.
How often should you reconcile in Xero?
There's no single rule, but here's what works for most small businesses:
- Weekly if you have regular sales, card payments or lots of small expenses. Ten minutes a week beats a whole weekend before the BAS is due.
- Fortnightly or monthly if you only have a handful of transactions.
- Always before each BAS or IAS, and before you send anything to your accountant at EOFY.
The longer you leave it, the harder it gets. Statement lines pile up, you forget what that $64.90 card payment was, and receipts go missing. If you're already months behind, don't panic: see the section on catching up below.
How to reconcile your bank account in Xero, step by step
Xero updates its screens from time to time, so a label may look slightly different in your file, but the process is the same.
- Check your bank feed is current. In the Accounting menu, open Bank accounts and make sure each account's feed has imported recent statement lines. If a feed has stopped, reconnect it before you start, or you'll be reconciling an incomplete picture.
- Open the Reconcile tab. Click the "Reconcile items" button on the account. You'll see your bank statement lines on the left and Xero's suggested match or new transaction on the right.
- Confirm suggested matches. Where Xero has found a likely match (for example, a customer payment against an open invoice), check the amount, date and contact. If it's right, click OK.
- Use Find & Match for anything less obvious. If one deposit pays several invoices, or a payment only partly covers a bill, use Find & Match to select every relevant transaction, then reconcile them together.
- Create transactions for lines with no match. Bank fees, a supplier you pay by card, or a sale that never had an invoice all need a new spend or receive money transaction. Choose the right contact, account code and tax rate (more on tax rates below).
- Record transfers between your own accounts. Paying your business credit card from your business cheque account is a transfer, not an expense. Use the Transfer option on one side; Xero records the other side for you, so you simply confirm it in the second account.
- Leave a note on anything you don't recognise. The Discuss option lets you add a note to a line and leave it unreconciled until you know what it is. A clear open question is far better than a wrong guess.
- Check the balances agree. Once the lines are cleared, run the Bank Reconciliation report (next section) to make sure Xero's figures match your real bank balance.
Rather not do this every week? Our bookkeeping service includes bank and credit card reconciliation as standard, from $250 a month. Get a free quote or book a discovery call and we'll look at your file.
Match, Create, Transfer or Discuss: which one do you need?
When you're staring at a bank line, ask one question first: does this transaction already exist in Xero?
- Match is for when it does exist: an invoice your customer paid, a bill you paid, or a transaction you've already entered.
- Create is for when it doesn't exist and isn't a transfer: bank fees, card purchases, small cash sales and so on.
- Transfer is for money moving between two accounts that both live in your Xero file, such as your cheque account, savings account or business credit card.
- Discuss is for when you genuinely don't know yet. Add a note and come back once you've checked.
A common trap is pressing Create for a payment that was already entered as a bill. That doubles the expense and doubles the GST credit. If you've entered bills or invoices, always look for a match before creating anything new.
How to check Xero actually agrees with your bank
An empty Reconcile tab doesn't always mean your account is reconciled. Duplicate statement lines, deleted transactions or lines manually marked as reconciled can leave Xero's balance out of step with the bank, even when there's nothing left to click.
The proof is the Bank Reconciliation report in Xero's reports area (you may see it called the Bank Reconciliation Summary). Run it for the account as at your bank statement date, then compare the statement balance in the report with the closing balance on your real bank statement or online banking. If they agree, you're reconciled. If they don't, the report helps you spot unreconciled lines, unpresented items and differences to investigate.
A word of warning about Mark as Reconciled. Xero Central says to use it only when you can't import the original bank statement data, because it creates a new statement line in Xero. If the real line later arrives through the feed, you end up with a duplicate and a balance that won't match your bank (Xero Central: manually mark a transaction as reconciled).
Getting tax rates right while you reconcile
Because your BAS is built from these transactions, the tax rate you choose on each line matters as much as the account code. A few plain-English reminders:
- Not every bank charge includes GST. Many bank account fees carry no GST, while some merchant and card terminal fees do. Check the statement or tax invoice rather than guessing.
- Keep your tax invoices. To claim a GST credit on a purchase over $82.50 (including GST), you generally need a valid tax invoice (ATO: tax invoices). Attach receipts to transactions in Xero as you go.
- Payment platform deposits are often net of fees. If Square, Stripe or PayPal pays you sales minus their fees, record the full sale and the fee separately so your income and GST aren't understated.
- Personal spending isn't a business expense. If something personal went through the business account, code it to the right owner or director account rather than an expense. How that's treated for tax depends on your structure, so speak to your tax agent or accountant about it.
- Loan repayments aren't all expense. A loan repayment usually mixes principal and interest, and only part of it belongs in your profit and loss. Set it up with your accountant once and reconcile the same way each time.
If you do find you've lodged a BAS with a coding error, our guide on how to fix a mistake on your BAS explains when you can correct it next quarter and when you need to revise.
Bank rules and cash coding: faster, not autopilot
Once you've reconciled a few weeks, you'll notice the same lines repeating: your phone bill, software subscriptions, the weekly fuel stop. Bank rules tell Xero how to code those automatically, so they appear ready to approve on the Reconcile tab. Cash coding lets you code many similar lines at once in a table view.
Both save real time, but they're only as good as the rule behind them. A bank rule with the wrong tax rate will repeat that mistake every single time. Review your rules each quarter, especially after a supplier changes, and keep clicking OK yourself rather than letting lines slip through unchecked.
Behind on your bank reconciliation?
It happens to almost everyone at some point: a busy season, a family thing, a bookkeeper who left. Months or years behind? No judgement. We've seen it all.
The fix is to work through it in order, oldest period first, with bank statements for the gaps, then lodge anything overdue once the figures are reliable. Our guide to catch-up bookkeeping in Australia explains how that process works, and our BAS and IAS lodgement service can take it from reconciled books to lodged statements.
When to call in a bookkeeper or BAS agent (and when to call a tax agent)
You can absolutely reconcile Xero yourself. It's worth getting help when:
- your Reconcile tab has more lines than you can face, or the balances won't agree and you can't see why
- you're unsure which GST tax rates apply to your regular transactions
- you're behind on a BAS and need the books fixed before you lodge
- you'd simply rather spend those hours running your business
Girl Friday Australia is a registered BAS agent and Xero Certified Advisor and Gold Partner, working with small businesses Australia-wide, 100% remotely. Reconciling, GST coding and BAS lodgement are our everyday work. Questions about how to structure owner drawings, director loans or income tax planning sit with your tax agent or accountant, and we're happy to hand clean, reconciled books to them.
Frequently asked questions
What does reconciling a bank account in Xero mean?
It means matching each bank statement line in Xero to a real transaction in your books, such as a paid invoice, a paid bill or a new spend or receive money entry, and then checking that Xero's balance agrees with your actual bank balance for the same date.
How often should I reconcile my bank account in Xero?
Weekly works well for most small businesses with regular transactions. At a minimum, reconcile every account fully before preparing each BAS or IAS and before sending your year-end figures to your accountant.
Why doesn't my Xero balance match my bank balance?
Common causes are duplicate statement lines (often from using Mark as Reconciled before the real line arrived), deleted or edited transactions, a bank feed that stopped importing, or transfers recorded in only one account. Run the Bank Reconciliation report as at your statement date to find the difference.
Should I click OK on every match Xero suggests?
Only after you've checked it. Xero's suggestions are usually helpful, but confirm the amount, date and contact first. A wrong match can mark the wrong invoice as paid, which affects your debtors, your cash flow and sometimes your GST.
Do bank fees include GST in Australia?
Not always. Many bank account fees carry no GST, while some merchant or card terminal fees do. Check the bank statement or the provider's tax invoice and use the matching tax rate in Xero rather than assuming.
Can Girl Friday reconcile my Xero file for me?
Yes. Bank and credit card reconciliation is part of our bookkeeping service, from $250 a month, and we also take on catch-up work for files that are months behind. Call 0404 877 436, email info@girlfridayaustralia.com, or get a free quote.
Reconciled books, calmer BAS time
Bank reconciliation isn't glamorous, but it's the habit that keeps everything else honest: your GST, your profit, your cash and your conversations with your accountant. A few minutes a week is all it takes once it's set up properly.
If you'd like a hand getting there, or you'd rather hand it over entirely, we're here. Get a free quote, book a free discovery call, call 0404 877 436 or email info@girlfridayaustralia.com. We reply within one business day, and there are no lock-in contracts.