How to Import a PDF Bank Statement into Xero (CSV or OFX)

Xero is built around bank feeds. Transactions flow in automatically and you reconcile them in the Reconcile tab. But feeds don’t cover everything. A new client may need last year’s books caught up, a feed may have dropped for a few weeks, or a bank or card may not connect at all. In those cases you import the bank statement into Xero manually, and since most banks hand out statements as PDFs, that means converting the PDF first.

This guide covers the formats Xero accepts, how to build a clean Xero CSV, the import steps, and the errors that most often get in the way.

What Xero accepts

Xero doesn’t read PDFs. Its statement import works with transaction files. CSV and OFX are the common ones, and in most regions Xero also lists QIF and QFX. The two you’ll most likely use:

Xero CSV OFX
Column mapping on import Yes No
Easy to edit in a spreadsheet first Yes Not really
Carries payee, description and reference separately Yes Partly, depends on the file
Best for Reviewing and tidying data before import Quick imports with no mapping

If you want to correct payee names, delete personal transactions or split a long statement before it reaches Xero, use CSV. If the data is already right and you just want it in, OFX is faster.

The Xero CSV format

Xero’s statement template uses one row per transaction. Date and Amount are required. The template also has optional columns for Payee, Description, Reference and Cheque/Check Number.

Date,Amount,Payee,Description,Reference
02/03/2026,2450.00,ACME Ltd,Invoice 1043 payment,INV-1043
04/03/2026,-118.42,City Energy Co,Direct debit,DD
05/03/2026,-63.19,High Street Stationers,Card purchase,

Three rules matter most:

  1. One signed Amount column. Money received is positive and money spent is negative. If your statement has separate Paid In and Paid Out columns, merge them into one: paid-in as positive, paid-out as negative.
  2. Dates in your organisation’s format. Xero interprets dates according to your organisation’s regional settings. A UK, Australian or New Zealand organisation expects DD/MM/YYYY. A US organisation expects MM/DD/YYYY. Some versions of the import screen let you confirm the format. Others simply read dates by region, so match it in the file and you’re safe either way.
  3. Plain numbers only. 1250.00, not £1,250.00 or 1,250.00 CR.

Payee is worth filling in. Xero’s bank rules and match suggestions lean on it, so a clean payee column saves time at every future reconciliation.

Step 1: Download the right PDF

Download the statement from online banking as a PDF. Don’t print the web page to PDF. Original statements contain selectable text, which converts accurately. Each bank lays out its statements differently. Some UK statements show the date only once per day, for example, and card statements often carry both a transaction date and a posting date. Our bank pages cover the details for each bank:

If the PDF is a scan or a phone photo, OCR is needed. See scanned bank statements.

Step 2: Convert the PDF to Xero CSV or OFX

You can do it manually. Copy the transactions into Excel, merge the paid-in and paid-out columns into a signed amount with a formula like =C2-D2, delete the balance column and any summary rows, and save as CSV UTF-8. For one short statement that’s fine. For a year of statements it is slow and error-prone. Our guide to converting a PDF bank statement to Excel compares the manual methods.

A converter does the restructuring for you. With pdf2statement.com, the PDF is processed in your browser and never uploaded. That’s useful when the statements belong to clients. The workflow:

  1. Drop in one or more PDFs. Batch conversion can merge them into one file or keep one sheet per statement.
  2. Check the preview. Every row is reconciled against the statement’s running balance, and the opening and closing balances are checked too. Rows that don’t tie out are highlighted, so you can fix them before export.
  3. Choose DD/MM/YYYY or MM/DD/YYYY to match your Xero organisation.
  4. Export as Xero CSV (laid out for Xero’s statement import, with signed amounts) or as OFX.

More on each format: bank statement to Xero, bank statement to OFX, and the general-purpose bank statement to CSV.

Step 3: Import the statement into Xero

Xero updates its navigation from time to time, so labels may differ slightly.

  1. Go to Accounting > Bank accounts.
  2. Find the bank account the statement belongs to. Make sure it’s the right account and currency. Open its Manage Account menu and choose Import a Statement.
  3. Browse to your CSV or OFX file and start the import.
  4. For CSV files, assign each column to a Xero field: Date to Date, Amount to Amount, and so on. Tell Xero whether the first row is a header so it doesn’t try to import your column names. Leave any extra columns unassigned.
  5. Review the summary Xero shows (number of lines, date range) and complete the import.
  6. Go to the account’s Reconcile tab. Your statement lines are now waiting to be matched or coded, exactly like feed transactions.

Step 4: Check the balances

On the bank accounts screen, Xero shows two figures for each account: the statement balance (built from imported and feed lines) and the balance in Xero (from reconciled transactions). After importing, compare the statement balance with the closing balance on your PDF.

If they differ, the cause is almost always one of three things. Lines are missing, lines were imported twice, or the account’s opening balance was never set correctly. Our guide to reconciling a bank statement in Excel shows how to locate the exact row with a running-balance check.

Common import errors and fixes

Dates rejected or days and months swapped. The file’s format doesn’t match your organisation’s region. Re-export in the correct format. Then check the dates in a text editor, not Excel, which reformats dates when it displays them.

Amounts missing or zero. Currency symbols, thousands separators, trailing “CR”/“DR” text, or negatives written in parentheses. Convert everything to plain signed numbers.

Everything imported as money in. You imported a two-column Paid In / Paid Out file and only mapped one column, or the paid-out amounts weren’t negative. Merge into one signed Amount column.

Header or summary rows imported as transactions. Delete account details, statement summaries and totals rows from the file. Keep only the header row and the transactions.

Blank lines or “invalid file”. Remove empty rows, especially at the end of the file. Save as CSV UTF-8 so accented payee names survive.

Duplicate statement lines. You imported a period that was already in Xero, from an earlier import or from the bank feed. Check the account’s latest statement date before importing, and trim overlapping days when combining statements.

Wrong file or wrong account. Xero lets you remove an imported statement from the account’s statement history. Look for the bank statements view under the account’s menu and delete the imported statement. Then re-import into the right account. Lines you’ve already reconciled may need to be unreconciled first.

Bank feeds vs manual import

Manual import complements feeds. It doesn’t replace them. Use it for:

  • Historic periods before the feed’s start date, typically when onboarding a new client mid-year.
  • Gaps when a feed connection lapsed and the bank won’t resend old transactions.
  • Banks and cards without a feed in your region.
  • Multi-currency accounts, such as Revolut or Wise, where each currency gets its own Xero bank account and its own import.

Once the feed is live and caught up, stop importing for that account, or you’ll double up.

If you also use QuickBooks

Accountants with mixed client lists often need both. The QuickBooks process uses a different CSV layout and its own Web Connect format. See how to import a bank statement into QuickBooks.

Summary

To import a bank statement into Xero: convert the PDF into a Xero CSV (Date, Amount, Payee, Description, Reference, signed amounts, your region’s date format) or an OFX file. Import it via the bank account’s Manage Account menu. Map the columns. Then reconcile the lines in the Reconcile tab. Check for overlap with earlier imports or feeds before you import, and compare Xero’s statement balance with the PDF’s closing balance afterwards. Those two checks catch almost every problem. A converter that reconciles each row against the running balance, like the free in-browser one at pdf2statement.com, means the numbers going into Xero already tie out.

FAQ

Frequently asked questions

Can Xero import a PDF bank statement?

No. Xero's statement import reads transaction files such as CSV and OFX, not PDFs. Convert the PDF into a Xero CSV or an OFX file first, then import that file into the matching bank account in Xero.

What columns does a Xero bank statement CSV need?

Date and Amount are required. Xero's template also has optional Payee, Description, Reference and Cheque or Check Number columns. Amounts go in a single column, positive for money received and negative for money spent.

Why are my imported dates wrong in Xero?

Xero interprets dates according to your organisation's regional settings, so a US-style MM/DD/YYYY file imported into a UK, Australian or New Zealand organisation can swap days and months or fail. Export the CSV in the date format your organisation uses, typically DD/MM/YYYY outside the US.

Should I import statements if I already have a bank feed?

Only for periods the feed doesn't cover, such as months before the feed started or gaps when the connection broke. Importing the same dates the feed already supplied creates duplicate statement lines you'll have to clean up.