BeyondERP.Newsletter
Menu

Setup step on the Bank to ledger reconciliation report page · Cash and bank management

Prove the bank subledger to the ledger at period end

Compare bank transactions with the bank main accounts before closing the period.

Business process
Reconcile bank accounts
Menu item
output:BankLedgerReconciliation
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 report that compares the bank transactions of each bank account with the general ledger transactions on its main account and shows the differences.
What you do hereUse this report at period end to prove that the bank subledger agrees with the bank main accounts in the general ledger.
ExampleFor example, at March close BEAT runs the report with Differences only = Yes: one line shows a difference of 150.00 on main account 110110, a manual general journal entry posted to the bank main account without a bank transaction.
Bank to ledger reconciliation report 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.

When to run it

When to run itAt period end, before you close the period, to prove that bank transactions agree with the general ledger.
How oftenAt each period end, and again after you correct a difference.
What the output showsBank balance, ledger balance and difference for each bank summary account, with voucher lines when Include details is Yes. A difference means a voucher reached the main account without a matching bank transaction, or the other way round. Microsoft's Account reconciliation workspace can do this comparison on a schedule.

Source: Microsoft Learn

Setup steps on this page

Prove the bank subledger to the ledger at period end

Compare bank transactions with the bank main accounts before closing the period.

How to use it

  1. Go to Cash and bank management > Periodic tasks > Bank to ledger reconciliation report.
  2. Enter the From and To dates of the period, and a Voucher if you investigate one posting.
  3. Enter a Main account range, or leave it empty to show only the summary accounts set on the bank accounts.
  4. Set Include details to Yes for voucher lines with bank balance, ledger balance and difference, and Differences only to Yes to list only lines that don't agree.
  5. Leave Currency at Accounting currency unless you reconcile in another currency, run the report and correct each difference.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExample
Main accountThe main account range; when left empty, only the summary accounts set on the bank accounts are shown.Checked in Dynamics 365110110
Include detailsShows transaction lines with voucher, bank balance, ledger balance and difference.Checked in Dynamics 365Yes
Differences onlyShows only the lines that have reconciliation differences.Checked in Dynamics 365Yes
Correction linesWhen a bank transaction was corrected during reconciliation, the report shows two bank lines, the original and the correction, matching the two general ledger lines.Microsoft Learn

Common errors and fixes

MessageWhat to do
Differences appear although every bank transaction is postedThe bank balance and the main account only agree when the main account is used by one bank account and all postings to it have posting type Bank. Look for manual journal entries posted straight to the main account. Microsoft Learn

Test checklist

  1. Run the report for the closed month with Differences only = Yes.
  2. Post a general journal line straight to the bank main account and run it again.
  3. Check the new line shows as a difference with its voucher.
  4. Reverse the test entry and check the difference is gone.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Prove the bank subledger to the ledger at period endRun it at each period end with Differences only = Yes and close the period only when no line is listed.A bank main account must hold only postings made through its bank account, or the bank and ledger balances drift apart.Should the bank main accounts be blocked for manual posting?Leaving the bank main accounts open for manual posting. Manual entries create ledger amounts with no bank transaction; block them for manual entry.Test: No difference after a normal period

Feature management and licence

Licence or add-inIn this system 10 roles can open this page, among them Treasurer, Chief financial officer, Accounting manager and Financial controller.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the bank accounts and main accounts of the current legal entity. Microsoft Learn
Can it be undoneReversible: The report changes no data.
If you change it laterThe report reads only. Differences are fixed with journal entries through the bank account, so the bank transaction and the ledger entry are created together. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:BankLedgerReconciliation Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itTreasurer PaymTreasurerChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 10 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:BankLedgerReconciliation
Data migrationLoad order: The Bank to ledger reconciliation report has no data entity in Data management, so it can't be loaded from a file or a configuration template. Post the opening bank balance through a journal to the bank account, not straight to the main account, so the report agrees from the first day.Microsoft Learn
Everyone

8Sources

To cite this step: CB-RPT-140, Prove the bank subledger to the ledger at period end. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-140