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:
- 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.
- 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.
- Plain numbers only.
1250.00, not£1,250.00or1,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:
- Barclays statements
- Commonwealth Bank statements
- ASB statements
- Wise statements (one statement per currency)
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:
- Drop in one or more PDFs. Batch conversion can merge them into one file or keep one sheet per statement.
- 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.
- Choose DD/MM/YYYY or MM/DD/YYYY to match your Xero organisation.
- 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.
- Go to Accounting > Bank accounts.
- 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.
- Browse to your CSV or OFX file and start the import.
- 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.
- Review the summary Xero shows (number of lines, date range) and complete the import.
- 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.