BeyondERP.Newsletter
Menu

Setup step on the Bank statements page · Cash and bank management

Import and validate bank statements

Import each electronic bank statement and validate it before reconciliation.

Used by
Accounts payable manager, Auditor, Chief executive officer and 7 more roles
Business process
Perform advanced bank reconciliation in Dynamics 365 Finance
Menu item
BankStatementTableMenuItem
Main table
BankStmtISOAccountStatement
Data entity
BankStatementEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page where you import electronic bank statements, validate them and post the new transactions they contain.
What you do hereUse this page to bring bank statements into Finance and get them ready for advanced bank reconciliation.
ExampleFor example, BEAT uploads one zip file holding the BAI2 statements of three bank accounts, two of them in another legal entity, with Import statement for multiple bank accounts in all legal entities = Yes; each statement goes to its own account and, with Reconcile after import = Yes, is validated and its default matching rule set runs.
Bank statements page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Import and validate bank statements

Import each electronic bank statement and validate it before reconciliation.

Steps from Microsoft

  1. Go to Cash and bank management > Bank statement reconciliation > Bank statements and select Import statement.
  2. For one account, set Import statement for multiple bank accounts in all legal entities to No and select the bank account; for a file or zip with several accounts, set it to Yes.
  3. Select Browse, choose the statement file, select Upload and then OK.
  4. Set Reconcile after import to Yes if the statement should be validated and matched straight away.
  5. Otherwise select Validate (and Confirm when Modern bank reconciliation is on) before you reconcile.
  6. After reconciliation, post the lines marked as New from this page; posting can be done once per statement.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Import statement for multiple bank accounts in all legal entitiesSet to Yes to import one file that holds statements for several bank accounts.Microsoft Learn Yes
Reconcile after importWhen Yes, the statement is validated, a reconciliation and worksheet are created, and the default matching rules run automatically.Microsoft Learn Yes
Statement formatThe format that matches the bank statement file being imported.Microsoft Learn

Common errors and fixes

MessageWhat to do
The statement isn't imported because it is a duplicateA statement with the same bank account, statement ID, from date and to date already exists. Import only new statements, or check whether the bank resent a file. Microsoft Learn
Validation fails on the opening balanceThe opening balance must equal the closing balance of the previous statement for the account, and dates must not overlap another statement. Import any missing statement first. Microsoft Learn
Import of bank statements was unsuccessful for specific bank accountsStatements that can't be tied to exactly one bank account by bank name, account number, routing number, SWIFT or IBAN aren't imported. Check those values on the bank account, and that the user has access to the account's legal entity. Microsoft Learn

Test checklist

  1. Import a statement for one account and select Validate.
  2. Check the status changes to Validated (and Confirm it when Modern bank reconciliation is on).
  3. Import the same file again and check it's rejected as a duplicate.
  4. Import a zip with statements of two accounts in different legal entities and check each lands on its own account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Import and validate bank statementsImport daily with Reconcile after import = Yes on each bank account, and use a zip file with Import statement for multiple bank accounts in all legal entities = Yes when one bank sends several accounts.Reconcile after import validates the statement, creates the reconciliation and runs the default matching rule set, leaving only the lines that need manual matching.Should statements be reconciled automatically after import?Skipping a statement. The next one fails validation because its opening balance doesn't equal the previous closing balance.Test: Statement imports and validates

Number sequences

ReferenceShared or per companyNote
Download IDSet on Cash and bank management parameters > Number sequences before the first statement import. Microsoft Learn
Statement IDSet on Cash and bank management parameters > Number sequences before the first statement import. Microsoft Learn
Reconcile IDSet on Cash and bank management parameters > Number sequences before the first statement import. Microsoft Learn
Bank reconciliationSet on Cash and bank management parameters > Number sequences before the first statement import. Microsoft Learn

Feature management and licence

Feature to turn onModern bank reconciliation (On by default from 10.0.43)
Licence or add-inIn this system 10 roles can open this page, among them Auditor, Chief executive officer, Chief financial officer and Accounts receivable manager.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Posting of New lines happens once per statement.
If you change it laterA validated statement becomes the basis of the reconciliation; its lines marked as New are posted from here once, and a posted statement can only be reversed with the Reverse posted bank statement with new transactions feature. Microsoft Learn
Technical architect

6Technical

Menu itemBankStatementTableMenuItem Checked in Dynamics 365
FormBankAutomationStatementForm Checked in Dynamics 365
TableBankStmtISOAccountStatementShown as “Bank statement account statement” in Record infoKey field: Identification, BankAccountTable, RegistrationId, SwiftNo, IBAN, SequenceNumberChecked in Dynamics 365
Data entitiesBankStatementEntityBank statement account statement Microsoft data model BankStatementImportEntityBank statements (Composite entity that imports a whole statement file: statement document, statement, balances and lines.) BankStatementDMFEntityBank statement header (Bank statement header only (statement ID, bank account, currency, balances and dates).) BankStatementLineDMFEntityBank statement lines (Bank statement lines only.)
Who can open itPrivilegesMaintain bank statement BankAccountStatementMaintainView bank statement BankAccountStatementViewDutiesEnable bank management process BankBankManagementProcessEnableReview bank management process performance BankBankManagementProcessPerfReviewInquire into bank management reference data BankBankMgmtReferenceDataInquire
10 security rolesAuditor AuditPolicyManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerTreasurer PaymTreasurerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTreasurer PaymTreasurerAccountant LedgerAccountantTo use itChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccounting supervisor LedgerAccountingSupervisorAccounts receivable manager CustInvoiceAccountsReceivableManagerGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankStatementTableMenuItem
Integrate withBankStatementEntity data entity Microsoft data model
Data migrationBankStatementDMFEntity (Bank statement header): STATEMENTID, BANKACCOUNT, CURRENCY, OPENINGBALANCE, ENDINGBALANCE, FROMDATE, TODATE.BankStatementLineDMFEntity (Bank statement lines): LINENUMBER, BANKACCOUNT, STATEMENTID, BOOKINGDATE, AMOUNT, BANKSTATEMENTTRANSACTIONCODE and the other line fields.Load order: Load the statement header before its lines. Statements are usually imported from the bank's file with Import statement rather than migrated.Load first: Bank accountsMicrosoft Learn
Table definitionBankStmtISOAccountStatement columns and relations Microsoft data model
Everyone

8Sources