How to Track Agency Project Margin in Real Time (Before the Project Closes)
How do you track agency project margin in real time? You connect logged time at cost rates to the project fee, and you compare burn rate against percent complete every week, not every month. Month-end reports tell you a project lost money after the money is gone. A live margin number tells you while there is still a decision to make.
How to track agency project margin in real time: the formula that has to stay live
Project margin is revenue minus delivery cost, divided by revenue. Delivery cost is logged hours times each person's cost rate, plus contractor and pass-through costs. The formula is simple. The hard part is keeping the inputs current, because a margin calculated from last month's timesheets is a history lesson, not a warning.
Real-time tracking means the number moves when a timesheet is submitted, not when the invoice goes out. If your team logs time daily, the margin updates daily. If your team logs time on Fridays, you get a weekly picture, which is still far better than month-end. The tracking habit matters more than the tool. A spreadsheet updated daily beats a dashboard nobody opens.
The four numbers that catch a dying project
First, burn rate against percent complete. If the team has burned 60% of budgeted hours but delivered 40% of the work, the project is heading for an overrun even if the margin still looks fine today. Percent complete is a judgment call, so get it from the project lead, not from the timesheet.
Second, realized rate. Divide billable value by hours logged and compare it to the rate you quoted. A project quoted at $150 an hour that realizes $110 is bleeding through rate mix, usually senior people doing junior work, or unbilled revisions.
Third, unbilled work in progress. Hours delivered but not yet invoiced hide margin erosion until close, especially on milestone-billed work. If the WIP balance grows while the margin holds steady, the margin is lying.
Fourth, role mix. The same 100 hours cost very different amounts depending on who logs them. When senior time creeps above the plan, margin falls even when total hours stay on budget. Our employees vs contractors guide covers the cost-rate side of this.
The $12,000 project that looks fine until it does not
Take a fixed-fee project: $12,000 fee, 100 hours budgeted at a blended cost rate of $70 an hour. Budgeted cost is $7,000. Planned margin is $5,000, or about 42%.
At the checkpoint, the team has logged 60 hours, so $4,200 of cost. The margin still shows 65% if you only compare cost to fee, because most of the fee is still unearned. But the project lead says 40% of the work is done. Projected total hours are 60 divided by 0.4, which is 150 hours. Projected cost is $10,500. Projected margin is $1,500, or 12.5%.
That is the whole argument for real-time tracking in one example. The naive margin says 65%. The burn-adjusted margin says 12.5%. Same project, same day, and only one of those numbers tells you to act. Run your own checkpoint on our agency project margin calculator with projected hours instead of logged hours.
Alerts, not reports
A number nobody watches is decoration. Set two thresholds and act on them. When burn rate passes percent complete by 10 points, the project lead explains the gap in the weekly check-in. When projected margin falls 10 points below plan, the account lead decides: descope, change-order, or eat it deliberately.
Deliberately is doing real work in that sentence. Sometimes you eat a loss to keep a client. The difference between eating a loss on purpose and discovering one at close is the difference between a decision and a surprise. Real-time tracking turns the second into the first.
Change orders are where the tracking pays for itself. When the client asks for extra work, the margin impact is calculable on the spot: added hours at cost rates against added fee. Our scope creep guide has the erosion math, and our over-servicing guide covers the unbilled-revision leak.
What to do when the numbers are ugly
Three moves, in order. First, stop the unbilled work. Every hour delivered without a change order is margin you chose to give away. Second, fix the staffing mix: move junior-capable work off senior calendars. Third, renegotiate scope with the client, with the numbers in hand. Clients respect a scope conversation backed by hours. They resent a surprise invoice backed by nothing.
The question I am leaving open is how often to look. Daily is right for a project in trouble. Weekly is right for a healthy one. The cadence should follow the risk, and the risk reading is the point of the dashboard in the first place.
Frequently Asked Questions
How do you track agency project margin in real time?
Connect logged time at cost rates to the project fee so margin updates when timesheets are submitted. Compare burn rate against percent complete, and watch realized rate, unbilled work in progress, and role mix.
What is the formula for agency project margin?
Project margin equals fee minus delivery cost, divided by fee. Delivery cost is logged hours times cost rates, plus contractor and pass-through costs.
What is a good alert threshold for project margin?
A common setup: flag the project when burn rate passes percent complete by 10 points, and escalate when projected margin falls 10 points below plan.
Why does my project margin look fine mid-project and collapse at close?
Because naive margin compares cost to fee instead of cost to progress. A project can show high margin mid-flight while burn-adjusted projections already show an overrun. Unbilled revisions and senior-heavy staffing are the usual causes.
Does real-time margin tracking require special software?
No. A spreadsheet updated when timesheets are submitted works if the team logs time daily or weekly. The tracking habit matters more than the tool.
Check Your Project Margin
Plug in fee, hours, and cost rates and see where the project stands.
Calculate My Margin