The short answer
A good utilization report shows billable hours as a share of available hours for each person, team and practice, with targets that reflect each role. To build one, connect time entries to an agreed definition of available capacity, separate billable, investment and admin time, and review it weekly so managers can act before the month closes.
Key takeaways
- Utilization is only useful when everyone agrees what counts as available and billable time.
- Targets should differ by role. One firm-wide number hides more than it shows.
- Pair utilization with realization and project margin, or you will reward the wrong behavior.
- Weekly, forward-looking views beat a monthly look back at hours already lost.
- Most firms already have the data. The work is connecting time, staffing and finance systems.
Ask a consulting or services firm how utilization is trending and you will usually get a number. Ask how that number was calculated and you will often get three different answers from three different people.
That is the real problem with utilization reporting. The math is simple. The definitions are not, and the data lives in a time tracking tool, a staffing spreadsheet, a PSA and the accounting system, none of which agree with each other.
What is utilization reporting?
Utilization reporting measures how much of your team’s available time goes to billable client work. The basic formula is billable hours divided by available hours, shown by person, role, team, practice and period.
It is the closest thing a services firm has to a capacity gauge. Too low and you are paying for time you cannot bill. Too high for too long and people burn out, quality slips and nobody has time to sell, train or improve the delivery model.
How should you define available and billable hours?
Agree on definitions before you build anything. Most utilization reports fail here, not in the dashboard.
| Term | Decision to make | Common approach |
|---|---|---|
| Available hours | Do you subtract holidays and approved time off? | Standard hours minus holidays and PTO, so people are not penalized for scheduled leave |
| Billable hours | Do write-offs and fixed-fee overruns count? | Count hours worked on client work, then track write-offs separately in realization |
| Investment time | Where do proposals, internal tools and training go? | Its own category, so it is visible and budgeted rather than hidden in admin |
| Admin time | What is the catch-all for everything else? | Keep the codes few and clear so people log time accurately |
Write the definitions down, get finance and delivery leaders to sign off, and keep them stable. Changing definitions mid-year makes every trend line meaningless.
What should a utilization report show?
A useful report answers four questions quickly: where are we now, who is over or under target, what is coming next, and is billable time turning into revenue.
- Utilization by person and role against a role-specific target. A partner, a senior consultant and an analyst should not share one goal.
- Trend over the last 8 to 12 weeks so a slow decline is visible before it shows up in the P&L.
- Forward-looking scheduled utilization from your staffing plan, so managers see the gap for the next four to six weeks, not just last month.
- Bench and overload lists showing who is under target and who has been over capacity for several weeks in a row.
- Billable time by client and project so you can tie hours to the work that drives them.
Keep the first version small. A one-page weekly view that people trust beats a 20-tab workbook nobody opens. If you want help scoping what belongs on it, our data and BI work for consulting firms starts with exactly that question.
Why isn’t utilization enough on its own?
Because hours are not dollars. A team can hit its utilization target and still lose money if the time is written off, discounted or spent on fixed-fee work that ran over.
Pair utilization with two other measures:
- Realization: the share of standard value you actually bill and collect after discounts and write-offs.
- Project margin: revenue minus the fully loaded cost of the people who did the work.
Together they show whether busy people are also profitable people. The logic is the same as building a margin view by product and customer, which we walked through in margin by product and customer: building the report.
Not sure your utilization number means what you think it means? We will map your definitions and data sources in one session. Book a working session ›
Where does the data for utilization reporting come from?
Most firms already capture what they need. It is just spread across systems that were never designed to talk to each other:
- Time entries from a time tracking tool or PSA
- Staffing and capacity from a resource plan, often a spreadsheet
- People data such as role, team, start date and standard hours from HR or payroll
- Billing and revenue from the accounting system
- Project and client details from the CRM or PSA
The work is mapping these into one model with consistent people, project and client IDs, then refreshing it automatically. That is usually a small data and BI build on top of what you have, not a new system. If the staffing plan only lives in a spreadsheet, a light custom tool or integration can make it a reliable source.
How do you get people to actually use the report?
Build it into the operating rhythm rather than sending it out and hoping.
- Review it weekly in an existing staffing or delivery meeting, focused on the next four to six weeks.
- Give every manager their own view of their team, with the same definitions as the firm-wide view.
- Fix time entry first. If time is logged late or loosely, the report will be wrong and people will stop trusting it. Simple codes and a clear weekly deadline help more than reminders.
- Act on the bench list. The point is to move people onto work or into investment time on purpose, not to grade them.
Our approach starts with the operating rhythm and the decisions the report needs to support, then works back to the data.
Frequently asked questions
What is a good utilization rate for a consulting firm?
There is no single right number. Targets depend on role, seniority and business model. Junior delivery staff usually carry higher targets than senior leaders who also sell and manage. Set role-specific targets, track them over time, and watch the trend and the gap to target rather than one firm-wide figure.
What is the difference between utilization and realization?
Utilization measures how much available time goes to billable work. Realization measures how much of the standard value of that work you actually bill and collect after discounts and write-offs. High utilization with low realization means people are busy but the firm is not getting paid for all of it.
Should PTO and holidays count against utilization?
Most firms subtract holidays and approved time off from available hours, so people are not penalized for scheduled leave. Whatever you choose, document it and apply it the same way for everyone, or comparisons between people and periods will be misleading.
How often should utilization be reviewed?
Weekly works best for managers, because they can still change staffing for the coming weeks. Leadership can review a monthly summary. A forward-looking view based on the staffing plan is more useful than only looking back at hours already logged.
Do you need a PSA to report on utilization?
No. A PSA can help, but many firms report utilization by connecting an existing time tracking tool, a staffing plan and the accounting system into one data model. The key requirement is consistent IDs for people, projects and clients across those sources.
