What file format do I need to import a bank statement to Xero?

Xero accepts CSV, OFX, and QIF files for bank statement import. CSV is the most reliable and most widely supported. The required CSV columns are: Date, Amount, Payee, Description. Our converter produces a correctly formatted Xero CSV automatically.

Can I import bank statements to Xero without a bank feed?

Yes. Xero's Import a Statement feature works completely independently from bank feeds. You don't need a direct bank connection. Upload a CSV, OFX, or QIF file and Xero imports all transactions as statement lines ready for reconciliation.

Import Bank Statement to Xero — Free PDF Converter, 100+ Banks

How to Import Bank Statement to Xero — 6 Steps

Download your PDF bank statementLog into your online banking portal. Download the statement for the date range you need. Most banks provide PDF statements — this is the format we convert.
Convert PDF to Xero CSV (free, no signup)Upload your PDF at bankstatementengine.com. If the PDF is password-protected, enter the password when prompted. Click Download CSV — get a Xero-formatted file instantly.
Log into Xero and go to Bank AccountsIn Xero, click Accounting in the top navigation menu → select Bank Accounts. You see your list of accounts.
Select the account and click ImportFind the bank account that matches your statement. Click Import a Statement (shown on the right of the account row, or via the three-dot "…" menu).
Upload and map columnsXero opens a file upload dialog. Browse to your downloaded CSV file and open it. Xero reads the file and shows a column-mapping preview. Confirm: Date → Date, Amount → Amount, Payee → Payee. If the date format prompt appears, select the correct format for your region.
Import and reconcileClick Import. All transactions load as statement lines in Xero. Open the account and start matching: Xero often auto-suggests matches for recurring payees, bills, and invoices. Review unmatched items and create new transactions as needed.

Tips for a Successful Import

⚠️ Check the date format

UK/AU/NZ: use DD/MM/YYYY. US: MM/DD/YYYY. International: YYYY-MM-DD. Our converter sets the right format for your bank's country automatically.

⚠️ No thousands separators

Xero expects plain numbers: 1500.00 not 1,500.00. If your bank exports include commas, our converter strips them automatically.

⚠️ Signs matter

Xero needs negative amounts for debits and positive for credits. Our converter handles debit/credit column formats and converts them to signed numbers.

💡 Duplicate detection

Xero won't import the same transaction twice. If you import overlapping date ranges, Xero skips duplicates — safe to re-import.

Import Bank Statements to Xero by Region

🇬🇧 United Kingdom

Most UK bookkeepers and accountants use Xero. Import Barclays, Lloyds, HSBC, NatWest, Santander, Halifax, Monzo, Starling, First Direct, and all UK bank PDF statements. Date format: DD/MM/YYYY, currency: GBP.

🇦🇺 Australia

Xero is hugely popular in Australia. Import CommBank, ANZ, Westpac, NAB, Macquarie, ING, Bendigo Bank, and all Australian bank PDF statements. Date format: DD/MM/YYYY, currency: AUD.

🇳🇿 New Zealand

Xero was founded in New Zealand and dominates the NZ market. Import ASB Bank, BNZ, ANZ NZ, Kiwibank, Westpac NZ, and Rabobank NZ PDF statements. Date format: DD/MM/YYYY, currency: NZD.

🇺🇸 United States

US businesses use Xero for its international capabilities. Import Chase, Bank of America, Wells Fargo, Citi, Capital One, US Bank, TD Bank, and all US bank PDF statements. Date format: MM/DD/YYYY, currency: USD.

🇮🇳 India

Growing Xero adoption among Indian exporters and businesses with international clients. Import HDFC, SBI, ICICI, Axis, Kotak, IndusInd, Yes Bank, and all Indian bank PDF statements. Password-protected PDFs supported.

🇨🇦 Canada

Canadian businesses increasingly use Xero alongside QuickBooks. Import TD, RBC, Scotiabank, BMO, CIBC, and all Canadian bank PDF statements. Currency: CAD.

Frequently Asked Questions

How do I import a bank statement to Xero?

Convert PDF to CSV free here → in Xero: Accounting → Bank Accounts → Import a Statement → upload CSV → confirm columns → Import. Under 3 minutes total.

What file format do I need to import to Xero?

Xero accepts CSV (most reliable), OFX, and QIF. Our converter produces a correctly formatted CSV with Date, Amount, Payee, Description columns mapped correctly for your bank's region.

Is importing a bank statement to Xero free and unlimited?

Yes — both Xero's import feature (included in all plans) and our PDF converter are 100% free and unlimited. No per-import charges, no limits on statements per month.

How far back can I import bank statements to Xero?

No limit. Unlike bank feeds (90 days), manual import lets you load years of history. Useful for new Xero account setup, historical reconciliation, and tax filing.

Why does Xero say "no transactions were imported"?

Usually a date format mismatch or all transactions already exist (duplicates). Our converter pre-formats dates for your region, so if you use this converter the date issue won't occur.

More Xero Tools

Import Bank Statement Xero Import PDF into Xero Importing Statements into Xero Upload to Xero Bank Statement to Xero Bank Statement to QBO

Import Bank Statement to Xero — Free PDF Converter, Any Bank

PDF Bank Statement → Xero CSV — Free & Unlimited