Invested Trust Report

The Invested Trust 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 Invested Trust Report is generated based on a user specified range of Clients, and either by Accounting Date or a range of Transaction Dates.The report can be produced in two different format: Summary and Detail.

Summary - when using this option, the report displays a list of all investments for each Client/Matter within the specified range. For each Client/Matter, the following information is provided: Client Number and Name, and Matter Number and Name. Investment information includes Bank Account Number and Name, Investment Date, and Investment ID. Totals are displayed for each investment, and for the report as a whole.

Detail - When using this option, the report displays details for all investments for each Client.Matter within the specified range. For each Client/Matter, the following information is provided: Client Number and Name, Matter Number and Name, Address, Phone, Responsible Timekeeper, Nature, Major Client, and Department. Investment details include Bank Account Number and Name, Certificate Number, Investment ID, Invested Date, Maturity Date, Term in Days, and Interest Rate. Each Investment is broken down into individual transactions, for which the following information is provided: Transaction Date, Transaction Description, Journal Type, Journal Number, and Amount. Amounts for Total Principle, Total Interest, Total Redemption, and Total Balance are provided for each Investment.

User Parameters

User Parameters

Report Type
From the list provided, the user must select the type of report they wish to produce. Valid options are Summary or Detail. This field defaults to the Summary option.

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

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

Accounting Month
If the user has chosen to generate the report by Accounting Month, they must manually enter the Accounting Month for which the report will be produced. All Invested Trust transactions up to and including the specified Accounting Date will be included in the report. This field defaults to the current Accounting Month.

Accounting Year
If the user has chosen to generate the report by Accounting Month, they must manually enter the Accounting year for which the report will be produced. All Invested Trust transactions up to and including the specified Accounting Date will be included in the report. This field defaults to the current Accounting Year.

Transaction Date X to X
If the user has chosen to generate the report by Transaction Date, they must manually enter the range of dates for which the report will be produced (i.e. all Invested Trust transactions as of these Dates will be displayed in the report content). These fields both default to the current system date.

Order By
From the list provided, the user must select the way in which the report information will be displayed. Valid options are by Client Number (i.e. Numerically) and by Client Name (i.e. Alphabetically). This field defaults to the Client Number option.

Suppress Zero
From the list provided, the user must select whether or not zero balances will be displayed in the report. Valid options are Y (Yes), and N (No). This field defaults to the Yes option.