Setup step on the Bank statement format page · Cash and bank management

Set up Bank statement format

Used so advanced bank reconciliation can read and process the statement files you import.

Used by: Accountant, Treasurer
Business process: Perform advanced bank reconciliation in Dynamics 365 Finance
Menu item: BankStatementFormat
Main table: BankStatementFormat
Data entity: BankStatementFormatEntity
Setup steps: 1 on this page

Show what matters for

Everyone

1What it is and why

What it is	A setup page where you create bank statement formats and link each one to the configuration that reads your bank's statement files.
What you do here	Used so advanced bank reconciliation can read and process the statement files you import.
Example	—

Bank statement format page in Dynamics 365 — The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process	Manage cash › Reconcile bank accounts › Perform advanced bank reconciliation in Dynamics 365 Finance
Menu path	Cash and bank management › Setup › Advanced bank reconciliation setup › Bank statement format
Set up first	—
Used next by	Bank accounts Microsoft Learn ↗
Related pages	—
In this process	—

End user · Functional consultant

3How to do it

Setup steps on this page

Set up Bank statement formatNo screenshots yet

Used so advanced bank reconciliation can read and process the statement files you import.

Microsoft's steps

Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format.
Select New.
Set the Statement format and Name fields.
Set the File type.
Select the Generic electronic import format checkbox.
In the Import format configuration field, select the configuration that matches your bank's file, such as ABR BAI2 format.
Save the record.

Source: Microsoft Learn ↗

Field guide

Field	What it means	Worked example	Table column
Statement format	The ID of the bank statement format.Microsoft Learn ↗	—	—
File type	The file type of the statement; for ZIP files it must match the files inside.Microsoft Learn ↗	—	—
Generic electronic import format	Uses an Electronic reporting configuration to import the statement.Microsoft Learn ↗	—	`UseGERConfiguration`
Processing group	The data management processing group used by the older import setup.Microsoft Learn ↗	—	—

Functional consultant

4Setup decisions

Setup step	Recommended value and why	Decision · common mistake · test
Set up Bank statement format	—	—

Solution architect

5Design impact

Shared or per company	Shared: the same records are used by every legal entity. Microsoft data model ↗
Can it be undone	—
Feature or country	—
If you change it later	The format on the bank account must match the statement file you import, or the import can fail. Microsoft Learn ↗

Technical architect

6Technical

Menu item	`BankStatementFormat` Checked in Dynamics 365
Form	`BankStatementFormat` Checked in Dynamics 365
Table	`BankStatementFormat`Shown as “Bank statement format” in Record infoKey field: FormatIdChecked in Dynamics 365
Data entities	`BankStatementFormatEntity`Bank statement format Microsoft data model ↗
Who can open it	PrivilegesMaintain bank statement format `BankStatementFormatMaintain`DutiesEnable bank management process `BankBankManagementProcessEnable` 2 security roles Accountant `LedgerAccountant`Treasurer `PaymTreasurer` Checked in Dynamics 365
Actions on the page	Options: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directly	`https://<your-environment>/?mi=BankStatementFormat`
Integrate with	`BankStatementFormatEntity` data entity Microsoft data model ↗
Table definition	`BankStatementFormat` columns and relations Microsoft data model ↗

Everyone

8Sources and checks

learn.microsoft.com/dynamics365/finance/accounts-payable/import-bai2-er
learn.microsoft.com/common-data-model/schema/core/operationscommon/tables/finance/bank/reference/bankstatementformat
learn.microsoft.com/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process
learn.microsoft.com/dynamics365/finance/cash-bank-management/configure-advanced-bank-reconciliation
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.

CB-SETUP-140 — Set up Bank statement format. Beyond ERP Atlas Hub, snapshot 2026-10-16, partly verified. https://www.beyonderp.cloud/atlas/step/CB-SETUP-140