convertbank.onlineOpen Converter →
tool · xero

PDF to Xero CSV converter

Turn any bank statement PDF into the exact CSV format Xero accepts. Strict column order, locale-aware dates, MTD-friendly — and your file never leaves your device.

Open the converter QuickBooks vs Xero — full comparison
GDPR / MTD-safe
PDF parsed locally. Xero never sees the conversion step.
Strict column order
Date, Amount, Payee, Description, Reference, Cheque Number — exactly what Xero expects.
Locale-aware
UK / AU / NZ get DD/MM/YYYY. US gets MM/DD/YYYY. No manual fixing.

The 3-step PDF → Xero workflow

  1. 01
    Export the monthly statement PDF from your bank's online portal — every major UK, AU, NZ, US, and Canadian bank works.
  2. 02
    Drop the PDF into convertbank.online/converter and pick the Xero CSV export option. The file downloads in the exact column order Xero requires.
  3. 03
    In Xero: Accounting → Bank accounts → pick account → Manage account → Import a Statement → upload the CSV. Xero will preview and import.

The exact CSV format Xero accepts

Date,Amount,Payee,Description,Reference,Cheque Number
03/06/2026,-87.42,Whole Foods,Groceries,,
03/06/2026,2410.00,Stripe,Stripe payout,STP-202606,
04/06/2026,-312.55,AWS,EC2 + S3 invoice,INV-9981,

The six columns must appear in this exact order. Empty fields are fine — leave Reference or Cheque Number blank when the bank doesn't provide one. Xero auto-detects the header row.

Why Xero over QuickBooks for bank reconciliation

Bank Rules engine
Auto-categorise on payee, amount, description, OR any combination. Faster and more powerful than QuickBooks' built-in matching.
No transaction cap
Upload 5,000 transactions in one CSV. QuickBooks Online caps each upload at 1,000.
Multi-currency that works
Each bank account in its own currency, FX gains/losses calculated automatically. QuickBooks' multi-currency is per-transaction and clunkier.
MTD-native
Built for HMRC Making Tax Digital from day one. Native VAT returns, CIS, and payroll on the UK plan.
Read the full QuickBooks vs Xero comparison

Xero import — common gotchas

Wrong column order
Xero is strict. Date must be column 1, Amount column 2. The converter handles this — manual CSVs from Excel often don't.
Date format mismatch
UK / AU / NZ tenants want DD/MM/YYYY. US tenants want MM/DD/YYYY. Pick the right locale in the converter.
Sign convention
Xero uses signed Amount (negatives for money out). The converter exports this shape by default.
Duplicate transactions
Xero deduplicates on date + amount + reference. Use the merger tool to dedupe across overlapping CSVs before import.

FAQ

What CSV format does Xero need?+

Xero accepts CSV with this column order: Date, Amount, Payee, Description, Reference, Cheque Number. The order is strict — Xero rejects files with the wrong column sequence. The converter emits exactly this shape when you pick the Xero option.

Does this work for MTD (Making Tax Digital) in the UK?+

Yes. The converter runs entirely in your browser, so your statement never leaves your device — which keeps your MTD-bridging workflow GDPR-safe. The exported CSV is in the shape Xero VAT returns accept.

Can I import multi-currency Xero accounts?+

Yes. Xero's multi-currency feature (Premium plan) accepts CSV in the same format per currency account. Run each currency statement through the converter separately and import to the matching Xero bank account.

How do I import the CSV into Xero?+

In Xero go to Accounting → Bank accounts → pick the account → Manage account → Import a Statement. Upload the CSV, confirm the column mapping (it should auto-detect), and Xero will preview the transactions before final import.

Will it handle Xero's date format quirks?+

Yes. Xero is strict about DD/MM/YYYY in UK/AU/NZ tenants and MM/DD/YYYY in U.S. tenants. The converter detects your locale on export and matches Xero's expected format.

Convert your first PDF for Xero

Free, private, no signup. Strict Xero CSV on the other side.

Open the converter