DeepLedger
Menu

Bookkeeping

Xero Bank Reconciliation with AI: What to Automate

Xero bank reconciliation: the Reconcile tab, bank rules, JAX, the report pack and Xero's fixes, plus what an AI can automate and what a person reviews.

Published by DeepLedger12 min read

Xero bank reconciliation means matching each imported bank statement line to a transaction in Xero on the Reconcile tab, until the Statement Balance in Xero agrees with your bank and with the Balance in Xero. Bank rules, Xero's JAX auto-reconciliation and an AI connected to the books can take the routine matching; a person reviews exceptions, corrections and the sign-off. This guide is for bookkeepers and accountants reconciling Xero organisations.

How does bank reconciliation work in Xero?

Xero works with two lists for each bank account.

  • Bank statement lines come from your bank, through a bank feed or a statement file you import.
  • Account transactions are created in Xero: invoices and bills with their payments, expense claims, spend money, receive money and transfers.

Reconciling links each statement line to its transaction, or creates one. Xero Central says you need the administrator role, or the standard role with bank accounts, to reconcile (Bank reconciliation in Xero, as of November 2026).

Xero shows two balances that should agree:

BalanceWhat it is
Statement BalanceThe opening balance plus every statement line imported into the account
Balance in XeroThe opening balance plus every account transaction in the account; this is the figure on the Balance Sheet

Source: Why are the Statement Balance and Balance in Xero different?

How do I reconcile a bank account in Xero?

These steps follow Xero Central's Reconcile your bank account guide, as of November 2026.

  1. Prepare. Enter the invoices, bills, credit notes and expense claims you know about. Check the opening balance.
  2. Open the account. On the homepage, click Reconcile [number] items on the bank account. If the account is not on the homepage, go to Accounting → Bank accounts.
  3. Accept a correct match. Statement lines are on the left, Xero's suggestion on the right. If the suggested transaction is right, click OK.
  4. Look at other matches. If the suggestion is wrong, click [number] other possible matches found.
  5. Use Find & Match. If the transaction exists but is not suggested, click Find & Match, search by name, invoice number, amount or reference, tick each transaction, and click Reconcile. Find & Match also handles one line paying several invoices, a small bank fee (Adjustments → Bank fee) and part payments (Find transactions to match).
  6. Create a transaction. If nothing exists, use the Create tab for spend money or receive money.
  7. Record a transfer once. Use the Transfer tab for money moved between your own accounts. Xero creates the other side, so in the second account you only click OK.
  8. Ask when unsure. Add a comment on the Discuss tab for your adviser or a colleague. Do not guess.
  9. Check the balances. When every line is done, the Statement Balance and the Balance in Xero should be the same.

How do bank rules, cash coding and JAX help?

Xero builds three kinds of automation into reconciliation. Each still needs a review.

Suggestions. When no existing transaction matches, Xero looks at your bank rules and suggests a transaction that follows the rule. With Suggest previous entries ticked at the bottom of the screen, Xero also suggests transactions from similar past reconciliations (memory) or predicts a contact and account (predictions, shown in italics).

Cash coding. Cash coding reconciles many cash lines at once in a spreadsheet view. Xero shows up to 200 lines at a time and suggests reconciling fewer than 100 at once. Go to Accounting → Bank accounts, click the account name, then select the Cash coding tab. Cash coding creates new spend or receive money transactions, so Xero says not to use it for anything already entered. Reconcile invoices, bills, refunds, prepayments, expense claims and transfers on the Reconcile tab first (Reconcile statement lines in bulk).

JAX automatic bank reconciliation. As of November 2026, Xero Central describes automatic reconciliation by JAX, Xero's AI. You turn it on for each account under Accounting → Bank accounts, the account, the Reconcile tab, Auto-reconcile, then Turn on Auto Bank Reconciliation and Save. You need to be the subscriber or an administrator. JAX reviews only statement lines imported after you turn it on, and reconciles those that meet its high-confidence criteria. Each reconciled item is labelled Rule, Match, Memory or Prediction on the Reconciled transactions screen, which you open with Review reconciled. Xero Central says it is included on Standard plans and above, and on Lite and Starter through the AI Automate add-on; plan names differ by region (How to use automatic bank reconciliation).

How do I check the statement balance against Xero?

Use the Bank Reconciliation report pack. It holds the Bank Reconciliation Summary, the Bank Statement report and the Statement Exceptions report.

  1. Go to Reporting → All reports.
  2. Open the Bank Reconciliation report pack.
  3. Under Contents, choose the report.
  4. Set the Pack date range to the statement period.
  5. On the summary, enter your bank's closing figure under Bank statement ending balance.
  6. Read Calculated balance out by. It should be zero.

When everything is up to date at the report date, Xero says the Balance in Xero, the Statement balance (calculated) and your online banking balance should be the same (Bank Reconciliation reports). For a transaction-level view, the Bank Reconciliation Detail report takes both the opening and closing statement balances. Save the pack with the statement as your evidence for the period.

What goes wrong in Xero bank reconciliation, and how do I fix it?

Xero Central says to check the Statement Balance against the bank first (Compare the statement balance). Run the Bank Reconciliation Summary month by month to find when the balances last agreed.

ProblemHow it showsXero's documented fix
Duplicate statement line from a feed plus a manual importStatement Balance higher or lower than the bank; flagged on Statement Exceptions or the Duplicate Statement Lines reportDelete one copy: on the Reconcile tab, Options → Delete statement line, or from Bank Statements, Showing: Statement lines, tick and Delete
Duplicate account transaction, created instead of matchedUnreconciled account transactions you thought were done; Balance in Xero wrongTick the duplicate and click Remove & Redo
Missing statement lineStatement Balance short of the bankImport a statement file for it; use Mark as Reconciled only if it can never be imported
Statement line deleted in errorShown as deleted on Statement ExceptionsFrom Bank Statements, Showing: Statement lines, tick it and Restore
Transaction marked as reconciled, then the real line importedA manual line plus an imported lineDelete the manual statement line
Wrong opening balanceBalances never agreed from the startCheck the conversion balance against the bank's closing balance for the day before your conversion date, under Accounting → Accounting settings → Conversion balances; do not use trial balance amounts
Payment matched to the wrong invoice or billThe right invoice still shows awaiting paymentOpen the reconciled transaction, Options → Unreconcile, then reconcile the line to the correct payment
Line reconciled to spend or receive money instead of the invoiceThe invoice still shows awaiting payment, and income or expense is doubledOpen it, Options → Remove & Redo to delete the cash transaction, then match the line to the invoice or bill
A correction is blockedA padlock icon on the transactionIt is in a locked or closed period; the lock date must be removed or the period opened first

Sources, all Xero Central: deleting or restoring lines, duplicate lines, incorrect reconciliations, mark as reconciled and opening balances.

Changing a locked period is a reviewer's decision. If the period was reported or filed, agree the correction with whoever signed it off.

What should you automate, and what should a person review?

WorkAutomateA person reviews
Repeat card and direct debit linesBank rules, cash coding with rules, JAXNew rules, and a sample of lines each month
Matching payments to invoices and billsXero suggestions, JAX, an AI's proposed matchesPart payments, one payment for several invoices, overpayments
Finding missing and duplicate linesAn AI comparing the statement with XeroWhich copy to delete, and any restore
Bank fees and interestAn AI's proposed entryThe account and tax rate before it is recorded
Transfers between accountsXero's Transfer tabThat the other account shows one transfer, not two
Corrections in reconciled or locked periodsNothingEvery one, with the reviewer of that period
The statement balance checkReport pack figures pulled by an AIThe bank's own closing balance, read from the statement
Sign-offNothingAlways a person

What can an AI do in Xero bank reconciliation?

An AI connected to Xero can read bank accounts, balances and the transactions recorded in Xero, and compare them with a statement you give it. It cannot see statement lines in Xero, and it cannot click OK on the Reconcile tab for you. The prompts use Harbour Cafe Ltd, a fictional company.

Check the starting point (read only)

For Harbour Cafe Ltd, read only: show each bank and card account's opening and closing balance for October 2026, and the count and oldest date of unreconciled transactions in Xero. Do not change anything.

Compare the statement with Xero (read only)

For Harbour Cafe Ltd, read only: compare the October 2026 statement for the business current account in Documents with the transactions recorded in Xero for October 1 to 31. List statement lines with no Xero transaction, Xero transactions with no statement line, and possible duplicates, each with date, amount and reference. Do not change anything.

Prepare a bank fee for approval (prepares for approval)

For Harbour Cafe Ltd: the October 2026 statement shows a £45.00 bank fee on October 31 with no transaction in Xero. Propose a spend money transaction with the date, account, tax rate and reference, and show it to me. Do not record it until I approve.

The £45.00 is an example figure. A spend money transaction is recorded as soon as it is created; it is not a draft. Then match it to the statement line on Xero's Reconcile tab. Creating it again from the Create tab would duplicate it.

What can go wrong, and how do I review the AI's work?

  • Wrong organisation. Check the organisation name in the answer, especially for related companies with similar names.
  • Wrong period or account. Use the statement's dates and the exact account name.
  • An incomplete statement. A missing page creates false "missing" items. Check the page count and balances first.
  • A delayed feed. If Xero has not imported recent lines, compare against the statement, not the feed.
  • Duplicates. Before you approve a new transaction, ask the AI to check it is not already in Xero.
  • A summary that does not match the report. Run the Bank Reconciliation report pack and compare its figures with what the AI said.
  • Invented numbers. Every figure should trace to a statement line, a Xero transaction or a report.
  • Cut-off. A payment dated October 31 may clear in November. Carry it forward as outstanding.

Where DeepLedger fits

DeepLedger connects Xero to Claude, ChatGPT and other MCP clients through one address, https://mcp.deepledger.ai/mcp. See the Xero MCP server guide for how it compares, and the steps to connect Claude to Xero or connect ChatGPT to Xero.

DeepLedger reads Xero bank and card accounts, their balances and the unreconciled transactions recorded in Xero. Xero's API does not expose bank statement lines or the bank feed. Lines not yet imported or recorded in Xero are invisible to the AI, and a person finishes matching in Xero's own Reconcile screen.

When you ask, DeepLedger prepares and proves the reconciliation, entering statement lines only from the statement you provide. It refuses to mark the reconciliation ready until both differences are 0.00, every statement line is matched and nothing is flagged. A fee missing from the books stays flagged until it is recorded with approval. A person signs off. New invoices, bills, credit notes and journals are saved as drafts by default. DeepLedger will not change or delete a spend money, receive money or transfer transaction that is reconciled, it refuses a write dated on or before the organisation's lock date, and deleting anything already approved or posted waits for your confirmation. Every write must name its company, or DeepLedger refuses it and nothing is written.

The same approach works for automated bank reconciliation in QuickBooks, and reconciliation is the first step of month-end close automation.

Frequently asked questions

How does bank reconciliation work in Xero?

Xero imports bank statement lines through a bank feed or a statement file, and you match each line to a transaction in Xero on the Reconcile tab. Where no transaction exists, you create one, such as spend money, receive money or a transfer. The account is reconciled when the Statement Balance in Xero agrees with your bank and with the Balance in Xero.

Does Xero reconcile bank transactions automatically?

Yes, for some organisations. As of November 2026, Xero Central describes automatic bank reconciliation by JAX, which you turn on for each bank account and which reconciles only new statement lines that meet high-confidence criteria. Xero includes it on Standard plans and above, and on Lite and Starter through the AI Automate add-on, and you review its work on the Reconciled transactions screen.

How do I undo a reconciled transaction in Xero?

Open the reconciled transaction, select Options, then Unreconcile to keep the payment and send the statement line back to unreconciled. Use Remove & Redo instead when the transaction itself is wrong, which deletes it. A transaction in a locked period shows a padlock and cannot be removed until the lock date is changed.

Why is my Statement Balance in Xero different from my bank balance?

Xero says either the opening balance is wrong or there is an error in the statement lines. Check for a missing, duplicate or wrongly deleted statement line, or a transaction marked as reconciled by mistake. The Statement Exceptions report in the Bank Reconciliation report pack lists deleted, manual and possible duplicate lines.

Can an AI match statement lines in Xero's Reconcile screen?

No, not through Xero's API. Xero's API does not expose bank statement lines or the bank feed, so an AI connected through DeepLedger reads only the transactions recorded in Xero. You give it the statement, it prepares and proves the reconciliation, and a person finishes matching in Xero's Reconcile screen.

Should I use cash coding if the transaction is already in Xero?

No. Cash coding creates new spend or receive money transactions, so using it for an invoice payment or a transfer already in Xero creates a duplicate. Reconcile those on the Reconcile tab first, then cash code what is left.

See every connection and its status on AI Platforms & Integrations, then ask your AI app to compare last month's statement with one Xero bank account before you reconcile it.

Ready to get started?

Connect QuickBooks and try your first task with an AI agent.

Create an Account

With your permission, Google Analytics measures visits to our public website and blog. Essential cookies work either way. Change your choice in Cookie settings. Privacy policy