BeyondERP.Newsletter
Menu

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

Print the bank statement for a period

Show the bank transactions of one bank account for a period.

Business process
Reconcile bank accounts
Menu item
output:BankAccountStatement
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 bank statement for a bank account.
What you do hereUse this report to show and print the bank transactions of one bank account for a period, for example to compare them with the statement the bank sent.
ExampleFor example, BEAT's auditor asks for the transactions of the operating account from 1 to 31 March: the report lists the 286 bank transactions with the closing figure, which is compared with the bank's March statement.
Bank statement 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 itAfter you reconcile a bank account, to view the bank statement for that account and period.
How oftenOn demand, usually once per bank statement period.
What the output showsThe bank transactions of the selected bank account between the Opening and Closing dates. A figure that differs from the bank's own statement usually means transactions are dated outside the period or haven't been posted yet.

Source: Microsoft Learn

Setup steps on this page

Print the bank statement for a period

Show the bank transactions of one bank account for a period.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Bank reconciliation reports > Bank statement.
  2. Under Period, enter the Opening date as the first date and the Closing date as the last date to show transactions for.
  3. Select the Bank account to show the statement for.
  4. Under Records to include, add further filters if you need them.
  5. Compare the transactions and closing figure with the statement the bank sent for the same period.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
OpeningThe first date of the period to show transactions for.Checked in Dynamics 36501.03.2026
ClosingThe last date of the period to show transactions for.Checked in Dynamics 36531.03.2026
Bank accountThe bank account to show the statement for.Microsoft Learn OPERATING

Common errors and fixes

MessageWhat to do
The closing figure differs from the bank's statementLook for transactions not yet on the bank's statement (run Unreconciled bank transactions) and fees on the statement not yet posted. Microsoft Learn

Test checklist

  1. Run the report for one bank account with Opening 1 March and Closing 31 March.
  2. Compare the closing figure with the bank's statement.
  3. Check that a transaction dated 1 April is not listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Print the bank statement for a periodSet Opening and Closing to the bank's statement period and select one bank account.The report is compared line by line with the bank's statement for the same dates.Which period should the report cover?Choosing dates that don't match the bank's statement period. The closing figure then never agrees.Test: Report matches the bank statement

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.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: one bank account of the current legal entity. Microsoft Learn
Can it be undoneReversible: The report changes no data.
If you change it laterThe report reads posted bank transactions; it changes nothing. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:BankAccountStatement 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:BankAccountStatement
Data migrationLoad order: The Bank statement 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.Microsoft Learn
Everyone

8Sources

To cite this step: CB-RPT-130, Print the bank statement for a period. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-130