Bank statement converters by bank
Each bank exports transactions its own way. These bank statement converters are set up for one bank’s layout, with notes on where to find its download and what usually goes wrong. Free, with no upload.
United States
- Chase CSV to QuickBooks
Seven columns with a signed Amount; card files add a posting date. Month-first dates.
- Bank of America CSV to QuickBooks
A balance summary above the table and a running balance on every line.
- Wells Fargo CSV to QuickBooks
Five quoted columns with no header row and no balance.
- Citi CSV to QuickBooks
Separate Debit and Credit columns and a Cleared/Pending status.
- Capital One CSV to QuickBooks
Two layouts: cards with Debit/Credit, 360 accounts with a Transaction Type.
United Kingdom
- Barclays CSV to Xero
Signed Amount and the payee and reference run together in Memo. Day-first dates.
- HSBC UK CSV to Xero
Three columns — date, description, amount — with no header row.
- Monzo CSV to Xero
Transaction IDs, names, emoji and categories, with date and time separate.
- Lloyds CSV to Xero
Debit Amount, Credit Amount and a running balance; also Halifax and Bank of Scotland.
- NatWest CSV to Xero
A signed Value column and apostrophes before text; also RBS.
- Starling CSV to Xero
Counterparty, reference and signed amount with a running balance.
Canada
- RBC CSV to QuickBooks
Two description columns and CAD$ / USD$ amount columns.
- BMO CSV to QuickBooks
A text line above the headings and dates written as 20260105.
Australia
- CommBank CSV to Xero
Date, amount, description and balance with no header row.
- Westpac CSV to Xero
Separate Debit Amount and Credit Amount columns with a running balance.
Bank not listed?
Use the general bank statement to QuickBooks or CSV to Xero converter: they detect dates, amounts and descriptions from any bank’s export, and you can choose columns by hand. The guide to bank formats by country explains the differences. To ask for your bank to get its own page, get in touch. See also all free tools.