BAI2 statement format – knowledgebase JJ

BAI2, also called the “Bank Administration Institute Version 2”, is the upgraded version of the BAI file format.

It was introduced by the “Bank Administration Institute”, based in the US, to facilitate previous day reporting of account balance information to clients and their agents, for activities that have occurred on a client’s accounts.

The main objective of the BAI2 file format is to provide clients with structured, machine-readable account information that can be consumed and processed by client systems automatically, to provide sufficient account information to support their business needs including automated account reconciliation processes (i.e. ERP “Electronic Reconciliation Processing” systems like SAP, MYOB etc).

Format overview

The following diagram depicts the BAI2 file layout.

Sample – Record 01:

01,WPACAU2DK,WIBSCUST,060302,1301,01,080,,2/

Meaning: The sender Bank Westpac (WPACAU2DK) is sending data to receiver (WIBSCUST) on 2nd Mar 2006 13:01 hrs. This is the first file of the day, with physical record length of 080 and in BAI file version number 2.

Record 02 – Group header

Sample 02 Record:

02,WIBSCUST,WPACAU2DK,1,060302,,AUD,2/

Meaning: The receiver (WIBSCUST) is receiving update data (1) from sender Bank Westpac (WPACAU2DK) on 2nd Mar 2006 in Australian dollars for the previous day.

Record 03 – Account identifier and summary status

Sample 03 Record:

03,032000000007,AUD,010,300000,,,015,-100000,,,045,765000,,,/

88,100,9760000,1,,400,503333,2,/

Meaning: The following account information for Customer account 032000000007 has been reported within this record.

Opening Balance of 3000.00 AUD.
Closing Balance of -10000.00 AUD.
Available Closing Balance of 7650.00 AUD.
Total value of Credit transactions is 97600.00 AUD, with 1 transaction.
Total value of Debit transactions is 5033.33 AUD, with 2 transactions.

Record 16 – Transaction detail

Record 88 – Continuation

Sample 03 Record Continuation:

03,032000000007,AUD,010,904444445,,,015,904444453,,,045,904444453,,,100,200000/

88,10,,400,500000,10,/

Sample 16 Record Continuation:

16,698,90000,Z,0000050000,/

88,YOUR REFERENCE: IA000000000

Record 49 – Account trailer

Sample 49 Record:

49,98530055,8/

Meaning: The total value of amounts reported for this account is 985300.55 AUD, over 8 records.

Record 98 – Group trailer

Sample 98 Record:

98,1093333111333,28,117/

Meaning: The total value of amount reported for this group is 10933331113.33 AUD, for 28 accounts reported in 117 records.

Record 99 – File trailer

Sample 99 Record:

99,1093333111333,10,315/

Meaning: The total value of amount reported for this file is 10933331113.33 AUD, for 10 groups reported in 315 records.

Type codes

Account status – Type codes

Account summary – Type codes

Format variations

Enrichment support

If you receive a data-enriched (bulked, reconciled or debulked) statement there will be some modifications to the Transaction Detail records.

Bulked/reconciled enrichment

For bulked and reconciled enrichment, the following modifications will be applied to the 16 record:

Bank Reference: This field will be populated with a unique, BankRec-generated transaction identifier.
Customer Reference: This field will be populated with the Batch Payment Reference Code.

Debulked recievables enrichment

For debulked recievables enrichment, the following modifications will be applied to the 16 record:

Each 16 record that previously represented a bulk settlement record will be replaced with multiple 16 records representing each transaction that formed the bulk settlement.
Bank Reference: This field will be populated with the Customer Reference Number.
Customer Reference: This field will be populated with the Payment Reference Code.

Debulked payables enrichment

For debulked payables enrichment, the following modifications will be applied to the 16 record:

Each 16 record that previously represented a bulk settlement record will be replaced with multiple 16 records representing each transaction that formed the bulk settlement.
Bank Reference: This field will be populated with the Payer Reference.
Customer Reference: This field will be populated with the Payee Reference.

External entry enrichment

For external entry enrichment (i.e, transactions enriched with information from an external EFT feed), the following modifications will be applied to the 16 record:

Bank Reference: This field will be populated with the Customer Code sourced from the external feed.
Customer Reference: This field will be populated with the Remitter Name sourced from the external feed.

If you require further enrichment (transaction code manipulation, alternate reference values, etc.), you should discuss this during your implementation.