Unposted Billings and Revenue

The values appearing in the Unposted Billings and Unposted Revenue sections on the Post >> List screen reflect the sum of the projected journal entry transactions that would result from posting a particular project (as if the post had occurred).

Clicking on any of the values in the Unposted Billings and Unposted Revenue columns will display a Billing and Revenue Details report showing the projected journal entry transaction details that make up the amounts displayed on this List screen.

See the Cost Plus Post Process and T&M / Fixed Price Post Process details to understand specifically how pre-billed labor, labor, expense and fixed price items are qualified to be included in a post process.

What do these amounts include?

General Assumptions:

Only those time and expense actuals that have reached the LOCKED or EXTRACTED will be considered.

No data that has previously participated in a post will be included.

Item Date <= Include Actuals Through date

For Cost Plus projects (Billing Type = CP):

Because we are dealing with Cost Plus projects, the project type associated with project / task and time and expense actuals does not come into play, that is, the cost for all actuals are considered.

Because the Unbilled and Recognized Revenue amounts use the same labor and expense cost values (as detailed below) the only difference you would see in the values for these two entries would be the result of using different Cost Plus Bill Rate and Cost Plus Recognition Rate values as defined on the Admin >> Setup >> Billing screen.

• Unbilled:

• • All Labor costs - calculated as hours times effective cost rates
  • All Expense amounts (the non-marked up expense amount)
  • All Item amounts -  these would reflect the marked up amounts for items defined at the master or project level
  • Indirect costs calculated using the project's cost structure and the appropriate indirect cost rates as specified on the Admin >> Setup >> Billing screen
  • Fee (if the project has a fee method specified on the Project >> Profile >> Budget tab)
      

• Deferred Revenue:

• • Calculated as the difference between projected recognized revenue and projected Unbilled amount for this project.  
  • You would not see any amount in this field if the same rates were defined on the Admin >> Setup >> Billing screen for Cost Plus Bill Rate and Cost Plus Recognition Rate
     

• Recognized Revenue:

• • All Labor costs - calculated as hours times effective cost rates
  • All Expense amounts (the non-marked up expense amount)
  • All Item amounts -  these would reflect the marked up amounts for items defined at the master or project level
  • Indirect costs calculated using the project's cost structure and the appropriate indirect cost rates as specified on the Admin >> Setup >> Billing screen
  • Fee (if the project has a fee method specified on the Project >> Profile >> Budget tab)

For Non-Cost Plus projects (Billing Type = TM or FP):

For TM & FP projects, we will consider the project type that time and expense actuals have been charged against and only consider those charged to billable project types.

• Unbilled:

• • Pre-Billed Labor (those billable unposted Pre-Billed Labor entries having a Bill Date <= Include Actuals Through date)
  • Billable Labor charges against a TM project or task - which are not covered by a Pre-Billed labor entry - calculated as hours times effective bill rate
  • Billable Expenses charges against a TM project or task - these would reflect the marked up amounts for those expense types having a mark up
  • Billable Item charges against a TM project or task - these would reflect the marked up amounts for items defined at the master or project level
  • Fixed Price item amounts from those billable items that have yet to be posted, which may include:
  • • FP items with a bill date before or in the Include Actuals Through date
    • FP items that represent completed milestones (i.e. the linked project / task completion date has been populated with a date <= Include Actuals Through date and Percent Complete populated with 100%)

• Deferred Revenue:

• • Fixed Price item amounts from the items that are recognized when billed, are already billable, but have not yet been posted. Those include:
  • • FP items with a bill date before or in the Include Actuals Through date
    • FP items that represent completed milestones (i.e. the linked project / task completion date has been populated with a date <= Include Actuals Through date and Percent Complete populated with 100%)
  • All billable unposted Pre-Billed labor entries
  • Deferred revenue will be reduced by all billable time charges that go against the Pre-Billed labor amounts

• Recognized Revenue:

1. • Unlike the calculation for Unbilled -- we do not include any Pre-Billed Labor entries (but we will want to include the labor that was covered by a Pre-Billed Labor entry (that is we do not bill for the labor covered by a Pre-Billed Labor entry-- but we will recognize that labor).
   • Billable Labor charges against a TM project or task - calculated as hours times effective bill rate
   • Billable Expenses charges against a TM project or task - these would reflect the marked up amounts for those expense types having a mark up
   • Billable Item charges against a TM project or task
   • Revenue associated with a Fixed Price item that is:
   • • recognized on schedule and has at least one FP item schedule date <= Include Actual Through date. In this case, recognized revenue will be based on the amount from the FP schedule.
     • recognized based on % complete.  Recognized revenue will be calculated as a difference between all of the previously recognized revenue for this item and a product of the current % complete and the FP amount.