Convert bank statements to the file format you need
Upload a statement as a PDF, scan, photo, CSV, Excel, OFX, QIF, CAMT.053 or MT940 file and export it as Excel, CSV, QuickBooks, Xero, OFX or QIF. Every conversion gives each transaction a clean payee and a category, and checks it against the statement's balances.
Updated October 28, 2026
Which file format do I need?
| You want to… | Export | Guide |
|---|---|---|
| Analyse, total or send transactions to a client or lender | Excel (.xlsx) | Bank statement to Excel |
| Use Google Sheets, Numbers, a budgeting app or a script | CSV | Bank statement to CSV |
| Upload to QuickBooks Online | QuickBooks Online CSV | Bank statement to QuickBooks |
| Import into QuickBooks Desktop | .qbo Web Connect file | Bank statement to QuickBooks |
| Import into Xero | Xero CSV | Import a bank statement into Xero |
| Import into GnuCash, MoneyMoney, Wave, Sage and other apps that read bank files | OFX | Bank statement to OFX |
| Import into Quicken or an older desktop app | QIF | Bank statement to QIF |
| Read a CAMT.053 or MT940 file from your bank | Excel or CSV | CAMT.053 to Excel · MT940 to Excel |
CSV, OFX and QIF: what's the difference?
CSV is a plain table: any columns, in any order, so every app expects its own layout — which is why QuickBooks and Xero get their own CSV exports. OFX (Open Financial Exchange) is a standard bank-data format that also carries the account, the closing balance and a unique ID for each transaction, so apps can recognise transactions they've already imported. QIF is Quicken's older text format: one field per line, with categories but without unique IDs. More in what is an OFX file.
- Categorize bank transactions automaticallyCategorize bank transactions automatically: upload any statement and get clean payee names, your own categories and rules that always win. Totals in Excel.
- Convert a bank statement to CSVConvert a bank statement PDF, scan or photo to CSV: one clean row per transaction, categorized and balance-checked. Comma or semicolon, any date format.
- Convert a PDF bank statement and import it into XeroImport any PDF bank or credit card statement into Xero: convert it to a Xero statement CSV, check it balances, then import it in a few clicks.
- Convert bank statements for QuickBooks Online and QuickBooks DesktopConvert PDF bank statements to a QuickBooks Online CSV or a .qbo Web Connect file for QuickBooks Desktop — categorized and balance-checked first.
- Convert bank statements to ExcelConvert any bank statement PDF, scan or photo to Excel in seconds. Every transaction categorized and checked against your balances. See it before you pay.
- Convert bank statements to OFX filesConvert a bank statement PDF, scan or CSV to an OFX file for GnuCash, Xero, Wave, Sage and more. Every transaction is balance-checked before you import.
- Convert bank statements to QIF for Quicken and other money appsConvert a bank statement PDF, scan or CSV to a QIF file for Quicken, GnuCash or HomeBank, with clean payees, categories and a balance check before import.
- Convert CAMT.053 files to ExcelConvert camt.053 bank statement XML to Excel or CSV: one row per entry with signed amounts, payee and category, checked against the file's balances.
- Convert credit card statements to ExcelConvert credit card statement PDFs to Excel, CSV, QuickBooks or Xero. Charges and payments are signed consistently and checked against the new balance.
- Convert MT940 files to ExcelConvert MT940 statement files (.sta, .mt940) to Excel or CSV: :61: and :86: decoded into dates, signed amounts, payees and categories. Balance-checked.
- Convert scanned bank statements and photos to ExcelConvert scanned bank statements, faxes and phone photos to Excel. Every row is checked against the statement's balances, so a misread digit gets caught.
Questions
Which file format do I need for Excel, QuickBooks, Xero or Quicken?
Excel (.xlsx) for spreadsheets, the QuickBooks Online CSV for QuickBooks Online, a .qbo Web Connect file for QuickBooks Desktop, the Xero CSV for Xero, and QIF for Quicken.
What is the difference between CSV, OFX and QIF?
CSV is a plain table each app reads its own way; OFX is a bank-data standard with account details and unique transaction IDs; QIF is Quicken's older format with categories but no unique IDs.
Your next statement takes seconds.
See what we find on your statement before you pay.