Consulting KPI Dashboard Template

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.

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.