Consulting KPI Dashboard Template

Start by setting up the Goals & Benchmarks sheet with your annual targets — total revenue, target billable utilization rate, effective hourly rate goal, and net margin. These don't need to be precise on day one; rough targets are better than none, and you can refine them after two or three months of actual data. Then move to the Monthly Input sheet and enter your numbers for the most recent completed month. You'll need your time tracking reports, invoices or billing records, and a basic expense summary. The entry process takes about 10–15 minutes.

Each month, return to the Monthly Input sheet and add a new row of data. The KPI Dashboard, Revenue by Engagement Type, and Goals & Benchmarks sheets all update automatically. The Project Tracker is worth updating whenever you close a project or at the end of each month — enter the hours spent and revenue collected for each active engagement, and the sheet will flag which projects are over budget on time and which clients are your highest-margin work. Most consultants find this is the sheet that most directly changes how they price and scope future work.

Once you have 3–4 months of data, patterns emerge that aren't visible from your invoicing system alone. You'll see whether your billable utilization is trending up or slipping — a drop below 60% is usually a signal that business development needs attention. You'll see whether your effective hourly rate is growing (good) or whether you're discounting to win work in ways that hurt profitability. Review the Goals & Benchmarks sheet quarterly, and use the Project Tracker data to make evidence-based decisions about which types of engagements are worth taking on.

Most consultants have a general sense of whether they're having a good month or a bad one, but few track the numbers that explain why. Billable utilization rate — the percentage of available working hours that are billed to clients — is the single most important operational metric for a consulting firm. At 60–65% utilization, most solo consultants and small firms break even comfortably. At 70–80%, they're generating strong margins. Below 50%, even high hourly rates struggle to produce a healthy net income. Without tracking utilization consistently, it's easy to stay busy on non-billable work without realizing how much revenue that's costing.

Effective hourly rate and project margin are the two metrics that reveal whether your pricing is working. Effective hourly rate accounts for all the hours that go into a project — preparation, revisions, client calls, project management — not just the hours you bill. A consultant billing $200/hour on a fixed-fee project who routinely does 30% more hours than estimated is actually earning $140/hour. Tracking effective hourly rate by project type over time shows which engagements are systematically underpriced and should be scoped more conservatively or priced higher. Project margin by client shows which relationships are genuinely profitable and which consume time disproportionate to revenue.

A KPI dashboard turns these numbers from annual surprises — discovered when doing taxes — into monthly data points you can act on. When you see utilization drop two months in a row, you know to accelerate outreach to existing clients or activate dormant leads before the pipeline empties. When effective hourly rate on fixed-fee projects is consistently lower than on hourly work, you have the evidence to renegotiate how you structure those engagements. Consultants who track their business weekly and review their KPIs monthly tend to catch problems earlier, price more accurately, and build more consistent revenue than those who look at the numbers once a year.