Bank statements to Xero, verified to the cent
A pre-mapped CSV that Xero accepts directly in Bank accounts → Import a statement, with dates, amounts and payee columns already in the order Xero expects.
Before any file leaves Parseledger, the extracted figures must reconcile against the statement's own balances — opening + credits − debits = closing, checked line by line. What you import into Xero is provably consistent with the paper.
| Date | Description | Amount | Balance |
|---|---|---|---|
| Opening balance | |||
| 06-012026-06-01 | Acme Consulting Ltd — invoice 0142 | ||
| 06-032026-06-03 | HMRC VAT | ||
| 06-052026-06-05 | WeWork — office | ||
| 06-092026-06-09 | Tesco | ||
| 06-122026-06-12 | Stripe payout | ||
| 06-162026-06-16 | Salary — J. Doe | ||
| 06-202026-06-20 | Adobe Creative Cloud | ||
| 06-242026-06-24 | Client refund — invoice 0139 | ||
| 06-272026-06-27 | Bolt & Sons — invoice 0143 | ||
| 06-302026-06-30 | Bank charges | ||
| Closing balance | |||
This is the check every statement goes through. Try fixing the flagged row — the amount was misread as 68.44; the statement says 64.88.
Live demo — this is the real verification engine. Click the flagged amount and fix it.
Importing the file into Xero
- 01
In Xero, open Accounting → Bank accounts and select the bank account the statement belongs to.
- 02
Choose Import a statement (or Manage account → Import a statement).
- 03
Upload the CSV Parseledger produced. The columns — date, amount, payee, description — are already in the order Xero expects, so the field mapping step is a confirmation, not a puzzle.
- 04
Review the imported statement lines and reconcile as usual. Because the file was verified before export, the imported total matches the statement closing balance to the penny.