Is it free?
Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.
Is my file stored?
No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.
Can I try it without uploading my own file?
Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.
What is a BAI2 file?
A bank cash-management report in the BAI2 format (the Cash Management Balance Reporting Specification, version 2), which US banks send to treasury, ERP and accounting systems, usually as a previous-day file every morning. It's plain text: an 01 file header, an 02 group per as-of date, an 03 record per account with balance summaries, one 16 record per transaction, 88 continuation records, and 49, 98 and 99 trailers with control totals. Banks name it .bai, .bai2 or .txt.
Can I open a BAI2 file in Excel?
Only as text. Excel shows lines such as 16,475,120000,0,000415,1043 in one column, with amounts in cents and no dates on the transaction lines. Convert it here and open the CSV instead: one row per transaction with the group's as-of date, the amount in dollars and a running balance, ready to sort, filter or Save As .xlsx.
How are amounts and signs worked out?
BAI2 amounts have no decimal point: 120000 is 1,200.00 in a two-decimal currency such as USD. The sign comes from the three-digit type code: 100 to 399 are credits (money in, positive), 400 to 699 are debits (money out, negative).
What about type codes outside 100–699?
Loan codes (700s), non-monetary records (890) and bank-specific codes in the 900s mean different things at different banks, so we don't guess their direction. Those detail records are left out, the preview lists their codes, and the balance check shows the gap if they moved money. Ask your bank what the code means, then add the row by hand.
Which date does each row get?
The as-of date on the 02 group header. BAI2 16 records don't carry their own posting date, so every transaction in a group gets that day. A value date on a funds type V record is an availability date, not the posting date, so it isn't used.
What goes in Description and Reference?
Description is the 16 record's text, with any 88 continuation joined on. When a bank sends no text (often on paid checks), it's the type code's name, or Check plus the check number. Reference is the customer reference (the check number on a paid check), else the bank reference.
Is the balance checked?
Yes. For every account in every group we add the transactions to the 010 opening ledger and compare the result with the 015 closing ledger, and the preview says whether each one ties. When they all tie, the CSV gets a running Balance column. We also check the 49, 98 and 99 control totals and record counts, which catch a cut-off file.
My file has several accounts or several days. Does that work?
Yes. The same account across several groups (one per as-of date) is joined in date order, so a week of previous-day files pasted together becomes one CSV. Each different account gets its own tab in the preview, its own CSV and a combined CSV with an Account column. One credit covers the whole file.
Is BAI2 the same as a bank statement PDF, MT940 or camt.053?
No. A BAI2 file is a US bank's machine-readable balance and transaction report for treasury systems, not the PDF statement you get each month. MT940 and camt.053 are the European SWIFT and ISO 20022 equivalents; use the MT940 to CSV or CAMT.053 to CSV converters for those. We read BAI version 2 only, not version 1 files or BAI lockbox transmissions, and we don't write BAI2.
