Export format
Bank statement to Xero converter
Date / Amount / Payee / Description / Reference columns matching Xero's bank statement import template. Any bank, digital or scanned PDF, with the running balance reconciled before you import anything.
What's in the Xero file
- Columns: *Date (DD/MM/YYYY), *Amount, Payee, Description, Reference — Xero's own template order.
- Import it in Xero: Bank account → Manage account → Import a statement.
- Amounts are signed: negative = spent, positive = received.
Other formats: Excel · CSV · QuickBooks
The extracted data
| A · Date | B · Description | C · Debit | D · Credit | E · Balance | |
|---|---|---|---|---|---|
| 1 | 2026-08-02 | CARD PURCHASE 08/01 STARBUCKS #2231 NEW YORK NY | 6.85 | 4,805.55 | |
| 2 | 2026-08-03 | ACH DEBIT CON EDISON UTILITY PAYMENT | 142.19 | 4,663.36 | |
| 3 | 2026-08-04 | ZELLE PAYMENT FROM J. MARTINEZ | 350.00 | 5,013.36 | |
| 4 | 2026-08-08 | DIRECT DEPOSIT ACME CORP PAYROLL | 3,240.00 | 7,664.94 | |
| 5 | 2026-08-12 | CHECK #1042Verify — read from image | 130.00 | 7,534.94 |