Timekeeper Detail Distribution Report

The Timekeeper Detail Distribution 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 Timekeeper Detail Distribution Report is generated based on a user specified range of Timekeepers of a certain type (i.e. Working, Originating, or Responsible), and a user specified Accounting Period. The user has the option to include/exclude Billings, include/exclude Receipts, include/exclude Write Offs, and to include/exclude Zero Balances.

For each Matter within the selected criteria range, the report displays all associated Bills. Each Bill is broken down into the individual transactions that made up that Bill. Bill details include the following: Bill Number, Bill Date, Fees Amount, Disbursements Amount, Tax Amount, and Interest Amount. Totals are presented per Client/Matter and per Timekeeper.

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\Sample_TMKP_Detail_Dist.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

Timekeeper Type
From the list provided, the user must select the type of Timekeepers for whom the report will be produced. Valid options are Working Timekeeper, Originating Timekeeper, and Responsible Timekeeper. The user also has the option to manually enter their Timekeeper Type choice. This field defaults to the Working Timekeeper option.

Start Timekeeper, End Timekeeper
From the lists provided, the user must select the range of Timekeepers for whom the report will be generated. The user also has the option to manually enter the unique identifiers of the Timekeepers. These fields default to the first and last Timekeepers in the list (i.e. by default, all Timekeepers will be included in the report).

Accounting Month X to X
From the lists provided, the user must select the range of Accounting Months for which the report will be produced. The user also has the option to manually enter the numbers of the Accounting Months. These fields default to the current Accounting Month.

Accounting Year
The user must manually enter the Accounting Year for which the report will be produced. This field defaults to the current Accounting Year.

Report By
To include both a Detail and Summary section in the report content, the user must select the "Detail and Summary" option from the list provided; to include only a Detail section in the report content, the user must select the "Detail" option from the list provided; to include only a Summary section in the report content, the user must select the "Summary" option from the list provided. This field defaults to the "Detail and Summary" option.

Include Billings
To include in the report information regarding the Timekeeper's Billings, the user must select "Y" from the list provided; to not include in the report information regarding the Timekeeper's Billings, 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.

Include Receipts
To include in the report information regarding the Timekeeper's Receipts, the user must select "Y" from the list provided; to not include in the report information regarding the Timekeeper's Receipts, 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.

Include Write Offs
To include in the report information regarding the Timekeeper's Write Offs, the user must select "Y" from the list provided; to not include in the report information regarding the Timekeeper's Write Offs, 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 Client/Matter records carrying zero balances, the user must select "N" from the list provided; to not include Client/Matter records carrying zero balances, the user must select "Y" from the list provided. The user also has the option to manually enter either "Y" or "N". 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\Sample_TMKP_Detail_Dist.xls).