BeyondERP.Newsletter
Menu

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

Create and maintain bank accounts

Create each company bank account with its main account, bank group, status and reconciliation options.

Used by
Accounts payable manager, Chief financial officer, Accounts receivable manager and 6 more roles
Business process
Create bank accounts in Dynamics 365 Finance
Menu item
BankAccountTableListPage
Main table
BankAccountTable
Data entity
BankAccountEntity
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 enter and maintain all the information for the company's bank accounts.
What you do hereUse this page to create each company bank account, link it to its main account and bank group, set its status and active dates, and choose how it is reconciled.
ExampleFor example, BEAT opens operating account OPERATING in USD with main account 110110 and bank group of its bank; it sets Advanced bank reconciliation to Yes, Statement format to its BAI2 format and Allowed penny difference to 0.05, so a statement line of 1,000.03 still matches a payment of 1,000.00.
Bank accounts 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

Create and maintain bank accounts

Create each company bank account with its main account, bank group, status and reconciliation options.

Steps from Microsoft

  1. Go to Cash and bank management > Bank accounts > Bank accounts and select New.
  2. Enter the bank account ID, a name that identifies the account and the bank account number, and select the Bank groups value so its address and routing details are copied.
  3. Select the Main account the bank account posts to and the currency.
  4. Set Bank account status and, if needed, Active from and Active to; enter the Credit limit if the bank gives one.
  5. If the bank needs prenotes before electronic payments, select Prenote required and enter Prenote response days.
  6. On the Reconciliation FastTab, set Advanced bank reconciliation to Yes and choose the Statement format, Allowed penny difference and Default matching rule set, then save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Main accountThe general ledger account that the bank account posts to.Microsoft Learn 110110LedgerDimension
Bank groupsThe bank group whose address and routing details are copied to the bank account.Microsoft Learn BankGroupId
Prenote requiredTurn on when the bank needs a prenote before it accepts electronic payments.Microsoft Learn isBankPrenote
Prenote response daysHow many days the bank takes to process a prenote.Microsoft Learn PrenoteResponseDays
Bank account statusWhether the account is active for all transactions, inactive for new ones, or inactive for all.Microsoft Learn Active for all transactionsBankAccountStatus
Active fromThe date from which the account can be used for new transactions.Microsoft Learn ActiveFrom
Active toThe date after which the account can't be used for new transactions.Microsoft Learn ActiveTo
Credit limitThe credit amount that the bank offers on this account.Microsoft Learn OverDraftLimit
Advanced bank reconciliationTurns on electronic statement import and automatic matching for this account.Microsoft Learn
Allowed penny differenceThe largest amount difference that still counts as a match during reconciliation.Microsoft Learn 0.05BankReconAllowedPennyDifference
Statement formatThe import format used to read this account's electronic bank statements.Microsoft Learn FormatId
Clear bridged transactions during reconciliationWhen on, bridged payments are cleared to the bank automatically when the reconciliation worksheet is marked as reconciled.Microsoft Learn BankReconBridgedAutoClearing
Reconcile after importValidates the statement, creates a reconciliation and worksheet and runs the default matching rule set as soon as a statement is imported.Microsoft Learn Yes
Default matching rule setThe matching rule set that runs on the worksheet and automatically after import.Microsoft Learn
Bank name in statementsThe identifier the bank uses for this account on electronic statements; used when one file holds several accounts.Microsoft Learn

Common errors and fixes

MessageWhat to do
A new payment can't use the bank accountWith Bank account status Inactive for new transactions, or after the Active to date, no new transactions can be scheduled on the account; pending payments still go through. Check the status and the active dates. Microsoft Learn
A new bank account waits for approvalWith Bank account lifecycle management on and Change approval on creation selected, creating a bank account starts the Workflow for proposed bank account change. Submit it and have it approved. Microsoft Learn
Statement import fails for the accountThe Statement format on the bank account must match the format of the bank's file. Select the right format on the Reconciliation FastTab. Microsoft Learn

Test checklist

  1. Create the bank account with Main account, currency and Bank groups.
  2. Set Advanced bank reconciliation to Yes and select the Statement format.
  3. Import a sample bank statement and check the lines appear on the statement page.
  4. Run reconciliation with the default matching rule set and check matched lines; check amounts within Allowed penny difference still match.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Create and maintain bank accountsOne bank account per bank account held, each with its own main account; Advanced bank reconciliation = Yes with the matching Statement format for accounts with electronic statements.The workspace and the bank reports only agree with the trial balance when a main account is used by one bank account; advanced reconciliation needs the statement format that matches the bank's file.Should bank account creation and changes go through approval?Sharing one main account between several bank accounts. The bank balance then can't be reconciled to the main account's trial balance.Test: Bank account posts and reconciles

Feature management and licence

Feature to turn onBank account lifecycle management (Optional; generally available from 10.0.46)
Licence or add-inIn this system 9 roles can open this page, among them Chief financial officer, Accounts receivable manager, Payroll administrator and Accountant.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneOne-way: A bank account used in posted documents can't be deleted; retire it with its status or Active to date.
If you change it laterStatus and Active to dates stop new transactions while pending payments still go through. With Bank account lifecycle management on, changes to protected fields go through the approval workflow and are kept in the change history. Turning on Advanced bank reconciliation changes how the account is reconciled from then on. Microsoft Learn
Technical architect

6Technical

Menu itemBankAccountTableListPage Checked in Dynamics 365
FormBankAccountTable Checked in Dynamics 365
TableBankAccountTableShown as “Bank accounts” in Record infoKey field: AccountID, BankCodeType, RegistrationNum, AccountNum, BankCIN, SWIFTNo, IBAN, CompanyPaymId, DivisionPaymIdChecked in Dynamics 365
Data entitiesBankAccountEntityBank accounts Microsoft data model
Who can open itPrivilegesMaintain bank accounts BankAccountTableMaintainView bank accounts BankAccountTableViewDutiesInquire into bank accounts master BankBankAccountsInquireMaintain bank accounts master BankBankAccountsMaintain
9 security rolesChief financial officer CompanyChiefFinancialOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerPayroll administrator HcmPayrollAdministratorAccountant 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 PaymTreasurerTo use itChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantAccounting supervisor LedgerAccountingSupervisorGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Actions on the pageReconcile: ReconcileManage payments: Deposits, Remittances, Journals, Related information, Statistics, Positive paySet up: Negotiable instruments, Layout, Methods of paymentOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankAccountTableListPage
Integrate withBankAccountEntity data entity Microsoft data model
Data migrationBankAccountEntity (Bank accounts): loaded for each company, in Microsoft's default template 100 - Bank.Load order: Microsoft's default template 100 - Bank loads Bank accounts at execution unit 1, level 100, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: Currencies, Journal names, Bank groups, Customer charge groups, Reconciliation matching rule sets, the default templates at lower levels (System setup to dependency bands 30 to 90)Microsoft Learn
Table definitionBankAccountTable columns and relations Microsoft data model
Everyone

8Sources