Cash and bank managementInquiries and reportsDeposit slips
output:BankDepositByDate
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 is
A report of the deposits into selected bank accounts for given dates or date ranges.
What you do here
Use this report to match deposit totals per bank account and date with the credits on the bank statement before you reconcile.
Example
For 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.
The page in Dynamics 365. page title tab to open what to set or check
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 it
Before bank reconciliation, to match deposit totals per bank account with the bank statement.
How often
On demand, usually once per bank statement period.
What the output shows
Deposit 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.
Filter it to No to leave out deposit slips whose cancellation is entered but not posted.Microsoft Learn
No
Common errors and fixes
Message
What to do
The daily deposit totals include payments whose reversal or cancellation is entered but not yet posted
Add 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
Bank account = the account being reconciled; dates = the statement period; Pending cancellation = No.The daily totals then match the credits the bank should show.
Per company: the report reads the deposit slips of the current legal entity. Microsoft data model
Can it be undone
Reversible: The report changes no data.
If you change it later
Deposits 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 item
output:BankDepositByDateChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load 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
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.
To cite this step: CB-RPT-260, Match daily deposits with the statement. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-260