BeyondERP.Newsletter
Menu

Setup step on the Payment summary by date report page · Cash and bank management

Report bank payments by date

List the payments of a bank statement period per bank account and date.

Business process
Reconcile bank accounts
Menu item
output:BankPaymentByDate
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 of the bank payments made from a selected range of bank accounts on a range of dates.
What you do hereUse this report to list the payments of a period per bank account and date, for example to match them with the outgoing amounts on the bank statement.
ExampleFor example, the bank statement for 1 to 7 October shows outgoing payments of 18,420.00 on the operating account. You run the report for that account and those dates with Pending cancellation = No and match the daily totals.
Payment summary by date 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 itBefore or during bank reconciliation, when you need the bank payments of a period listed by bank account and date.
How oftenOn demand, for example once per bank statement period.
What the output showsBank payments listed by bank account and payment date for the period you selected. A date that doesn't agree with the bank statement usually has a payment pending cancellation or a payment posted with another date.

Source: Microsoft Learn

Setup steps on this page

Report bank payments by date

List the payments of a bank statement period per bank account and date.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Payment summary by date report.
  2. Under Records to include, filter on the bank accounts and on the payment dates of the period you want to see.
  3. Add a filter on Pending cancellation so that payments whose reversal isn't posted yet are left out of the period totals.
  4. Run the report and match the payment amounts per date against the outgoing amounts on the bank statement for those dates.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Pending cancellationFilter on this to leave out payments whose reversal isn't posted yet.Microsoft Learn No
Bank accountThe bank accounts the report covers.Microsoft Learn The operating account
DateThe payment dates the report covers; match them to the bank statement period.Microsoft Learn 10/1/2026 to 10/7/2026

Common errors and fixes

MessageWhat to do
The daily payment totals include payments whose reversal or cancellation is entered but not yet postedAdd a filter on Pending cancellation = No under Records to include. While a reviewer hasn't posted or rejected the reversal, the payment stays Pending cancellation. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Report bank payments by dateBank account = the account being reconciled; dates = the statement period; Pending cancellation = No.The report then shows the payments that should appear on that statement.Which date range is used?Choosing dates that don't match the statement period, so daily totals never match.Test: Daily payments match the statement

Feature management and licence

Licence or add-inIn this system 13 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 bank transactions of the current legal entity. Microsoft data model
Can it be undoneReversible: The report changes no data.
If you change it laterPayments still Pending cancellation are in the totals unless filtered, and they can't be cleared on the statement until the reversal is posted or rejected. Microsoft Learn
Technical architect

6Technical

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

7Developer

Open it by URLhttps://<your-environment>/?mi=output:BankPaymentByDate
Data migrationLoad order: The Payment summary by date 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

To cite this step: CB-RPT-230, Report bank payments by date. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-230