Billings, Receipts, Writeoffs, and Variances by Timekeeper

The Billings, Receipts, Write-offs, and Variances by Timekeeper 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 Billings, Receipts, Write-offs, and Variances by Timekeeper report is generated based on a user selected Office, range of Departments, range of Timekeepers, and range of Accounting Months. The user has the option of producing the report for a specific type of Timekeeper (i.e. Working, Responsible, Originating, and Billing) and can also select whether or not to include information regarding Billings, Receipts, Write-offs, and Variances.

The report details can be sorted by either Timekeeper or Office, and within each grouping, all associated Client/Matters are displayed. For each Client/Matter record, the following information is displayed: Client Number and Name, Matter Number and Name, Transaction Date, Bill Number, Sub-Bill Number, Fees, and Disbursements.

Totals are presented per Timekeeper and per Client/Matter, and for each, the totals are broken down into Billing Totals, Receipt Totals, Write-off Totals, and Variance Totals. Client/Matters carrying a zero balance will not be included in this report. This report will balance to the related General Ledger Accounts.

User Parameters

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).

Start Department, End Department
From the lists provided, the user must select range of Departments for which the report will be produced. The names of all Departments associated with your Firm will be displayed in the lists. To include all Departments in the report, the user must select the Select All options. The user also has the option to manually enter the unique identifiers of the Departments. These fields default to the Select All option (i.e. by default, all Departments will be included in the report).

Timekeeper Type
From the list provided, the user must select the type of Timekeeper for which the report will be produced. Valid options include: Billing, Originating, Responsible, and Working. The user also has the option to manually enter the Timekeeper Type. This field defaults to the Working Timekeeper option.

Start Timekeeper, End Timekeeper
From the lists provided, the user must select the range of Timekeepers to be included in the report. 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 of the specified type 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 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.

Sort By
From the list provided, the user must select the way in which the report information will be sorted. Valid options are by Timekeepers or by Office. This field defaults to the Timekeepers option.

Include Billings
To include information on Billings in the report, the user must select the "Y" option from the list provided; to not include information on Billings, the user must select the "N" option from the list. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Include Receipts
To include information on Receipts in the report, the user must select the "Y" option from the list provided; to not include information on Receipts, the user must select the "N" option from the list. 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 information on Write-offs in the report, the user must select the "Y" option from the list provided; to not include information on Write-offs, the user must select the "N" option from the list. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Include Variances
To include information on Variances in the report, the user must select the "Y" option from the list provided; to not include information on Variances, the user must select the "N" option from the list. 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\Billing Receipts Write-offs Variances.xls).