Bank Statement File Converter

Convert BAI2, CAMT.053 (ISO 20022) and MT940 bank statement files to Excel or CSV. No signup, no upload, no limits.

🔒 Your file never leaves your computer — conversion runs entirely in your browser
Drop your statement file here or click to choose  ·  the format is detected automatically
.bai.bai2.xml (CAMT.053) .sta.mt940.txt

What this tool does

Corporate bank statements rarely arrive in a format you can actually read. US banks send BAI2 files for cash management, European banks send CAMT.053 XML under ISO 20022, and SWIFT reporting still uses MT940. Opening any of them in Excel gives you an unusable wall of commas or XML tags. This converter parses the records properly and returns a clean spreadsheet with dates, amounts, direction, references and descriptions in their own columns.

BAI2 → Excel / CSVRecord types 01, 02, 03, 16, 88, 49, 98, 99 including continuation lines. Cents converted to decimals, type codes decoded into readable names.
CAMT.053 → CSV / ExcelISO 20022 entries with booking and value dates, credit/debit indicator applied, bank transaction codes, end-to-end IDs and remittance text.
MT940 → Excel / CSVSWIFT tags :25:, :60F:, :61:, :86:, :62F: with decimal commas normalised and multi-line descriptions joined.
Nothing is uploadedBank statements are sensitive. This page has no server component — your file is read and parsed by JavaScript on your own machine.

Frequently asked questions

Is my bank statement uploaded anywhere?

No. The conversion happens in your browser using JavaScript. There is no upload endpoint. You can verify this by opening your browser's network tab while converting — you will see no requests. You can also save this page and use it with no internet connection.

What is a BAI2 file?

BAI2 is a bank reporting format from the Bank Administration Institute, used widely in the United States for corporate cash management and reconciliation. Each line starts with a record code — 01 file header, 03 account identifier, 16 transaction detail — and amounts are stored in cents, with credit or debit determined by the transaction type code. More on BAI2 conversion →

What is CAMT.053?

CAMT.053 (camt.053.001.xx) is the ISO 20022 BankToCustomerStatement message, the XML successor to MT940 across SEPA and most European banks. Amounts are always positive and direction is stored separately in CdtDbtInd. More on CAMT.053 conversion →

Why are some amounts negative?

Debits are written as negative so the Amount column sums correctly. For BAI2 the direction comes from the type code range (100–399 credit, 400–699 debit); for CAMT.053 and MT940 it comes from the credit/debit indicator.

Is there a file size limit?

No fixed limit — you are bound only by your own device's memory, since nothing is uploaded. Statements with tens of thousands of transactions convert in a second or two.