Convert a PDF bank statement to CSV for Xero

Quick answer

Xero imports bank activity from a CSV with Date, Amount, and Payee/Description columns (a Reference column is optional). When a bank has no direct feed, QuickBankConvert reads your PDF statement in the browser and exports exactly those columns — so you can go to the bank account in Xero, choose Manage Account → Import a Statement, upload the file, and map the columns. CSV export is free with no account, and the PDF is parsed locally, so your client data never leaves your device.

When you need a CSV import in Xero

Xero is happiest when a direct bank feed streams transactions in automatically. But feeds aren't always available, and that's when a manual CSV import is the right tool:

• The bank or card issuer isn't supported by a Xero feed in your region
• A new feed has a gap before it goes live and you need to backfill history
• You're onboarding a client and importing months of prior activity
• A feed broke or duplicated lines and you're re-importing a clean period
• You're working from a savings, loan, or merchant account that never feeds

In all of these cases you already have the data — it's sitting in the PDF statements your bank produces. The problem is that a PDF isn't a spreadsheet. You need to turn those statement lines into a CSV Xero can read, without retyping every transaction.

The columns Xero expects

Xero's statement import is flexible about column order and headings — you map them during import — but every row needs a date and an amount, and a description makes reconciliation far easier. A clean file looks like this:

A few details matter. Xero accepts a single signed Amount column (negatives for spend) — you don't need separate debit and credit columns, though Xero can map those too if your file has them. Keep the header row simple and avoid blank rows, running balances, or summary boxes mixed into the transaction lines; those confuse the importer. QuickBankConvert exports a tidy, single-amount layout by default, which maps cleanly onto Xero's fields.

How to import a PDF statement into Xero

1. Download the PDF. Sign in to online banking and download the statement period you need as a PDF.
2. Convert it to CSV. Drag the PDF onto the converter. Parsing happens in your browser. Review the Date, Description, and Amount columns in the preview, fix the rare misread inline, and export CSV (free, no account).
3. Import into Xero. In Xero, go to Accounting → Bank accounts, open the relevant account, then click Manage Account → Import a Statement.
4. Upload and map columns. Choose your CSV, then tell Xero which column is the date, which is the amount, and which is the payee/description. Confirm the date format, and import.
5. Reconcile. Xero drops the imported lines into the account, ready to match against bills, invoices, and existing transactions.

That's the whole loop: PDF in, CSV out, import and reconcile — no manual data entry and no fragile copy-paste from a PDF viewer.

Date-format tips

Dates are the most common reason a Xero import stalls, so get them right before you upload:

• Be consistent. Every row in the file should use the same date format. A mixed file (some 01/02/2026, some 2026-02-01) will fail or import wrong.
• Watch day-vs-month order. 03/04/2026 is March 4 in the US and April 3 in the UK/AU/NZ. Xero asks you to confirm the format on import — pick the one that matches your file and your organisation's region.
• Prefer an unambiguous format when you can. DD/MM/YYYY or YYYY-MM-DD leaves the least room for error.
• Use the four-digit year so Xero doesn't have to guess the century.

QuickBankConvert keeps the statement's dates in a single consistent column, so you confirm the format once during the Xero mapping step.

Is it private?

Yes. QuickBankConvert parses your statement in the browser — the PDF is not uploaded to our servers for conversion, which matters when you're handling client bank data under an engagement. You never link a bank login or share credentials; you simply download the statement yourself and convert it. See the Privacy Policy for how analytics and account data are handled, and the FAQ for more on the in-browser model.

Free vs paid

• CSV export is free with no account — and a generic CSV is all you need for Xero's statement import on any plan.
• Excel (.xlsx) export is free once you create an account, handy if you want to clean or pivot the data before importing.
• Plus ($29/mo) and Pro ($49/mo) add more export formats — TSV, JSON, QBO, and QIF — and raise the limits: roughly 10 pages per statement on Free, 50 on Plus, and 100 on Pro, with batch processing for whole folders of statements on Pro.
• A dedicated Xero export format is a Pro feature, but you don't need it for the manual import described here — the free CSV maps onto Xero's Date, Amount, and Description fields just fine.

See pricing for current limits and the full formats list.

Related guides

• PDF bank statement to CSV
• QuickBooks integration
• Browse all supported banks
• All export formats