Contents of the Manage Unbilled Reason Codes Screen

Use the fields and options to configure the Manage Unbilled Reason Codes screen.

Table Window

Field Description
Unbilled Reason Code

Enter a user-defined unbilled reason code that you want to use to describe unbilled amounts that cannot be computed by Costpoint. You can use this user-defined reason code on the Edit Unbilled Reason Codes screen to provide a further breakdown of the amount that has been assigned to the NONE reason code.

There are nine Costpoint-defined unbilled reason codes for which unbilled amounts can be calculated by Costpoint. These Costpoint-defined codes automatically display in this field. The Create Unbilled Analysis Report Tables screen calculates the unbilled amounts (if any) for each of these codes and assigns the remaining unbilled balance to the NONE reason code. Costpoint-defined codes are as follows:

  • AWARDFEE: Costpoint assigns an unbilled amount to the AWARDFEE function code if award fee amounts have been accrued but not yet billed.  
  • NONE: Costpoint assigns any excess unbilled balance that has not been assigned to any other Costpoint-defined reason code to the NONE reason code. You can assign the amount assigned to this reason code to user-defined reason codes as needed. For example, after you have executed the Create Unbilled Analysis Report Tables screen, $10,000 is assigned to the NONE reason code. You can enter a zero in the Actual Amount and/or Target Amount columns on the Edit Unbilled Reason Codes screen and reassign the $10,000 to a user-defined Costpoint code such as CONTRACT (waiting for contract) or COMPLETION (project cannot be billed until completion).
  • PYREV: Costpoint assigns the PYREV reason code to an unbilled amount if a prior year revenue from adjustment periods has been used on the project.
  • REVADJ: Costpoint assigns the REVADJ unbilled reason code to an unbilled amount if a revenue adjustment has been used on the project.  A revenue adjustment is entered on the Manage Revenue Information screen. A revenue adjustment creates an unbilled balance if a revenue adjustment is posted but has not yet been billed.
  • RTNGE: Costpoint assigns a RTNGE reason code to an unbilled balance if there has been retainage on the project. Retainage is calculated and posted during the billing process. Usually there is a stipulation in the contract that a certain percent of the bill be withheld until the project is completed and approved. If retainage has been posted on a bill, more revenue is recognized than has been billed on the project causing an unbilled balance.
  • RTVAR: Costpoint assigns a RTVAR reason code to an unbilled balance if a difference between the rate used for revenue recognition and the rates used for billing exists. This type of unbilled balance usually exists with cost-type projects (Cost Plus Fixed Fee or any loaded labor project that involves billing burden). Bills are generally calculated using provisional rates that are specified in the contract. Revenue is generated using either target or actual rates. Target rates are generally budgeted rates developed internally and actual rates are those that are calculated by Costpoint. When there is a difference between the rates used for revenue and billing, an unbilled balance results.
  • SUBBILL: Costpoint assigns a SUBBILL reason code to an unbilled balance if there has been a subsequent billing of the balance in a future period. The Create Unbilled Analysis Report Tables process is run through a fiscal year/period/subperiod entered on the Create Unbilled Analysis Report Tables screen. For example, if revenue was computed and posted in fiscal year 2005, period 5, subperiod 1, and the billing related to that revenue was not computed and posted until fiscal year 2005, period 6, subperiod 1, then a subsequent billing unbilled balance exists if the Create Unbilled Analysis Report Tables process was run for fiscal year 2005, period 5, subperiod 1. Generally, this type of unbilled balance exists if your policy is to recognize revenue for the current period and calculate and post the bills in the next period.
  • UNTRAN: Costpoint assigns an UNTRAN reason code to an unbilled balance if there are unbilled transactions on the Manage Open Billing Detail screen for the project. 
  • WH: Costpoint assigns a WH reason code to an unbilled amount if withholding has been used on the project.

You cannot modify Costpoint-defined codes. Data entered in this screen is stored in the UNBILLED_RSN_CD table and cannot be modified once it is used in a process.

Reason Code Description

Enter a description of the reason for the unbilled balance. This field is required.

System Code

The initial values in this column are S (System-Defined Code) and U (User-Defined Code). You can modify Costpoint-defined codes to N, which turns off the automatic calculation of that code for all projects. You can set it back to S to reinstate the automatic calculation. The only valid value for a user-defined code is U.