The Project Dashboard provides a comprehensive overview of your Project's financial health, including contract values, budgets, billing status, projected costs, labor details, document statuses, and more, allowing you to efficiently manage and monitor your project's progress and finances.
To access a Project Dashboard, open a Project. The Dashboard will display on the landing page by default.
Contract
Total Contract: This value represents the total contract value, which is the sum of all Schedule of Value (SOV) lines.
Total Budget: This represents the total budget from the Finance tab > Updated Budget, which is the summation of all budget lines (costs).
Projected Cost to Complete: This value equals your Actual Costs plus Projected Additional Cost.
Projected GM (Gross Margin): This is calculated as Contract minus Projected Cost to Complete.
Projected Additional Cost: This value accounts for remaining costs from the budget that have not been allocated and is sourced from the 'Projections' section.
Total Budget Remaining: This represents the remaining Total Budget minus Projected Costs to Complete.
Contract Bar Graphs
Contract Value
Green: Original contract value.
Orange: Approved change orders.
Contract Growth %: This represents the percentage by which the contract has increased due to approved change orders.
Billing
Green: The value of paid invoices.
Red: The value of unpaid invoices.
Yellow: The amount of retainage withheld.
Blue: The remaining contract value yet to be billed.
% Billed: The percentage of the contract value billed to date.
Original GM (Gross Margin): Based on the contract value:
((Total Contract - Total Budget) / Total Contract).
Executed GM (Gross Margin): actual costs over the project billings
((Billed Amount + Retained Amount - Actual Costs) / (Bill Amount + Retained Amount))
Billed Amount = Paid Invoice + Open Invoices
Projected GM (Gross Margin): If values are entered in the Projection section, this will show the projected gross margin based on the values entered.
((Total Contract - Projected Cost to Complete) / Total Contract)
Projections
Projections are used to perform 'what-if' analysis of additional project costs.
Adding values to the available fields helps anticipate how the project may evolve compared to the original budget.
A user can add additional costs to the projection fields and then hover over the circle graph to see how the projected additional costs compare to the original budget.
Projected lines within the Contract section update accordingly.
The "Projected Additional Cost" summation field on the right turns red if it nears 10% of your Total Contract Value, yellow within 10%-50%, and green if 50% and above.
Labor Hours
Green: Labor hours used to date.
Orange: Projected additional labor hours.
Blue: Remaining labor hours from the original budget.
Labor Budget
Green: Labor budget used to date.
Orange: Projected additional labor cost.
Blue: Remaining labor cost from the original budget.
Blended Rates
These rates are based on the hourly cost paid to field employees (Technicians).
Printing
To maintain a record of projections, utilize the print button in the top right corner of the Contract section. A direct save function is forthcoming.
Documents
This section provides a high-level status overview of project documents.
Unapproved CO (Change Order) Cost: Dollar value of open Change Orders that are not approved.
Green: Unapproved CO cost is $0.
Orange: Unapproved CO cost is < 10% of the total budget.
Red: Unapproved CO cost is > 10% of the total budget.
# (Number) of Unapproved CO: The number of open change orders that have not been approved.
Green: 0
Red: Over half of COs are in any status other than approved.
Submittal Items Needed: Unsent submittals past their due dates.
Overdue Submittal Packages: Number of submittal packages sent to the client but past the due date and not yet approved.
Overdue RFIs (Request for Information): Number of RFIs emailed to the client but past the due date and not yet approved.
Green: 0 items
Orange: < 5 items
Red: > 5 items
Daily Report Information
This section displays basic information submitted in the latest Daily Report, including Notes, Work Performed, Delays, Out of Scope Work, Safety Concerns, Other Observations, and Internal Notes.
FAQs
Will this data update live as I enter new Purchase Orders, Invoices, Timesheets etc.?
Yes, but there is a slight delay from entering costs to the Dashboard updating.
Do the colors mean anything?
Yes, colors are used to indicate different statuses. Green signifies on-budget, yellow serves as a warning or potential risk, red represents over-budget, while blue and orange denote unused or remaining.
NOTE: A color will turn red when it reaches 10% of the budget line item remaining.
How is ‘Projected Cost to Complete’ in the Contract section calculated?
Projected Cost to Complete is the sum of actual costs in the finance tab of the project plus projected actual costs. Committed costs should be considered in your projected actual costs field.