How to import a bank statement into Xero
To import a bank statement into Xero, first turn the PDF into a CSV with Date, Amount, and Description (or Payee) columns. Then import it against the right Xero bank account.
Fictional sample output
Preview the CSV before importing into Xero
Statently turns separate withdrawals and deposits into one signed Amount column, cleans descriptions, and adds a category. This preview uses a fictional statement.
| Date | Description | Amount | Category |
|---|---|---|---|
| 2026-06-03 | Northwind Payroll | +3,450.00 | Income |
| 2026-06-04 | Harbor Market | -84.21 | Groceries |
| 2026-06-06 | City Utilities | -126.40 | Utilities |
| 2026-06-08 | Cloudwork | -18.00 | Software |
Private by design. Your uploaded PDF is processed in memory to create the CSV and is not stored.
Always review before importing. Compare totals and a sample of transactions with the original statement before reconciliation, tax filing, or accounting import.
How to import a statement into Xero
- 1. Convert the statement. Upload the statement PDF and download the CSV.
- 2. Go to the bank account. In Xero: Accounting → Bank accounts → your account → Manage → Import a Statement.
- 3. Map & import. Match Date, Amount, and Description to the CSV columns and import.
Frequently asked questions
- What CSV format does Xero need?
- Xero needs a Date column, an Amount column (signed), and a Description or Payee column. The converter outputs exactly these.
Export to other tools
Convert a statement from your bank
Related guides
- How to Import Bank Statements into Xero
How to get transactions from a PDF bank statement into Xero using a CSV — the exact column format Xero expects and how to prepare it in seconds.
- How to Convert a Bank Statement PDF to CSV
The fastest way to turn a bank statement PDF into a clean CSV — what a CSV needs to contain, why manual methods break, and how to do it in seconds.
- How to Convert a Scanned Bank Statement to CSV
Scanned or photographed bank statements have no selectable text, so most converters choke on them. Here's how to turn an image-only PDF into a clean CSV.
- How to Import Bank Statements into QuickBooks
How to get transactions from a PDF bank statement into QuickBooks Online using a CSV — the format QuickBooks expects, and how to prepare it in seconds.