Project Cost Detail

The Project Cost Detail data model provides a detailed view of project financial activity from Sage Intacct Construction / CRE. It combines project estimates, actual costs, commitments, billing, contract values, retainage, and profitability measures across project, cost code, cost type, vendor, customer, department, location, project manager, and reporting period.

Benefits of This Data Model

• Strengthen project cost control: Compare original and revised estimates with actual costs, commitments, and payments.
• Monitor project profitability: Review contract value, billing, earned revenue, gross profit, margin, and over/under billing.
• Centralize job-cost analysis: Analyze project financial performance by project hierarchy, cost code, vendor, customer, department, location, and period.

Key Performance Indicators (KPIs)

• Original Estimate: Original estimated project cost.
• Estimate Revision: Amount of estimate revisions.
• Estimate Approved Changes: Approved changes to the project estimate.
• Total Estimate: Current total project estimate.
• Estimate Labor: Estimated labor cost.
• Estimate Material: Estimated material cost.
• Estimate Subcontract: Estimated subcontract cost.
• Estimate Equipment: Estimated equipment cost.
• Estimate Other: Estimated other cost.
• Estimate Overhead: Estimated overhead cost.
• Actual Labor: Actual labor cost.
• Actual Material: Actual material cost.
• Actual Subcontract: Actual subcontract cost.
• Actual Equipment: Actual equipment cost.
• Actual Other: Actual other cost.
• Actual Overhead: Actual overhead cost.
• Total Estimate vs Actual Variance: Variance between total estimated and actual project cost.
• Estimate vs Actual Cost Margin %: Percentage margin between estimated and actual cost.
• Original Commitment: Original project commitment amount.
• Approved Changes Commitment: Approved changes to commitments.
• Commitments Invoiced: Amount invoiced against commitments.
• Total Commitment: Current total commitment amount.
• Open Commitments: Remaining open commitment amount.
• Total Cost: Total project cost.
• Total Paid: Total amount paid.
• Pending Change Request Cost: Cost associated with pending change requests.
• Pending Change Request Price: Price associated with pending change requests.
• Original Contract Price: Original project contract price.
• Revised Contract Price: Current revised contract price.
• Approved Change Price: Approved contract change price.
• Payment Received: Payments received against the project.
• Billed Price: Amount billed.
• Remaining Contract to Bill: Contract value remaining to be billed.
• % Paid: Percentage of the relevant billed or contract amount that has been paid.
• Original Estimated Gross Profit: Gross profit based on the original estimate.
• Original Estimated Gross Margin %: Gross margin percentage based on the original estimate.
• Current Estimated Gross Profit: Gross profit based on the current estimate.
• Current Estimated Gross Margin %: Gross margin percentage based on the current estimate.
• Percent Complete: Project completion percentage.
• Percent Billed: Percentage of the project contract billed.
• Revenue Earned: Revenue earned for the project.
• Earned Profit: Profit earned for the project.
• Actual Gross Margin: Actual project gross margin.
• Billing in Excess of Cost: Billing amount that exceeds recognized cost.
• Cost in Excess of Billing: Recognized cost that exceeds billing.
• Over/Under Billed: Net overbilled or underbilled position.
• Project Contract Retainage Held: Retainage held on project contract billing.
• Project Contract Retainage Released: Project contract retainage released.
• AP Retainage Held: Accounts payable retainage held.
• AP Retainage Released: Accounts payable retainage released.
• AP Total Paid: Total accounts payable amount paid.

Available Visualizations

View Name	Description
Project Cost Overview	Summarizes estimates, commitments, project costs, payments, billing, and project performance.
Job Cost GL Detail	Provides detailed project cost activity with accounting context such as GL account, journal, and batch.
Estimate vs Actual Costs	Compares estimated project costs with actual costs and related variances.
Project Contracts	Reviews project contract values, billing, retainage, and related project financial measures.
WIP (as of…)	Provides work-in-progress reporting as of a selected date, including project cost, billing, and over/under billed position.