
If Xero reconciliation is not working, the problem is usually not the reconcile button itself. The most common causes are missing bank statement lines, duplicate imports, transactions entered with the wrong date or amount, an incorrect opening balance, transfers recorded incorrectly, or a bank feed or import gap. Start by comparing Xero's statement balance with the actual bank balance on the same date, then work backwards to the last date they matched.
In this guide:
Book a free consultation with Maaliya's UAE bookkeeping team and we'll help you track down the exact cause.
Book a free consultation today!There are two different problems people often describe as a reconciliation issue. One is that Xero cannot find or suggest the transaction you expect it to match. The other is that you can reconcile individual lines, but the statement balance in Xero still does not agree with the bank. Treat these separately: matching problems are usually transaction-level, while balance problems are usually caused by missing, duplicated, deleted, or incorrectly dated statement data.
Xero's own reconciliation guidance explains that the Bank Reconciliation Summary can be used to investigate differences between the actual bank balance and Xero's statement balance. Xero recommends confirming the opening balance, finding the last date the balances agreed, and then narrowing the discrepancy down by period.
A missing statement line means the bank shows a transaction that never reached the Xero bank account. This is common after a bank feed interruption, when a feed starts from a later date than expected, or when a manual import does not cover the full period.
For UAE businesses, manual statement imports are especially useful when a direct bank feed is unavailable or incomplete. Xero supports manual statement imports, including OFX, QFX, and QuickBooks-format files, and recommends OFX when the bank provides it.
If your UAE bank only gives you a PDF or an awkward export, turn it into an import-ready file before you touch reconciliation.
Parse your bank statements now!Duplicates can make the Xero balance look wrong even when every real-world bank transaction appears to be present. They can arise when overlapping files are imported, when a bank feed is replaced by manual imports, or when an accounting transaction is created twice.
Xero recognises duplicate transactions already imported in other files and excludes them during supported statement imports, but you should still review the affected period if you changed feeds, accounts, or import methods.
Xero's matching depends on the underlying records. If a supplier payment was entered for AED 4,950 but the bank line is AED 5,000, or if the payment date is materially different, Xero may not offer the match you expect. The same applies to customer receipts, bank charges, and foreign-currency settlements.
Before creating a new Spend Money or Receive Money transaction, search Xero for the invoice, bill, payment, or existing transaction. Creating a second accounting entry just because the original does not appear as a suggested match can duplicate income, expenses, receivables, or payables.
If the opening bank balance is wrong, every later reconciliation can appear wrong even when the current period's transactions are correct. This is particularly common after migrating from Excel, QuickBooks, Zoho Books, Tally, or another accounting system.
If this issue started after a migration, revisit the conversion balances you brought across from your previous system as part of that changeover.
A bank feed can be connected and still leave a historical gap. When a feed starts, changes provider, or reconnects, compare the first imported date with the last date already present in Xero. Xero specifically advises checking for missing or duplicate transactions when bank feeds change, and manually importing missing lines where necessary.
For UAE-specific feed limitations and alternatives, see Maaliya's guides on why Xero bank feeds don't work in the UAE and the best alternatives to Xero bank feeds in the UAE.
Money moved between two business bank accounts is not income in one account and an expense in the other. In Xero it should normally be recorded as a transfer between the relevant bank accounts. If each side is coded independently to revenue or an expense account, the bank may reconcile while the accounting becomes wrong.
Transfers are also a common source of timing differences: one bank may show the outgoing side on one date, and the receiving bank may show the incoming side a day later. That timing difference does not justify creating extra income or expense entries.
Use a controlled, date-by-date approach instead of editing random transactions. Xero recommends finding the last date when the statement balance in Xero matched the actual bank account, running the Bank Reconciliation Summary for the next period, and progressively narrowing down the date on which the difference appeared.
This is usually faster and safer than unreconciling months of transactions.
If a bank statement line has already been reconciled to the wrong Xero transaction, view its reconciliation details before changing anything. Xero lets you inspect the accounting transaction or transactions behind a reconciled statement line; if the match is wrong, unreconcile it and then reconcile it to the correct transaction.
A reconciliation is not correct merely because Xero shows fewer unreconciled lines. The objective is for the bank statement data and accounting records to represent the same real transactions.
Xero's UAE site says JAX can automatically reconcile transactions when it has high confidence, using rules, matches, memory, and predictions, with review available to the user.
Automation can reduce routine matching work, but it cannot make incomplete bank data complete or turn an incorrect opening balance into a correct one. If your underlying statement data is messy, fix the data source first: a clean bank-import workflow matters just as much as the reconciliation screen itself.
Check whether the accounting transaction already exists, whether its amount and date are correct, and whether the corresponding bank statement line actually reached Xero. A missing statement line and a missing accounting transaction are different problems.
Check the statement date range, missing or duplicate imports, unreconciled items, payments recorded in the wrong bank account, incorrect opening balances and manually entered transactions. Do not plug the difference to an expense account without identifying the cause.
Yes. Xero supports manual bank statement imports. Import only the missing period and review the file carefully to avoid overlap with existing feed data.
Match an existing transaction whenever the accounting event is already recorded, such as an invoice or bill. Create a new transaction only when the bank line represents a genuine event that is missing from Xero.
Record it as a transfer between the two Xero bank accounts, then reconcile the statement line on each side. Do not record one side as income and the other as an expense.
Maaliya's UAE bookkeeping team can review your Xero file and fix the underlying bank data, not just the balance.
Book a free consultation today!Xero Central, Compare the statement balance in Xero to your actual bank balance. Accessed 26 September 2026.
Xero Central, Import an OFX, QFX or QuickBooks bank statement. Accessed 26 September 2026.
Xero Central, Update your bank feeds when you change banks. Accessed 26 September 2026.
Xero Central, View bank reconciliation details. Accessed 26 September 2026.
Xero UAE, Bank reconciliation software for small businesses. Accessed 26 September 2026.

Lina Mansouri is a Corporate Services specialist at Maaliya, where she helps UAE businesses with company incorporation, VAT and corporate tax registration, and liquidation. She writes Maaliya's guides to Xero, UAE VAT, bank reconciliation and eInvoicing, drawing on the questions UAE founders and finance teams bring to Maaliya every day.
Like what you read? Add Maaliya as a preferred source on Google.