PDF bank statements and Xero

Xero Won't Import Your PDF Bank Statement. What Now?

Last checked against Xero's documentation: 12 September 2026

Short answer

Short answer

You cannot upload a PDF bank statement through Xero's standard manual bank-statement import workflow. Xero accepts OFX, QFX, QIF, CSV and QuickBooks formats and tells customers with PDF-only statements to use a third-party conversion service. Convert the PDF to CSV first, check the resulting transactions, then import that CSV into the correct Xero bank account.

This is common when the bank no longer offers a transaction export for the period you need, the account has closed, or a client has sent statements rather than an online-banking export.

Why a PDF-to-CSV step is needed

A PDF is designed to preserve the visual statement a person reads. Xero's standard import workflow needs structured transaction fields instead: dates, descriptions and amounts in a supported data file.

Xero recommends OFX when it is available because it can be imported without editing. If the transactions only exist as PDF, conversion fills the gap between the financial record you have and the structured file Xero can ingest. AussieBankStatements is one independent conversion service built for Australian bank layouts; it is not affiliated with or endorsed by Xero.

The safe workflow

  1. 01

    Get the original PDF

    Download the statement directly from your Australian bank rather than using a scan or screenshot.

  2. 02

    Convert it to CSV

    Choose the matching bank parser and convert the PDF into structured transaction rows.

  3. 03

    Verify the statement

    Check the account, date range, opening and closing balances, and spot-check debits and credits.

  4. 04

    Import into Xero

    Open the correct bank account in Xero, choose Import a Statement, upload the CSV and map its columns.

  5. 05

    Review before completing

    Exclude duplicates or unwanted rows, complete the import, then reconcile in Xero.

The Xero actions above follow Xero's published CSV statement import instructions, including column mapping, date-format confirmation and transaction review.

Checks before you complete the import

  • The CSV belongs to the same account and currency as the Xero bank account.
  • Dates cover the missing period without overlapping an existing bank feed or prior import.
  • Money-out and money-in values have not been reversed.
  • Opening balance, closing balance and transaction movement reconcile where the statement provides them.

What Xero itself documents

Xero's manual-import guide says the standard workflow accepts OFX, QFX, QIF, CSV and QuickBooks formats, recommends OFX where available, and directs people with PDF-only statements towards a third-party conversion service.

Xero also documents manual imports for missing lines and transactions from before a feed starts. Its troubleshooting guide says CSV imports can fail because of invalid dates, spaces, blank lines, corrupt files or incorrectly prepared data. That is another reason to review the file before treating an import as finished.

Frequently asked questions

Can Xero convert a PDF bank statement to CSV?

Not through Xero's standard manual statement-import workflow. Xero's help page says PDF statements cannot be imported and points people with PDF-only statements towards a third-party conversion service.

Which file format should I use for Xero?

Use OFX when your bank supplies it, because Xero recommends that format. When PDF is the only usable source, convert it to a clean CSV and check it before importing.

Does AussieBankStatements connect to my Xero account?

No. It prepares the CSV before Xero. You remain in control of the file, the destination account, the import and the reconciliation.

Should I import a PDF conversion without checking it?

No. Financial imports should be checked against the original statement, especially the account, date range, balances and debit or credit direction.

Related Xero guides