Bank reconciliation in Xero means checking that the transactions imported from your bank agree with the records in your bookkeeping system. Done regularly, it helps you spot missing payments, duplicates and coding errors before they become a larger problem.
This illustrated guide uses fictional figures and interface-style examples. Menus can change as Xero updates its software, so check Xero Central if your screen looks different.
What does reconciling a bank account actually do?
A bank feed brings statement lines into Xero. Those lines still need to be connected to the correct invoices, bills, transfers or expense categories. Reconciliation creates that connection. It does not simply mean that the bank feed is connected.
The money that entered or left your real bank account.
The invoice, bill, transfer or coded receipt that explains the movement.
When these records agree, Xero can produce more reliable bookkeeping reports. If the wrong explanation is selected, the numbers may still appear to balance while the bookkeeping remains inaccurate.
Before you start
- Make sure you have selected the correct bank account and date period.
- Confirm that the bank feed is current or import the missing statement lines.
- Have invoices, receipts and supplier details available.
- Investigate unfamiliar transactions rather than guessing.
- Avoid reconciling a payment twice—especially when an invoice or bill already exists.
How to reconcile a bank account in Xero
Open the bank account
From the Xero dashboard or Accounting menu, open Bank accounts. Choose the account you want to work on and select Reconcile. Check the account name and the statement balance before continuing.
Review the statement line
Read the payee, reference, date and amount. Ask what the transaction relates to and whether supporting evidence exists. A clear reference can help, but it should not replace checking the underlying record.
Use Match when a record already exists
If Xero finds an invoice, bill or other existing transaction with a corresponding amount, it may suggest a match. Verify the contact, reference, date and amount. Select the match only when it genuinely explains the bank movement.
Use Create when there is no existing record
For a transaction that has not already been entered, use the create option and select the appropriate contact, description, account category and VAT treatment. The category should reflect what the purchase or receipt actually was—not simply the supplier’s name.
Handle transfers correctly
Money moved between two business bank accounts is usually a transfer, not income or an expense. Use the transfer option and select the destination account. Treating transfers as sales or costs can distort your reports.
Check, then reconcile
Review the information one final time. If the statement line and Xero record agree, select Reconcile or OK, depending on the screen presented. If they do not agree, pause and investigate rather than forcing the transaction through.
What do the main reconciliation options mean?
Match
Connect the statement line to a transaction already recorded in Xero.
Create
Enter a new receipt or payment to explain the statement line.
Transfer
Record money moving between your own business bank accounts.
Discuss
Leave a note or flag the transaction when more information is needed.
Common Xero reconciliation mistakes
Creating a payment when an invoice already exists
This can duplicate income or expenditure. Search for the existing invoice or bill before creating another transaction.
Accepting every suggested match
Automation saves time, but similar amounts and dates can produce the wrong suggestion. Verify each match rather than relying on the green prompt alone.
Using a broad category for everything
Repeatedly choosing “general expenses” reduces the usefulness of your bookkeeping records. Use an appropriate category and consistent descriptions.
Ignoring unreconciled or duplicated statement lines
Old outstanding lines can signal an incomplete bank feed, duplicated import or incorrect entry. Investigate the cause instead of allowing the list to build up.
Guessing the VAT treatment
An incorrect VAT rate can affect the VAT records. Retain valid evidence and obtain appropriate support when the treatment is unclear.
How often should a small business reconcile?
Weekly reconciliation suits many active small businesses. A lower-volume sole trader may choose a different routine, but leaving everything until the end of a quarter or year makes missing paperwork and unclear transactions harder to resolve. Regular bookkeeping also provides a more useful view of amounts owed and available cash.
A simple monthly reconciliation checklist
- Bring every relevant bank and card feed up to date.
- Review and explain each statement line.
- Match existing invoices and bills before creating new entries.
- Record transfers between business accounts correctly.
- Check receipts and VAT evidence.
- Review unreconciled lines, duplicates and unusual balances.
- Keep a note of questions that need clarification.
When should you ask for help?
Consider support when transactions have been duplicated, the Xero balance does not agree with the real bank statement, VAT treatment is uncertain, old lines remain unexplained, or bookkeeping has fallen several months behind. Real Key Accountancy provides practical bookkeeping and computerised accountancy-system support for sole traders and small businesses in Wolverhampton and across the West Midlands.
Explore our accountancy packages, return to the Knowledge Hub, or learn more about Real Key on our home page.
Need help getting your Xero bookkeeping organised?
Tell us what has built up and we will explain the bookkeeping support available. New enquiries receive a response within two business days, Monday to Friday excluding bank holidays.
Frequently asked questions
Does a connected bank feed reconcile itself?
No. The feed imports bank-statement information, but each line still needs to be matched, created, transferred or queried correctly.
Should I reconcile a transaction if I do not recognise it?
No. Check the bank reference and supporting records first. Leave it for review if the purpose is unclear.
Can bank reconciliation find bookkeeping errors?
It can reveal missing, duplicated or unmatched transactions, but it does not guarantee that every account category or VAT treatment is correct.
Is this guide a substitute for tailored advice?
No. It provides general bookkeeping information. Your circumstances and the supporting evidence determine how a particular transaction should be recorded.
Xero is a trademark of Xero Limited. Real Key Accountancy is not affiliated with or endorsed by Xero Limited. Interface illustrations on this page are original examples and may differ from the current software.
Pingback: How to Import Bank Transactions into Xero: UK Guide - Real Key Accountancy
Pingback: Xero vs QuickBooks vs FreeAgent for UK Sole Traders - Real Key Accountancy