KPI dashboard for SMBs: 12 examples with formulas

A dashboard only matters if someone acts on it

Most small and mid-sized businesses are not short of numbers. The accounting system, time tracking and CRM are full of them. What is missing is a short overview that answers the same question every week: are we on track, and if not, who does what?

A KPI (key performance indicator) is therefore not just any number. It is a metric with a target, a threshold and an owner. Revenue is information. Gross margin below 35 percent, after which the sales director reviews that month's pricing agreements, is a KPI.

Below are twelve KPIs that deliver the most value in practice for businesses with 5 to 250 employees. Each one comes with a formula, the usual source and the action that goes with it. Do not pick all twelve at once: six to eight is enough for most management teams.

Financial KPIs

DSO is one of the most underrated metrics. If your DSO rises from 38 to 52 days on annual revenue of EUR 1.2 million, roughly EUR 46,000 more is tied up with customers. That is money you do not have to borrow if you collect it on time. Read more about managing receivables with data.

Project and services KPIs

Utilization and project margin belong together. A team can be 85 percent billable and still lose money if the rate is too low or change orders are not invoiced. For the per-project view, see automating job costing.

Commercial KPIs

How to build the dashboard

Step 1: write down every definition. For each KPI, record what counts. Is revenue including or excluding recharged costs? Does a credit note count in the month of the original invoice? Without fixed definitions, meetings debate the number instead of the action. A semantic layer helps keep those definitions consistent across tools.

Step 2: connect the sources once. Manual exports are the main reason dashboards stop being updated after three months. With a connector for your accounting system, figures arrive automatically, for example from Exact Online, Twinfield or Moneybird.

Step 3: add budget and targets. A KPI without a target says little. Upload your budget or monthly targets as a CSV file so the dashboard can show actual versus target.

Step 4: show the trend, not just the value. A gross margin of 38 percent is good or bad depending on the previous twelve months. Show the current value, the target and a trend line for each KPI.

Step 5: agree on a rhythm. Review the dashboard every week or month in the same meeting. When a threshold is crossed, send an automatic alert or email report to the owner.

Want to see these KPIs on your own figures? Request a 20-minute demo. We set up one source and show which metrics your records can already deliver.

Practice with sample data first

The financial dashboard example page contains a fictional monthly dataset with revenue, direct costs, payroll, housing, receivables balance and FTE. Download the CSV and recalculate the first five KPIs from this article in Power BI or Excel. That way you can test whether a KPI definition suits your business before you connect anything.

Common mistakes

• Too many KPIs. Twenty tiles on one screen means nobody knows where to look. Keep the management dashboard to one screen.
• Averaging percentages. The average of twelve monthly margins is not the annual margin. Always recalculate margins from totals.
• Summing receivables across months. A receivables balance is a point-in-time value. Use the closing balance of the period, not the sum.
• No owner. If nobody is responsible for a red KPI, nothing changes.

From dashboard to question

A dashboard shows that margin is falling. The next question is why. With the DigiData AI agent you ask that follow-up question in plain language on the same connected data, for example which customers or projects cause the drop. For more ideas, read 50 questions to ask your business data.