A comparison of estimated and actual job contribution requires a job identifier, the agreed scope, estimated and actual resource events, and consistent cost attribution. Revenue and departmental payroll totals alone are insufficient.
Why product resale and service delivery need different cost records
A distributor buys a product for a known price and sells it for another. Direct product cost can often be attributed to the sales order with limited ambiguity. In a service business, delivery itself consumes labour, travel, equipment and sometimes subcontractors. Many of those costs are shared across jobs or recorded only as totals.
That means a CRM with quote values and a finance system with payroll figures may still lack the events needed to explain job-level performance. A single spreadsheet joining quote, hours and direct costs by job ID is useful only if those elements are actually recorded and can be assigned to the same job under consistent rules.
Minimum record structure
| Record | Example grain | Decision supported |
|---|---|---|
| Quote or statement of work | Job / scope version | What was promised, at what estimated price and effort? |
| Job / work order | Service episode | What work was authorised and actually executed? |
| Labour event | Person × job × date × duration or activity | How much delivery capacity did the job use? |
| Material / subcontract cost | Cost line × job | Which variable costs should be attributed to the job? |
| Scope change | Approved change / variation | What was added, priced or delivered without new commercial approval? |
The necessary grain depends on the decision. Weekly departmental staffing may support capacity planning but cannot necessarily explain whether Job A was profitable. Conversely, capturing every minute may be costly and may distort employee behaviour when decision-making needs only coarse job categories.
Example: estimated and actual contribution
Assume a job price of £4,000, with estimated direct labour of £1,600 and materials of £500. Estimated contribution before other costs is £1,900. If actual attributable labour is £2,100 and materials £650, actual contribution on the same basis is £1,250: a £650 adverse variance. This is not net profit or a fully allocated margin. The figures identify a variance but do not establish whether it arose from scope change, estimation, labour rates or execution.
Compare estimates and actuals using the same costing policy. Specify whether labour uses direct pay or a loaded rate, whether travel is included, how warranty rework is assigned and whether recorded time is scheduled or actual. Different conventions produce different contribution figures; the difference is not a CRM configuration issue.
Assign capture to the operating event
Record an operational event in the workflow responsible for executing it, at the granularity needed for its decisions. CRM may require the agreed scope, commitments and relevant cost status, but it does not automatically need to own job execution. Integration can transfer a record only after that record exists.
If actual job labour is not currently recorded, building a dashboard to compare quoted and actual margin creates false precision. The first potential intervention may be to define a job identifier, a small taxonomy of chargeable and non-chargeable work, and an owner for recording exceptions. Software selection comes later.
Questions to validate before designing reports
- What operational unit does the business manage — contract, job, visit, ticket or asset?
- At what point does a customer promise become a delivery commitment?
- Which costs are attributable to that unit, and which are allocations?
- Where do authorised scope changes appear?
- What decision would improve if quoted and actual contribution were visible earlier?
A dashboard specification requires an agreed cost definition, a record of the operational event and a decision owner. Without them, additional fields or integrations do not produce reliable job-level analysis.
For related analysis, see how to distinguish missing data from missing integration and where operational records belong.
Illustrative calculations and process analysis, not an estimate of any real company's financial performance. Actual cost attribution requires agreed accounting policies.
Related method: Data ownership and decision fitness
About these notes. ProperBizFix uses business-model and system-coverage analysis to identify questions worth testing with an existing client. Examples are illustrative unless expressly described otherwise. How the research works.