Trust Allocation by Client Report

The Trust Allocation 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 Allocation by Client Report can be generated for a user specified range of Clients, Matters, and Responsible Timekeepers, and can be produced either by Accounting Month or by Transaction Date. The report displays information for every Client and Matter within the specified ranges carrying a trust balance. Report details include general Client and Matter information, Responsible Timekeeper, Trust Bank information, Account and Trust Fund type, and the amount of each Trust Fund type per Client/Matter. Negative amounts indicate an overdraft of that Trust Account.

Accounting Month - If the user chooses to produce the report by Accounting Month, they must then enter the Accounting Month and Year for which the report will be generated. All Trust Transactions that have been posted up to and including the specified date will be included in the report. The details of the report are lifetime to date (i.e. from the time of file inception up to and including the specified Accounting Month and Year), and the totals presented should balance to the appropriate General Ledger Accounts.
Transaction Date - If the user chooses to produce the report by Transaction Date, they must then enter the Transaction Date for which the report will be generated. All Trust Transactions with a Transaction Date up to and including the specified date will be included in the report. The details of the report are lifetime to date (i.e. from the time of file inception up to and including the specified Transaction Date), and totals cannot be as balancing tools (i.e. the report totals will not balance to General Ledger Accounts).

Totals are presented per type of Trust Account, type of Trust Funds, Client, Matter, and per Timekeeper. A report total (i.e. total of all Trust Funds in all Accounts) is also given.

User Parameters

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

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

Resp Timekeeper X to X
From the lists provided, the user must select the range of Responsible Timekeepers to be included in the report. The user also has the option to manually enter the unique identifiers. These fields default to the first and last possible Timekeepers (i.e. be default, all Responsible Timekeepers 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 select the Accounting Month for which the report will be produced from the list provided. The user also has the option to manually enter the Accounting Month. All Trust Transactions posted before or on 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 Transactions posted before or on 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 generated. All Trust Transactions dated before or on this date will be included in the report. This field defaults 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.

Sort By
From the list provided, the user must select the way in which the report information will be grouped. Valid options are by Client and by Responsible Timekeeper (i.e. display the Client and then all related records, or display the Timekeeper and then all related records). This field defaults to the Client 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.