Overview: PDF in, reconciled in Xero
Xero's live bank feeds are excellent going forward, but they don't help with historical months, closed accounts, or banks that have no feed. For those, you import the statement manually — and the bridge from your bank's PDF is to convert the bank statement to Xero's CSV layout and upload it. Once imported, the lines appear on the Reconcile tab ready to match.
This guide covers Xero's exact column layout, the conversion step, the upload, reconciliation, and how to do a whole year at once. If your platform is QuickBooks instead, see how to import bank statements into QuickBooks.
Xero's CSV layout
Xero's manual statement import expects a precise set of columns. Here's the layout and what each one holds — FlowParse outputs exactly this so the mapping step is a formality.
| Column | Example | Notes |
|---|---|---|
| Date | 14/05/2026 | Match your Xero region's date format |
| Amount | -42.50 | Single signed column; money out negative |
| Payee | Tesco | Who the transaction was with |
| Description | Card payment | Free-text memo from the statement |
| Reference | POS 4471 | Optional bank reference / cheque no. |
The single signed Amount column is the key difference from a raw bank CSV that splits debits and credits — FlowParse normalises both into one signed value. For the underlying mechanics see bank statement to CSV and structured field extraction.
Before you start
- Your PDF bank statement(s) — digital or scanned, any bank.
- Access to your Xero organisation and the bank account set up in it.
- Knowing your Xero region's date format (DD/MM/YYYY vs MM/DD/YYYY).
Nothing to install, no per-bank template. Start from the bank statement to Xero page or the bank statement converter hub.
Step 1 — Convert the PDF to Xero CSV
Upload the PDF
Open the converter and drop your statement. Digital and scanned PDFs both work, and multi-page statements are handled automatically.
Let the AI extract transactions
FlowParse reads every transaction, normalises debits and credits into one signed Amount, and validates the running balance.
Review the preview
Check the editable preview. The validation report flags low-confidence fields, duplicates and balance breaks so you can fix them before export.
Export the Xero CSV
Choose the Xero CSV layout (Date, Amount, Payee, Description, Reference) and the right date format, then download.
Step 2 — Import into Xero
- 1Go to Accounting → Bank accounts and open the account the statement belongs to.
- 2Click Manage account → Import a statement.
- 3Upload your CSV and continue.
- 4Confirm Xero's column mapping for Date, Amount, Payee, Description and Reference.
- 5Click Import — the statement lines are added to the account.
Step 3 — Reconcile in Xero
Once imported, the lines show on the account's Reconciletab. Xero suggests matches to existing bills and invoices, and your bank rules auto-categorise the rest; you confirm each match. Because the converted amounts and balances are validated up front, your reconciled total ties out to the statement's closing balance. For the wider workflow see bank reconciliation software.
Avoiding duplicates
Xero warns when it detects statement lines it has already imported, but the safest habit is to import non-overlapping date ranges — one clean month or quarter at a time. FlowParse also runs duplicate detectionbefore export, so repeated rows inside the file itself are flagged before they ever reach Xero. If you're combining several statements, let Smart Merge de-duplicate the overlap for you.
Worked examples
| Scenario | What to do |
|---|---|
| One historical month | Convert to Xero CSV, Import a statement, map, reconcile. |
| A full year of catch-up | Upload all 12 PDFs, consolidate with Smart Merge, export one CSV per account. |
| A closed account with no feed | Convert the final statements and import them to complete the history. |
| Multiple bank accounts | Convert each account separately and import under its matching Xero account. |
| Scanned statements | Upload as-is; OCR runs first, then verify flagged fields before export. |
Doing a year? Read consolidate a year in minutes or batch it with the batch bank statement converter.
Common mistakes
- Trying to upload the PDF straight to Xero — it only imports CSV/OFX/QIF.
- Using a date format that doesn't match your Xero region, causing a mapping warning or wrong dates.
- Leaving debits and credits in two columns when Xero wants one signed Amount.
- Importing overlapping date ranges and creating duplicate statement lines.
- Skipping the balance check, so a missing transaction breaks reconciliation later.
- Importing into the wrong Xero bank account.
Best practices
- Export the CSV in your Xero region's date format and with a single signed Amount column.
- Keep one CSV per bank account so each imports under the right account.
- Validate balances on every file before importing.
- Import non-overlapping ranges to avoid duplicate statement lines.
- For catch-up, consolidate a year first, then export — fewer files, fewer errors.
- Review the editable preview and resolve flagged fields before download.
Get your statement into Xero now
Upload a PDF, export a Xero-ready CSV, and import it for reconciliation in a couple of clicks — balance-validated, any bank.