📘 Xero

Import Bank Statement CSV into Xero

Convert bank statements to CSV format compatible with Xero's bank import

Xero is a popular cloud accounting platform for small businesses and their advisors. When direct bank feeds are unavailable or you need to import historical data, a CSV file from a converted bank statement lets you bring transactions into Xero manually.

Required format: CSV with Date, Payee/Description, and Amount columns. Xero supports both single-amount and split debit/credit column formats.

Step-by-Step: Import into Xero

Convert your bank statement PDF

Use the converter to turn your bank statement PDF into a CSV file.

Go to your bank account in Xero

In Xero, navigate to 'Accounting' > 'Bank accounts' and select the account you want to import into.

Click 'Import a Statement'

On the bank account page, click the 'Import a Statement' button.

Upload and map columns

Select your CSV file. Xero will show a preview and ask you to confirm which columns contain the date, description, and amount.

Reconcile transactions

Imported transactions appear in the reconciliation view. Match them against invoices, bills, or create new transactions.

Workflow Examples

Catch-up bookkeeping: Import months of statements to reconcile a new Xero account

Bank feed gap: When Xero's automatic feed misses transactions, fill the gap with a CSV import

Migration: Moving from another platform to Xero, import historical bank data via CSV

Tips for Xero Import

Xero requires dates in DD/MM/YYYY or MM/DD/YYYY format depending on your organization settings
If using split debit/credit columns, leave the opposite column blank (not zero)
Xero detects and warns about duplicate statement lines during import
Import the opening balance first if you're setting up a new bank account in Xero

Cited Statistics

Data breaches in the financial sector increased 18% year-over-year.

Source: Identity Theft Resource Center 2024 Data Breach Report
U.S. consumers used an average of 5.3 financial products in 2023.

Source: Federal Reserve - Economic Well-Being of U.S. Households

Convert Your Statement to CSV →

Also Import Into

📊 Excel 📗 Google Sheets 🌊 Wave 📕 FreshBooks

Frequently Asked Questions

Does Xero accept CSV imports?

Yes. Xero accepts CSV, OFX, and QIF file formats for manual bank statement imports. Our converter outputs CSV, which is the most widely compatible format.

My Xero bank feed stopped working. Can I use this instead?

Yes. When your direct bank feed has gaps or stops working, download your statement as a PDF from your bank, convert it to CSV, and import into Xero to fill the gap.

Will Xero match imported transactions with existing invoices?

Yes. During reconciliation, Xero suggests matches between imported transactions and outstanding invoices or bills. You can also create new transactions from the imported data.

Ready to Import Your Bank Statement?

Convert your PDF to CSV first, then follow the steps above to import into Xero.

Convert PDF to CSV →