Blog · Finance metrics and formulas · Professional services
Connect engagement revenue, utilization, realization and delivery costs to the firm's financial result. Use a worked practice review and spreadsheet formulas to reconcile profitability and identify the working capital questions behind it.
Professional services financial analysis explains how engagement revenue becomes practice profit, company profit and eventually cash. Read utilization, fee realization and delivery costs together, then reconcile the practice totals to the ledger. A busy team is only one part of a profitable firm.
Start with the monthly engagement revenue export, approved time detail, payroll-cost allocation, subcontractor invoices and general ledger. Add an accounts receivable aging report and a schedule of unbilled work. Use stable engagement, client and practice IDs so a renamed client does not split the history.
Revenue should follow the firm's recognition policy. FASB's revenue recognition implementation guidance connects recognition to the transfer of promised goods or services. Invoice dates and cash receipts belong in the review, but they cannot simply replace recognized revenue.
Close the reporting period before drawing conclusions. Accrue delivered subcontractor work, check late timesheets and separate client pass-through amounts if your management measures exclude them. The companion professional services revenue analysis covers the revenue review in more detail.
For this internal review, available hours exclude approved leave and holidays but include business development, training and unassigned time. Billable hours are the approved delivery hours associated with the recognized fee revenue below. Document a different denominator if your firm uses one.
Revenue realization is recognized fee revenue divided by the standard fee value of those same hours. It is a management measure, especially on fixed-fee work; it does not establish the accounting recognition method.
An illustrative US advisory firm has the following September results. Dollar amounts are USD. Percentages are rounded to one decimal from unrounded values.
| Practice | Available hours | Billable hours | Standard rate (USD/hour) | Standard fee value (USD) | Recognized fee revenue (USD) | Utilization | Realization |
|---|---|---|---|---|---|---|---|
| Advisory | 4,000 | 3,200 | 125 | 400,000 | 320,000 | 80.0% | 80.0% |
| Systems | 2,000 | 1,500 | 200 | 300,000 | 180,000 | 75.0% | 60.0% |
| Total | 6,000 | 4,700 | — | 700,000 | 500,000 | 78.3% | 71.4% |
Put this table in A:H, with Advisory on row 2. In Excel, calculate standard fee value in E2, utilization in G2 and realization in H2:
=C2*D2
=IF(B2=0,NA(),C2/B2)
=IF(E2=0,NA(),F2/E2)
The total formulas use the underlying amounts:
=SUM(C2:C3)/SUM(B2:B3)
=SUM(F2:F3)/SUM(E2:E3)
The Systems team has both lower utilization and lower realization. Ask whether the realization gap comes from agreed discounts, hours beyond a fixed-fee budget, credits or a timing mismatch. Asking staff to record more billable time does not by itself fix the fee economics.
For a raw engagement export, aggregate revenue to the practice with practice IDs in column B and revenue in column F:
=SUMIFS(Engagements!$F$2:$F$5000,Engagements!$B$2:$B$5000,$A2)
Microsoft's SUMIFS documentation explains how criteria select the rows to sum. Use matching ranges and filter the export to the same period. Covirage is not affiliated with Microsoft.
Do not stop at the cost assigned to client hours. Unassigned delivery staff still cost money. Keep that cost visible at the practice level even when it cannot fairly be attached to one engagement.
The following labor amounts include the firm's employer payroll costs and benefits under a consistent allocation policy. Gross wages alone omit employer costs: the IRS Employer's Tax Guide distinguishes employer Social Security and Medicare obligations from amounts withheld from employees.
| Practice | Revenue (USD) | Assigned labor (USD) | Unassigned labor (USD) | Other delivery (USD) | Subcontractors (USD) | Total delivery cost (USD) | After delivery costs (USD) |
|---|---|---|---|---|---|---|---|
| Advisory | 320,000 | 160,000 | 40,000 | 30,000 | 40,000 | 270,000 | 50,000 |
| Systems | 180,000 | 90,000 | 30,000 | 20,000 | 20,000 | 160,000 | 20,000 |
| Total | 500,000 | 250,000 | 70,000 | 50,000 | 60,000 | 430,000 | 70,000 |
With the second table in A:H, use =SUM(C2:F2) in G2 and =B2-G2 in H2. Fill down. Assigned engagement contribution, defined here as revenue less assigned labor, other delivery and subcontractors, is $140,000 before unassigned labor. Deducting $70,000 of unassigned labor leaves $70,000 after all delivery costs.
This engagement contribution definition is not the conventional variable-cost contribution margin. The dedicated professional services cost analysis covers the cost assignment questions; gross margin for a service business covers consistent delivery-cost classification.
The review needs a bridge, not a second set of unexplained totals:
| Reconciliation step | Amount (USD) |
|---|---|
| Recognized revenue | 500,000 |
| Less assigned labor | (250,000) |
| Less other delivery and subcontractors | (110,000) |
| Engagement contribution before unassigned labor | 140,000 |
| Less unassigned delivery labor | (70,000) |
| Result after delivery costs | 70,000 |
| Less selling and administrative expenses | (45,000) |
| Operating profit | 25,000 |
The result after delivery costs is 70,000 / 500,000 = 14.0% of revenue. Operating margin is 25,000 / 500,000 = 5.0%. Tie the $500,000 to revenue accounts, the combined assigned and unassigned labor to payroll, and the other cost categories to their ledger accounts.
Unmapped costs stay in an exception list until resolved. They should not disappear because an engagement ID is blank. Review individual jobs through project margin analysis, while keeping this bridge as the firm-wide proof.
Bring the receivables aging and unbilled-work schedule alongside the profit bridge. Review balances by client, age and responsible partner. Ask whether a billing delay, disputed milestone or overdue invoice explains the cash tied up.
These balances are stocks at the cutoff date, while monthly revenue is a flow. Do not add them to revenue or deduct them from profit as if they were delivery costs. Use working capital for service businesses for the separate funding review.
Finance owns the reconciliation. Practice leaders own staffing and delivery assumptions. Engagement partners own pricing, scope and billing actions. Give each material exception a named owner and a date for the next review.
Bring a sample of your own engagement, time-cost and ledger exports. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.
See Covirage for professional services for the industry context.
Start with recognized revenue, engagement contribution, delivery labor cost, utilization and realization. Then connect the practice result to company overhead and operating profit. Add receivables and unbilled work to understand funding needs. Interpret the measures together because strong activity can coexist with weak pricing or slow collections.
Staff may be busy on discounted work, rework or engagements that need more senior hours than priced. Subcontractor spending and unassigned payroll can also absorb the margin. Review realized revenue against the standard value of delivered hours, alongside actual labor and supplier costs, before concluding that more utilization will help.
Not in the revenue realization measure used here. Revenue realization compares earned fees with the standard fee value of the corresponding work. Collection measures cash received against amounts due. Some firms use the word realization for a collection measure, so document the numerator and denominator before comparing reports.
Use a monthly review after revenue, payroll and supplier accruals are complete. Project leaders may need more frequent operational reviews of hours and remaining costs. Keep those interim estimates distinguishable from the closed financial period so late timesheets or invoices do not create unexplained differences.