Overview
The Project datasets provide project-level metrics in CORE, drawn from three related data sources: Projects, Project Metrics - Monthly, and Project Metrics - Cumulative. Most fields are shared across all three; each dataset differs mainly in whether it stores a single current value, a monthly snapshot, or a Project-to-Date (PTD) snapshot. The Fields table below lists every field once and marks which of the three datasets each one is available in.
Dataset Structure
Projects holds current, non-historical project metrics. Each project or phase has a single, always-current record. Filter on Project Level to avoid combining Root Project and Phase totals.
Project Metrics - Monthly and Project Metrics - Cumulative are both multi-level and snapshot-based: they store a record for every project or phase for each reporting month, rather than a single live record. This lets you navigate between different reporting periods, such as for trend or Project-to-Date charts. Filter on Project Level and Month Start before charting; Project Metrics - Cumulative also requires Is Latest to isolate PTD totals. If a chart does not filter to a single level or reporting period, both levels or all periods are included, which may produce inflated or duplicated totals.
Note: Not every field applies to every dataset — see the Projects, Project Metrics - Monthly, and Project Metrics - Cumulative columns in the Fields table below. The Project Level Rollup column indicates whether the field's value rolls up from Phase to Root Project.
Fields
| Type | Column | Description | Calculation | Projects | Project Metrics - Monthly | Project Metrics - Cumulative | Project Level Rollup |
|---|---|---|---|---|---|---|---|
| Value | All Cost | Total cost incurred for the project, including billable and non-billable services and expenses. | Billed Cost + Unbilled Cost + Non-Billable Cost | ✓ | – | ✓ | ✓ |
| Value | All Hours | Total hours recorded for the project, including billable and non-billable time entries. | Billed Hours + Unbilled Hours + Non-Billable Hours | ✓ | ✓ | ✓ | ✓ |
| Value | Billed | Total amount invoiced for billable services and expenses, including write-up/down (WUD) adjustments and expense markups. Excludes discounts and miscellaneous invoice adjustments. | Billed Contract + Billed Extra | ✓ | ✓ | ✓ | ✓ |
| Value | Billed and Unbilled | Combined value of billable services and expenses that have been invoiced or are pending invoicing. | Billed + Unbilled | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Contract | Combined value of billable contract services and expenses that have been invoiced or are pending invoicing. | Billed Contract + Unbilled Contract | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Contract Cost | Total cost associated with billed and unbilled contract services and expenses. | Billed Contract Cost + Unbilled Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Contract Profit | Profit generated from billed and unbilled contract work after associated costs are applied. | Billed and Unbilled Contract - All Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Contract Value | Total value of billed and unbilled contract services and expenses, excluding write-up/down (WUD) adjustments. | Billed and Unbilled Expenses Contract Value + Billed and Unbilled Services Contract Value | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Cost | Total cost associated with billed and unbilled services and expenses. | Billed Cost + Unbilled Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Expenses | Combined value of billable expenses that have been invoiced or are pending invoicing, including markups. | Billed Expenses + Unbilled Expenses | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Expenses Contract | Combined value of billable contract expenses that have been invoiced or are pending invoicing, including markups. | Billed Expenses Contract + Unbilled Expenses Contract | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Expenses Contract Cost | Total cost associated with billed and unbilled contract expenses. | Billed Expenses Contract Cost + Unbilled Expenses Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Expenses Cost | Total cost associated with billed and unbilled expenses. | Billed Expenses Cost + Unbilled Expenses Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Expenses Extra | Combined value of billable extra expenses that have been invoiced or are pending invoicing, including markups. | Billed Expenses Extra + Unbilled Expenses Extra | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Expenses Extra Cost | Total cost associated with billed and unbilled extra expenses. | Billed Expenses Extra Cost + Unbilled Expenses Extra Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Extra | Combined value of billable extra services and expenses that have been invoiced or are pending invoicing, including write-up/down (WUD) adjustments and markups. | Billed Extra + Unbilled Extra | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Extra Cost | Total cost associated with billed and unbilled extra services and expenses. | Billed Extra Cost + Unbilled Extra Cost | ✓ | – | ✓ | ✓ |
| Value | Billed And Unbilled Hours | Total billable hours that have been invoiced or are pending invoicing. | Billed Hours + Unbilled Hours | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Profit | Profit generated from billed and unbilled work after all associated costs are applied. | Billed and Unbilled - All Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services | Combined value of billable services that have been invoiced or are pending invoicing, including write-up/down (WUD) adjustments. | Billed Services + Unbilled Services | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Contract | Combined value of billable contract services that have been invoiced or are pending invoicing, including write-up/down (WUD) adjustments. | Billed Services Contract + Unbilled Services Contract | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Contract Cost | Total cost associated with billed and unbilled contract services. Includes services performed by employees, contract employees, and outside consultants. | Billed Services Contract Cost + Unbilled Services Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Contract Unloaded Cost | Labor cost of billed and unbilled contract services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Billed Services Contract Cost + Unbilled Services Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Contract Value | Total value of billed and unbilled contract services, excluding write-up/down (WUD) adjustments. | Billed Services Contract Value + Unbilled Services Contract Value | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Cost | Total cost associated with billed and unbilled services. Includes services performed by employees, contract employees, and outside consultants. | Billed Services Cost + Unbilled Services Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Extra | Combined value of billable extra services that have been invoiced or are pending invoicing, including write-up/down (WUD) adjustments. | Billed Services Extra + Unbilled Services Extra | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Extra Cost | Total cost associated with billed and unbilled extra services. Includes services performed by employees, contract employees, and outside consultants. | Billed Services Extra Cost + Unbilled Services Extra Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Extra Unloaded Cost | Labor cost of billed and unbilled extra services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Billed Services Extra Cost + Unbilled Services Extra Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Extra Value | Total value of billed and unbilled extra services, excluding write-up/down (WUD) adjustments. | Billed Services Extra Value + Unbilled Services Extra Value | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Profit | Profit generated from billed and unbilled services after all associated service costs are applied. | Billed and Unbilled Services - (Billed Services Cost + Unbilled Services Cost + Non-Billable Services Cost) | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Unloaded Cost | Labor cost of billed and unbilled services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Billed Services Unloaded Cost + Unbilled Services Unloaded Cost | ✓ | – | ✓ | ✓ |
| Value | Billed and Unbilled Services Value | Total value of billed and unbilled services, excluding write-up/down (WUD) adjustments. | Billed Services Value + Unbilled Services Value | ✓ | – | ✓ | ✓ |
| Value | Billed Contract | Total value of billable contract services and expenses that have been invoiced, including write-up/down (WUD) adjustments and markups. | Billed Expenses Contract + Billed Services Contract | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Contract Cost | Total cost associated with billed contract services and expenses. | Billed Expenses Contract Cost + Billed Services Contract Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Contract Profit | Profit generated from billed contract work after associated contract costs are applied. | Billed Contract - (Billed Contract Cost + Non-Billable Contract Cost) | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Cost | Total cost associated with billed services and expenses. | Billed Expenses Cost + Billed Services Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Discount | Total discount amount applied to project invoices. | ✓ | ✓ | ✓ | ✓ | |
| Value | Billed Employee Services Contract | Total value of billed contract services performed by employees and contract employees. Excludes services performed by outside consultants. | Billed Services Contract - Billed Outside Consultant Services Contract | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Employee Services Extra | Total value of billed extra services performed by employees and contract employees. Excludes services performed by outside consultants. | Billed Services Extra - Billed Outside Consultant Services Extra | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Employee Services Unloaded Cost | Labor cost of billed employee services before overhead allocations are applied. Includes employees and contract employees but excludes outside consultants. | Billed Services Unloaded Cost - Billed Outside Consultant Services Unloaded Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Expenses | Total value of billed expenses, including contract and extra expenses with applicable markups. | Billed Expenses Contract + Billed Expenses Extra | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Expenses Contract | Total value of billed contract expenses, including applicable markups. | Units × Cost × ((100 + Markup)/100) | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Expenses Contract Cost | Total cost associated with billed contract expenses. | Units × Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Expenses Cost | Total cost associated with billed contract and extra expenses. | Units × Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Expenses Extra | Total value of billed extra expenses, including applicable markups. | Units × Cost × ((100 + Markup)/100) | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Expenses Extra Cost | Total cost associated with billed extra expenses. | Units × Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Extra | Total value of billed extra services and expenses, including write-up/down (WUD) adjustments and markups. | Billed Expenses Extra + Billed Services Extra | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Extra Cost | Total cost associated with billed extra services and expenses. | Billed Expenses Extra Cost + Billed Services Extra Cost | – | ✓ | ✓ | ✓ |
| Value | Billed Hours | Total billable hours that have been invoiced or included on a final invoice. | ✓ | ✓ | ✓ | ✓ | |
| Value | Billed Misc Adjustment | Total miscellaneous invoice adjustments applied to project invoices, excluding discounts. | ✓ | ✓ | ✓ | ✓ | |
| Value | Billed Outside Consultant Services Contract Unloaded Cost | Labor cost of billed contract services performed by outside consultants before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Outside Consultant Services Extra Unloaded Cost | Labor cost of billed extra services performed by outside consultants before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Outside Consultant Services Unloaded Cost | Total labor cost of billed services performed by outside consultants before overhead allocations are applied. | Billed Outside Consultant Services Contract Unloaded Cost + Billed Outside Consultant Services Extra Unloaded Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Profit | Profit generated from billed services and expenses after all associated billed and non-billable costs are applied. | Billed - (Billed Cost + Non-Billable Cost) | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Profit All Cost | Profit generated from billed services and expenses after all project costs, including billed, unbilled, and non-billable costs, are applied. | Billed - All Cost | ✓ | – | ✓ | ✓ |
| Value | Billed Services | Total value of billed services, including write-up/down (WUD) adjustments. | Billed Services Contract + Billed Services Extra | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Contract | Total value of billed contract services, including write-up/down (WUD) adjustments. | Bill Rate × Client Hours × WUD Multiplier | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Contract Cost | Total cost associated with billed contract services. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Contract Unloaded Cost | Labor cost of billed contract services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Contract Value | Total value of billed contract services, excluding write-up/down (WUD) adjustments. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Cost | Total cost associated with billed contract and extra services. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Extra | Total value of billed extra services, including write-up/down (WUD) adjustments. | Bill Rate × Client Hours × WUD Multiplier | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Extra Cost | Total cost associated with billed extra services. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Extra Unloaded Cost | Labor cost of billed extra services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Extra Value | Total value of billed extra services, excluding write-up/down (WUD) adjustments. | Actual Hours × Bill Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Profit | Profit generated from billed services after all associated billed and non-billable service costs are applied. | Billed Services - (Billed Services Cost + Non-Billable Services Cost) | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Unloaded Cost | Total labor cost of billed services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Services Value | Total value of billed contract and extra services, excluding write-up/down (WUD) adjustments. | Actual Hours × Bill Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Billed Tax | Total tax amount included on billed invoices. | ✓ | – | ✓ | ✓ | |
| Value | Billed Value | Total value of billed services and expenses, excluding write-up/down (WUD) adjustments. Excludes discounts and miscellaneous invoice adjustments. | Billed Contract Value + Billed Extra Value | ✓ | ✓ | ✓ | ✓ |
| Value | Budget | Total budget amount allocated to the project or phase. | Budget Services + Budget Expenses + Budget Misc | ✓ | – | ✓ | ✓ |
| Value | Budget Expenses | Total budgeted amount allocated for project expenses. | Budget Units × Cost × ((100 + Markup)/100) | ✓ | – | ✓ | ✓ |
| Value | Budget Expenses Remaining | Remaining expense budget available after recorded expenses are applied. | Budget Expenses - Spent Expenses | ✓ | – | ✓ | ✓ |
| Value | Budget Hours | Total budgeted hours allocated to the project or phase. | ✓ | – | ✓ | ✓ | |
| Value | Budget Hours Remaining | Remaining budgeted hours available after recorded hours are applied. | Budget Hours - Spent Hours | ✓ | – | ✓ | ✓ |
| Value | Budget Hours Spent Percent | Percentage of budgeted hours that have been used. | (Spent Hours / Budget Hours) × 100 | ✓ | – | ✓ | ✓ |
| Value | Budget Remaining | Remaining project budget available after recorded costs are applied. | Budget - Spent | ✓ | – | ✓ | ✓ |
| Value | Budget Services | Total budgeted amount allocated for project services. | Budget Hours × Bill Rate | ✓ | – | ✓ | ✓ |
| Value | Budget Services Remaining | Remaining service budget available after recorded service costs are applied. | Budget Services - Spent Services | ✓ | – | ✓ | ✓ |
| Value | Budget Spent Percent | Percentage of the total budget that has been used. | (Spent / Budget) × 100 | ✓ | – | ✓ | ✓ |
| Value | Budgeted Percent | Percentage of the contract amount that has been budgeted. | (Budget / Contract) × 100 | ✓ | – | ✓ | ✓ |
| Value | Contract Amount | Total contract amount allocated to the project or phase. | – | – | ✓ | – | |
| Value | Contract Billed Percent | Percentage of the contract amount that has been billed. | (Billed Contract / Contract) × 100 | ✓ | – | ✓ | ✓ |
| Value | Contract Billed Remaining | Remaining contract amount that has not yet been billed. | Contract - Billed Contract | ✓ | – | ✓ | ✓ |
| Value | Contract Remaining | Remaining contract value available based on billed and unbilled contract work. | Contract - Billed and Unbilled Contract | ✓ | – | ✓ | ✓ |
| Value | Contract Used Percent | Percentage of the contract amount that has been used through billed and unbilled contract work. | (Billed and Unbilled Contract / Contract) × 100 | ✓ | – | ✓ | ✓ |
| Value | Direct Labor Multiplier | Measures labor efficiency by comparing billed employee service revenue to employee labor cost. A higher value indicates greater revenue generated per labor dollar spent. | Billed Employee Services / (Billed Employee Services Unloaded Cost + Non-Billable Employee Services Unloaded Cost) | ✓ | ✓ | ✓ | ✓ |
| Value | Gross Margin Billed | Profit margin for billed work after accounting for discounts and invoice adjustments. | (Net Billed Profit / Net Billed) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Gross Margin Billed and Unbilled | Profit margin for billed and unbilled work after accounting for discounts and invoice adjustments. | (Net Billed and Unbilled Profit / Net Billed and Unbilled) × 100 | ✓ | – | ✓ | ✓ |
| Value | Gross Margin Billed and Unbilled Contract | Profit margin for billed and unbilled contract work after accounting for discounts and invoice adjustments. | (Net Billed and Unbilled Contract Profit / Net Billed and Unbilled Contract) × 100 | ✓ | – | ✓ | ✓ |
| Value | Gross Margin Billed Contract | Profit margin for billed contract work after accounting for discounts and invoice adjustments. | (Net Billed Contract Profit / Net Billed Contract) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Net Billed | Total billed amount after discounts and miscellaneous invoice adjustments are applied. Excludes taxes and retainer applications. | Billed - Billed Discount + Billed Misc Adjustment | ✓ | ✓ | ✓ | ✓ |
| Value | Net Billed and Unbilled | Combined net value of billed and unbilled services and expenses after discounts and invoice adjustments are applied to billed amounts. Excludes taxes and retainer applications. | Net Billed + Unbilled | ✓ | – | ✓ | ✓ |
| Value | Net Billed and Unbilled Contract | Combined net value of billed and unbilled contract services and expenses after discounts and invoice adjustments are applied to billed amounts. | Net Billed Contract + Unbilled Contract | ✓ | – | ✓ | ✓ |
| Value | Net Billed and Unbilled Contract Profit | Profit generated from billed and unbilled contract work after all associated contract costs are applied. | Net Billed and Unbilled Contract - (Billed Contract Cost + Unbilled Contract Cost + Non-Billable Contract Cost) | ✓ | – | ✓ | ✓ |
| Value | Net Billed and Unbilled Profit | Profit generated from billed and unbilled services and expenses after all associated costs are applied. | Net Billed and Unbilled - (Billed Cost + Unbilled Cost + Non-Billable Cost) | ✓ | – | ✓ | ✓ |
| Value | Net Billed Contract | Net billed value of contract services and expenses after discounts and miscellaneous invoice adjustments are applied. Excludes taxes and retainer applications. | Billed Contract - Billed Discount + Billed Misc Adjustment | ✓ | ✓ | ✓ | ✓ |
| Value | Net Billed Contract Profit | Profit generated from billed contract work after all associated contract costs are applied. | Net Billed Contract - (Billed Contract Cost + Non-Billable Contract Cost) | ✓ | ✓ | ✓ | ✓ |
| Value | Net Billed Profit | Profit generated from billed services and expenses after all associated billed and non-billable costs are applied. | Net Billed - (Billed Cost + Non-Billable Cost) | ✓ | ✓ | ✓ | ✓ |
| Value | Net Billed Profit All Cost | Profit generated from billed services and expenses after all project costs, including billed, unbilled, and non-billable costs, are applied. | Net Billed - All Cost | ✓ | – | ✓ | ✓ |
| Value | Net Realization Rate | Percentage of potential billable revenue that was realized after discounts and invoice adjustments are applied. | (Net Billed / Billed Value) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable | Total value of non-billable services and expenses recorded for the project. | Non-Billable Services + Non-Billable Expenses | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Contract | Total value of non-billable contract services and expenses recorded for the project. | ✓ | – | ✓ | ✓ | |
| Value | Non-Billable Contract Cost | Total cost associated with non-billable contract services and expenses. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Cost | Total cost associated with non-billable services and expenses. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Employee Services Unloaded Cost | Labor cost of non-billable employee services before overhead allocations are applied. Excludes services performed by outside consultants. | Non-Billable Services Unloaded Cost - Non-Billable Outside Consultant Services Unloaded Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Expenses | Total value of non-billable expenses, including applicable markups. | Non-Billable Expenses Contract + Non-Billable Expenses Extra | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Expenses Contract | Total value of non-billable contract expenses, including applicable markups. | Units × Cost × ((100 + Markup)/100) | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Expenses Contract Cost | Contract Cost | Units × Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Expenses Cost | Total cost associated with non-billable contract and extra expenses. | Units × Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Expenses Extra | Total value of non-billable extra expenses, including applicable markups. | Units × Cost × ((100 + Markup)/100) | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Expenses Extra Cost | Total cost associated with non-billable extra expenses. | Units × Cost | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Extra | Total value of non-billable extra services and expenses recorded for the project. | ✓ | – | ✓ | ✓ | |
| Value | Non-Billable Extra Cost | Total cost associated with non-billable extra services and expenses. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Hours | Total non-billable hours recorded for the project. | ✓ | ✓ | ✓ | ✓ | |
| Value | Non-Billable Outside Consultant Services Contract Unloaded Cost | Labor cost of non-billable contract services performed by outside consultants before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Outside Consultant Services Extra Unloaded Cost | Labor cost of non-billable extra services performed by outside consultants before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Outside Consultant Services Unloaded Cost | Total labor cost of non-billable services performed by outside consultants before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Services | Total value of non-billable services recorded for the project, including write-up/down (WUD) adjustments. | Non-Billable Services Contract + Non-Billable Services Extra | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Services Contract | Total value of non-billable contract services recorded for the project, including write-up/down (WUD) adjustments. | Bill Rate × Client Hours × WUD Multiplier | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Services Contract Cost | Total cost associated with non-billable contract services. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Services Contract Unloaded Cost | Labor cost of non-billable contract services before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Services Cost | Total cost associated with non-billable contract and extra services. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Services Extra | Total value of non-billable extra services recorded for the project, including write-up/down (WUD) adjustments. | Bill Rate × Client Hours × WUD Multiplier | ✓ | – | ✓ | ✓ |
| Value | Non-Billable Services Extra Cost | Total cost associated with non-billable extra services. | Actual Hours × Cost Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Services Extra Unloaded Cost | Labor cost of non-billable extra services before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Non-Billable Services Unloaded Cost | Total labor cost of non-billable services before overhead allocations are applied. | Actual Hours × Pay Rate | ✓ | ✓ | ✓ | ✓ |
| Value | Open AR | Outstanding accounts receivable balance for the project. Does not include write-offs. | ✓ | – | ✓ | ✓ | |
| Value | Paid | Total payments applied to project invoices. | ✓ | ✓ | ✓ | ✓ | |
| Value | Percent Complete | Percentage of project completion entered manually for the project or phase. | ✓ | – | ✓ | – | |
| Value | Phase Contract | Total contract amount from all child phases associated with the project. | ✓ | – | ✓ | – | |
| Value | Project Margin Billed | Profit margin for billed work. Includes billed services and expenses but excludes discounts and miscellaneous invoice adjustments. | (Billed Profit / Billed) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Project Margin Billed All Cost | Profit margin for billed work based on all project costs, including billed, unbilled, and non-billable costs. Excludes discounts and miscellaneous invoice adjustments. | (Billed Profit All Cost / Billed) × 100 | ✓ | – | ✓ | ✓ |
| Value | Project Margin Billed and Unbilled | Profit margin for billed and unbilled work. Includes contract and extra services and expenses while excluding discounts and miscellaneous invoice adjustments. | (Billed and Unbilled Profit / Billed and Unbilled) × 100 | ✓ | – | ✓ | ✓ |
| Value | Project Margin Billed and Unbilled Contract | Profit margin for billed and unbilled contract work. Includes contract services and expenses while excluding discounts and miscellaneous invoice adjustments. | (Billed and Unbilled Contract Profit / Billed and Unbilled Contract) × 100 | ✓ | – | ✓ | ✓ |
| Value | Project Margin Billed and Unbilled Services | Profit margin for billed and unbilled services. Includes contract and extra services while excluding discounts and miscellaneous invoice adjustments. | (Billed and Unbilled Services Profit / Billed and Unbilled Services) × 100 | ✓ | – | ✓ | ✓ |
| Value | Project Margin Billed Contract | Profit margin for billed contract work. Includes contract services and expenses while excluding discounts and miscellaneous invoice adjustments. | (Billed Contract Profit / Billed Contract) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Project Margin Billed Services | Profit margin for billed services. Includes contract and extra services while excluding discounts and miscellaneous invoice adjustments. | (Billed Services Profit / Billed Services) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Realization Rate | Percentage of potential billable revenue that was realized through invoicing. Excludes discounts and miscellaneous invoice adjustments. | (Billed / Billed Value) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Retainer Applied | Total retainer amount applied to project invoices. | ✓ | ✓ | ✓ | ✓ | |
| Value | Retainer Balance | The current retainer balance of this project or phase. | ✓ | – | ✓ | – | |
| Value | Retainer Received | The total retainer received for this project or phase. | ✓ | ✓ | ✓ | – | |
| Value | Spent | Total amount spent on project services and expenses. | Spent Services + Spent Expenses | ✓ | – | ✓ | ✓ |
| Value | Spent Expenses | Total value of expenses recorded against the project, including applicable markups. | Spent Units × Cost × ((100 + Markup)/100) | ✓ | – | ✓ | ✓ |
| Value | Spent Hours | Total hours recorded for the project, including billable and non-billable time entries. | ✓ | – | ✓ | ✓ | |
| Value | Spent Services | Total value of services recorded against the project, excluding write-up/down (WUD) adjustments. | Spent Hours × Bill Rate | ✓ | – | ✓ | ✓ |
| Value | Unbilled | Total value of billable services and expenses that have not yet been invoiced. Includes write-up/down (WUD) adjustments and expense markups. Excludes discounts and miscellaneous invoice adjustments. | Unbilled Contract + Unbilled Extra | ✓ | – | ✓ | ✓ |
| Value | Unbilled Contract | Total value of billable contract services and expenses that have not yet been invoiced. Includes write-up/down (WUD) adjustments and expense markups. | Unbilled Expenses Contract + Unbilled Services Contract | ✓ | – | ✓ | ✓ |
| Value | Unbilled Contract Cost | Total cost associated with unbilled contract services and expenses. | Unbilled Expenses Contract Cost + Unbilled Services Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Cost | Total cost associated with unbilled services and expenses. | Unbilled Expenses Cost + Unbilled Services Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Expenses | Total value of billable expenses that have not yet been invoiced, including applicable markups. | Unbilled Expenses Contract + Unbilled Expenses Extra | ✓ | – | ✓ | ✓ |
| Value | Unbilled Expenses Contract | Total value of billable contract expenses that have not yet been invoiced, including applicable markups. | Units × Cost × ((100 + Markup)/100) | ✓ | – | ✓ | ✓ |
| Value | Unbilled Expenses Contract Cost | Total cost associated with unbilled contract expenses. | Units × Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Expenses Cost | Total cost associated with unbilled contract and extra expenses. | Units × Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Expenses Extra | Total value of billable extra expenses that have not yet been invoiced, including applicable markups. | Markup)/100) | ✓ | – | ✓ | ✓ |
| Value | Unbilled Expenses Extra Cost | Total cost associated with unbilled extra expenses. | Units × Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Extra | Total value of billable extra services and expenses that have not yet been invoiced. Includes write-up/down (WUD) adjustments and expense markups. | Unbilled Expenses Extra + Unbilled Services Extra | ✓ | – | ✓ | ✓ |
| Value | Unbilled Extra Cost | Total cost associated with unbilled extra services and expenses. | Unbilled Expenses Contract Cost + Unbilled Services Contract Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Hours | Total billable hours that have not yet been invoiced. | ✓ | – | ✓ | ✓ | |
| Value | Unbilled Services | Total value of billable services that have not yet been invoiced. Includes write-up/down (WUD) adjustments. | Unbilled Services Contract + Unbilled Services Extra | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Contract | Total value of billable contract services that have not yet been invoiced. Includes write-up/down (WUD) adjustments. | Bill Rate × Client Hours × WUD Multiplier | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Contract Cost | Total cost associated with unbilled contract services. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Cost Rate | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Contract Unloaded Cost | Labor cost of unbilled contract services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Pay Rate | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Contract Value | Total value of unbilled contract services, excluding write-up/down (WUD) adjustments. | Bill Rate × Actual Hours | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Cost | Total cost associated with unbilled contract and extra services. Includes services performed by employees, contract employees, and outside consultants. | Unbilled Services Contract Cost + Unbilled Services Extra Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Extra | Total value of billable extra services that have not yet been invoiced. Includes write-up/down (WUD) adjustments. | Bill Rate × Client Hours × WUD Multiplier | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Extra Cost | Total cost associated with unbilled extra services. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Cost Rate | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Extra Unloaded Cost | Labor cost of unbilled extra services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Actual Hours × Pay Rate | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Extra Value | Total value of unbilled extra services, excluding write-up/down (WUD) adjustments. | Bill Rate × Actual Hours | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Unloaded Cost | Total labor cost of unbilled services before overhead allocations are applied. Includes services performed by employees, contract employees, and outside consultants. | Unbilled Services Contract Unloaded Cost + Unbilled Services Extra Unloaded Cost | ✓ | – | ✓ | ✓ |
| Value | Unbilled Services Value | Total value of unbilled contract and extra services, excluding write-up/down (WUD) adjustments. | Unbilled Services Contract Value + Unbilled Services Extra Value | ✓ | – | ✓ | ✓ |
| Value | Utilization Rate | Percentage of total recorded hours that are billable. | (Billable Hours / All Hours) × 100 | ✓ | ✓ | ✓ | ✓ |
| Value | Writeoff | Total amount written off for the project or phase. | ✓ | ✓ | ✓ | ✓ |