Finance Toolkit — free template
Project Profitability Tracker Template
Budget versus actual, hours versus plan, and true margin on every active project — one tracker that shows which engagements are earning their keep and which are quietly draining the firm.
What it is
Most project firms know their overall margin from the monthly P&L. Far fewer can answer the harder question: which projects made money and which lost it. The project profitability tracker closes that gap. It's a working spreadsheet where every active project gets a row — its budget, its actual hours and costs to date, its recognized revenue, and its true margin — updated monthly (or weekly on large engagements) so problems surface while there's still time to intervene.
The tracker is deliberately simple: one line per project, honest numbers, no allocations that require a finance degree to explain. Its power comes from consistency — the same definitions, applied to every project, reviewed on a cadence — which turns scattered project knowledge into decisions about pricing, staffing, and which work to take next.
What's inside
The tracker is built around a project register — one row per project — plus the margin math and flags that make it actionable.
Project list
Every active engagement gets a row with the fields that identify and frame it: project name, client, contract type (fixed fee, time-and-materials, retainer, or milestone), contract or budget value, start and expected end dates, and the project manager responsible. Closed projects roll off to a history tab so the active view stays clean — and so you build a record of past performance that makes future estimates honest.
Budget vs. actual hours and cost
The heart of the tracker. For each project: budgeted hours and budgeted cost, actual hours and actual cost to date (from timesheets and payroll, not estimates), and the resulting percent-complete on budget and on schedule. Two columns here do the heavy lifting — budget remaining and forecast at completion. Forecast at completion takes the burn rate so far and projects where the project lands if nothing changes. That single number is what turns a tracker from a history lesson into a decision tool.
Margin by project
True project margin, computed the same way on every project: recognized revenue to date minus direct labor at loaded cost minus project-specific expenses (subcontractors, travel, materials, any other direct costs). The template expresses it as a percentage of recognized revenue and as dollars. A firm-level target column sits alongside — say, 40% for professional services — so underperformers are obvious without anyone needing to run the math in their head.
Flags and commentary
The tracker flags what needs attention: projects where forecast margin is below target, projects burning budget faster than they're completing work, and projects where unbilled time is accumulating (hours worked but not yet billable or billed — a classic margin leak). A notes column captures the project manager's read on each flagged project: what's driving it, and what's being done. The flags do the analysis; the notes capture the judgment.
How to use it
Run the tracker on a monthly rhythm, tied to your close. The cadence that works:
1. Lock the inputs
After month-end, pull actual hours from your timesheet system and actual costs from payroll and the ledger. Enter project-specific expenses. The numbers must be real — estimates and allocations belong nowhere in this sheet.
2. Update recognized revenue
For each project, enter revenue recognized under your revenue policy — for fixed-fee work, typically percent-complete against contract value; for T&M, actual billable amounts. Keep this consistent with your WIP review so margin and revenue tell the same story.
3. Read the flags
Sort by forecast margin and by budget burn. The flagged projects are your agenda — not all of them, just the ones below target or deteriorating. Everything on target gets a pass.
4. Review with project managers
For each flagged project: why is it off, what's the corrective action, and what does it do to the forecast at completion? Scope change, client delays, underpriced work, and understaffing are the usual suspects — each has a different fix.
5. Feed the lessons forward
Patterns across closed projects — chronic underestimates on a service line, a client type that always runs over — go straight into future pricing and scoping. This is where the tracker pays for itself: it makes the next estimate honest instead of hopeful.
A note on loaded cost: the template multiplies hours by each person's loaded rate — base pay plus payroll taxes, benefits, and PTO — not their salary alone. It's the single most common place firms understate project cost, and the one that most changes which projects look profitable.
Who it's for
This template is for firms that feel busy but can't point to where the profit is — IT and technology consulting shops with utilization questions, engineering and EPC firms juggling fixed-fee jobs, architecture firms with phase-level margin drift, and professional services teams wondering why growth isn't translating into bottom-line results. If your P&L looks fine but some projects keep quietly losing money, the tracker is where you find them.
It also serves principals preparing to price new work: a history of true margins by project type is the most defensible basis for raising fees, tightening scope, or walking away from bad-fit engagements.
Get the template
Template downloads are being prepared — check back soon. The walkthrough above covers everything the template contains, so you can start building your own version now or wait for the finished file.
Coming soon
Want project-level profitability as a standing discipline, reviewed with you every month? That's core to a Mesfonic engagement. See the Decision Support & Profitability service.
Run your projects with financial confidence.
Talk to a finance advisor who speaks project economics — backlog, bench, WIP, and margin — not just accounting.