What is a BAI2 file and how does conversion work?
BAI2 is the Bank Administration Institute cash management format used by US banks to report prior-day and intraday corporate transactions across hierarchical record codes. EasyExtract parses 03 account headers, 16 transaction records, and 88 continuation lines inside your browser, converts implied-cent integers to two-decimal amounts, and exports clean CSV.
How to convert BAI2 to CSV online
- Drop your .bai or .bai2 file. Select your corporate treasury export (.bai, .bai2, or .txt). Your browser reads the file from local disk with zero server uploads.
- Inspect parsed 03, 16, and 88 records. The parser tracks the active 03 account number, splits 16 transaction rows (type code, implied-decimal amount, bank reference), and appends 88 continuation lines.
- Download or copy CSV. Click Download CSV to save bai2-transactions.csv for Excel, NetSuite, or SAP reconciliation, or copy to clipboard.
What fields this converter extracts
- Account (
03record): Carries the active bank account identifier onto every following16transaction row. - Type Code & Implied-Decimal Amount (
16record): Reads the 3-digit BAI code and divides integer cents by100to two decimal places. - Bank Reference & Description (
16+88): Captures bank reference tokens and merges multi-line88continuation descriptions into one field.
Supported formats and preview bounds
Inputs: Comma-delimited BAI2 text files (.bai, .bai2, .txt) ending lines with /.
Outputs: RFC 4180 UTF-8 .csv with formula-injection protection. Up to 500 transactions render in preview while the full file exports to CSV.
Why treasury files stay in your browser
BAI2 files contain corporate operating account numbers, wire references, payroll totals, and counterparty details. EasyExtract parses the entire file inside client RAM with zero network uploads.
What this tool does not do
- It divides amounts by 100 for 2-decimal currencies: Zero-decimal currencies (such as JPY) will appear scaled by 100 and need manual adjustment.
- It keeps positive integer magnitudes as reported: BAI2 encodes credit or debit direction in the 3-digit Type Code rather than negative signs.
When to use BAI2 to CSV
- Daily treasury reconciliation: Convert raw US bank lockbox and wire feeds into clean Excel rows.
- ERP exception debugging: Inspect why NetSuite, Workday, or SAP rejected a BAI2 file by viewing flat continuation lines.
BAI2 compared with MT940 and CAMT.053
US treasury teams typically receive BAI2, European and international SWIFT banks emit MT940, and ISO 20022 institutions deliver CAMT.053 XML. Read our guide on how to convert BAI2 to CSV.
Frequently asked questions
What is a BAI2 file?
BAI2 is the Bank Administration Institute standard format used by US banks for corporate cash management and prior-day or intraday reporting.
Why are BAI2 amounts shown without decimal points in the raw file?
The BAI2 specification stores USD amounts as integer cents (for example 10050 equals 100.50). EasyExtract divides implied-decimal integers by 100 automatically.
Are my corporate bank files uploaded?
No. Everything runs 100% locally in your browser memory with zero server uploads.