Table of Contents

BAI File Structure

The BAI file is a text file with a .bai file extension.

The fields in the individual BAI transaction codes will be mapped to the appropriate tables and columns in your environment. The file is then loaded into a buffer file in Business Central.

You will normally obtain a document version (e.g. pdf) of the bank statement which will be used for manual reconciliation as you can read the contents of the BAI more easily in the pdf version of the bank statement.

The BAI file can contain statement information for multiple bank accounts.

The BAI file follows a specific structure:

Record Code BAI Type Code Description
01

The File Header, which includes the following:

  • Sender ID, which identifies the bank.

  • Receiver ID, which identifies the client.

The record applies to the whole BAI file.
02

The Group Header, which includes the following:

  • Statement Date

  • Currency Code

The record applies to the whole BAI file.
03 Header for one particular bank account. The record contains summary information, which can include the following

  • Last Statement Balance

  • Statement Ending Balance

  • Currency Code

  • Various summaries and ledger balances such as group total and available balances.
16

Contains the detailed transaction information. There are hundreds of type codes as defined by the Banking Administration Institute. These codes and descriptions may vary from bank to bank.

Examples are as follows:

  • 115 Lockbox Deposit

  • 121 EDI Transaction

  • 142 Direct Deposit

  • 166 ACH Settlement

The type codes contain both summary and detailed transaction information.
16 49 Trailer record.
16 98 Trailer record.
16 99 Trailer record.