Skip to content

What is a BAI2 file? Definition, format, and example

Accounts receivable, billing and collections

Definition

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.

RecordNameWhat it holds
01File headerSender, receiver, file creation date and time
02Group headerBank, as-of date, currency
03Account identifierAccount number and balance or summary codes
16Transaction detailOne transaction: type code, amount, references
88ContinuationContinuation of fields or text from the preceding record
49Account trailerAccount control total and record count
98Group trailerGroup control total, accounts, and records
99File trailerFile 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.

CodeMeaning
010Opening ledger balance
015Closing ledger balance
045Closing available balance
100Total credits
195Incoming money transfer
400Total debits
475Check paid
495Outgoing 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/
CheckAmount
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.

DateAccountDebitCredit
Nov 2, 2026Cash15,000
Accounts receivable, Bayside Builders15,000
Nov 2, 2026Cash5,000
Unapplied cash5,000
Total20,00020,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.

TermWhat it isHow it differs from BAI2
MT940SWIFT customer statement messageUsed by banks worldwide; BAI2 is mainly US
camt.053ISO 20022 XML bank-to-customer statementStructured XML with richer remittance data
BTRS (X9.121)Balance and Transaction Reporting Standard from X9The ANSI standard written as an update to BAI2
Lockbox fileBank file of checks and remittance data from a lockboxDetail 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.

  1. Check control totals: Reject files where the trailers don't match
  2. Load every day of the period: Including any weekend or holiday files your bank sends
  3. Match and apply: Clear receipts against invoices and clear unapplied cash
  4. 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