Detail Trust Listing Report

The Detail Trust Listing 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 Detail Trust Listing Report can be generated in two different formats; by Trust Bank or by Office and Department. When generated by Trust Bank, report content is sorted by Bank Number first, and then by Client and Matter Number. When generated by Office and Department, report content is sorted by Office Number first, and then by Departments within each Office. Information is then further sorted by Bank Number, Client Number, and Matter Number.

The report displays all Trust transactions for each Client/Matter. Report details include the following: Bank Number and Name, Client Number and Name, Matter Number and Name, Journal Type, Transaction Description, Trust Type (i.e. Retainer/Allocated), Receipt Amount, and Withdrawal Amount. Opening And Closing Balances are displayed for each Client/Matter, and Totals are presented per Bank and for the entire report.

User Parameters

Show Office/Department
From the list provided, the user must select whether or not the Office and Department names will be displayed in the report. If the user selects "N" (No), the report content will be displayed by Trust Bank; if the user selects "Y" (Yes), the report content will be displayed by Office and Department. The user also has the option to manually enter either "Y" or "N". This field defaults to the "N" option.

Office
From the list provided, the user must select the name of 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. The user also has the option to manually enter the unique identifier of the Office. This field defaults to the Select All option (i.e. by default, all Offices will be included in the report).

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

Bank X to X
From the lists provided, the user must select the range of Trust Bank Accounts that are to be included in the report. Only information about Bank Accounts within this range will be included in the report. These fields default to the first and last Bank Accounts in the list.

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

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

Transaction Date X to X
The user must enter the range of trust transaction dates for which the report will be generated. These fields default to the current system date.

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\Collection Detail.xls).