Trust Balances by Client Report

The Trust Balances by Client 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 Balances by Client Report is generated for a user specified Office, range of Departments within the select Office(s), range of Clients, and for either a specific Accounting Period or a specific Transaction Date. The user also has the option to suppress records carrying zero balances.

For each Client included in the report, the following information is displayed: Client Number and Name, Matter Number and Name, Bank Account Number and Name, Date, Account Type, Amount of Regular Trust, and the amount of Special Trust. Special and Regular Trust Totals are presented per Client/Matter, per Department, per Office, and for the entire report (i.e. Report Grand Total).

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 Balances by Client.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/Department
The user must specify whether or not the names of the Offices and Departments will be displayed in the report (i.e. will the information be displayed by Office/Department, or just by Banks). To show Office/Department names, the user must select "Y" (Yes); to not show Office/Department names, the user must select "N" (No). This field defaults to the "N" option.

Office
From the list provided, the user must select the Office for which the report will be produced. 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 user also has the option to manually enter the unique identifiers of the Departments. These fields both default to the Select All options (i.e. by default, all Departments within the selected Office(s) will be included in the report).

Client No 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 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. If the user chooses to generate the report based on Accounting Month, they must then specify the Accounting month and Year (i.e. see the fields below); if the user chooses to generate the report based on Transaction Date, they must then specify the Transaction Date (i.e. see the Transaction Date field below).

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 Trust Balances for 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 Trust Balances for the specified Accounting Date will be included in the report. This field defaults to the current Accounting Year.

Transaction Date
If the user has chosen to generate the report by Transaction Date, they must manually enter the Transaction Date for which the report will be produced (i.e. report contents will be restricted to transactions that occurred on the date entered here). This field defaults to the current system date.

Sort By
From the list provided, the user must select the way in which report contents will be sorted and displayed. Valid options are sorted 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.

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\Trust Balances by Client.xls).