Client Financial Detail Report

The Client Financial Detail 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 Client Financial Detail Report is produced for a user specified Accounting Month and Year, and a user specified range of Offices, Departments, and Clients. The user also has the option to include/exclude information regarding files that are soft closed, include/exclude zero balances, and include/exclude Client carrying trust balances. Report contents can be sorted either by Client or by Office and Department.

For each Client included in the report, the information displayed includes the following: Last Billed Date, Last Active Date, AR Fees, AR Disbursements, AR Tax, Total AR, Total Interest, WIP Fees, WIP Disbursements, WIP Hours, Regular Trust, and Invested Trust. Totals are presented per column.

User Parameters

Run By
From the list provided, the user must select the format in which the report contents will be generated. Valid options are by Client and by Office and Department. The user also has the option to manually enter the Run By option. This field defaults to the Client option. If the user selects the Client option, they must then specify the range of Clients for whom the report will be produced; if the user selects the Office and Department option, they must then specify the Office and range of Departments within that Office for which the report will be generated.

Office
From the list provided, the user must select the name of the Office for which the report will be produced. The names of all Offices associated with your Firm will be displayed in the list. To include all Offices in the report, the user must select the Select All option. 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 the Departments for which the report will be produced. The names of all Departments associated with your Firm will be displayed in the lists. The user also has the option to manually enter the unique identifiers of the Departments. These fields default to the Select All options (i.e. by default, all Departments will be included in the report).

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

Accounting Month, Accounting Year
The user must select the Accounting Month from the list provided, and manually enter the Accounting Year for which the report will be produced. These fields default to the current Accounting Month and Year.

Include Closed Matters
To include Closed Files in the report, the user must select "Y" from the list provided: to not include Closed Files in the report, the user must select "N" from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "N" option.

Include Soft Closed Files
To include Soft Closed Files in the report, the user must select "Y" from the list provided: to not include Soft Closed Files in the report, the user must select "N" from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Suppress Zero
To include Files carrying a zero balance in the report, the user must select "Y" from the list provided: to not include Files carrying a zero balance in the report, the user must select "N" from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Clients With Trust Only
To include only those Clients carrying a Trust balance in the report, the user must select "Y" from the list provided: to include all Clients in the report, the user must select "N" from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "N" option.

Sort By
From the list provided, the user must select the way in which the report contents will be sorted. Valid options are "Numeric" and "Alphabetic". This field defaults to the "Numeric" 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\Client Financial Detail.xls).