A project profitability report answers one question: did this project make money, and how much? The template has three sections. Section 1 (Project Inputs) captures budgeted and actual hours, rates, and revenue. Section 2 (Direct Costs) tallies labor cost by role and any direct out-of-pocket expenses. Section 3 (Profitability Metrics) calculates project gross margin, realization rate, and margin per consultant. A well-structured project profitability report template turns months of scattered data into a single sheet that tells you which clients, project types, and engagements are actually worth your time.
Why Most Firms Fly Blind on Project Profitability
Most 10–100 person professional services firms don't have a consistent project profitability report. What they have instead is intuition: "This project felt tight," or "That engagement was our best quarter." Intuition is not a business strategy.
The three most common reasons profitability reporting breaks down:
A project profitability report template solves all three — it creates a single structure where every project lands in the same format, every time.
The Project Profitability Report Template: Column by Column
Here's the structure. Every row is a project. Every column feeds one of the three sections.
| Project | Client | Budgeted Revenue | Billed Revenue | Labor Hours | Labor Cost | Direct Costs | Total Cost | Gross Margin ($) | Gross Margin (%) | Realization Rate |
|---|---|---|---|---|---|---|---|---|---|---|
| Project Alpha | Acme Corp | $75,000 | $61,500 | 490 hrs | $44,100 | $3,200 | $47,300 | $14,200 | 23.1% | 82% |
| Project Beta | GlobalTech | $120,000 | $118,800 | 380 hrs | $36,200 | $0 | $36,200 | $82,600 | 69.5% | 99% |
| Project Gamma | Summit Partners | $50,000 | $47,500 | 620 hrs | $58,900 | $4,100 | $63,000 | -$15,500 | -32.6% | 95% |
Sample data. Your columns may vary based on your billing structure. Download a blank template via the ROI calculator.
Project Name
A consistent internal identifier — not the client name, because you may run multiple projects for one client. "Acme Discovery" and "Acme Implementation" are separate rows.
Client
The client name. Useful for client-level rollup reports and for identifying concentration risk — if one client accounts for more than 30% of your top-line revenue, that's a signal worth tracking.
Budgeted vs Billed Revenue
Budgeted revenue is the contract value — what you quoted or agreed to at project start. Billed revenue is what you actually invoiced. The ratio is your realization rate. A 90% realization rate means you left 10% of planned revenue on the table.
Labor Hours and Labor Cost
Hours come from your timesheet. Cost comes from hours × each person's billable rate. Track by role if you have varied rate structures (senior vs junior rates). This column is where most firms lose visibility — if people don't log time, the labor cost shows zero.
Direct Out-of-Pocket Costs
Subcontractor invoices, software licenses bought for this project, travel expenses billed directly to the client, or third-party tools. Do not include overhead allocation here — that's a firm-level number, not a project-level number.
Total Project Cost
Labor cost + direct costs. This is your true cost of delivery for this project. Everything else — firm overhead, admin, management time — belongs to a different report (the firm P&L).
Gross Margin ($)
The dollar amount left after covering direct project costs. Positive means the project paid for itself. Negative means you lost money on delivery — regardless of what was invoiced.
Gross Margin (%)
The margin as a percentage of revenue. Used for benchmarking across project types. A $15K margin on a $75K project (20%) and a $20K margin on a $120K project (16.7%) look similar in dollars but tell different stories about efficiency.
Realization Rate
Already covered in Section 1, but worth repeating here: realization rate is a revenue quality metric, not a profitability metric. You can have 100% realization and still lose money if your costs are too high. They're different problems.
What Your Project Gross Margin Benchmarks Should Look Like
These benchmarks are for project gross margin — revenue minus direct project costs only. Do not include overhead in these numbers; you'll end up with meaningless negative margins across the board.
Typical Range
Well-run firms. Low direct costs (no materials), labor is the primary cost driver. Pricing discipline and utilization efficiency are what separate 65% from 45%.
Typical Range
Lower than consulting due to higher overhead per project (redlines, revisions, site visits). Spec work and change orders can compress margins rapidly. Track by project type — site visits are typically low-margin.
Typical Range
Retainer-heavy engagements can push higher if scope is tight. Realization is the bigger problem here — scope drift in managed services is the most common margin killer. Project gross margin often looks fine; realization rate reveals the leak.
Typical Range
Tax and compliance work tends to be higher-margin due to standardized scope. Advisory projects vary widely based on engagement type. Flag any project below 35% gross margin for a post-mortem.
The Threshold to Watch
A project gross margin below 30% almost always has a root cause — scope creep, under-pricing, resource misallocation, or excessive write-offs. Flag it in the monthly report and do a five-question post-mortem with the project lead. The ProServ Health Assessment scores your firm's project margin discipline across your portfolio.
How to Build This Report in a Spreadsheet
No PSA software required. If you have a timesheet and a billing system, you can build this in Excel or Google Sheets.
If this sounds like too much spreadsheet surgery, try the free ROI Calculator to estimate what automation could save you in annualized revenue — and then explore the Margin Diagnostic as a starting point for building proper project-level visibility.
Three Decisions This Report Enables
Know which project types to quote higher
If your engineering projects consistently land at 28% gross margin but management consulting hits 58%, you're under-pricing engineering work. The data tells you where you have pricing leverage.
Know which consultants to assign to what
If senior consultants are carrying 70% of hours on 25% margin projects, you're burning margin on labor. Junior staff should carry the work that doesn't require senior rates.
Know which clients to fire or restructure
A client that generates $200K in revenue at 20% margin generates less profit than a $100K client at 60% margin — and typically demands twice the management attention. The report quantifies this.
Know what's coming in next quarter
Running the report monthly with a rolling 3-month projection gives you a forward view of project completion and revenue recognition. Better than guessing.