Maturing Trust Deposits Report

The Maturing Trust Deposits 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 Maturing Trust Deposits Report is generated based on a user specified range of Clients, and range of Maturity Dates (i.e. the date signifying the end of the term). All term deposits with a Maturity Date within the specified range of dates will be included in the report. Report contents can be grouped by either Bank Account or Client, and can then be sorted within each grouping by either Client Number, Client Name, or Maturity Date. The user also has the option to suppress records carrying zero balances.

For each Term Deposit in the report, the following information is displayed: Client Number, Matter Number, Bank Number, Bank Name, Term (i.e. length in days), Certificate Number, Due Date (i.e. Maturity Date), Deposit Type, and Deposit Amount.

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\Maturing_Trust_Deposits.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

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

Maturity Date
The user must manually enter the Maturity Date. All Term Deposits with a Maturity Date up to and including the date specified in this field will be included in the report. This field defaults to the current system date.

Report By
From the list provided, the user must select the format by which the report will be produced. Valid options are Bank and Client. The user also has the option to manually enter their choice. This field defaults to the Bank option. If the user chooses to generate the report based on the Bank, the report content will be grouped according to Bank Accounts; if the user chooses to generate the report based on Clients, the report content will be grouped according to Client.

Sort By
From the list provided, the user must select the way in which report content is sorted and displayed within each section (i.e. sections will be based on either Bank Account or Client, depending on the selection made in the previous field). Valid options are by Client Number (i.e. records will be sorted numerically based on client Number), by Client Name (i.e. records will be sorted alphabetically based on Client Name), or by Maturity Date (i.e. records will be sorted chronologically based on Maturity Date). This field defaults to the Client Number option.

Suppress Zero
To include in the report those records displaying zero balances, the user must select the "N" (i.e. No, do not suppress zeros) option; to not include in the report those records displaying zero balances, the user must select the "Y" (i.e. Yes, suppress zeros) option. This field defaults to the "Y" 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\Maturing Trust Deposits.xls).