Contents of the Print Billing Worksheet Screen

Use the fields and options to configure the Print Billing Worksheet screen.

Print Billing Worksheet

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use this block to limit the data that are printed.

Accounting Period

Use these fields to identify the period through which you would like to include data on the report. If you are printing the worksheet for unposted bills, the selected fiscal year, period, and subperiod will be the time frame that the bill was calculated. For posted bills, these define the time frame the bill was posted.

Field Description
Option

This field always displays One.

Fiscal Year

Enter, or click to select, a valid fiscal year for the report.

Period

Enter, or click to select, a valid period for the report.

Subperiod

Enter, or click to select, a valid subperiod for the report.

Ending Date

This non-editable field displays the selected subperiod end date.

Projects

Use these fields to limit the projects that print on the report. The lookup in these fields includes only the projects that exist in Project Billing Information.

Field Description
Option

Use this drop-down list to select the range of projects you want to print. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting project of the range you want to include in the report. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending project of the range you want to include in the report. If you select All or To End in the Option field, this field is inactive.

Non-Contiguous Range

Select this check box to enable the Project Non-Contiguous Ranges subtask. Use this subtask to create a customized list of projects to print on the report.

Invoices

Use these fields to select the range of invoices you want to print. Invoices within this range for the projects selected are printed.

The lookup in these fields depends on whether you are printing the billing worksheet for unposted or posted invoices. If Posting Status is set to Unposted Only, invoices that exist on the Manage Standard Bills screen will display in the lookup. If Posting Status is set to Posted Only, invoices that have already been posted will be displayed in the lookup.

Field Description
Option

Use this drop-down list to select the range option of invoices to be included. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting invoice for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending invoice for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Billing Formulas

Use these fields to select the range of billing formulas you want to print. Your selection of projects is limited to those included in the range of billing formulas selected.

Note: This application does not print the following billing formulas in the report even if they are included in the range of billing formulas selected: NONE, MANUAL, UNIT, and 1443.
Field Description
Option

Use this drop-down list to select the range option of billing formulas to be included. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting billing formula for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending billing formula for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Project Managers

Use these fields to select the range of project managers you want to print. Your selection of projects is limited to those included in the range of project managers selected.

Field Description
Option

Use this drop-down list to select the range of project managers to be included. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting project manager for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending project manager for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Billing Cycles

Use these options to select the range of billing cycles for which you want to print the report. Your selection of projects is limited to those included in the range of billing cycles selected. 

Field Description
Option

Use this drop-down list to select the range option of billing cycles to be included. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting billing cycle for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending billing cycle for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Bill Groups

Use these fields to select the range of user groups for which you want to print the report. You are limited to user groups to which you belong. Your selection of projects is limited to those included in the range of user groups selected.

Field Description
Option

Use this drop-down list to select the range option of bill groups to be included. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting bill group for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending bill group for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Billing Format

Use these fields to select the range of billing formats you want to print. Your selection of projects is limited to those included in the range of billing formats selected.

Field Description
Option

Use this drop-down list to select the range option of billing formats to be included. Valid options are:

  • All
  • One
  • Range
  • From Beginning
  • To End

The default for this field is All.

Start

Enter, or click to select, the starting billing format for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending billing format for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Options

Use the options in this block to select documents to print and other data to be included in the report.

Display

Field Description
Rate Type

Select Actual to print the report using actual indirect rates, or Target if you want to use target indirect rates. The rate type will be used to pull the ITD Cost Incurred column amounts at actual or target rates.

Summarize Indirect Costs and COM Rows

Select this check box to summarize indirect costs and cost of money (COM) rows.

If you select this check box, there will be one row per cost pool displayed with a total burden amount. If you do not select this check box, there will be one row for each fiscal year and pool displayed.

Select Printing

Field Description
Billing Worksheet Only

Select this option to print the billing worksheet without printing the supporting schedules.

Supporting Schedules Only

Select this option to print the supporting schedules without printing the billing worksheet.

The supporting schedules display the following: transactions on hold, hours on hold, write off amounts, and write off hours from open billing detail. Also displayed are details on over total ceiling amounts, over cost ceiling amounts, over fee ceiling amounts, and direct cost ceilings.

Billing Worksheet and Supporting Schedules

Select this option to print both the billing worksheet and the supporting schedules.

For sample reports with this option selected, see the topics under Billing Worksheet Samples.

Include

Field Description
Unselected Invoices

If you select this check box, invoices with a status of Unselected and Hold are printed. This check box is enabled only if the Unposted Only option is selected.

Detail Invoices

Select this check box to print out detail invoices. If you do not select this check box, the application prints only summary invoices.

The detail invoices are identified on the Detail Levels subtask of the Manage Project Billing Information screen.

Posting Status

Field Description
Unposted Only Select this option to print unposted standard bills.
Posted Only Select this option to print standard bills that have already been posted. If you select this option, the Unselected Invoices check box becomes cleared and disabled.

Show for T&M Projects

Field Description
PLC / PLC Name Select this option to display the project labor category (PLC) and PLC description on the report for T&M projects.
ID / Name Select this option to display the employee ID/vendor ID/vendor employee ID and name on the report.
Both Select this option to display both the PLC and employee ID/vendor ID/vendor employee ID on the report.

To view a sample billing worksheet with T&M projects, see T&M Billing Worksheet.

Subtask

Subtask Description
Project Non-Contiguous Ranges If you selected the Non-Contiguous Ranges check box, use the Project Non-Contiguous Ranges subtask to select a noncontiguous range of projects.