The Bank Reconciliation check gives you an overview of the reconciliation status across all of a client's Xero bank accounts. It shows unreconciled transactions, outstanding payments, and outstanding receipts, and lets you jump directly into Xero to action them from there.
To access it, go to a client's account and select Data Health in the left navigation, then select Bank reconciliation.
Important: This check is available for Xero clients only. For QuickBooks Online clients, see Unreconciled Transactions.
Who can use this check
The Bank Reconciliation check is available to practices with the Data Health & Insights add-on, on Practice Essentials and Practice Advanced plans.
The Summary tab
The Summary tab gives you a snapshot of the client's overall bank reconciliation position at a selected reporting date. It covers four areas: Financial position, Bank status, Reconciliation status, and Bank accounts.
Financial position
The Financial position section shows two figures for the client:
Net Assets - a calculated balance of all transactions with an Account Class of Asset minus all transactions with an Account Class of Liability, up to the reporting date. This figure is also available as a metric in the Practice insight.
Cash Position - the consolidated statement balance across all bank accounts at the reporting date. This figure is also available in the Practice insight. Where the client has foreign currency accounts, balances are converted to the base currency - use it as a guideline only.
Bank status
The Bank status section shows:
No. of Manual Feeds - the number of bank accounts updated with manual feeds rather than a live bank connection. Accounts with manual feeds show a broken chain indicator next to their name in the Bank accounts section below. Accounts with an active feed show a linked chain indicator.
Last Statement Activity - the date of the most recent activity recorded across the client's bank accounts.
Reconciliation status
The Reconciliation status section shows totals across all bank accounts:
Unreconciled Transactions - the total number of unreconciled bank statement lines, with the date of the oldest unreconciled transaction.
Outstanding Payments - transactions created in Xero that haven't yet been matched to a bank statement line.
Outstanding Receipts - receipts created in Xero that haven't yet been matched to a bank statement line.
The Unreconciled Impact section below shows the difference between the Statement Balance and the Xero Balance. Select it to see the breakdown by bank account.
Bank accounts
Each bank account appears as its own card. Select a card to expand it and see three categories:
Plus Outstanding Payments
Less Outstanding Receipts
Plus Unreconciled Statement Lines
Each category shows a pass or fail status. Expanding a category shows transaction-level detail, where you can sort by oldest records and filter by locked period. Select any transaction to open it directly in Xero.
At the bottom of each card, Dext shows the Calculated Balance and the Xero Statements Balance. These should match when the account is fully reconciled.
The All statements tab
The All statements tab shows all bank statement lines for the client across all accounts - both reconciled and unreconciled. You can use it to search for a specific transaction across all bank accounts, which isn't possible directly in Xero.
The Statement Range at the top of the tab sets the date window for the data shown. The grid supports filtering, sorting, grouping, and exporting. To group transactions by bank account, drag the Bank Account column to the grouping area. To split reconciled from unreconciled transactions, drag the Reconciled column into the grouping area alongside it.
Foreign currency bank accounts
Dext detects when a bank account is in a different currency from the client's base currency. For these accounts, a toggle lets you view reconciliation totals in either the account's native currency or the base currency.
Note: Dext doesn't have access to Xero's exchange rates, so base currency figures for foreign currency accounts may not match Xero exactly. Use them as a guideline only.
How Dext calculates unreconciled transactions
Dext uses the reconciled status field in Xero's bank statement data to determine whether each transaction is unreconciled.
On the first sync for a client, Dext retrieves all available bank statement data.
On subsequent syncs, Dext retrieves only the 12 months of data before the sync date.
Important: If bank statement data older than 12 months is changed in Xero, Dext won't automatically reflect that change. To include changes older than 12 months, contact Dext support to request a full data rebuild for the client.
Syncing and recalculating data
To update the Bank Reconciliation check, use the two buttons at the top of the page:
Sync - pulls any new data or changes from Xero into Dext.
Recalculate - recalculates the check based on the latest data pulled from Xero into Dext.
If you've made changes in Xero, select Sync first, then Recalculate to see the updated