How to find unreconciled transactions in Xero

Xero already has several places that list what is not yet reconciled. Start there. They are built for exactly this.

1. The Reconcile screen

Go to Accounting > Bank accounts and open the account. The Reconcile tab lists the bank statement lines that still need to be matched or coded. Anything still in that list is unreconciled.

2. The Status column on bank statements

On the account's Bank statements screen, each statement line has a Status: Unreconciled, Reconciled or Deleted. Filter by that status and by date to see the lines that are still open.

3. Export the unreconciled statement lines

Xero administrators can export a list of statement lines that have not been reconciled, as PDF or CSV, filtered by bank account and date. Use this when you need the list outside Xero, for example to send to a client.

4. The Bank Reconciliation reports

Run Bank Reconciliation Summary for a date. When transactions and reconciliation are up to date on that date, the balance in Xero, the statement balance and the balance in your online banking should be the same. Xero also points to this report for finding duplicate statement lines. Bank Reconciliation Detail lets you enter your real opening and closing statement balances to compare them with Xero's.

5. Duplicate transactions in the ledger

Run the Account Transactions report for the bank account over the period. Two entries with the same date, amount and payee are the usual sign of a double entry.

6. A line was matched wrongly

Xero lets you undo the reconciliation of a line or use Remove and Redo, depending on the situation. The Xero Central article below explains which one to use.

Sources

Checked against the vendor's own help pages on 6 November 2026. Menu names and report layouts change between plans, regions and releases, so confirm them on your screen.

• Xero Central: Bank Reconciliation reports
• Xero Central: Bank Reconciliation Detail report
• Xero Central: Export a list of uncoded bank statement lines
• Xero Central: View bank statements and bank statement lines
• Xero Central: Fix an incorrectly reconciled bank statement line
• Xero Central: Reconcile your bank account