Most project-based businesses don’t find out a project lost money until the final invoice goes out, and by then there’s nothing left to do but write down the loss. Industry research puts unbilled or written-off work at 10% to 20% of all hours performed by professional services firms. That’s revenue that walked out the door quietly, one missed timesheet or scope change at a time. The good news: the signals of an unprofitable project show up weeks before the project closes, if you know where to look.
What Makes a Project Unprofitable?
A project becomes unprofitable when the cost of delivering it (labor, overhead, expenses) exceeds what you can bill and collect for it. That sounds obvious, but the erosion is rarely a single event. It’s usually a slow leak: a few unbilled hours here, a discounted change order there, a consultant working above their billable rate ceiling. By the time the final invoice is cut, the margin has already been lost. Catching it early means tracking profitability continuously, not just at close-out.
Types of Margin Erosion to Watch For
- Budget erosion: actual hours or costs outpace the original estimate.
- Billing erosion: work gets performed but never makes it onto an invoice.
- Rate erosion: senior staff get billed at junior rates, or blended rates drift below target.
The Formula for Real-Time Project Margin
You don’t need to wait for a monthly close to know where a project stands. Real-time margin gives you a live read on profitability at any point in the project.
Project Margin % = ((Revenue Earned to Date − Cost Incurred to Date) ÷ Revenue Earned to Date) × 100
- Revenue earned to date: the value of work performed, based on your recognition method (percent complete, milestone, or time and materials).
- Cost incurred to date: labor cost (hours worked × cost rate) plus any direct expenses.
- Margin %: the result, benchmarked against the target margin set at the proposal stage.
Example: a project budgeted at a 35% margin is tracking at 12% halfway through delivery. Even if the remaining work goes exactly to plan, the project will likely close well below target unless something changes now.
Pairing Margin With Burn Rate
Margin alone can be misleading early in a project, when there’s not much cost or revenue to measure yet. Pair it with burn rate:
Burn Rate % = (Actual Cost or Hours Used ÷ Total Budgeted Cost or Hours) × 100
If burn rate is running ahead of percent complete, the project is spending faster than it’s delivering, which is one of the clearest early indicators of a losing engagement.
Step-by-Step: Catching a Losing Project Early
- Set the target margin at the quote stage. You can’t identify an underperforming project without a baseline to measure against.
- Track actuals weekly, not monthly. Firms that review time and cost data weekly catch write-offs 25% to 50% less often than those relying on month-end reporting, because timesheets are fresher and more accurate.
- Compare burn rate to percent complete every week. A gap between the two is your earliest warning sign, often visible before margin dips noticeably.
- Reconcile unbilled hours against WIP regularly. Work-in-progress that sits too long without turning into an invoice is revenue at risk of being written off.
- Flag rate mismatches as they happen, not at invoicing. A senior consultant logging time at a junior rate, or a fixed-fee project absorbing scope without a change order, should trigger a review immediately.
Warning Signs to Watch For
Scope Creep Without a Change Order
When deliverables expand but the contract and budget don’t, the extra hours get absorbed silently. Track scope changes against the original statement of work, and flag any work that falls outside it before it accumulates.
Unbilled Hours Piling Up in WIP
A growing WIP balance that isn’t converting into invoices at a steady pace is often the clearest sign of billing lag. If WIP-to-invoice cycles stretch out, that’s cash and margin sitting exposed.
Utilization or Blended Rate Drifting Below Target
If the mix of staff on a project skews toward higher-cost roles doing lower-value work, the blended rate for the engagement falls, even if hours logged look normal on the surface.
Actuals Consistently Outpacing the Budget Curve
A project that’s 40% through its timeline but has already consumed 60% of its budget is a project heading toward a loss, regardless of what the invoice says today.
Making Early Detection Routine
Identifying unprofitable projects before they finish comes down to one habit: checking margin, burn rate, and WIP against target on a regular cadence, not waiting for the numbers to surface on their own. Firms that build this into a weekly rhythm catch the leak while there’s still time to course-correct, whether that means a scope conversation with the client, a staffing change, or a rate adjustment.
Want to see what real-time project profitability tracking looks like for your firm? Schedule a personalized demo and see how you can spot margin risk before it shows up in your numbers.
