The short answer: calculate margin from the work actually delivered
Consulting project profitability is project revenue minus the cost required to deliver that revenue. For a labor-heavy firm, the largest controllable input is usually actual project time multiplied by a loaded labor-cost rate. Add project-specific expenses, subcontractors, travel, software, write-offs, or other delivery costs that are not already included in the rate.
The formula is simple. The difficult part is keeping revenue, time, rates, and costs aligned to the same project and period. If consultants enter time late, project codes are too broad, or historical rates change when salaries change, the margin percentage can look precise while answering the wrong question.
- Project revenue = recognized fixed fee, earned retainer revenue, or billable time and materials for the period
- Labor cost = actual project hours × effective-dated loaded labor-cost rate
- Total delivery cost = labor cost + project-specific non-labor cost
- Gross project profit = project revenue − total delivery cost
- Gross project margin = gross project profit ÷ project revenue × 100
Decide which profit layer the report is showing
A project report can show contribution after direct labor, gross margin after loaded labor, or a fuller margin after allocated overhead. These are different answers. A delivery manager needs an early operating view; finance may need a result tied to the general ledger. Label the cost basis instead of calling every result ‘profit.’
For weekly management, a loaded labor rate can include salary or wages, employer payroll taxes, benefits, and a documented share of labor-related overhead. Keep company-wide selling, general, and administrative costs outside the project view unless the firm has a consistent allocation method and managers understand it.
Use the right revenue rule for the engagement model
For time-and-materials work, revenue usually follows approved billable hours and contractual bill rates, adjusted for caps, write-offs, or non-billable project time. For fixed-fee work, more hours do not create more revenue; the relevant question is how much fee has been earned and how much delivery effort remains. For retainers, compare the recurring fee with included capacity, actual service effort, and any billable overage.
Do not compare a full fixed fee with partial-period labor and call the resulting percentage current margin. Either recognize revenue using the firm’s accounting policy or show a clearly labeled operational forecast that compares the full fee with forecast total cost.
Build a project record that can support the calculation
Every active engagement needs a stable project identifier, customer, commercial model, start and expected end dates, original hours or cost budget, current approved budget, responsible project manager, applicable rates, and a status. If the work contains meaningful phases or workstreams, budget and record time at that level without creating a code list employees cannot use correctly.
Separate budget changes from actual performance. Keep the original baseline, approved change orders, current budget, and forecast. Replacing the original budget with the latest expectation hides whether sales under-scoped the work, the client expanded the scope, or delivery used more effort than planned.
Review actuals and estimate at completion every week
Actual cost explains what has happened. Estimate at completion adds the cost of the work still required. A project can show a healthy current margin and still be heading toward a loss if the difficult delivery phase remains. Ask the project manager for forecast remaining hours by role or phase, then calculate forecast total cost and forecast margin.
The review should identify the decision, not only the variance. A budget alert can lead to a scope conversation, change order, staffing change, technical escalation, write-off decision, or a revised forecast. If no one owns the next action, a red dashboard is only decoration.
- Actual hours and cost through the same cutoff date
- Missing or unapproved time that could change the result
- Forecast remaining hours by role, phase, or deliverable
- Approved and pending scope changes kept separate
- Forecast revenue, total cost, effective rate, profit, and margin
- Named owner and date for the next commercial or delivery decision
Do not improve margin by hiding hours
When a fixed-fee project is over budget, pressure can shift from controlling the work to changing where employees record it. That makes the project appear healthier but destroys the data needed to improve future estimates, staffing, and pricing. Record the work where it occurred, then decide whether it is billable, recoverable, written off, or absorbed.
Accurate non-billable project time is especially important. It distinguishes scope expansion, rework, learning, presales support, and internal administration from profitable delivery. A firm cannot fix a recurring margin problem if the timesheet contains only the hours the budget could tolerate.
Connect the operating view with QuickBooks without forcing an ERP project
QuickBooks Online Projects can organize project income, expenses, time, and profitability, and supported editions can compare estimates with actuals. That makes QuickBooks a useful financial system of record for many small consulting firms. Delivery leaders still need current time, budget burn, forecast remaining effort, and missing-time status before payroll and accounting close.
A practical architecture keeps customer, project, approved time, and rate mappings controlled upstream; sends or reconciles approved data with QuickBooks; and compares the operating view with posted financial results. Differences should produce an exception list rather than a second unofficial set of books.
The minimum weekly consulting profitability dashboard
Start with fewer measures that lead to action. Show current and forecast hours versus budget, actual and forecast labor cost, revenue basis, gross profit, margin, effective bill rate, missing time, unapproved time, and the latest forecast date. Segment by project and responsible manager, then let users trace each total to the people, dates, and work codes underneath it.
Use the completed projects to improve new estimates. Compare planned and actual hours by phase, role mix, revision cycle, and client type. The most valuable output of project profitability reporting is not a historical percentage; it is a better scope, price, staffing plan, and intervention point for the next engagement.