Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Dynamics 365 for Operations – Import Bank Statement using BAI2 format

***[BRIEF DESCRIPTION] ***

Import Bank statement for multiple bank using BAI2 format.

1. Login to Visual studio to download following files and save them in local drive:

2. Set up BAI2 bank statements format from System administration > Data management

3. Create Bank statement format from Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format.

4. Create 3 bank account with Advance bank reconciliation setup from Cash and bank management > Bank accounts.

5. Import Bank statement from Cash and bank management > Bank statement reconciliation > Bank statements

1. Login to Visual studio to download following files and save them in local drive:

Resource name File name
BankStmtImport_BAI2CSV_to_BAI2XML_xslt BAI2CSV-to-BAI2XML.xslt
BankStmtImport_BAI2XML_to_Reconciliation_xslt BAI2XML-to-Reconciliation.xslt
BankStmtImport_BankReconciliation_to_Composite_xslt BankReconciliation-to-Composite.xslt
BankStmtImport_SampleBankCompositeEntity_xml SampleBankCompositeEntity.xml

Go to Visual studio > resource


Search for BankStmtImport_BAI2CSV_to_BAI2XML_xslt

Verify BankStmtImport_BAI2CSV_to_BAI2XML_xslt is filtered

Double click on BankStmtImport_BAI2CSV_to_BAI2XML_xslt (to save the record)

Click on File > ‘save as’ to save the file in local drive.


Similarly search and save other files (mentioned above) in local drive

2. Set up BAI2 bank statements format from System administration > Data management:


Click Import.


Enter a name for the format, such as BAI2.

Set the Source data format field to XML-Element.

Set the Entity name field to Bank statements.


To upload import files, click Upload, and then browse to select the SampleBankCompositeEntity.xml file that has been saved earlier step in local drive.

Click the View map action for the entity.

Verify the Bank statements entity is a composite entity that consists of four separate entities. In the list, select BankStatementDocumentEntity.

Click the View map action.

Click New > Transformations tab

Click Upload file, and select the BAI2CSV-to-BAI2XML.xslt file that you saved earlier.

Click New

Click Upload file, and select the BAI2XML-to-Reconciliation.xslt file that you saved earlier.

Click New to create a new record

Click Upload file, and select the BankReconciliation-to-Composite.xslt file that you saved earlier.

Click Apply transforms.

3. Create Bank statement format from Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format.

Click on new to create a new record

Statement format: BAI2

Name: BAI2

Processing group: BAI2

Set the File type field to txt


4. Create 3 bank account with Advance bank reconciliation setup from Cash and bank management > Bank accounts.

Click on new to create a new account

Bank Account: CBA1

Routing number: 400012

Bank account number: 222222

Main account: 110110

Name: CBA1

Currency: USD

Reconciliation > Advanced bank reconciliation: Yes

Reconciliation >Statement format: BAI2

Save the record.


Close the form.

Click on new to create another Bank account

Bank account: CBA2

Routing number: 400013

Bank account number: 333333

Main account: 110110

Name: CBA2

Currency: USD

Reconciliation > Advanced bank reconciliation: Yes

Reconciliation >Statement format: BAI2

Save the record.


Close the form.

Click on new to create another Bank account

Bank account: CBA3

Routing number: 400014

Bank account number: 444444

Main account: 110110

Name: CBA3

Currency: USD

Reconciliation > Advanced bank reconciliation: Yes

Reconciliation >Statement format: BAI2

Save the record.


Close the form.

5. Import Bank statement from Cash and bank management > Bank statement reconciliation > Bank statements


Click on import statement

Statement format: BAI2

Browse the file need to import


Click on upload from ‘import bank statements’ form


Click ok

NOTE: The bank accounts are created with numbers 222222, 333333, and 444444, so that is what needs to go into the BAI2 file. bank statements imported successfully after updating the bank account numbers in the bank statement import file to use bank accounts (222222, 333333, 444444), and left the bank account field blank in the import dialog.