April 17, 2026 · 6 min read

Import a PDF Bank Statement into Xero (the right way)

Why Xero prefers CSV over QBO, the exact column mapping Xero expects, and how to avoid the most common reconciliation pitfalls.

Xero handles bank imports differently from QuickBooks. While QuickBooks prefers QBO/OFX with stable transaction IDs, Xero leans on CSV — and is fairly strict about the column names. Get the format right and the rest is automatic.

The format Xero expects

Xero's manual statement import (Accounting → Bank accounts → Manage account → Import a statement) accepts a CSV with these columns:

  • Date — DD/MM/YYYY for AU/UK/NZ Xero, MM/DD/YYYY for US
  • Amount — single signed column (negative = withdrawal)
  • Payee — counterparty / merchant
  • Description — memo line
  • Reference *(optional)* — your own ID
  • Cheque Number *(optional)*

Two amount columns (Debit/Credit) won't work — Xero needs a single signed amount.

How to produce the right file

Our PDF to Xero CSV converter emits the exact column schema above — *Date in DD/MM/YYYY, signed *Amount, Payee auto-extracted, Description, Reference. Drag-drop the PDF, download the CSV, upload to Xero. Done. (For the universal CSV that works in QuickBooks/Wave/FreshBooks too, use PDF to CSV.)

Common Xero import errors

  • "Date format not recognised." Your Xero org is in DD/MM/YYYY but the CSV is in US format. Switch the locale in the converter dropdown before exporting.
  • "Amount must be a number." The CSV has thousands separators (1,234.56) inside an unquoted field. Our CSV is RFC 4180-compliant — fields with commas are quoted — so this should never trip you up.
  • "Statement already imported." Xero dedupes on date + amount + description. If you re-upload an overlapping period, Xero usually catches duplicates — but doesn't always. For airtight deduping, switch to QuickBooks' QBO format — Xero is the wrong tool here if dedupe is critical.

Bank feeds vs. manual import

If your bank supports a Xero direct feed, prefer that over manual CSV uploads. CSV import is for:

  • Banks without a Xero feed
  • Historical periods before the feed was connected
  • Recovering a missing day or week

See also

Try it on your own statement

Convert a PDF to Excel free — no sign-up required.

Convert a PDF →