Bank Deposit Report
June 30, 2025
all plans
This article shows how to run the Bank Deposit Report, and includes examples of the report run in the detail and summary layout.
Running the Bank Deposit Report
You can access the Bank Deposit Report from the Reports Center.
- Click the
Reports menu. - On the NextGen tab, click the Bank Deposit Report.
- Specify your desired options on the following tabs:
- Filter
- Sort
- Display Options
- Click Run Report. The report will be opened in a new window.
For additional information on using the Reports Center, see the Reports Overview article.
Filter
The Filter tab allows you to limit information shown on the report depending on one or more criteria. For example, you can limit transactions based on the date of the deposit and/or the client they are assigned to. The following options are available:
- All Dates – Select a date option by day, week, month, quarter, or year; select Custom and enter the Date From and Date To; or select All to include all dates.
- Clients – Select the client(s) you want to be included on the report, or select All Clients. Optionally select the Include Inactive Clients check box.
- Originator – Select the originator you want to be included on the report, or select All Originators.
- Billing Partners – Select the billing partner(s) you want to be included on the report, or select All Partners.
Sort
The Sort tab allows you to change the order and the grouping of information shown on the report depending on one or more criteria. For example, you can show detailed or summary information, sorted by date but grouped by client, with or without a total for the group. The following options are available:
- Sort by – Select the field used to sort the records on the report.
- Sort Order – Select whether you want the report to be sorted in Ascending or Descending order.
- Group by – Select whether you want records grouped by Deposit Date or Bank.
- Group Sort Order – Select whether you want the groups to be sorted in Ascending or Descending order.
- Sub-Group by – The option not selected in the Group by field is automatically selected for the Sub-Group by field.
- Sub-Group Sort Order – Select whether you want the sub-group to be sorted in Ascending or Descending order. (Note: Sub-Group Sort Order is only available if the Layout is set to Detailed)
Display Options
The Display Options tab shows additional options for the report. For example, you may be able to include or exclude a total for all records on the report. The options available depend on the selected report.
- Layout – Select if you want a Detailed report, or a Summary report.
- The Detailed report includes the deposit information. Columns include the Deposit Date, Payment Date, Client, Client #, Bank, Ref #, Memo, and Amount.
- The Summary report displays the total deposits by Group. Columns include the Deposit Date, Bank, Memo, and Amount.
- Display Report Total – Select this check box if you want to display a total at the bottom of the report.
- Display Group Total – Select this check box if you want to display a total for each group. (Note: Display Group Total is only available if the Layout is set to Detailed)
- Display Sub Group Total – Select this check box if you want to display a total for each sub-group. (Note: Display Sub Group Total is only available if the Layout is set to Detailed)
Examples of the Bank Deposit Report
This report can be run using a Detailed or Summary layout.
Detailed Report
The Detail Open Retainer Invoice report provides a list of all deposits for the selected criteria. Columns include the Deposit Date, Payment Date, Client, Client #, Bank, Ref #, Memo, and Amount.
Summary Report
The Summary Open Retainer Invoice report includes a summarized list of deposits for the selected criteria. Columns include the Deposit Date, Bank, Memo, and Amount.
Common Questions
- The NextGen Reports tab is not available. Why?
- The NextGen Reports feature has recently completed development and is now in the process of being rolled out to users. If you are unable to access this feature, please contact Mango Support and they can work to make this available for you.
- I can’t always see the NextGen Reports tab. How can I access it?
- On some devices, the screen does not show enough space for the NextGen Reports tab to be displayed. Try decreasing the Zoom setting in your browser to provide more space.
- Can we change the orientation of the NextGen reports?
- No, NextGen reports print in landscape in order for all columns to fit on the page.