Before vs After: The Manual Bank Import Problem
❌ Before — The Problem
- Bank not in Xero's feed list
- Need data older than 90 days
- Bank feed broken or disconnected
- PDF statement only, no export option
- Manually re-entering every transaction
- Hours of data entry per month
✅ After — With This Tool
- Upload any PDF from any bank
- Get Xero-formatted CSV instantly
- Import in 3 clicks inside Xero
- 100+ banks globally supported
- Any date range, any history length
- Free, unlimited, no account needed
How to Import Bank Statement into Xero — Step by Step
1
Download PDF from your bankLog into your bank's online banking and download the PDF statement
2
Convert to Xero CSVUpload the PDF here — get a Xero-formatted CSV file instantly, free
3
Import into XeroAccounting → Bank Accounts → Import a Statement → upload CSV
Detailed Xero Import Walkthrough
1
Convert your PDF bank statement hereUpload your bank statement PDF at bankstatementengine.com. If the PDF is password-protected (common with HDFC, ICICI, Axis, some UK banks), enter the password when prompted — it's only used to open the file. Click Download CSV. Save the file to your desktop.
2
Log into XeroOpen Xero in your browser and go to the organisation where you want to import the statement. If you have multiple organisations, make sure you're in the right one.
3
Navigate to Bank AccountsIn the top menu: Accounting → Bank Accounts. You'll see a list of all your connected bank accounts. Find the bank account that matches the statement you're importing.
4
Click "Import a Statement"On the right side of the account row, click Import a Statement (or the three-dot menu → Import a Statement). A file upload dialogue appears.
5
Upload the CSV fileSelect your downloaded CSV file. Xero reads the file and shows you a preview of the column mapping: Date, Amount, Payee, Description. Confirm the columns are correctly mapped. If Xero asks for the date format, select the correct one (DD/MM/YYYY for UK/AU/NZ, MM/DD/YYYY for US, YYYY-MM-DD for international).
6
Import and reconcileClick Import. Xero loads all transactions into the bank account's statement line list. Open the account and start reconciling: match transactions to existing invoices and bills, or create new entries for unmatched items. Xero's smart matching often auto-suggests matches for recurring payees.
Xero Bank Import CSV Format
Xero expects a CSV with these four columns (header row required):
Date,Amount,Payee,Description
31/05/2026,-156.40,TESCO STORES 3456,Grocery shopping
30/05/2026,2500.00,PAYROLL BACS,Monthly salary
28/05/2026,-45.00,BT BROADBAND,Internet bill
27/05/2026,-12.99,NETFLIX,Monthly subscription
Our converter produces this exact format automatically — dates in DD/MM/YYYY for UK/AU/NZ accounts, amounts as signed numbers (negative = money out, positive = money in), and payee text from the transaction description.
Why Import Manually Instead of Using Xero's Bank Feed?
Xero's automatic bank feed is excellent when it works — but manual import is necessary for:
- Historical data: Bank feeds typically provide only 90 days of history. For tax year-end reconciliation, importing older statements manually is the only option.
- Unsupported banks: Not every bank in every country is connected to Xero's feed. Smaller regional banks, credit unions, and banks in emerging markets often require manual import.
- Broken connections: Bank feeds disconnect during security upgrades, password changes, or MFA changes. Manual import fills the gap.
- Controlled imports: When migrating bookkeeping between periods or accountants, manual import gives you exact control over what goes in.
- Closed accounts: You can't reconnect a closed account's feed. Manual import via PDF statement is the only way to get those transactions into Xero.
Supported Banks — Import Any Bank Statement into Xero
United Kingdom
Barclays
Lloyds
HSBC UK
NatWest
Santander UK
Halifax
Nationwide
Monzo
Starling
TSB
First Direct
Metro Bank
Australia
CommBank
ANZ
Westpac
NAB
Macquarie
ING AU
Bendigo Bank
Bank of Qld
New Zealand
ASB Bank
BNZ
ANZ NZ
Kiwibank
Westpac NZ
Rabobank NZ
United States
Chase
Bank of America
Wells Fargo
Citi
Capital One
US Bank
India
HDFC Bank
SBI
ICICI Bank
Axis Bank
Kotak Bank
PNB
Frequently Asked Questions
How do I import a bank statement into Xero?
Convert your PDF to Xero CSV here (free, no signup) → in Xero go to Accounting → Bank Accounts → select the account → Import a Statement → upload the CSV → confirm columns → import. Under 3 minutes.
What format does Xero need for bank statement import?
Xero accepts CSV (most reliable), OFX, and QIF. CSV format: Date, Amount, Payee, Description — our converter produces this automatically.
Is importing bank statements into Xero free?
Yes — Xero's import feature is included in all plans. Our PDF-to-CSV converter is also 100% free and unlimited. Convert as many statements as you need at zero cost.
Why use manual import instead of Xero bank feed?
Bank feeds only provide 90 days of history and only work for supported banks. Manual import handles any bank, any history length, closed accounts, and broken feed connections.
Why are some transactions missing after importing into Xero?
Common reasons: date format mismatch (Xero requires DD/MM/YYYY for UK/AU/NZ), duplicate detection (Xero skips transactions matching existing entries), or currency mismatch. Our converter pre-formats dates correctly for your region.
Import Bank Statement into Xero — Free & Unlimited
Any bank · Any country · No signup · No cost ever · Instant Xero CSV output
Convert for Xero — Free →