Use this screen as the first step in a four-step process to create an unbilled balances report by project. When you complete all the steps, you can create a report that groups unbilled balances by project and by reason code. You can use this report to analyze unbilled balances by project. Click here to learn more.
Use this screen to initialize all unbilled reason codes that are used by your company before running the Update Unbilled Analysis Report Tables screen. You cannot assign reason codes to unidentified balances until they have been initialized here.
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 seven 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).
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.
WH — Costpoint assigns a WH reason code to an unbilled amount if withholding has been used on the project.
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.
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.
Enter a description of the reason for the unbilled balance. This field is required.
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.