A completed project can look successful on paper and still produce a disappointing return once unplanned hours, revisions, subcontractors, software, and payment fees are included. This project profitability review template helps you compare the original quote with actual results, calculate the effective hourly rate and realized margin, and turn the findings into a better estimate for the next client project.
Overview
A project profitability review is a short financial post-mortem completed after delivery, invoicing, or payment collection. Its purpose is not to assign blame. It is to replace assumptions with evidence before you reuse a scope, price a similar engagement, or build a service package.
The central comparison is estimated versus actual performance:
- Quoted price: the amount included in the proposal or contract.
- Planned hours: the time you expected to spend, including delivery and project administration.
- Actual hours: the time recorded across planning, production, meetings, revisions, handoff, and follow-up.
- Estimated costs: expected subcontractor, software, materials, transaction, and other direct costs.
- Actual costs: what the project really consumed.
- Revenue collected: the amount received, separated from amounts invoiced but unpaid.
Two useful outputs are the effective hourly rate and realized margin. The effective hourly rate shows what the project generated for each hour invested. Realized margin shows what remains after direct project costs. Together, they provide a more reliable view than the quoted price alone.
This review complements, rather than replaces, your normal bookkeeping. Keep taxes, owner compensation, overhead allocation, and accounting treatment consistent with your existing records. For pricing decisions, use the same definitions every time so that one project can be compared with another.
How to estimate
Start with a spreadsheet or project profitability calculator containing one row for the estimate and one for actual results. Add a variance column for each important input.
- Record the quoted price. Use the contracted project value before or after discounts according to the convention you use for other pricing reviews. Note separately whether taxes or pass-through charges are included.
- List planned hours by activity. Break the estimate into discovery, project management, production, meetings, revisions, quality checks, and delivery. A single total makes it harder to see which part of the scope was underestimated.
- Capture actual hours. Use time records, calendar entries, task history, or a retrospective estimate if time was not tracked. Label reconstructed figures clearly; an imperfect record is still more useful than ignoring the work.
- Separate included and extra work. Record client-requested revisions, new deliverables, delays, and internal rework. If the contract was changed, show the additional fee separately from the original quote.
- Enter direct costs. Include subcontractor costs, project-specific software or asset purchases, materials, travel where applicable, and payment processing fees. Do not count a recurring tool twice if it is already included in your chosen overhead method.
- Calculate the results. Use the formulas below, then compare them with your target rate or margin.
Core formulas:
- Total direct cost = subcontractor costs + software expenses + materials or other project costs + payment fees.
- Project contribution = revenue collected − total direct cost.
- Effective hourly rate = revenue collected ÷ actual hours.
- Realized margin = project contribution ÷ revenue collected × 100.
- Hours variance = actual hours − planned hours.
- Cost variance = actual direct cost − estimated direct cost.
- Margin variance = realized margin − estimated margin.
If the invoice has not been paid, calculate a provisional margin using invoiced revenue, then update it with revenue collected. This keeps pricing analysis separate from cash-collection risk.
Inputs and assumptions
Copy this reusable project profitability review template into a spreadsheet, project management tool, or client record:
| Field | Estimate | Actual | Variance or note |
|---|---|---|---|
| Quoted price | Include discount policy | ||
| Revenue collected | Record unpaid balance separately | ||
| Planned hours | Break down by activity | ||
| Actual hours | Include meetings and administration | ||
| Revision rounds | Compare included with delivered | ||
| Subcontractor costs | Use committed or paid cost consistently | ||
| Software expenses | Identify project-specific tools | ||
| Payment fees | Apply the fee basis used by your payment method | ||
| Total direct cost | Sum eligible project costs | ||
| Effective hourly rate | Revenue divided by actual hours | ||
| Realized margin | Contribution divided by revenue |
Define your assumptions before comparing projects. Decide whether internal meetings count as project hours, whether recurring software is allocated per project, and whether revenue means invoiced or collected revenue. A small business may also choose to add an overhead allocation for rent, insurance, administration, and general software. That produces a fuller profitability view, but only if the allocation method is applied consistently.
Do not confuse markup with margin. Markup compares profit with cost, while margin compares profit with revenue. If you need to check the distinction before setting a target, see the markup vs. margin calculator guide. For building an initial quote from hours, the hourly rate to project price worksheet provides a useful starting point.
Worked examples
Suppose a service business quotes a fixed project at $3,600. The estimate is 30 hours and $300 in direct costs. The completed project takes 38 hours and includes $420 in subcontractor, software, and payment costs. Assume the full project amount is collected.
The estimated effective hourly rate is $3,600 ÷ 30, or $120 per planned hour. The estimated contribution is $3,600 − $300 = $3,300, producing an estimated margin of 91.7% before any broader overhead allocation.
Actual performance is different. The effective hourly rate is $3,600 ÷ 38, or approximately $94.74 per hour. Actual contribution is $3,600 − $420 = $3,180, and realized margin is $3,180 ÷ $3,600 × 100, or approximately 88.3%. The project remains positive under these assumptions, but eight additional hours reduced the effective hourly rate by about $25 per hour.
The next question is why. Suppose the eight-hour variance consists of four extra hours of revisions, two additional client meetings, and two hours of internal rework. The corrective action may be different for each cause:
- Extra revisions may require a clearer revision limit, approval checkpoint, or change-order process.
- Additional meetings may indicate that the project schedule or communication plan needs adjustment.
- Internal rework may point to a weak brief, missing quality check, or unrealistic production sequence.
For a second scenario, consider a $2,000 project estimated at 16 hours and $100 of direct costs. If actual time reaches 24 hours and direct costs reach $160, the effective hourly rate falls from $125 planned to approximately $83.33 actual. The direct-cost margin is still 92% before overhead, but the time variance is the main pricing lesson. A future quote based only on the original 16-hour estimate is likely to repeat the problem.
When to recalculate
Complete the review after every meaningful client project, especially fixed-fee work or projects with repeated scope. Do not wait until an annual review; details about revisions, delays, and unplanned tasks become harder to reconstruct.
Recalculate a group of projects when you are:
- raising or lowering your standard rates;
- turning custom work into a fixed service package;
- changing subcontractor, software, or payment costs;
- introducing a new delivery process or project management tool;
- seeing repeated overruns in hours, revisions, or meetings;
- deciding whether a client type, service, or project size still fits your business.
End each review with three decisions: what to change in the next estimate, what to change in the delivery process, and what to clarify in the proposal. Keep the lessons specific—for example, “include two approval checkpoints” is more actionable than “manage scope better.”
Store the completed reviews together and revisit them during a monthly close or quarterly pricing review. Pairing this analysis with a quarterly productivity stack review can reveal whether a new tool is saving time or merely adding cost. If meetings are a recurring source of variance, use a meeting cost audit to examine them separately.
The practical goal is not to make every project identical. It is to make your assumptions visible, compare them with actual delivery, and improve the next quote while the evidence is still useful.