BeyondERP.Newsletter
Menu

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

Match daily deposits with the statement

Compare deposit totals per bank account and date with the bank statement credits.

Business process
Reconcile bank accounts
Menu item
output:BankDepositByDate
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 deposits into selected bank accounts for given dates or date ranges.
What you do hereUse this report to match deposit totals per bank account and date with the credits on the bank statement before you reconcile.
ExampleFor example, the statement of the collections account shows credits of 3,300.00 on 3 October and 2,150.00 on 6 October. You run the report for that account and week and match each day's deposit total.
Deposit 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

Business processManage cash › Reconcile bank accounts
Menu pathCash and bank management › Inquiries and reports › Deposit slips › Deposit summary by date report
Set up firstDeposit slips Microsoft Learn
Used next byBank statement reconciliation: Bank accounts Microsoft Learn
Related pagesDeposit summary by customer report Microsoft Learn Deposit slip report Microsoft Learn
In this process Report bank payments by date
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 bank reconciliation, to match deposit totals per bank account with the bank statement.
How oftenOn demand, usually once per bank statement period.
What the output showsDeposit totals per bank account for each date or date range you chose. A date that differs from the bank statement often has a deposit slip that was generated with another date.

Source: Microsoft Learn

Setup steps on this page

Match daily deposits with the statement

Compare deposit totals per bank account and date with the bank statement credits.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Deposit slips > Deposit summary by date report.
  2. Under Records to include, choose the bank accounts and the deposit dates to cover.
  3. Pick a date range that matches the bank statement period you are about to reconcile.
  4. Compare the deposit total per bank account and date with the credits on the bank statement.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Bank accountThe bank accounts the report covers.Microsoft Learn The collections account
DateThe deposit dates or date ranges to report.Microsoft Learn 10/1/2026 to 10/7/2026
Pending cancellationFilter it to No to leave out deposit slips whose cancellation is entered but not posted.Microsoft Learn No

Common errors and fixes

MessageWhat to do
The daily deposit 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
Match daily deposits with the statementBank account = the account being reconciled; dates = the statement period; Pending cancellation = No.The daily totals then match the credits the bank should show.Which date range is used?Including deposits whose cancellation is pending, so a returned check shows as a deposit.Test: Daily deposits match the statement

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.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report reads the deposit slips of the current legal entity. Microsoft data model
Can it be undoneReversible: The report changes no data.
If you change it laterDeposits with a cancellation waiting for review stay in the daily totals unless filtered, and they can't be cleared on the statement until the cancellation is posted or rejected. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:BankDepositByDate 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:BankDepositByDate
Data migrationLoad order: The Deposit 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