How Xero reads this file
Xero imports statement lines into a bank account, then lets you reconcile them against bills, invoices, and spend money transactions.
Use a signed Amount column and keep descriptions clear enough for matching rules.
CSV template
Download a Xero bank statement CSV template with Date, Amount, Description, and Reference columns.
| Date | Amount | Description | Reference |
|---|---|---|---|
| 2026-06-02 | 4200.00 | Direct Deposit ACME Payroll | PAYROLL-JUN |
| 2026-06-04 | -86.43 | Office Depot | CARD-4821 |
| 2026-06-07 | 912.18 | Stripe Payout | STRIPE-8821 |
Xero imports statement lines into a bank account, then lets you reconcile them against bills, invoices, and spend money transactions.
Use a signed Amount column and keep descriptions clear enough for matching rules.
No. Xero imports CSV, OFX, and QIF. Convert a statement PDF before upload.
No, but it helps when the source statement has transaction IDs, check numbers, or bank references.
Upload the original PDF, statement, or accounting file and create your own export.