Blog · Board and management reporting · Professional services
A consultant dashboard connects working capacity, realized billing rates, and project delivery margin. Use a worked practice example to reconcile time, invoice revenue, and direct costs without confusing billing with cash collection.
A consultant dashboard connects billable utilization, realized billing rates, and project margin for a consulting practice. It shows whether people had client work, what that work earned per hour, and what remained after direct delivery costs. Read the measures together because a strong utilization percentage can coexist with a weak margin.
A practice leader needs to know whether the current work mix supports the business plan. A project manager needs to know whether delivery effort and direct costs are consuming the agreed fee. Finance needs a comparison that ties back to approved time entries, invoices, credits, and recorded costs.
Start with those questions rather than a list of available charts. This dashboard uses a billing-based delivery view for a completed work cohort: all hours, invoices, and direct costs relate to the same work. It excludes sales tax and pass-through expense reimbursements from professional fees.
The utilization dashboard covers capacity definitions in detail. Here, available hours have already been agreed and checked against schedules and leave records, so the main task is connecting deployment with realized fees and delivery cost.
Use an approved time export containing work date, person identifier, project identifier, billable hours, and labor cost or the applicable cost rate. The capacity file supplies available hours by person for the same period. The invoice export supplies project identifier, service period, professional fees, discounts, and credit amounts.
Bring other direct project expenses in a separate export. Match all files using project identifiers and work periods. Do not repeat a whole invoice amount on every time-entry row: that multiplies revenue when the rows are summed. Summarize hours, fees, and costs separately to the same project level before combining them.
Direct cost boundaries need a written policy. For federal contracts, FAR 31.202 distinguishes costs specifically identified with a final cost objective and requires consistent treatment in relevant circumstances. This example applies a clearly stated management boundary: assigned delivery labor plus other directly attributable project costs. It does not claim to determine the allowability of government contract costs.
Billable utilization = Approved billable hours / Available hours
Realized billing rate = Net billed professional fees / Approved billable hours
Direct project profit = Net billed fees − Direct labor cost − Other direct costs
Direct project margin = Direct project profit / Net billed fees
Realized billing rate here is a billing measure, not cash collected per hour. If the practice reports accounting revenue instead, use a separately labeled revenue measure and reconcile unbilled work and deferred amounts. The IRS explanation of accounting methods distinguishes income earned under accrual accounting from income received under cash accounting. That distinction is one reason billing, revenue, and collection reports should not be combined without a bridge.
A US practice reviews completed September 2026 work after all related invoices and credits have been posted. Each practice team in this example worked on a separate project, and its available capacity is assigned once. Direct labor cost includes the firm's agreed payroll burden for delivery hours; other direct costs include project-specific external support.
| Team and project | Available hours | Billable hours | Net billed fees (USD) | Direct labor cost (USD) | Other direct costs (USD) |
|---|---|---|---|---|---|
| Strategy | 160 | 120 | 30,000 | 10,800 | 1,200 |
| Operations | 160 | 144 | 30,240 | 14,400 | 3,840 |
| Change | 80 | 48 | 14,400 | 4,320 | 1,680 |
| Total | 400 | 312 | 74,640 | 29,520 | 6,720 |
The following table calculates the dashboard from those source amounts. Rates are rounded to the nearest cent and percentages to one decimal place, after calculations using unrounded values.
| Team and project | Utilization | Realized billing rate (USD/hour) | Direct project profit (USD) | Direct project margin |
|---|---|---|---|---|
| Strategy | 75.0% | 250.00 | 18,000 | 60.0% |
| Operations | 90.0% | 210.00 | 12,000 | 39.7% |
| Change | 60.0% | 300.00 | 8,400 | 58.3% |
| Total | 78.0% | 239.23 | 38,400 | 51.4% |
Operations illustrates why the measures belong together. Utilization is 144 / 160 = 90.0%, but direct project profit is 30,240 − 14,400 − 3,840 = $12,000. Dividing that profit by $30,240 gives a 39.7% margin, lower than either of the other projects.
Change has the lowest utilization but the highest realized rate: 14,400 / 48 = $300.00 per hour. That rate does not establish that Change is the strongest practice overall. Its direct project margin excludes the cost of unassigned capacity and corporate overhead.
Total utilization is 312 / 400 = 78.0%. The total realized billing rate is 74,640 / 312 = $239.23 per hour. Total direct project profit is 18,000 + 12,000 + 8,400 = $38,400, which also equals 74,640 − 29,520 − 6,720.
The practice margin is 38,400 / 74,640 = 51.4%. Calculate it from the summed dollar amounts. A simple average of the three project margins would be 52.7% using unrounded inputs, giving the smaller Change project too much influence.
Tie billable hours back to the approved time register. Tie net billed fees to the included invoices less credits, and direct costs to the project cost register. Verify that every included invoice refers to the selected work cohort. A September posting date alone does not prove that an invoice covers September work.
The worked utilization and realization example provides another view of the distinction between time deployment and earned value. For the broader difference between direct and fully allocated profitability, see gross, contribution, and net margin.
Suppose Operations issues a $2,400 credit for the same completed work. Hours and costs remain unchanged. Net billed fees fall from $30,240 to $27,840, and the realized billing rate becomes 27,840 / 144 = $193.33 per hour.
Operations direct profit becomes 27,840 − 14,400 − 3,840 = $9,600, and its margin becomes 34.5%. Its utilization remains 90.0% because the credit changes the value billed, not the hours worked.
Practice fees become $72,240 and direct profit becomes $36,000. Practice margin falls to 49.8%. This is a pricing or billing adjustment for investigation by the engagement owner and finance; reclassifying time would obscure what actually changed.
Bring approved time, capacity, invoice, credit, and direct-cost exports for the same projects. Covirage maps the columns, and its tools compute the measures and check the totals; 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 a sample of your own data.
See project cost control for the supporting workflow.
Include available hours, approved billable hours, net billed fees, direct labor cost, other direct project costs, and their derived measures. Show the work period and project owner. Keep cash collections and accounting revenue separate when they do not refer to the same activity.
For the billing view used here, divide net billed professional fees by approved billable hours for the same work. Include related credits and discounts in the numerator, and exclude pass-through reimbursements. Label other conventions, such as recognized revenue per delivery hour, separately.
No. Utilization describes the share of available capacity spent on billable work. Profitability also depends on realized fees, labor cost, other delivery costs, and overhead. A heavily utilized team can produce a lower project margin than a less utilized team.
The direct project margin here excludes corporate overhead and unassigned labor. A fully allocated view can add them using a documented allocation policy. Keep the two measures labeled separately so a change in allocation does not look like a change in delivery performance.