Upload a PDF bank statement and get a clean file you can run through Xero's Import a Statement: a CSV with the date, description, and signed amount in their own columns, or an OFX that Xero reads without any edits. No retyping, no rebuilding the layout by hand.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
The short answer
Xero cannot import a PDF bank statement. Its Import a Statement tool reads CSV, OFX, QFX, and QIF files, so you convert the PDF first. This converter turns the statement into Xero's CSV layout, with the transaction date, a description, and a single signed amount column (income positive, expenses negative, US MM/DD/YYYY dates, no commas in numbers), or into an OFX file Xero imports as is. Upload the PDF, check the preview, export, then load it under Accounting, Bank accounts, Import a Statement.
Last updated June 2026
Xero's bank feed handles most day-to-day transactions automatically, but the feed is not always an option. A bank may not connect to Xero, the feed can miss older periods, an account may be closed, or a client sends only the PDF statement. In every one of those cases you fall back to a manual import, and Xero will not read a PDF. It needs a structured file. Typing hundreds of lines into a spreadsheet by hand is slow and easy to get wrong, so this converter reads the statement PDF and builds the file for you, with the date, description, and amount in the columns Xero maps on upload.
Date, description, and a signed amount land in their own columns, the exact layout Xero's CSV import maps. Income stays positive, expenses go negative, so each line posts the right way.
Xero rejects a CSV when the dates do not match your organisation's region. For a US org the dates come out as MM/DD/YYYY, so the import does not stall on a date error.
Xero recommends OFX because it imports with no edits. The converter exports OFX and QFX too, so you can skip column mapping entirely on banks where that is the cleaner path.
Xero's Import a Statement screen accepts four manual formats. The converter can produce the ones you are most likely to use, so you can pick whichever fits the bank you are working with.
| Format | What Xero needs | Effort to import | From this converter |
|---|---|---|---|
| CSV | Date and amount at minimum, with description recommended; dates in your region format. | Low, with column mapping on first use | Yes, in Xero's layout |
| OFX | A structured statement file; Xero reads it without changes. | Lowest, no mapping | Yes |
| QFX | The Web Connect variant of OFX from some US banks. | Lowest, no mapping | Yes |
| QIF | A simple text ledger format Xero also accepts. | Low | Yes |
| Not supported by Xero's import at all. | Must be converted first | This is the input |
If your bank offers OFX or QFX from its online portal, that is the lowest-effort path because the data arrives pre-structured. When all you have is the PDF, convert it to Xero's CSV layout instead. For a CSV-first workflow on any target, the general PDF bank statement to CSV converter and the bank statement OFX converter cover the same output, and the general bank statement converter handles every format from one upload.
Xero takes two CSV shapes. You can use a single signed amount column, or split debits and credits into two columns. The converter produces the signed-amount version by default because it is the simplest to map, and the totals tie back to the statement either way.
Single signed amount column
| Date | Description | Amount |
|---|---|---|
| 03/04/2026 | ACH Deposit Acme LLC | 1450.00 |
| 03/06/2026 | Card Purchase Staples | -86.20 |
| 03/09/2026 | Monthly Service Fee | -15.00 |
Prefer split columns? Export the four-column shape with Date, Description, Debit, and Credit, which Xero also reads.
Four steps, no software to install.
Download the statement PDF from your bank, or use the file a client sent you. It works for checking, savings, and credit card statements from any US bank.
Drop the PDF into the converter at the top of this page. Password-protected files are detected the moment you upload them.
The statement is read into rows. Confirm the date, description, and amount columns look right, then export as CSV, OFX, or Excel.
In Xero, open Accounting, Bank accounts, the menu for the account, then Import a Statement. Upload the file and map the columns if you chose CSV.
Want the full walk-through with the Xero screens? See the step-by-step guide on how to import a bank statement into Xero, and the deeper post on importing bank statements into Xero, which both cover the column mapping and reconciliation in detail.
Clients often forward only the statement PDF. Convert it into an import-ready CSV or OFX and post the month without retyping a single line.
Handle banks with no Xero feed and catch-up jobs across many clients. A clean import keeps each ledger reconciled without manual entry.
Turn a stack of bank and card PDFs into upload files so your Xero books stay current, even on accounts the feed will not connect.
Backload past periods when you move onto Xero, converting older PDFs into clean files so the opening history is complete and reconciled.
A bank statement PDF carries opening and closing balances, deposits, withdrawals, checks, card activity, fees, and interest, often across several pages. Xero needs that as a structured file with consistent columns so the import can post each line and reconciliation has something clean to match. The converter handles that shape so the upload maps cleanly the first time.
Export to CSV or OFX for the Xero import, or to Excel (.xlsx) to review the data first. The same file works in other systems too. If you also enter vendor bills in Xero, you can pull the line items off those documents with an invoice OCR tool, and turn any other report PDF into a spreadsheet with a PDF to Excel converter.
No. Xero's Import a Statement tool reads CSV, OFX, QFX, and QIF files, not PDFs. A PDF statement has to be converted to one of those formats first. This converter reads the PDF and outputs an import-ready CSV with the date, description, and signed amount in their own columns, or an OFX file Xero imports with no edits at all.
Convert the statement PDF to a CSV or OFX here, then in Xero go to Accounting, Bank accounts, click the menu icon for the account, and choose Import a Statement. Upload the file. For a CSV you map the date, amount, and description columns once; an OFX needs no mapping. Xero then brings the lines in to reconcile.
At a minimum Xero needs a date column and an amount column, though a description makes reconciliation far easier. The amount sits in one column with income positive and expenses negative, and the dates must match your organisation's region, which is MM/DD/YYYY for a US org. The converter outputs exactly this layout.
Use OFX or QFX when your bank offers it, because Xero imports those files without any reformatting. Use CSV when all you have is the PDF statement, since almost any statement reduces cleanly to the date, description, and amount columns. The converter produces both, so you can match the format to the bank you are working with.
The most common causes are dates that do not match your region format, commas inside the number values, an amount split incorrectly across columns, or empty rows in the file. The converter avoids these by writing US MM/DD/YYYY dates, plain numbers without commas, and a single clean signed amount column, so the import does not stall on a format error.
Yes. The converter includes optical character recognition, so it reads scanned statements and image-only PDFs, not just digital ones. That matters for older periods and for files a client photographed or saved from a teller. The text is pulled into the same date, description, and amount columns, so the file imports into Xero the same way a digital statement would.
Files are encrypted in transit and at rest while they are processed, and the conversion runs without sharing your data with third parties. You never enter your bank login or your Xero credentials, because the converter works straight from the PDF you already downloaded. You stay in control of the file and the export from upload to download.
The full step-by-step guide with the Xero screens.
Export OFX that Xero imports with no edits.
The general converter for any CSV import target.
Convert statements for a Wave import too.
Statement data prepared for multi-client books.
Match converted data against your books cleanly.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
