Consulting Practice Metrics Template
Five sheets that report utilization on every denominator, split the rate to bank gap into three leaks, and date the first unsold week.
Free download · No account needed
Every practice dashboard reports utilization and none of them says what it divided by. The same 1,004 billed hours read 48 percent against the federal 2,087 hour work year, 54 percent against the hours left after leave and holiday, 58 percent against the hours actually worked, and 88 percent against delivery hours alone. Four true numbers, forty points apart, for one year. Every benchmark you have been measured against is unreadable until somebody names the divisor, so Capacity and Utilization carries all four.
Realization is the second number the category defines two ways, and each definition swallows the others. Rate realization is what you agreed against what you publish. Time realization is what you billed against what you worked. Collection realization is what arrived against what you invoiced, and on the cash method most independent practices use it is the only one of the three that counts as income. They multiply, so a 280 dollar card rate lands at 218.20 an hour on delivery time and 144.54 across every hour worked.
Coverage is a ratio and a ratio has no date, so a practice at 98 percent coverage still has a hole three weeks out. Capacity Forecast is one row per forward week and Pipeline and Dated Gap carries an earliest start week per opportunity, so the first short week arrives with a date beside it. Send River your time export, invoices and enquiry threads, or take the sheets blank. Client-facing work lives in the intake pack and the proposal pack.
What's in the pack
Capacity and Utilization
Billed hours over four denominators on every row: the published work year, the hours left after leave and holiday, the hours actually worked, and delivery hours alone. Available hours are built from leave actually taken rather than from entitlement, because the two differ by a week most years.
Realization by Engagement
Rate, time and collection realization as three separate columns per engagement, their product, and the effective hourly rate that product produces against your card. One engagement can lose on all three for entirely different reasons.
Revenue by Client and Type
Income by client with how each one arrived and who they referred, then by engagement type with the effective rate each type earned. This is the sheet that changes what you sell, and the one that shows a referral chain resting on a single relationship. Turning the type that earns best into a fixed-scope offer is the productized service design pack.
Capacity Forecast
One row per forward week: contracted hours against delivery capacity, the shortfall, a running cumulative, and the named opportunities that could still reach that week. The first materially short week is a date, not a worry.
Pipeline and Dated Gap
Every live opportunity with an earliest start week set by the client's budget year, shutdown or notice period rather than by their enthusiasm, so coverage gets tested against the calendar. A paid assessment is the fastest thing to put into a short week, and that is the diagnostic assessment pack. Keeping the pipeline fed in the first place, especially from past clients before a busy quarter goes quiet on them, is the business development tracker.
How the Numbers Are Defined
Every denominator, formula and boundary written down once: what counts as a delivery hour, what a selling hour is, and how the median sales cycle gets measured from your own closed work rather than borrowed from a benchmark.
Where the Rate Goes
The card to bank gap split three ways with the card value of each leak beside it, so the biggest one gets the fix. In the worked year that is 38,640 dollars of unbilled hours, and no amount of rate card revision touches it. Rebuilding the card itself is the rate card pack.
Operating Review and Target Setting
A monthly review that opens on the forward calendar instead of last month, and a target model that sets next year from realization and available hours rather than from a revenue figure someone liked the look of.
How to use it
- 1
Open in River, or take it blank
Install the pack and hand River your records, or download the Word documents and CSV sheets and fill them in yourself.
- 2
Send the records
A time tracker export, a folder of invoices, bank statements, the enquiry threads, a calendar export. Thin timesheets get delivery hours reconstructed from calendar and file activity, and those rows are marked as reconstructed.
- 3
Set the denominators once
Available hours get built from leave actually taken. Every utilization figure then recomputes on all four divisors, and the space rule stops any of them being reported on its own.
- 4
Read the calendar forward
The first short week gets a date, your own median sales cycle decides what can still reach it, and the hours nothing can reach get priced at your effective rate.
Frequently asked questions
Is this template free?
Yes. The download is Word documents and CSV sheets, no account and no card. Edit with AI is the optional half: River reads your time export, invoices and enquiry threads and fills the sheets before you look at them. Every other pack sits in the template library.
What format are the downloaded files?
Word (.docx) for the five documents and CSV (.csv) for the five sheets, zipped together. Excel, Numbers and Google Sheets open the sheets straight off the download, and the review notes open in Word or Pages. Nothing to convert, and no formula locked to one program.
My time records are incomplete. Does that break it?
That is the normal case, and it is why time realization is its own column. Where the timesheet is thin, delivery hours get reconstructed from calendar entries and file activity, and those rows are marked reconstructed so they never pass as recorded time. The 138 unbilled hours in the worked year were found that way. Per engagement, that rebuild is its own analysis.
Why 2,087 hours rather than 2,080?
Because 2,080 assumes a 364 day year. Averaged over the 28 year cycle the calendar takes to repeat there are four years of 262 workdays, seventeen of 261 and seven of 260, which is 2,087.143. Federal pay computation uses the rounded figure, and so does the gross column here.
Which utilization number should I actually report?
All four, or the one your reader already uses with the divisor written next to it. A lender comparing you against a salaried alternative wants collected income over every hour worked. Your own pricing wants billed over delivery hours. Those were 58.2 and 87.9 percent in the same year.
Does it read my accounting system?
It reads whatever the accounting system exports, which is usually a CSV of invoices and a bank statement. Nothing needs connecting, and the sheets stay readable without it. Rate and collection realization only need the invoice total, the collected total and the card rate.
Is this for my practice or for a client's numbers?
Yours. It runs the practice rather than an engagement, so it never scopes work or produces a client deliverable. Getting oriented in a client's management accounts is a separate diagnostic, and pricing a recommendation for their board is a separate build with its own value model behind it.
Find out which week runs out
Take the Word documents and CSV sheets blank, or open this exact pack in River and let it build the denominators from your own records first.
Build my dashboard