PRINT UNBILLED ANALYSIS

Use this screen to print the Unbilled Analysis Report or the Unbilled Reason Code Report. The Unbilled Analysis Report provides information on the computation of the unbilled balance and the major components of the balance. The Summary Report provides an overview of the unbilled balances and how they were derived. Use the Detail Report to understand the timeframe in which some of the unbilled components will be billed. The Unbilled Reason code Report will print data from the RPT_UNBILLED_RSN table. You can also view this data in the Edit Unbilled Reason Codes screen (Projects » Billing » Unbilled Receivables).

Use this screen whenever you want to print the Unbilled Receivable Analysis report or the Unbilled Reason Code Report. To obtain the most current data, you must run the Create Unbilled Analysis Report screen (Projects » Billing » Unbilled Receivables) before printing these reports.

Choose Report

Select the report you would like to print. Based on the selection you make here, other fields in this screen may not be available. Valid options are Unbilled Analysis Report and Unbilled Reason Code Report.

Report Type

This group box is available only if you selected the Unbilled Analysis Report option.

Summary Report

Select this option to print the summary report. This report provides a quick reference on the unbilled balance computation. It includes the following information:

• Project

• Project name

• Project type (Cost Plus Fixed Fee, Time & Materials, etc.)

• Account group (Commercial, Government, etc.)

• Status (Active or Inactive)

• ITD revenue

• ITD billings

• Unbilled amount per formula (revenue minus billings)

• Unbilled amount per General Ledger

Detail Report (legal/landscape)

Select this option to print the detail report. This report provides information on the major components that comprise the unbilled balance. All amounts on this report will be displayed rounded to the nearest whole currency unit (such as dollar or Euro). The Detail Report includes the following information:

• Project

• Project name

• Project type (Cost Plus Fixed Fee, Time & Materials, etc.)

• Period of performance

• Unbilled amount per General Ledger

• Subsequent billings

• Current year rate variance

• Prior years rate variance

• Retainage

• Transactions not billed (hours)

• Transactions not billed (costs)

• Revenue Adjustment

• Award Fee

• Miscellaneous

Period

Use this group box to select the period ending date for your report. Records having a period ending date up to and including the one entered here will be included on the report. 

Fiscal Year

Enter, or use the drop-down list to select, the year for which you want to print the report.

Period

Enter, or use the drop-down list to select, the period for which you want to print the report.

Subperiod

Enter, or use the drop-down list to select, the subperiod for which you want to print the report.

Select Grouping

Use this group box to limit the projects on the report.

Select

Use the drop-down list to select the desired grouping to indicate how the report will be sorted. Valid options are:

• Project

• Organization

• Project Manager

• Project Type

• Project Classification

• Project Account Group

• Customer

• Bill User Group 

• Reason Code  

The default for this field is Project.

Reason Code is not available unless you selected Unbilled Reason Code Report in the Choose Report group box.

Range Option

Use this drop-down list to select the range of items to include on the report. Valid options are

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

Enter, or use to select, the starting item for the range that you want to include in the report. If you selected All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending item for the range that you want to include in the report. If you selected All, One, or To End in the Range Option field, this field will be inactive.

Include

Use this group box to select the desired level for your report.

Organization Level ____ and below

Enter the organization level to include on this report. This field is not available if you selected Bill Group in the Select drop-down list.

Project Level ____ and below

Enter the project level to include on this report. This field is not available if you select the Project Unbilled Level check box.

Project Unbilled Level

Select this check box to print the report at the current unbilled project level, which is where the general ledger balance resides. This check box is not available if you selected Customer or Reason Code in the Select drop-down list.

Revenue Rate Type

Use this group box to select the desired revenue rate type.

Actual

Select this option to print an actual rate.

Target

Select this option to print a target rate.

Show

Use this group box to select various print options.

Amount in Thousands

Select this check box to include the amount in thousands on the report.

Lines With No Activity

Select this check box to include lines with no activity on the report.

Inactive Projects

Use this group box to include inactive projects in your report. Selecting this check box will make the report substantially longer if you have many inactive projects in your database

Reason Code Notes

Select this check box to include the reason code Notes entered in the Edit Unbilled Reason Codes screen (Projects » Billing » Unbilled Receivables) on this report. This check box is available only if you selected Unbilled Reason Code Report in the Choose Report group box.

Table Information

This process uses the following tables to create the reports:

PROJ (if the report is grouped by Project Account Group or Customer)

BILL_GRP (if the report is grouped by Bill User Group)

RPT_PROJ_UNBILLED

RPT_UNBILLED_RSN