Title: FP Revenue Recognition and Forecasting - % Complete

Brief description:
This step-by-step guide outlines which project management and billing & revenue posting processes to follow on Fixed Price projects when you are using the % Complete revenue recognition method. It includes different processes depending on whether you are allowing Unanet to drive the % Complete calculation or manually managing the % Complete rates. It also describes the implication of revenue calculations on Project Accounting reports when you reporting on Plans and Assignments/Budgets within Unanet. The overall scenario is that you are recognizing revenue at the Project rather than Task level (though it would work similarly at the task level).

If your particular process is not covered in this guide, the Help Docs - System Generated Report Estimates describes all cases of how the system calculates revenue when the % Complete, Budget, ETC, Estimated Total fields are entered or left blank (system calculated).

What’s covered in this document:

Understanding How Fixed Price Revenue Calculates on Project Accounting Reports

Revenue calculations may vary depending on whether you are running Project Accounting reports based on Actuals, Budgets, or Plans. This directly impacts how you will forecast and report on your project throughout its lifecycle.

For more information see Help Docs - Report Calculations.


Fixed Price Revenue calculated as the sum of the following components:

Note: If either Estimated Total or Budget values above were not provided, they will also be estimated based on the rules outlined in Report Calculations.

Note: Only consider items falling within the INCLUDE ACTUALS THROUGH date range (i.e., ignore any revenue that has been posted into the Forecast range).


If you are using Plans to represent your baseline/proposal/contract budget (you do not modify your plans), and you only update Assignments/Expense Budgets during project execution:

As an example, calculating the total forecasted revenue where % Complete is being auto-calculated based on Labor Cost:

Example Spreadsheet

You can download the attached Excel spreadsheet to browse different examples and the formulas used to calculate values: FP Percent Complete Calculations - Examples.xlsx.

Option 1: Allowing Unanet to Calculate the % Complete Based on Hours, Labor Cost, or Total Cost 

Option 1 - Project Inception & Planning

  1. On a new FP Project, populate the Fixed Price Items to add up to the total funded value, choosing % Complete as the revenue recognition method. The Bill Dates should be based on the actual invoicing schedule (they can be independent from the revenue recognition schedule).

     



  2. Enter your People and Expense Plans prior to beginning work on the projects.

  3. Run the Cost Summary & Status report on Plans to confirm the associated Hours Budget, Labor Cost $ Budget, and Expense Cost $ Budget amounts.

  4. Populate these amounts on the Project Profile > Budget tab, and establish whether the COMPLETED PERCENT will be based on Hours, Labor Cost, or Total Cost (dropdown menu).

  5. Follow your processes for converting the Plans into Assignments (or make blanket assignments) so project activities can begin.


If you are using plan sets, you may refer to the KC - Quick Topic - Fixed Price Revenue Budgeting and Locking to find out how you may lock FP revenue on a locked plan set.

Option 1 - Project Execution

Every month (or period), before you recognize revenue on a FP project based on % Complete:

  1. Ensure the project team has updated the people assignments and expense budgets (or people plans and expense plans, depending on your process) going forward for the remainder of the project.

  2. Run the Cost Summary & Status report with Actuals up to the previous month (the period for which you are recognizing revenue), and with either:
    1. Budgets going forward (Actuals Combined with Budgets) - if you are updating people assignments/expense budgets on an ongoing basis.
    2. Plans going forward (Actuals Combined with Plans) - if you are updating people plans/expense plans on an ongoing, forward-looking basis.

      Notice that the calculated Revenue amount no longer adds up to the total Revenue.

  3. Update the Project Profile > Budget tab with data from the ACTUALS & ALLOCATED column.
    1. Method 1 - If you are using plans for your baseline/proposal/contract budget and regularly forecasting using assignments/expense budgets, populate the Est. Total fields with the latest totals.
      1. Hours Est. Total (necessary if choosing Estimate from Hours COMPLETED PERCENT method).
      2. Labor Cost $ Est. Total (necessary if choosing Estimate from Labor Cost or Total Cost COMPLETED PERCENT methods).
      3. Expense Cost $ Est. Total (necessary if choosing Estimate from Total Cost COMPLETED PERCENT method).



        When you run the Cost Summary & Status report on Plans on one row, and Actuals + Budgets on another row, you can see that the revenue calculation for the original Plans remains spread out over the months. You can also see that the BUDGETED column still shows the original budgeted amounts on the project.

    1. Method 2 - If you are using blanket assignments/expense budgets at project inception and regularly updating plans throughout the project execution, replace the Budgeted fields with the latest totals.
      Note that this will also redistribute revenue across the months, so reports on cumulative revenue will be more meaningful than periodic revenue.
      1. Hours Budgeted (necessary if choosing Estimate from Hours COMPLETED PERCENT method).
      2. Labor Cost $ Budgeted (necessary if choosing Estimate from Labor Cost or Total Cost COMPLETED PERCENT methods).
      3. Expense Cost $ Budgeted (necessary if choosing Estimate from Total Cost COMPLETED PERCENT method).



        If you replace these fields, your monthly revenue calculation on the original plans will change. The BUDGETED column on the reports will also change.

  4. Run the Billing & Revenue Post process as usual (KC - I&P GUIDE - Billing & Revenue Post).

Option 1 - Project Completion

  1. When all activities on the project are complete, you should delete any remaining assignments/budgets for the project.

  2. Run the Cost Summary & Status report and update the Project Profile > Budget tab with final data from the ACTUALS & ALLOCATED column. This will ensure that the forecasted revenue amounts for months/periods is updated as well.

  3. If you have remaining revenue to post at the end of the project, you should populate the COMPLETED PERCENT field with 100 (and update the COMPLETED DATE if Bill On Completion is selected for any of the fixed price items). This will also ensure any remaining fixed price items are available to include on your final invoice.

Option 2: Manually Providing the % Complete

This option will work for either scenario whether using Assignments/Budgets or Plans for forecasting. The difference from the above method is you are manually entering the COMPLETED PERCENT amounts on the project rather than letting the system calculate the % Complete. This may be because how you calculate % Complete and revenue on FP projects is different from the automated options currently available in Unanet.

Option 2 - Project Inception & Planning

  1. On a new FP Project, populate the Fixed Price Items to add up to the total funded value, choosing % Complete as the revenue recognition method. The Bill Dates should be based on the actual invoicing schedule (they can be independent from the revenue recognition schedule).

  2. Enter your People and Expense Plans prior to beginning work on the project.

  3. Run the Cost Summary & Status report on Plans only to confirm the associated Hours Budget, Labor Cost $ Budget, and Expense Cost $ Budget amounts.

  4. Populate these amounts on the Project Profile > Budget tab, and establish whether the COMPLETED PERCENT will be based on Hours, Labor Cost, or Total Costs (dropdown menu).

  5. Follow your processes for converting the Plans into Assignments (or make blanket assignments) so project activities can begin.


If you are using plan sets, you may refer to the KC - Quick Topic - Fixed Price Revenue Budgeting and Locking to find out how you may lock FP revenue on a locked plan set.

Option 2 - Project Execution

Every month (or period), before you recognize revenue on a FP project based on % Complete:

  1. Ensure the project team has updated the people assignments and expense budgets (or people plans and expense plans, depending on your process) going forward for the remainder of the project.

  2. Run the Cost Summary & Status report with Actuals up to the previous month (the period for which you are recognizing revenue), and with either:
    1. Budgets going forward (Actuals Combined with Budgets) - if you are updating people assignments/expense budgets on an ongoing basis.
    2. Plans going forward (Actuals Combined with Plans) - if you are updating people plans/expense plans on an ongoing, forward-looking basis.

    Notice that the calculated Revenue amount does not add up to the total expected Revenue.

  3. Update the Project Profile > Budget tab with latest data from the ACTUALS & ALLOCATED column:
    1. Method 1 - If you are using plans for your baseline/proposal/contract budget and regularly forecasting using assignments/expense budgets, populate the Est. Total fields with the latest totals.
      1. Hours Est. Total (necessary if choosing Estimate from Hours COMPLETED PERCENT method).
      2. Labor Cost $ Est. Total (necessary if choosing Estimate from Labor Cost or Total Cost COMPLETED PERCENT methods).
      3. Expense Cost $ Est. Total (necessary if choosing Estimate from Total Cost COMPLETED PERCENT method).



    2. Method 2 - If you are using blanket assignments/expense budgets at project inception and regularly updating plans throughout the project execution, replace the Budgeted fields with the latest totals.
      Note that this will also redistribute revenue across the months, so reports on cumulative revenue will be more meaningful than periodic revenue.
      1. Hours Budgeted (necessary if choosing Estimate from Hours COMPLETED PERCENT method).
      2. Labor Cost $ Budgeted (necessary if choosing Estimate from Labor Cost or Total Cost COMPLETED PERCENT methods).
      3. Expense Cost $ Budgeted (necessary if choosing Estimate from Total Cost COMPLETED PERCENT method).



      In either case, when you refresh/run the same Cost Summary & Status report with the Project Profile > Budget tab fields, the total Revenue amount will now be reflected in the ACTUALS & ALLOCATED column.

      However, if you follow Method 1 of updating the Estimated Totals, you can retain the original Plans revenue calculation across the months when running a comparative view of the report:

  4. Before running the Billing & Revenue Post, populate the amount in the COMPLETED PERCENT field (as a number, not a percent (EX: 6.45% = 6.45).



    Note: If you do populate the COMPLETED PERCENT amount and run the same report again, the Actuals revenue amount will appear as $0 until you have completed the Billing & Revenue Post. 

  5. Run the Billing & Revenue Post process as usual (KC - I&P GUIDE - Billing & Revenue Post).

  6. Once you have completed the Billing & Revenue Post process for the given month, you will see the Actual revenue amount as it was posted.

    If you leave the COMPLETED PERCENT amount populated in the project profile after your Billing & Revenue Post, this amount will appear in reports showing the % Complete, such as the Project Status report, until the next time you update the COMPLETED PERCENT field.



    Alternatively, if you clear out the COMPLETED PERCENT amount after your Billing & Revenue Post, the system calculated amount will reappear in reports.



    You will be able to see the previous % Complete amounts entered (or any changes made to the project budget or task budget profile) when running the Audit Trail.

Option 2 - Project Completion

  1. When all activities on the project are complete, you should delete any remaining assignments/budgets for the project.

  2. Run the Cost Summary & Status report and update the Project Profile - Budget tab with final data from the ACTUALS & ALLOCATED column. 

    This will ensure that the forecasted revenue amounts for months/periods is updated as well.

  3. If you have remaining revenue to post at the end of the project, you should populate the COMPLETED PERCENT field with 100 (and update the COMPLETED DATE if Bill On Completion is selected for any of the fixed price items). This will also ensure any remaining fixed price items are available to include on your final invoice.

Requirements

  1. Ensure your team is regularly updating assignments (or plans) to reflect true expected activity on projects (or tasks).

  2. Ensure you are communicating with your PM team so you are aligning the project/task updates with your billing and revenue process.
    1. If your timing does not align, you may modify your Billing & Revenue Post to exclude FP projects that may not be updated (or process the billing separate from revenue recognition).

  3. Ensure project has a Cost Structure so costs are appropriately burdened with indirect costs in the Project Accounting reports.

  4. Ensure you have set up FP items and chosen the Revenue Recognition method of % Complete.

  5. The Bill Date is ENTIRELY IGNORED for purposes of revenue recognition on % Complete. Billing is separate from Revenue.


Additional Information

Help Docs - Report Calculations

Help Docs - Project Billing - Fixed Price

Help Docs - System Generated Report Estimates

KC - I&P GUIDE - Billing & Revenue Post

KC - Quick Topic - Fixed Price Revenue Budgeting and Locking

KC - Quick Topic - Methods for Forecasting Fixed Price Revenue