JA Technology Solutions
BAI2 File Explorer
Parse BAI2 bank statement files into structured views with type code lookup, transaction details, and CSV export.
BAI2 File Explorer
Parse BAI2 (Bank Administration Institute Version 2) bank statement files into structured views used by corporate treasury departments for bank reconciliation and cash management. Navigate groups, accounts, and transactions in a collapsible tree with opening and closing balances, currency codes, and account identifiers at each level; click any transaction for its type-code description, reference numbers, and addenda text records. File-level control totals are verified against computed sums so hash mismatches surface immediately instead of silently breaking downstream reconciliation. Export transactions as a flat CSV or Excel table with full account context. All parsing happens client-side — your statements never leave your browser.
Learn more ↓
Loading interactive explorer...
What Is the BAI2 Format?
BAI2 (Bank Administration Institute Version 2) is the standard file format used by banks to deliver account statements electronically to corporate customers. Each file contains a hierarchy of records: file headers (01), group headers (02), account headers (03), transaction details (16), and corresponding trailer records with control totals. Treasury teams, accounts payable departments, and ERP systems rely on BAI2 files for automated bank reconciliation and cash position reporting.
Why BAI2 Files Are Difficult to Read
BAI2 files are comma-delimited with numeric type codes instead of readable labels. A transaction coded 16,142,125000 means “wire credit of $1,250.00” — but only if you know that type code 142 is “Miscellaneous ACH Credit.” This tool decodes every type code, formats amounts, and groups transactions under their accounts so you can read the statement without a reference manual.
Automating Bank Reconciliation
Manually reviewing BAI2 files is feasible for occasional troubleshooting but not for daily operations. I build automated reconciliation pipelines that ingest BAI2 files from bank SFTP servers, match transactions against ERP records, flag exceptions, and produce reconciliation reports — all without manual file handling. Learn about integration services or get in touch to discuss automating your bank reconciliation.
All tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.