🔒 Private by design — your files are processed in your browser and never uploaded
Free · 100% in your browser · No upload

Bank statements → Excel, CSV & QuickBooks

Drop a PDF statement, BAI2, CAMT.053 or MT940 file — get a clean spreadsheet or QuickBooks import in seconds. No signup, no page limits, no watermarks.

Drop your statement file here or click to choose  ·  the format is detected automatically
.pdf.bai.bai2.xml (CAMT.053) .sta.mt940.txt
🔒 Files never leave your device ⚡ Instant — no signup 🧮 Automatic balance check ✓ 4 inputs · 8 output formats

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.

PDF statement → Excel / CSVThe one most people need: drop the PDF your bank gave you and get one row per transaction. Read in your browser — unlike every other PDF converter, nothing is uploaded.
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.

More conversions

PDF → Excel / CSV / QBO / OFXDrop a text-based PDF statement and get a full spreadsheet or QuickBooks file, with a balance check on every row.
BAI2 → QBO / OFXQuickBooks Web Connect export with mapped TRNTYPE codes and unique FITIDs.
BAI2 → CSVComma or semicolon CSV with a UTF-8 BOM, ready for Excel or accounting import.
MT940 → QBO / OFXSWIFT statement lines converted straight into a QuickBooks-ready file.
MT940 → CSVDecimal commas normalised and :86: continuation lines joined into one CSV row per transaction.
CAMT.053 → QBO / OFXISO 20022 entries with CdtDbtInd applied, exported as QuickBooks Web Connect or OFX.
CAMT.053 → ExcelAmounts written as real numbers with booking and value dates split into their own columns.
CSV → QBO / OFXTurn a generic bank CSV export into a QuickBooks-ready .qbo or .ofx file.
Three-way reconciliation templateA ready-made template for tying bank, book and statement balances together.
Accurate Bank Statement ConverterRecomputes opening + credits − debits against the statement's own closing balance and names the exact row when it doesn't tie.
Bank Statement → Tally XMLBalanced Receipt/Payment vouchers in Tally's own import format, from a PDF, BAI2, CAMT.053, MT940 or CSV statement.

By bank

Chase statement → ExcelConvert a Chase PDF statement, or use Chase's own CSV/QFX/QBO export when your account has one.
Bank of America statement → ExcelConvert a Bank of America PDF statement, with a note on CashPro BAI2 files for treasury customers.
Wells Fargo statement → ExcelConvert a Wells Fargo PDF statement, or the CEO® BAI2 export if your business account has one.
Citibank statement → ExcelConvert a Citibank PDF statement, including international layouts read by position, not template.
Capital One statement → ExcelConvert a Capital One PDF statement, or its 360 account's direct CSV export.
PNC statement → ExcelConvert a PNC PDF statement, or a treasury-management BAI2 file directly.
U.S. Bank statement → ExcelConvert a U.S. Bank PDF statement, or a BAI2 cash-reporting file from its treasury platform.
Truist statement → ExcelConvert a Truist PDF statement, including legacy BB&T- and SunTrust-branded formats.
TD Bank statement → ExcelConvert a TD Bank PDF statement, or its direct CSV export of recent activity.
Fifth Third statement → ExcelConvert a Fifth Third PDF statement, or a treasury BAI2 cash file.
Regions Bank statement → ExcelConvert a Regions PDF statement, or a business BAI2 cash-tracking file.
KeyBank statement → ExcelConvert a KeyBank PDF statement, or a commercial BAI2 cash-reporting file.
Huntington statement → ExcelConvert a Huntington PDF statement, or a business-banking BAI2 feed.
M&T Bank statement → ExcelConvert an M&T Bank PDF statement, or a commercial BAI2 cash file.
Citizens Bank statement → ExcelConvert a Citizens Bank PDF statement, or a treasury BAI2 cash-reporting file.
Ally Bank statement → ExcelConvert an Ally Bank PDF statement, or its online-account CSV export.
Discover statement → ExcelConvert a Discover card or bank PDF statement, or its direct CSV export.
American Express statement → ExcelConvert an Amex PDF statement, or use its built-in OFX/QFX/QBO/CSV download.
Navy Federal statement → ExcelConvert a Navy Federal Credit Union PDF statement for the largest US credit union's members.
Charles Schwab statement → ExcelConvert a Schwab brokerage or bank PDF statement, or its CSV/QFX export.

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.