Transaction page · Cash and bank management

Bank statements

A list page where you import electronic bank statements, validate them and post the new transactions they contain.

Used by: Accounts payable manager, Auditor, Chief executive officer and 7 more roles
Business process: —
Menu item: BankStatementTableMenuItem
Main table: BankStmtISOAccountStatement
Data entity: BankStatementEntity
Setup steps: —

Show what matters for

Everyone

1What it is and why

What it is	A list page where you import electronic bank statements, validate them and post the new transactions they contain.
What you do here	Used to bring bank statements into Finance and get them ready for advanced bank reconciliation.
Example	For example, you can upload one zip file that holds several statement files, and each statement goes to the right bank account, even in other legal entities.

Functional consultant · Solution architect

Business process	—
Menu path	Cash and bank management › Bank statement reconciliation › Bank statements
Set up first	Bank accounts Microsoft Learn ↗Bank statement format Microsoft Learn ↗
Used next by	Bank reconciliation Microsoft Learn ↗
Related pages	—

End user · Functional consultant

Go to Cash and bank management > Bank statement reconciliation > Bank statements.
Select Import statement.
In the Bank account field, select the bank account that the statement belongs to.
In the Statement format field, select the bank statement format.
Select Browse, select the statement file, and then select Upload.
Select OK to import the statement.
Select Validate to check the statement before you reconcile it.

Field	What it means	Worked example	Table column
Import statement for multiple bank accounts in all legal entities	Set to Yes to import one file that holds statements for several bank accounts.Microsoft Learn ↗	—	—
Reconcile after import	When Yes, the statement is validated, a reconciliation and worksheet are created, and the default matching rules run automatically.Microsoft Learn ↗	—	—
Statement format	The format that matches the bank statement file being imported.Microsoft Learn ↗	—	—

Functional consultant

Setup step	Recommended value and why	Decision · common mistake · test
— No setup is made on this page.

Solution architect

Shared or per company	Per company: each legal entity has its own records. Microsoft data model ↗
Can it be undone	—
Feature or country	—
If you change it later	A statement with the same account, statement ID and dates as an existing one is treated as a duplicate and isn't imported. Microsoft Learn ↗

Technical architect

Menu item	`BankStatementTableMenuItem` Checked in Dynamics 365
Form	`BankAutomationStatementForm` Checked in Dynamics 365
Table	`BankStmtISOAccountStatement`Shown as “Bank statement account statement” in Record infoKey field: Identification, BankAccountTable, RegistrationId, SwiftNo, IBAN, SequenceNumberChecked in Dynamics 365
Data entities	`BankStatementEntity`Bank statement account statement Microsoft data model ↗
Who can open it	PrivilegesMaintain bank statement `BankAccountStatementMaintain`View bank statement `BankAccountStatementView`DutiesEnable bank management process `BankBankManagementProcessEnable`Review bank management process performance `BankBankManagementProcessPerfReview`Inquire into bank management reference data `BankBankMgmtReferenceDataInquire` 10 security roles Auditor `AuditPolicyManager`Chief executive officer `CompanyChiefExecutiveOfficer`Chief financial officer `CompanyChiefFinancialOfficer`Accounts receivable manager `CustInvoiceAccountsReceivableManager`Accountant `LedgerAccountant`Accounting manager `LedgerAccountingManager`Accounting supervisor `LedgerAccountingSupervisor`Financial controller `LedgerFinancialController`Treasurer `PaymTreasurer`Accounts payable manager `VendInvoiceAccountsPayableManager` Checked in Dynamics 365
Actions on the page	Options: Personalize, Page options, Edit, ShareChecked in Dynamics 365

Developer

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

Everyone