Xero Bank Statement Import Guide
Official Xero documentation on importing bank statements and setting up automatic bank feeds for reconciliation.
Xero Central
Why Import Bank Statements to Xero?
Streamline your accounting workflow with automated bank reconciliation
Xero-Ready CSV
Convert bank statements to Xero-compatible CSV, OFX, or QIF format instantly
80% Faster Reconciliation
Reduce bank reconciliation time from hours to minutes with automated matching
Multi-Currency Support
Process statements in any currency with automatic Xero currency mapping
Enterprise Security
256-bit encryption with automatic file deletion — trusted by accountants worldwide
Xero Bank Statement Import Explained
Understanding how to get bank data into Xero when bank feeds are unavailable
Why Banks Cannot Always Connect Directly to Xero
Xero supports automatic bank feeds for many major banks through direct integrations. However, many banks — especially regional banks, credit unions, international banks, and older bank accounts — do not have native Xero bank feed connections.
In these cases, the standard workflow is to download your bank statement as a PDF, convert it to a Xero-compatible format (CSV, OFX, or QIF), and import it manually via Xero's Statement Import feature. This gives you the same reconciliation capability as a bank feed, without requiring a direct bank connection.
CSV vs OFX vs QIF for Xero
CSV (Recommended)
Most flexible — Xero accepts CSV with customizable column mapping. Best for international banks and custom date formats. Works with all Xero plans.
OFX
Open Financial Exchange format. Good for direct bank downloads that Xero can read automatically without column mapping.
QIF
Older Quicken format supported by Xero. Use if your existing workflow requires QIF compatibility with other tools.
Benefits for Your Business
Reduce reconciliation time by 80%
Eliminate duplicate entries
Improve accuracy with automated matching
Better financial reporting
Streamlined audit trail
Support for all major UK banks:
Convert statements from HSBC, Barclays, Lloyds Bank, NatWest, Monzo, and Starling Bank for seamless Xero import.
Browse all supported banksXero-Compatible Formats
Choose from multiple formats optimised for Xero import. CSV is recommended for best compatibility with Xero's automatic bank feed matching and column mapping.
CSV
Convert to CSV format for Xero import
OFX
Convert to OFX format for Xero import
QIF
Convert to QIF format for Xero import
EXCEL
Convert to EXCEL format for Xero import
Starting at $15/month for Xero• Free Trial Available
Which Banks Work with Xero?
Convert bank statements from major UK and international banks for seamless import into Xero. Our Xero-compatible CSV format ensures automatic transaction matching and reconciliation.
Barclays
UK • Convert to Xero CSV
HSBC
UK/Global • Convert to Xero CSV
NatWest
UK • Convert to Xero CSV
Lloyds Bank
UK • Convert to Xero CSV
Monzo
UK • Convert to Xero CSV
Starling Bank
UK • Convert to Xero CSV
JPMorgan Chase
US • Convert to Xero CSV
Bank of America
US • Convert to Xero CSV
Wells Fargo
US • Convert to Xero CSV
RBC
Canada • Convert to Xero CSV
Deutsche Bank
Europe • Convert to Xero CSV
Revolut
Global • Convert to Xero CSV
Need to convert statements from a different bank? We support all major banks worldwide.
View All Supported BanksHow to Import Bank Statements into Xero
Follow these steps to convert your bank statement and import it into Xero
1
Upload Your PDF Bank Statement
Upload your PDF bank statement to our converter. We support scanned PDFs, digital PDFs, and image-based statements from any bank worldwide.
Tip: Download statements directly from your bank online portal for best quality. Most PDFs convert without any issues.
2
Select Xero-Compatible Format
Choose CSV for the best Xero compatibility, or OFX/QIF if your workflow requires those formats. Our AI detects your bank and optimises the output format accordingly.
Tip: CSV is the most flexible and is the format Xero recommends for manual statement imports.
3
Download Your Converted File
Download your clean CSV or OFX file. Transaction data includes date, description, amount (positive/negative), and reference number in the columns Xero expects.
Tip: Check that dates are in DD/MM/YYYY format for UK Xero organisations, or MM/DD/YYYY for US organisations.
4
Open Xero and Navigate to Bank Accounts
Log in to Xero and go to Accounting > Bank Accounts. Select the bank account you want to import transactions into.
Tip: Make sure the bank account currency matches your statement currency to avoid conversion errors.
5
Import Statement and Map Columns
Click Import a Statement, upload your file, and choose the date format and currency. Map the CSV columns to Xero fields: Date, Description, Amount (or separate Spent/Received).
Tip: Xero remembers your column mapping for future imports from the same file structure.
6
Review Matches and Reconcile
Xero will suggest matches between imported transactions and existing invoices, bills, and bank rules. Review suggestions, accept matches, and create transactions for unmatched items.
Tip: Set up bank rules for recurring transactions to automate future reconciliation.
Ready to import into Xero?
Convert your bank statement to Xero-compatible CSV in under 60 seconds. For best results with CSV format — it gives you full control over column mapping in Xero.
Convert Bank Statement for XeroWho Uses Xero Bank Statement Import?
Accountants & Bookkeepers
Process client bank statements and import them into Xero for reconciliation. Handle multiple clients with different banks efficiently, eliminating manual data entry.
Small to Medium Businesses
Import bank statements from banks that do not have Xero bank feeds. Keep your Xero books up to date without waiting for automatic feed connections to be established.
Finance Teams & CFOs
Import historical bank data when migrating to Xero. Reconcile past periods, close the books for old years, and establish a complete audit trail in Xero.
Ready to Streamline Your Xero Workflow?
Join accountants and finance teams reducing reconciliation time by 80% with automated Xero imports.
No credit card required • Bank-level security • Instant conversion
Frequently Asked Questions About Xero Bank Import
What format should I use to import bank statements into Xero?
Xero supports three formats for importing bank statements: CSV, OFX, and QIF. CSV is the most flexible and widely recommended because it gives you full control over date formatting, currency, and column structure. OFX works well for direct bank imports, while QIF is an older format. For best results with Xero automatic transaction matching, use CSV format with columns for date, description, amount, and optionally reference.
How do I import a bank statement into Xero?
To import a bank statement into Xero: 1) Go to Accounting > Bank Accounts and select the account you want to import into, 2) Click Import a Statement, 3) Select your file format (CSV, OFX, or QIF), 4) Upload your file, 5) Map the columns to Xero fields (date, payee, description, amount), 6) Review and import. Xero will then suggest matches against your existing transactions for reconciliation.
Does this work with Xero bank feeds?
Yes. The CSV format we generate matches Xero bank feed format, so transactions import cleanly and Xero automatically suggests matches to existing invoices, bills, and bank rules. If your bank does not support direct Xero bank feeds, importing via CSV from a PDF bank statement is the recommended alternative.
Can I import statements from multiple banks into Xero?
Absolutely. You can convert statements from any bank and import them into separate Xero bank accounts. Each bank account in Xero can accept statement imports independently. We support all major UK banks (Barclays, HSBC, Lloyds, NatWest, Starling, Monzo), US banks, and international banks.
What about multi-currency transactions in Xero?
Our converter preserves the original currency codes in the exported data. Xero handles multi-currency accounts natively — when you import transactions in a foreign currency, Xero applies its own exchange rates or lets you specify the rate. Ensure your Xero account has multi-currency enabled (available on Business and above plans).
Which banks work best with Xero?
Xero has native bank feed integrations with many UK banks including Barclays, HSBC, NatWest, Lloyds, Monzo, and Starling. For banks not directly connected, or when you need to import historical data, converting your PDF bank statement to CSV and importing manually is fully supported. This works with any bank worldwide.
Is my financial data secure during conversion?
Yes. We use enterprise-grade 256-bit encryption, process files in isolated containers, and automatically delete all files after conversion. Your bank statement data is never stored, indexed, or shared with third parties. Our security standards meet the same requirements as major financial institutions.
How do Xero bank rules work with imported statements?
Xero bank rules automatically categorize and match transactions based on patterns you define — for example, any transaction from "Stripe" goes to Sales Income. When you import bank statements via CSV, Xero applies your existing bank rules automatically, so recurring transactions (payroll, utilities, subscriptions) are categorized immediately without manual review.
Related Format Converters
Need a different output format? Explore our other bank statement converters.
Official Xero Resources
Related Conversions
JPMorgan Chase Statement Converter
Convert JPMorgan Chase statements to CSV format
Learn more
Bank of America Statement Converter
Convert Bank of America statements to CSV format
Learn more
Wells Fargo Statement Converter
Convert Wells Fargo statements to CSV format
Learn more
Citibank Statement Converter
Convert Citibank statements to CSV format
Learn more
US Bank Statement Converter
Convert US Bank statements to CSV format
Learn more
PNC Bank Statement Converter
Convert PNC Bank statements to CSV format
Learn more
Capital One Statement Converter
Convert Capital One statements to CSV format
Learn more
TD Bank Statement Converter
Convert TD Bank statements to CSV format
Learn more
Explore by Topic
Tax & Compliance
Prepare statements for tax, audit, and visa applications
Business Management
Manage finances, bookkeeping, and reconciliation