Trust on Hold Report

The Trust on Hold Report screen is divided into two sections; System Parameters and User Parameters. In the System Parameters section, the user must specify details for the format of the report; in the User Parameters section, the user must specify details pertaining to the content of the report. For general information on running reports and on defining System Parameters, please refer to the Running Reports help document.

Report Description

The Trust on Hold Report is produced for a user specified Office and range of Departments within that Office. The user can also specify a range of Clients and a range of Hold Dates (i.e. the date on which the Trust Funds will be released from Hold). The report can be generated in either Detail or Summary format, and the user can specify whether the report contents be sorted numerically or alphabetically.

For each Client/Matter carrying a Trust balance on Hold, the following information is displayed: Client Number and Name, Matter Number and Name, Bank Account Number and Name, Release Date, Journal Type and Number, amount of Retainer Trust, and the amount of Allocated Trust. Retainer and Allocated Trust Totals are displayed for each Client/Matter, and for the report as a whole. The information is sorted first by Client, then by Matter, and then by Bank Account.

The report output can be generated into an Excel spreadsheet file, or in the same manner as most other reports (i.e. format selected in the System Parameters section). When generating an Excel file, the user must specify the full path and file name (i.e. c:\My Documents\Trust on Hold.xls). Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output in addition to output in another format.

User Parameters

Show Office/Dept
From the list provided, the user must select whether or not report information will be grouped by Office and Department. Valid options are "Y" (i.e. show Office and Department names) and "N" (i.e. do not show Office and Department names). This field defaults to the "Y" option.

Office
From the list provided, the user must select the Office for which the report will be produced. The names of all Offices associated with your Firm will be displayed in the list. To include all Offices in the report, the user must select the "Select All" option. This field defaults to the Select All option.

Department X to X
From the lists provided, the user must select the range of Departments to be included in the report. The names of all Departments associated with your Firm will be displayed in the list. The user also has the option to manually enter the unique identifiers of the Departments. To include all Departments in the report, the user must select the "Select All" option in both fields. These fields default to the Select All option.

Client X to X
The user must manually enter the range of Clients for whom the report will be produced. These fields default to the unique identifiers of the first and last possible Clients (i.e. by default, all Clients will be included in the report).

Hold X to X
The user must manually define the range of Hold Dates (i.e. the date on which the Trust Funds will be released from Hold) for which the report will be produced. The start date defaults to the current system date, and the end date defaults to five days past the current system date.

Report Type
From the list provided, the user must select the format by which the report will be produced. Valid options are Detail and Summary. The user also has the option to manually enter their choice. This field defaults to the Detail option.

Sort By
From the list provided, the user must select the order in which records will be sorted and displayed. Valid options are by Client Number (i.e. sorted numerically based on Client Number), or by Client Name (i.e. sorted alphabetically based on Client Name). This field defaults to the Client Number option.

Create Excel Output
To send the report contents to an Excel spreadsheet file, the user must select the "Y" (i.e. Yes) option form the drop down list provided. This field defaults to the "N" (i.e. No) option. Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output as well as output in another format.

Excel Destination
If the user has selected to send the report contents to an Excel spreadsheet file, they must then specify the exact path and name for that file (i.e. c:\My Documents\Trust_on_Hold.xls).