Completed Percent
The Completed Percent field can be used to capture the overall percentage of work that has been completed on the project or task. On a number of reports, this field can be used in conjunction with the budgeted amounts to calculate an Estimate to Complete and Estimated Total for budget comparison purposes.
Valid values range from 0 to 100, supporting 3 places to the right of the decimal.
Estimating Completed Percent
When the Completed Percent is not provided, various reports within Unanet will attempt to calculate this value (based on what information is supplied / available). As such, when establishing each project, you will need to define the estimation method. The current options include:
Estimate from Hours
Estimate from Labor Costs
Estimate from Total Costs (Labor and Expense)
Estimate from Total Cost + Burdens
Note: When selecting Total Cost + Burdens as the estimation method, you must also set a cost structure on the Accounting tab. If there is no cost structure defined for this project, you can save the project, but revenue will not be posted as part of Billing and Revenue post until the cost structure is defined.
Note that when the Estimate from value is set to Total Cost, the estimated total used in the calculation is calculated by first determining the "estimated total" of the Labor Cost and then the Expense Cost separately. You might expect different results if you assume they are first combined.
For example, if you were to set up a $1,000 labor cost budget but no expense cost budget, and then enter only $500 of expense cost actuals you might expect the system to declare the project 50% complete ($500/$1000). However, we would instead calculate the Estimated Completed Percent as 33%. Because we calculate the piece parts separately we would adjust the total budget to $1500 (the $1000 for labor cost plus the missing expense cost budget would be defaulted to $500 -- as the budget is determined to be equal to the actuals when no budget is provided). Given that, the Estimated Completed Percent would be calculated as Actuals of $500 / Estimated total of $1,500 = 33%.
See Report Calculations for more information about how Unanet handles missing values during report calculations.
Billing and Recognition based on % Complete
When using the Unanet Billing functionality and you have fixed price items having a Recognition based on % Complete, you may want to consider entering the Completed Percent vs having the system estimate it for you. Should you choose this option, you would want to initially populate the % Complete with a value of 0 (otherwise, the system will attempt to estimate a percent complete value and include that recognized amount when posting entries for that project). Further, to capture history of changes to the Completed Percent, you may want to consider using the Budget Snapshot functionality.
Frozen from further Modification
When using the Unanet Billing functionality, there are conditions when the Completed Percent is no longer modifiable.
When you have a fixed price item at the project level that is configured to Bill on Completion (see Project Billing>>Fixed Price), and billing transactions (see note below) have been generated for that item, then the % Complete and Completed Date fields will no longer be modifiable.
Note Billing transactions include:
Journal transactions with category UNBILLED generated as a result of running Billing & Revenue post that included the given fixed price item, or
BILLED journal transactions for that fixed price item resulting from running the Billing & Revenue post, adding those UNBILLED journal transactions to an invoice, and completing the invoice.