BeyondERP.Newsletter
Menu

Setup step on the Bank account balance report page · Cash and bank management

Run the Bank account balance report at period end

Use the report to compare each bank balance in its own currency and the accounting currency.

Business process
Track cash position
Menu item
output:LedgerBankAccountBalance
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 shows the currency and balance of each bank account, together with the balance in the accounting currency.
What you do hereUse this report to see the balance of every bank account in its own currency and in the accounting currency.
ExampleFor example, at month end BEAT runs the report for its three bank accounts; the EUR account shows 25,000.00 EUR and 29,250.00 in the accounting currency, which the controller compares with the bank main account before running foreign currency revaluation.
Bank account balance 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

Business processManage cash › Track cash position
Menu pathCash and bank management › Inquiries and reports › Bank accounts › Bank account balance report
Set up firstBank accounts Microsoft Learn
Used next byForeign currency revaluation Microsoft Learn
Related pagesBalance control Microsoft Learn Bank to ledger reconciliation report Microsoft Learn
In this process Use Balance control before payment runs
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 and after bank foreign currency revaluation, or whenever you need the cash position across all bank accounts.
How oftenOn demand, typically at each period end.
What the output showsOne line per bank account with its currency, its balance in that currency and its balance in the accounting currency.

Source: Microsoft Learn

Setup steps on this page

Run the Bank account balance report at period end

Use the report to compare each bank balance in its own currency and the accounting currency.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Bank accounts > Bank account balance report.
  2. Under Records to include, choose the bank accounts to show, for example only the accounts held in a foreign currency.
  3. Read the currency of each bank account and its balance in that currency next to the balance in the accounting currency.
  4. Compare the accounting currency balances with the ledger balances of the bank main accounts; a gap on a foreign currency account often means foreign currency revaluation hasn't been run yet.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Bank accountThe bank account the line is for.Checked in Dynamics 365EUR-OPS
CurrencyThe currency of the bank account.Microsoft Learn EUR
BalanceThe balance of the bank account in its own currency.Microsoft Learn 25,000.00
Balance in accounting currencyThe balance converted to the legal entity's accounting currency; after revaluation it reflects the revalued amount.Microsoft Learn 29,250.00

Common errors and fixes

MessageWhat to do
The accounting currency balance of a foreign currency account differs from the ledger after month endRun Foreign currency revaluation for the bank account. It revalues the accounting currency balance at the exchange rate date you choose and posts the unrealized gain or loss. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Bank account balance report at period endRun it at each period end after bank foreign currency revaluation, and compare the accounting currency balance of each account with the bank main account in the trial balance.Revaluation changes the accounting currency balance of foreign currency accounts, so the report agrees with the ledger only after it is posted.When should the bank balance report be part of the period-end close?Running the report before revaluation and treating the gap on foreign currency accounts as an error. The gap is the unrealized exchange difference that revaluation posts.Test: The report agrees with the ledger after revaluation

Feature management and licence

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

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report lists the bank accounts of the legal entity you run it in; bank accounts are kept per company. Microsoft data model
Can it be undoneReversible: The report changes no data.
If you change it laterThe accounting currency balance changes when bank foreign currency revaluation is posted or reversed, so run the report after revaluation to see the revalued amounts. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:LedgerBankAccountBalance 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, 11 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:LedgerBankAccountBalance
Data migrationLoad order: The Bank account balance report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads posted bank transactions, so there is nothing to migrate; load opening bank balances through a journal instead.Microsoft Learn
Everyone

8Sources

To cite this step: CB-RPT-410, Run the Bank account balance report at period end. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-410