KPI Dashboard Template for Fractional CFOs

A KPI dashboard is the visual heartbeat of your client's business. Updated monthly and presented in your financial review meetings, it transforms raw accounting data into the metrics that actually drive decisions. It's also one of the highest-value deliverables a fractional CFO provides.

This guide covers which KPIs to track by industry, how to build effective dashboards, and includes a professional template pack with 5 industry-specific dashboards ready to customize.

Why KPI Dashboards Matter for Advisory

Here's the truth about advisory services: clients don't pay for numbers — they pay for clarity. A bookkeeper delivers a P&L. A fractional CFO delivers a KPI dashboard that answers "how are we doing, and what should we focus on?"

The dashboard is what makes your monthly financial review meeting worth $3,000-$10,000/month. Without it, you're just reading financial statements — something the client could do themselves. With it, you're providing the visual context that drives action.

Essential KPIs by Industry

General / SMB (Any Small Business)

KPI	What It Measures	Target
Revenue	Total sales	Above budget
Gross Margin %	Profitability after direct costs	Industry-dependent (30-70%)
Net Profit Margin %	Bottom-line profitability	10-20% for healthy SMBs
Cash Position	Bank balance right now	2-3 months of operating expenses
Days Sales Outstanding	How fast you collect	<35 days
Current Ratio	Short-term liquidity	>1.5
Revenue per Employee	Productivity	$100K-$300K depending on industry

SaaS / Subscription Businesses

KPI	What It Measures	Target
Monthly Recurring Revenue (MRR)	Predictable monthly revenue	Growing month-over-month
Gross Revenue Churn %	Revenue lost to cancellations	<5% monthly
Net Revenue Retention %	Revenue kept + expanded	>100% (expansion exceeds churn)
Customer Acquisition Cost (CAC)	Cost to win one customer	Varies (but LTV:CAC >3)
Lifetime Value (LTV)	Total revenue per customer	>3× CAC
Burn Rate	Monthly cash consumption	Sustainable with runway
Runway (months)	How long until cash runs out	>12 months

For a deep dive on SaaS metrics, see our guide on startup CFO services and CFO dashboard best practices.

Professional Services (Accounting Firms, Consultants)

KPI	What It Measures	Target
Utilization Rate %	% of time spent on billable work	65-80%
Realization Rate %	% of billable work actually billed	>90%
Revenue per Employee	Individual productivity	$120K-$250K
Work in Progress (WIP)	Unbilled time/costs	Minimize — WIP is a cash drain
Backlog Value	Contracted but undelivered work	3-6 months of revenue

Construction

KPI	What It Measures	Target
Backlog	Contracted future revenue	6-12 months of revenue
Gross Margin by Job	Profitability per project	>15-25%
Overbilling / Underbilling	Cash flow vs. completion	Net overbilling position
Equipment Utilization %	Asset productivity	>70%

Building an Effective Dashboard

1. Start with 8-12 KPIs — enough for a complete picture, few enough to stay focused
2. Show trends, not just snapshots — 12 months of data reveals patterns a single number can't
3. Include a commentary section — numbers without narrative are useless. Add 3-5 bullet points highlighting key observations
4. Color-code status — green/yellow/red makes it scannable in seconds
5. Compare to benchmarks — "Is 42% gross margin good?" depends on the industry. Include benchmarks for context

How Fractional CFOs Deliver Dashboards

1. Week 1-2 (onboarding): Gather 3-6 months of historical data, populate the dashboard baseline
2. Monthly: Update with current month actuals. Identify 3-5 key observations. Schedule review meeting
3. During the meeting: Walk through each section. Focus on variances and trends. Recommend 2-3 specific actions
4. After the meeting: Export dashboard as PDF. Email to client as part of the monthly financial package

This delivery workflow — combined with a cash flow forecast and financial reporting package — is the core of what clients pay $3K-$10K/month for.

Related: CFO Dashboard Guide · FP&A Software Tools · Financial Reporting Guide · All Templates