Platform · operations

Margin while the project is still running

Project profitability is an accounting calculation that happens to need a schedule as an input, which is why it so rarely lives in the project tool. It needs loaded labour cost from payroll, pass-throughs from AP, write-offs from AR, and recognised revenue from the ledger — four systems, one spreadsheet, produced quarterly at best.

w0w3w6w9w12w15w18DiscoveryData mappingConfigurationReconciliationUATGo livetodayBudget$186,000Burned to date$104,200Forecast at complete$171,400Project margin38.4%
Recalculated on every postingLoaded cost, not billed rateForecast at complete

What it does

Six things, specifically.

Loaded labour cost

Salary or contractor cost, employer taxes, benefits, and an overhead allocation, applied per person and per role rather than as a blended rate across the team.

Pass-through cost

Subcontractors, travel, software, and production billed to the client, coded to the engagement as the vendor bills arrive rather than reconciled at closeout.

Write-offs and discounts

The gap between what was planned and what was actually invoiced — courtesy discounts, disputed lines, and written-off time. Usually the least-tracked input and a material one.

Recognised revenue

For fixed fee, revenue earned on progress rather than on billing, so margin is measured against what was earned rather than what was invoiced.

Forecast at complete

Recalculated on every posted timesheet and vendor bill, including committed cost from open purchase orders and subcontracts.

Margin by every cut

By engagement, phase, client, service line, and person — because the pattern is usually concentrated in one of those rather than general.

Why the project tool cannot answer this

Every service firm we work with runs a competent project tool and still cannot say, without a spreadsheet, which of last quarter’s engagements were profitable. That is not a discipline problem. The calculation requires four inputs and the project tool holds none of them.

So the honest framing is that project profitability belongs in the ledger and needs the schedule as an input, rather than belonging in the project tool and needing the ledger as an input. That inversion is why we read from Jira and Asana rather than replacing them.

Project profitability is an accounting calculation that needs a schedule. Not a project calculation that needs accounting. Which system it lives in follows from that.

Billed rate versus loaded cost

A margin figure built on billed rates measures pricing. One built on loaded cost measures profitability, and the two frequently disagree about which engagements are worth having — particularly where a project is staffed heavily with seniors or leans on subcontractors.

Blending cost across the team makes it worse in both directions: engagements staffed with juniors look less profitable than they are, and senior-heavy ones look better. Per-person loaded cost is more work to set up and it is the difference between a number you act on and one you argue about.

The write-off line

In professional services, write-offs commonly run five to seven percent of revenue and most firms discover the figure annually. It is almost never spread evenly — it concentrates in one client, one phase, or one pricing assumption, which means it is fixable once visible.

Including it in project margin rather than treating it as a separate revenue adjustment is what makes the concentration obvious. It is the single input most often missing from a hand-built margin spreadsheet.

Continuous, not post-mortem

The value is in the timing. A project trending fourteen percent over at week five is a scope conversation you can still have. The same project discovered at closeout is a write-off and an awkward renewal, and the analysis is identical — only the date differs.

Limits

Where this does not help.

Time data quality is the ceiling

Margin computed from reconstructed Friday timesheets inherits their inaccuracy. We will say when the input quality does not support the precision of the output.

Overhead allocation is a judgement

Headcount, revenue, or direct labour — there is no correct basis. We apply what you configure and show it on every report rather than pretending it is objective.

Not resource optimisation

We show margin, capacity, and over-commitment. Solving the staffing puzzle across constraints is a different product.

Questions

What people ask.

Can you produce this from data we already have?
Usually yes. A project list, timesheets, a payroll summary, and a ledger export is enough to produce historical margin by engagement within about a week.
How is overhead allocated?
By a method you configure — headcount, revenue, or direct labour — and it appears on every margin report. There is no objectively correct basis, so we show ours rather than hiding it.
Does it include unbilled work?
Yes, as work in progress, which ties to a control account rather than living in a separate schedule. That is what makes the margin figure reconcilable.
Can we see margin by person?
Yes, and it is usually uncomfortable and useful. The pattern is normally concentrated rather than general — one role or one client explains most of the variance.
What if our time data is unreliable?
Then margin inherits that, and we will say so rather than presenting a precise number built on approximate inputs. Improving time capture is usually the first fix.

Find out what last quarter earned.

A project list, timesheets, and a ledger export is enough to produce true margin by engagement.