BeyondERP.Newsletter
Menu

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

Reconcile a bank account with Account reconciliation

Reconcile bank accounts that don't use advanced bank reconciliation against each statement.

Used by
Accounts payable manager, Chief financial officer, Accounts receivable manager and 6 more roles
Business process
Reconcile bank accounts
Menu item
BankAccountTableListPage
Main table
BankAccountTable
Data entity
None for this page's own settings
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 isThe Bank accounts list opened from the Bank statement reconciliation menu, where you start the reconciliation of a bank account that doesn't use advanced bank reconciliation.
What you do hereUse this page to reconcile a bank account with its bank statement through Reconcile > Account reconciliation, and to reach the bank statements of accounts that use advanced bank reconciliation.
ExampleFor example, BEAT's petty cash bank account doesn't use advanced bank reconciliation: for the March statement with an ending balance of 15,240.00 the accountant marks 37 cleared transactions, adds a 25.00 bank fee and selects Reconcile account when Unreconciled reaches 0.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

Reconcile a bank account with Account reconciliation

Reconcile bank accounts that don't use advanced bank reconciliation against each statement.

Steps from Microsoft

  1. Go to Cash and bank management > Bank statement reconciliation > Bank accounts, select the bank account and select Reconcile > Account reconciliation.
  2. Enter Bank statement date and Bank statement, and the statement's ending balance in Ending balance.
  3. Select Transactions and select Cleared for each transaction on the statement, or use Mark check interval or Mark all as cleared.
  4. Enter any difference in Correction amount, and add lines for fees and interest that are on the statement but not in Finance, with their bank transaction type.
  5. When Unreconciled reaches zero, select Reconcile account. Accounts with Advanced bank reconciliation = Yes are reconciled on Bank reconciliation instead.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Main accountThe general ledger account that the bank account posts to.Microsoft Learn LedgerDimension
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 BankAccountStatus
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 BankReconAllowedPennyDifference
Statement formatThe import format used to read this account's electronic bank statements.Microsoft Learn BankStatementFormat
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
Ending balanceThe bank account balance as it appears on the bank statement.Microsoft Learn 15,240.00
ClearedSelect it for each transaction that is on the statement with the same amount; not available while a reversal is Pending cancellation.Microsoft Learn
Correction amountThe difference when the amount on the statement differs; can't be used when the transaction's fiscal period is closed.Microsoft Learn 0.03

Common errors and fixes

MessageWhat to do
The Cleared checkbox can't be selected for a transactionThe check or deposit slip payment has status Pending cancellation. A reviewer must post or reject the reversal on Payment reversal approvals first. Microsoft Learn
Correction amount can't be enteredThe fiscal period of the transaction is closed. Add a correction line dated in an open period with the original financial dimensions and the offset main account. Microsoft Learn

Test checklist

  1. Start Account reconciliation with the statement date and ending balance.
  2. Mark the statement's transactions as Cleared and add a 25.00 fee line with its bank transaction type.
  3. Check that Unreconciled is 0.00 and select Reconcile account.
  4. Run Unreconciled bank transactions and check only the transactions not on the statement are listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Reconcile a bank account with Account reconciliationReconcile each statement in date order, clear only transactions on the statement and add fees and interest as lines with their bank transaction type.Reconciled transactions are locked and drop out of later reconciliations, so clearing a transaction that isn't on the statement hides a difference.Which bank accounts are reconciled with Account reconciliation rather than advanced bank reconciliation?Clearing transactions that aren't on the bank statement to reach zero. They then never show again for reconciliation.Test: Account reconciliation posts and locks transactions

Feature management and licence

Licence or add-inIn this system 9 roles can open this page, among them Chief financial officer, Accounts receivable manager, Payroll administrator and Accountant.

Checked in Dynamics 365

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: Cancel only in entry order and with Allow bank statement edit on.
If you change it laterAfter the reconciliation is posted, its transactions can't be changed or corrected and don't show in later reconciliations. A posted reconciliation can only be cancelled, in the order it was entered, with Allow bank statement edit on in the parameters. 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 (The bank account and its reconciliation settings; reconciliations themselves aren't loaded.) 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
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