Bank reconciliation in Xero compares the transactions and balance recorded in Xero with the corresponding bank statement. It confirms that money entering and leaving the account has been captured accurately and helps identify missing transactions, duplicates, incorrect dates and payments posted to the wrong account.
Xero’s bank feeds can reduce manual data entry by importing transactions from supported banks and credit-card providers. The feed does not complete the bookkeeping automatically. Each transaction still needs to be matched, categorised or transferred correctly, and the final Xero balance must agree with the independent bank statement.
This guide explains the full reconciliation process, including bank-feed setup, transaction matching, transfers, outstanding items and the checks needed before monthly reports or VAT Returns are prepared.
What bank reconciliation in Xero means
Bank reconciliation in Xero involves comparing the accounting entries in a Xero bank account with transactions shown by the actual bank.
The Reconcile screen presents imported bank-statement lines alongside suggested matches or transaction-entry options. The user can match a bank line with an existing invoice, bill or payment, create a new transaction or record a transfer between accounts.
Processing every line on the Reconcile screen is only part of the process. The Xero account must also be compared with a bank statement for the same closing date.
A bank account can show no unreconciled feed lines and still contain an incorrect balance if historical transactions are missing, duplicated or altered.
Why bank reconciliation matters
Current reconciliation improves the reliability of the profit and loss account, balance sheet, customer balances, supplier balances and cash information.
Without reconciliation, income may be recorded twice, costs may be omitted and transfers may be treated incorrectly as sales or expenses.
Errors can also affect VAT Returns. A duplicated purchase could overstate input VAT, while omitted sales may understate the VAT due.
Regular reconciliation helps detect problems while transactions remain familiar, rather than leaving the investigation until year end.
Step 1: Add the bank account to Xero
Each business bank account should be represented separately in Xero. This includes current accounts, savings accounts, business credit cards and foreign-currency accounts.
Payment platforms such as PayPal and Stripe may also require separate accounts where they hold balances or combine sales, refunds and fees before transferring money to the main bank.
The account name, account number and currency should be checked before transactions are imported.
Omitting an account creates gaps in the bookkeeping and can leave unexplained transfers and balances elsewhere in the accounts.
Step 2: Connect the bank feed
A supported bank feed can import transaction data directly into Xero after the account holder completes the bank’s authorisation process.
The initial import may include historical transactions, depending on the financial institution and connection type. The selected start date should be reviewed carefully to avoid importing transactions already entered manually.
Bank-feed authorisation may need to be renewed periodically. A feed can also stop temporarily because of a banking connection issue.
A missing feed does not remove the need to maintain the records. Bank statements can be imported manually while the connection is unavailable.
Step 3: Check the opening balance
Before reconciling current transactions, confirm that the opening Xero balance agrees with the bank balance at the chosen starting date.
A business moving from another accounting system may need to enter a conversion balance based on its previous records.
The opening figure should be supported by a bank statement, completed accounts or another reliable report. It should not be estimated merely to make the current balance appear correct.
If the opening balance is wrong, every later reconciliation will begin from an unreliable position.
Step 4: Review imported bank-statement lines
The Reconcile tab displays bank-statement lines waiting to be processed.
For each line, review the date, amount, description and payee information. The description alone may not be sufficient to determine the correct accounting treatment.
A payment could represent a supplier bill, employee expense reimbursement, loan repayment, fixed asset purchase, personal transaction or transfer between accounts.
Supporting invoices, receipts and other records should be checked before accepting a category.
Step 5: Match customer receipts
Where a customer payment relates to an invoice already recorded in Xero, the bank line should be matched against that invoice.
Creating a new receive-money transaction instead would duplicate the income and leave the original invoice appearing unpaid.
Part-payments should be matched with the relevant invoice while leaving the remaining balance outstanding.
Where one bank deposit covers several customer invoices, the payment may need to be matched across multiple transactions.
Step 6: Match supplier payments
If a supplier bill has already been entered, the bank payment should be matched against that bill.
Coding the bank line directly to an expense account would record the cost twice and leave the supplier balance unpaid.
One payment may settle several bills, or a bill may be paid in instalments. The match should reflect the actual payment arrangement.
Credit notes and supplier refunds should also be applied to the correct supplier account rather than posted as unrelated income.
Step 7: Create transactions where no match exists
Some bank lines will not relate to an invoice or bill already recorded.
Examples include bank charges, interest, direct debits, subscriptions and small purchases paid immediately.
These can be entered as spend-money or receive-money transactions using the correct contact, account category and VAT treatment.
The supporting receipt or document should be attached where available.
Step 8: Record transfers correctly
Money moved between two business accounts is not income or an expense.
It should be recorded as a transfer from one Xero bank account to the other. This creates both sides of the transaction and allows each account to be reconciled.
Common examples include transfers from a current account to savings, credit-card repayments and movements between sterling and foreign-currency accounts.
Recording a transfer as income in one account and an expense in the other distorts turnover, costs and profit.
Step 9: Review Xero’s suggested matches
Xero can suggest matches and categories based on existing invoices, previous transactions and bank rules.
These suggestions can speed up reconciliation but should not be accepted without review.
Two transactions may have the same amount, or a recurring supplier may provide different goods and services requiring different categories.
The user should confirm the date, contact, document and business purpose before accepting the suggestion.
Step 10: Use bank rules carefully
Bank rules can automate recurring transactions such as bank fees, software subscriptions and regular transfers.
A rule should be specific enough to avoid applying to unrelated transactions with similar descriptions.
The VAT rate, account code and contact should be reviewed when the rule is created.
Rules should also be checked periodically because suppliers, payment descriptions and VAT treatment can change.
Step 11: Attach supporting documents
Receipts and invoices can be attached to the relevant Xero transaction.
The document supports the supplier, purchase date, business purpose, amount and any VAT reclaimed.
A bank-statement line alone does not normally prove how much VAT was charged or whether the purchase related wholly to the business.
Our guide to Xero expenses explains how businesses can capture receipts and distinguish employee claims from purchases paid directly by the company.
Step 12: Check for unreconciled account transactions
Xero can contain account transactions that do not yet have a corresponding imported bank-statement line.
These may be genuine outstanding payments, deposits not yet cleared or manually entered transactions awaiting the bank feed.
They may also represent duplicates, incorrect dates or payments that were never made.
Old unreconciled transactions should be investigated rather than carried forward indefinitely.
Step 13: Compare Xero with the bank statement
After processing the feed, obtain the bank statement covering the reconciliation date.
Compare the closing statement balance with the balance shown in Xero for the same date.
The two balances should agree after allowing for genuine outstanding items that have been recorded in Xero but have not yet cleared the bank.
The bank statement provides independent evidence. A balance displayed by the live bank feed should not be the only source used for verification.
Step 14: Run the bank reconciliation report
Xero’s bank reconciliation report compares the statement balance with the balance recorded in the accounting system.
The report can show outstanding payments, outstanding receipts and other differences affecting the account.
It should be reviewed at each month end and retained as part of the bookkeeping records where appropriate.
A report that does not balance should be investigated before management accounts or VAT Returns are finalised.
Common causes of reconciliation differences
A difference can arise because transactions were imported twice, entered manually as well as through the feed or recorded in the wrong bank account.
Another common cause is an incorrect opening balance or a transaction that was deleted after a previous reconciliation.
Date differences can also matter. A payment entered in Xero on one date may appear on the bank statement on another.
Bank charges, interest, foreign-exchange movements and card-processing fees are often missed where the business records only invoices and customer receipts.
How to find duplicated transactions
Compare transactions with identical or similar amounts, dates and descriptions.
A duplicate may arise when a manually entered transaction is followed by the same transaction arriving through a bank feed or statement import.
Customer income and supplier costs may also be duplicated where the payment is coded directly rather than matched with an existing invoice or bill.
Before deleting anything, confirm which entry contains the correct document, contact and reconciliation history.
How to handle missing transactions
A transaction visible on the bank statement but absent from Xero may not have imported because the bank feed began later or stopped temporarily.
The missing item can be added through a statement import or entered manually using the appropriate transaction type.
A transaction present in Xero but absent from the bank statement may be dated incorrectly or may not have occurred.
The underlying payment evidence should be checked before reversing or deleting the entry.
Correcting a previously reconciled transaction
Changing a transaction after reconciliation can cause later opening balances to differ from the expected position.
Xero’s history and reconciliation reports can help identify deleted or amended entries.
The correction should preserve a clear audit trail and reflect what actually happened in the bank.
Unsupported adjustments should not be added merely to force the account to balance.
Reconciling several bank accounts
Each bank, card and payment-platform account must be reconciled separately.
The total of all Xero account balances should then agree with the corresponding external statements at the same date.
Reconciling only the main current account leaves the business exposed to missing credit-card expenses, savings transfers and platform fees.
Transfers between accounts should be checked from both sides to ensure the amounts and dates correspond.
Reconciling business credit cards
A company credit card should normally be set up as a separate Xero bank account.
Individual card purchases are recorded and reconciled within that account. The payment made from the current account is then recorded as a transfer to the credit-card account.
Posting the complete credit-card repayment as an expense duplicates the purchases already recorded from the card statement.
Receipts should be attached to the individual purchases rather than only to the monthly repayment.
Reconciling PayPal, Stripe and card processors
Payment processors often deduct fees, refunds and chargebacks before transferring money to the bank.
The business should reconcile the processor account using settlement reports and transaction details from the platform.
Sales should normally be recorded at their gross value, with processing fees and refunds shown separately.
Treating the net bank deposit as total sales understates turnover and expenses and may affect VAT reporting.
Reconciling cash and petty cash
Cash activity does not appear through an ordinary bank feed unless the money is later deposited.
A separate cash or petty-cash account can be used to record takings, cash expenses and deposits.
The recorded balance should be checked against the physical cash held.
Cash differences should be investigated and documented rather than cleared repeatedly through a general expense account.
Bank reconciliation and VAT Returns
Relevant bank, card and payment-platform accounts should be reconciled before a VAT Return is submitted.
Reconciliation can identify omitted purchases, duplicated costs and customer income recorded incorrectly.
It does not by itself confirm that every VAT code is correct, so VAT reports and supporting invoices still require review.
Our VAT returns service explains how reconciliation, digital records and VAT review form part of an MTD-compliant filing process.
Bank reconciliation and monthly reports
Profit and loss and balance-sheet reports should normally be produced after the bank accounts have been reconciled.
Otherwise, reported income and costs may exclude transactions or contain duplicates.
The balance sheet can also show bank accounts with unexpected negative balances or historical differences requiring investigation.
Monthly reconciliation gives the owner greater confidence that the reports reflect the available records at the reporting date.
How often should bank reconciliation be completed?
Monthly reconciliation is a sensible minimum for many small businesses.
Weekly reconciliation may be more suitable where the business has high transaction volumes, several payment platforms or regular management reporting.
Very active accounts may benefit from more frequent processing so missing documents and unusual transactions are identified promptly.
The frequency should reflect the volume and complexity of the account, not simply the size of the business.
Good Xero reconciliation habits
Process transactions regularly rather than allowing several months to accumulate.
Attach invoices and receipts, review automated suggestions and investigate old outstanding items.
Compare each Xero account with an independent statement at month end and keep evidence of the completed reconciliation.
Our guide to good bookkeeping habits explains how regular transaction review and document collection support more reliable records.
Bank reconciliation for new Xero users
A new Xero organisation should begin with accurate bank-account details, opening balances and a carefully selected feed start date.
Importing historical transactions that overlap with conversion balances or manually entered records can create duplicates.
Our guide to setting up Xero explains how to configure bank feeds, conversion balances and user access before routine bookkeeping begins.
The first reconciliation should be completed before relying on Xero’s reports.
Catch-up bank reconciliation
A business may have months of imported transactions waiting to be processed or old differences carried forward from previous periods.
Catch-up work should proceed in date order, beginning with the earliest reliable bank statement and opening balance.
Transactions should be matched with invoices and supporting records rather than coded rapidly merely to clear the reconciliation screen.
Historical reconciliation may require separate clean-up work where previous entries were duplicated, deleted or posted to incorrect accounts.
Outsourcing bank reconciliation in Xero
An outsourced bookkeeper can maintain the bank feeds, process transactions, raise queries and complete regular reconciliations.
The business still needs to provide invoices, receipts and explanations for unusual payments.
Bookkeeping Packages Ltd provides Xero bookkeeping services that can include bank reconciliation, invoice processing, VAT records and monthly reporting.
Our wider bookkeeping services can also include catch-up work where the accounts have fallen behind.
Getting help with bank reconciliation in Xero
The first step is to review the Xero bank accounts, feed start dates, opening balances and most recent completed statements.
We can then identify missing periods, duplicated transactions, old outstanding items and accounts that have not been reconciled.
Where substantial historical correction is required, the clean-up work can be agreed separately before the regular monthly process begins.
To discuss bank reconciliation in Xero and the condition of your bookkeeping records, use the Bookkeeping Packages enquiry form or call 0161 531 0087.
About the Author
Stuart Kerr is Managing Director of Bookkeeping Packages Ltd, an outsourced bookkeeping service supporting UK small businesses and accountancy practices. With over 20 years of bookkeeping experience, Stuart specialises in helping businesses maintain reliable financial records and useful management information.
This article is provided for general information only. Stuart Kerr is a professional bookkeeper, not a tax, legal or regulated financial adviser. Nothing in this article constitutes tax, legal or financial advice. Advice specific to your circumstances should be obtained from an appropriately qualified professional.