Setup page · Cash and bank management

Bank statement format

A setup page where you create bank statement formats and link each one to the configuration that reads your bank's statement files.

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	—

Functional consultant · Solution architect

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	—

End user · Functional consultant

Set up Bank statement formatNo screenshots yet

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

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.

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

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

Solution architect

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

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

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