Interest Earned on Invested Trust Report

The Interest Earned on 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 Interest Earned on Invested Trust report is generated based on a user specified range of Bank Accounts, Clients, and Matters. The report can be based on either Accounting Month or Transaction Date, and contents can be sorted by either Client Number or Client Name.

The Interest Earned on Invested Trust Report information is grouped by by Bank Account. For each Invested Trust record, the following information is displayed: Bank Account Number and Name, Client Number and Name, Matter Number and Name, Certificate Number, Investment Type, and the amount of Interest earned to date. Totals are presented per Bank Account (i.e. Bank Totals), and for the entire report (i.e. Grand Totals).

User Parameters

User Parameters

Bank X to X
From the lists provided, the usr must select the range Bank Accounts for which the report will be produced. These fields default to the first and last Accounts in the list (i.e. by default, Investments associated with all Bank Accounts are included in the report).

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 possible Clients in the system (i.e. by default, Investments associated with all Clients are included in the report).

Matter X to X
The user must manually enter the unique identifiers of the Matters to define the range for which the report will be produced. These fields default to the first and last possible Matters in the system (i.e. by default, investments associated with all Matters are 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. Interest balances up to the specified Accounting Date will be displayed 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. Interest balances up to the specified Accounting Date will be displayed 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. These fields default to the current system date.

Sort By
From the list provided, the user must select the order in which report contents will be sorted. Valid options are sorted by Client Number or by Client Name. The user also has the option to manually enter their choice. This field defaults to the Client Number option.