What is a BAI2 file? Definition, format, and example
Accounts receivable, billing and collections
A BAI2 file is a plain-text bank statement format that US banks use to send balance and transaction data to companies, usually as a prior-day or intraday report. Created by the Bank Administration Institute, it's comma-delimited, with numbered records for the file, the account, and each transaction, and it loads into ERPs for bank reconciliation and cash application.
- Format
- Comma-delimited text
- Origin
- Bank Administration Institute
- Reports
- Prior-day or intraday
- Use
- Reconciliation and cash application
What does a BAI2 file contain?
A BAI2 file is built from numbered records, each ending with a slash. Every file has the same nesting: file, group, account, transactions.
| Record | Name | What it holds |
|---|---|---|
| 01 | File header | Sender, receiver, file creation date and time |
| 02 | Group header | Bank, as-of date, currency |
| 03 | Account identifier | Account number and balance or summary codes |
| 16 | Transaction detail | One transaction: type code, amount, references |
| 88 | Continuation | Continuation of fields or text from the preceding record |
| 49 | Account trailer | Account control total and record count |
| 98 | Group trailer | Group control total, accounts, and records |
| 99 | File trailer | File control total, groups, and records |
Amounts have no decimal point; $50,000.00 is written 5000000.
What are BAI2 type codes?
Type codes say what each balance or transaction is. Balance and summary codes such as 010 and 100 appear in the 03 record; transaction codes such as 195 and 475 appear in 16 records.
| Code | Meaning |
|---|---|
| 010 | Opening ledger balance |
| 015 | Closing ledger balance |
| 045 | Closing available balance |
| 100 | Total credits |
| 195 | Incoming money transfer |
| 400 | Total debits |
| 475 | Check paid |
| 495 | Outgoing money transfer (debit) |
Banks publish their own code lists, so check yours before mapping.
BAI2 file example
Example: Northline's bank sends its prior-day file for Monday, November 2, 2026, early on Tuesday, November 3. All amounts are illustrative.
01,BANKUS,NORTHLINE,261103,0600,1,,,2/
02,NORTHLINE,BANKUS,1,261102,,USD,2/
03,4415520091,USD,010,5000000,,,015,6250000,,,100,2000000,2,,400,750000,1,/
16,195,1500000,0,FT2611020001,,INV-3011 BAYSIDE BUILDERS/
16,195,500000,0,FT2611020002,,/
16,475,750000,0,CHK10452,10452,/
49,16750000,5/
98,16750000,1,7/
99,16750000,1,9/| Check | Amount |
|---|---|
| Opening ledger balance | $50,000.00 |
| Add: credits (incoming wires $15,000 + $5,000) | 20,000.00 |
| Less: debits (check paid) | (7,500.00) |
| Closing ledger balance | $62,500.00 |
The 49 record's control total, 16750000, is the sum of every amount in the 03 and 16 records. The 98 and 99 records repeat it and count the records: 5 for the account, 7 for the group, and 9 for the file. If a total doesn't match, the file is incomplete; reject it.
The $15,000 wire carries invoice INV-3011 in its reference, so cash application can match it. The $5,000 wire has no reference and sits as unapplied cash until it's identified.
| Date | Account | Debit | Credit |
|---|---|---|---|
| Nov 2, 2026 | Cash | 15,000 | |
| Accounts receivable, Bayside Builders | 15,000 | ||
| Nov 2, 2026 | Cash | 5,000 | |
| Unapplied cash | 5,000 | ||
| Total | 20,000 | 20,000 |
The $7,500 check was recorded when it was issued, so clearing it needs no new entry; it's matched in the bank reconciliation.
What is a BAI2 file confused with?
BAI2 is most often confused with other bank statement formats.
| Term | What it is | How it differs from BAI2 |
|---|---|---|
| MT940 | SWIFT customer statement message | Used by banks worldwide; BAI2 is mainly US |
| camt.053 | ISO 20022 XML bank-to-customer statement | Structured XML with richer remittance data |
| BTRS (X9.121) | Balance and Transaction Reporting Standard from X9 | The ANSI standard written as an update to BAI2 |
| Lockbox file | Bank file of checks and remittance data from a lockbox | Detail of receipts, not a full statement |
BAI2 files at month end
At month end, the BAI2 file is the bank's side of the bank reconciliation.
- Check control totals: Reject files where the trailers don't match
- Load every day of the period: Including any weekend or holiday files your bank sends
- Match and apply: Clear receipts against invoices and clear unapplied cash
- Reconcile: Closing ledger balance (015) to the general ledger cash account
our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.
Common BAI2 mistakes
The most common BAI2 mistakes come from loading files without checking them.
- Skipping the trailer checks: A truncated file loads short and the reconciliation breaks
- Loading the same file twice: Duplicate receipts overstate cash; check file ID and date
- Ignoring 88 records: Remittance text you need to match payments, and extra balance or summary fields, often sit there
- Using intraday files for the close: Reconcile to the final prior-day file