A useful KPI dashboard is not a wall of charts. It is a controlled monthly process: every input has an owner and source, every formula answers a decision question, and every exception ends with an action.
Take the free monthly-close readiness check
Score eight operating controls before building more charts. Your answers and score stay in this browser.
First priority:
Close the month in five passes
- Lock the period. Use one reporting month and document whether each source follows calendar months or another close cycle.
- Reconcile financial inputs. Tie revenue, direct costs, operating costs, cash collected and receivables to their owning systems.
- Freeze commercial counts. Capture leads, proposals, new clients, active clients and lost clients at the same cutoff.
- Validate capacity. Confirm delivery hours, available hours and full-time-equivalent headcount with one consistent method.
- Approve exceptions. Record estimates, late adjustments and definition changes before publishing the dashboard.
Keep accounting records separate from the dashboard. The dashboard summarizes source data; it does not replace the ledger, invoicing, CRM, time tracking or receivables systems. Cash collected should not automatically be called revenue: revenue recognition concerns the transfer of promised goods or services, while collections describe cash movement.
A compact 18-KPI set
| Area | KPI | Working formula | Decision question |
|---|---|---|---|
| Profit | Revenue | Recognized revenue for the period | What did the business earn under its policy? |
| Revenue growth | (Current − prior) ÷ prior | Is movement real, seasonal or definition-driven? | |
| Gross profit | Revenue − direct delivery costs | Does delivery create enough contribution? | |
| Gross margin | Gross profit ÷ revenue | Are pricing and delivery costs aligned? | |
| Operating margin | (Revenue − direct costs − operating costs) ÷ revenue | Does contribution cover the operating model? | |
| Pipeline | Lead-to-proposal rate | Proposals ÷ leads | Are leads relevant and qualified? |
| Proposal win rate | New clients ÷ proposals | Is the offer converting? | |
| Lead-to-client rate | New clients ÷ leads | How efficient is the full acquisition path? | |
| Revenue per new client | Revenue ÷ new clients | Is acquisition mix changing? | |
| Clients | Client loss rate | Lost clients ÷ opening active clients | Is the base eroding? |
| Net client change | New clients − lost clients | Is the active base expanding? | |
| Revenue per active client | Revenue ÷ active clients | Is account value moving? | |
| Capacity | Utilization | Delivery hours ÷ available hours | Is capacity balanced? |
| Revenue per delivery hour | Revenue ÷ delivery hours | What does delivered time support? | |
| Revenue per FTE-month | Revenue ÷ FTE | Is productivity moving sustainably? | |
| Cash | Collection rate | Cash collected ÷ invoiced amount | Are invoices turning into cash? |
| AR days | Receivables ÷ revenue × days in period | How much working capital is tied up? | |
| Overdue AR share | Overdue receivables ÷ total receivables | Where is collection risk concentrated? |
These are simplified management formulas. Cohort metrics, tax treatment, work in progress, deferred revenue, credit notes, deposits and project accounting may require different logic. Write the exact local definition next to every metric.
Use references, not universal benchmarks
A target becomes useful only when it reflects the business model, delivery mix, pricing, seasonality and risk tolerance. Start with a documented working range, compare like-for-like periods and explain why the range exists. If the model changes, update the range prospectively and preserve the history.
Run a 60-minute operating review
0–10 minutes: trust the data
Confirm close status, reconciliations, exceptions and changed definitions.
10–25 minutes: explain movement
Review material changes across profit, pipeline, clients, capacity and cash.
25–45 minutes: choose decisions
Separate symptoms from causes and choose the few actions worth owning.
45–60 minutes: assign control
Give each action one owner, due date, evidence source and success check.
Six mistakes that make dashboards less useful
- Mixing cash collected, invoices issued and recognized revenue.
- Changing a formula without recording the effective date.
- Using activity counts without a decision question.
- Comparing businesses with different pricing, staffing or revenue policies as if they were identical.
- Storing unnecessary personal data when aggregated monthly values are enough.
- Creating more actions than owners can complete before the next review.
Official guidance used
IFRS Foundation: IFRS 15 Revenue from Contracts with Customers — the core principle connects revenue recognition to transferring promised goods or services.
U.S. Small Business Administration: Manage your finances — bookkeeping, balance sheets, accounts receivable, accounts payable and bank reconciliation.
GOV.UK: Company and accounting records — keeping financial and accounting records, including money received and spent, assets and debts.
UK Information Commissioner's Office: Data minimisation — personal data should be adequate, relevant and limited to what is necessary.
Want the dashboard, definitions and review workflow ready to adapt?
See the planned Service Business KPI Starter: an editable Excel workbook and 13-page Word guide. No checkout is active yet. The site records only an anonymous CTA click and, if you choose it, a separate launch-interest signal.
View the KPI starterFrequently asked questions
Which KPIs should a small service business track?
Start with a compact set spanning profit, pipeline, clients, capacity and cash. Every KPI needs a documented formula, source, owner and review question.
Should cash collected be reported as revenue?
Not automatically. Revenue recognition and cash collection answer different questions. Reconcile each measure to the accounting policy and source system used by the business.
What is a good KPI target?
There is no universal target. Use documented working references, compare like-for-like periods and revise thresholds prospectively when the business model or definitions change.