Bank reconciliation Xero exports, matched outside the bank feed
Xero reconciles against its own bank feed. For a PDF statement, a missing feed, a catch up on old months or a reviewer who wants a full report, export the account from Xero and reconcile it here.
Xero export
Account Transactions
138 rows
- Date Date
- Source Type
- Description Description
- Reference Invoice or bill number
- Debit Money in
- Credit Money out
Columns detected
Ready to match
When a Xero bank reconciliation needs a second tool
- The feed stopped, duplicated lines or skipped a period
- Statement lines were imported by hand and some were deleted
- The Xero balance and the statement balance disagree and you cannot see why
- You need a reconciliation report per month for an audit or a lender
Export from Xero
- Go to Accounting, Reports and open Account Transactions.
- Select the bank account and the date range of the statement.
- Update the report and export it to Excel or CSV.
- Upload the file as Your books, next to the bank statement.
What you get back
- Statement lines with no Xero entry, ready to create as spend or receive money
- Xero entries the bank never saw, such as outstanding payments and deposits in transit
- Duplicates created by feed glitches or double imports
- The adjusted balances and a report in PDF and XLSX
Xero questions
Does BankReconciler connect to my Xero organisation?
No. You upload an export, and nothing is written back to Xero.
Can I find the cause of a Xero statement balance difference?
Yes. Reconcile the statement against the Account Transactions export and every line behind the difference is listed, including duplicates from the feed.
Reconcile your Xero account now
Upload the statement and the Account Transactions export.