BeyondERP.Newsletter
Menu

Setup step on the Check statistics page · Cash and bank management

Review check activity for a period

Run Check statistics for a date range before the bank reconciliation.

Business process
Cancel supplier payments
Menu item
output:BankChequeStatistics
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 on the checks of the company's bank accounts for a date range that you set with a From date and a To date.
What you do hereUse this report to look at check activity for a period, for example the checks issued in a month, before you reconcile the bank accounts.
ExampleFor example, at the end of October you run Check statistics from 1 October to 31 October to review the checks written from the operating account before you reconcile its October statement.
Check statistics 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 accounts payable › Cancel supplier payments
Menu pathCash and bank management › Inquiries and reports › Check statistics
Set up firstChecks Microsoft Learn
Used next byBank statement reconciliation: Bank accounts Microsoft Learn
Related pagesPayment summary by date report Microsoft Learn
In this process Look up checks and their status
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 itWhen you need an overview of check activity for a period, for example at month end before you reconcile the bank accounts.
How oftenOn demand, when you review check activity for a date range.
What the output showsCheck statistics for the period between the From date and To date. Totals that look too low usually mean that some checks are dated outside the range you entered.

Source: Microsoft Learn

Setup steps on this page

Review check activity for a period

Run Check statistics for a date range before the bank reconciliation.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Check statistics.
  2. Under Parameters, enter the From date of the first check date to include.
  3. Enter the To date, for example the last day of the month you report on.
  4. Run the report and compare its checks with the Checks page for the same bank account and dates.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From dateThe first check date included in the report.Checked in Dynamics 36510/1/2026
To dateThe last check date included in the report.Checked in Dynamics 36510/31/2026

Common errors and fixes

MessageWhat to do
Checks you expect are missing from the reportThe report selects by check date between From date and To date. Unused checks have no date; check the date range and the check status on the Checks page. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review check activity for a periodFrom date and To date = the bank statement period you are about to reconcile.Matching the period to the statement lets you compare the checks the report shows with the checks on the statement.When is Check statistics run?Using a date range that doesn't match the statement period, so the check list and the statement can't be compared.Test: Check statistics for one month

Feature management and licence

Licence or add-inIn this system 8 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 reads the checks of the current legal entity. Microsoft data model
Can it be undoneReversible: The report changes no data.
If you change it laterThe report only reads checks. Which checks it shows depends on the check dates, so unused checks without a date don't count. Microsoft Learn
Technical architect

6Technical

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

7Developer

Open it by URLhttps://<your-environment>/?mi=output:BankChequeStatistics
Data migrationLoad order: The Check statistics 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 data in each environment, so there is nothing to load for it. Migrate the transactions it reports on instead (for example open checks and deposits as part of the opening bank balances).Checked in Dynamics 365
Everyone

8Sources