Import Bank Statement in Dynamic 365 Finance and Operation

The Advanced bank reconciliation feature lets you import electronic bank statements and automatically reconcile them with bank transactions in Microsoft Dynamics 365 for Finance and Operations. This article explains how to set up the import functionality for your bank statements.

The setup for bank statement import varies, depending on the format of your electronic bank statement. Finance and Operations support three bank statement formats out of the box: ISO20022, MT940, and BAI2.

Set up the import of BAI2 bank statements

First, you must define the bank statement format processing group for BAI2 bank statements by using the data entity framework.

1. Go to Workspaces > Data management
2. Click Import.
3. Enter a name for the format, such as BAI2.
4. Set the Source data format field to XML-Element.
5. Set the Entity name field to Bank statements.
6. To upload import files, click Upload, and then browse to select the SampleBankCompositeEntity.xml file that you saved earlier.
7. After the Bank statements entity is uploaded and the mapping is completed, click the View map action for the entity.
8. The Bank statements entity is a composite entity that consists of four separate entities. In the list, select BankStatementDocumentEntity, and then click the View map action.
9. On the Transformations tab, click New.
10. For sequence number 1, click Upload file, and select the BAI2CSV-to-BAI2XML.xslt file that you saved earlier.
11. Click New.
12. For sequence number 2, click Upload file, and select the BAI2XML-to-Reconciliation.xslt file that you saved earlier. Note:Finance and Operations transformation files are built for the standard format. Because banks often diverge from this format, and you may have to update the transformation file to map to your bank statement format.
13. Click New.
14. For sequence number 3, click Upload file, and select the BankReconciliation-to-Composite.xslt file that you saved earlier.
15. Click Apply transforms.

After the format processing group is set up, the next step is to define the bank statement format rules for BAI2 bank statements.

1. Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format.
2. Click New.
3. Specify a statement format, such as BAI2.
4. Enter a name for the format.
5. Set the Processing group field to the group that you defined earlier, such as BAI2.
6. Set the File type field to txt.

The last step is to enable Advanced bank reconciliation and set the statement format on the bank account.

1. Go to Cash and bank management > Bank accounts.
2. Select the bank account, and open it to view the details.
3. On the Reconciliation tab, set the Advanced bank reconciliation option to Yes.
4. When you're prompted to confirm your selection and enable Advanced bank reconciliation, click OK.
5. Set the Statement format field to the format that you created earlier, such as BAI2.

-----------------------

Download Sample File and setup Files