KPI dashboard for SMBs: 12 examples with formulas
See 12 KPIs for a small business dashboard, each with a formula, source and action. Includes free sample data so you can build your own KPI dashboard.
By Auke Westra
Founder of DigiData
Short answer
A KPI dashboard for a small or mid-sized business shows a short list of metrics that are each tied to a decision, such as gross margin, outstanding receivables, billable utilization and project margin. Give every KPI one definition, one source system, one owner and a threshold that triggers action. Start with six to eight KPIs from your accounting and project software, and only add more once the team uses them every week.
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
| KPI | Formula | Typical source | Action when off target |
|---|---|---|---|
| 1. Revenue vs budget | Actual revenue ÷ budgeted revenue | Accounting + budget | Adjust forecast and capacity |
| 2. Gross margin % | (Revenue − cost of sales or direct costs) ÷ revenue | Accounting | Review prices, discounts and purchasing |
| 3. Operating profit | Revenue − direct costs − staff − other costs | Accounting | Discuss the cost lines that grew most |
| 4. DSO (days sales outstanding) | Outstanding receivables ÷ revenue × days in period | Accounting | Tighten reminders and payment terms |
| 5. Overdue receivables % | Overdue outstanding ÷ total outstanding | Accounting | Personally call the top 10 overdue items |
| 6. Cash position next 13 weeks | Bank balance + expected receipts − expected payments | Accounting + forecast | Move payments or arrange financing |
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
| KPI | Formula | Typical source | Action when off target |
|---|---|---|---|
| 7. Billable utilization % | Billable hours ÷ available hours | Time tracking | Review planning and non-billable work |
| 8. Project margin % | (Project revenue − project costs) ÷ project revenue | Project software + accounting | Record change orders, protect scope |
| 9. Budget burn | Hours or costs spent ÷ budget | Project software | Project manager intervenes before overrun |
| 10. Work in progress | Delivered but not yet invoiced | Project software + accounting | Invoice milestones |
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
| KPI | Formula | Typical source | Action when off target |
|---|---|---|---|
| 11. Weighted pipeline | Sum of (deal value × probability) | CRM | Schedule additional prospecting |
| 12. Quote win rate | Quotes won ÷ quotes issued | CRM or project software | Analyze lost quotes on price and lead time |
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. Single ratios such as solvency, return on equity and utilization you can check with the free financial ratio calculators.
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.
Want to fill the commercial KPIs above from real sources? Connecting HubSpot to Power BI shows how to pull the weighted pipeline and win rate from your CRM, Google Analytics 4 in Power BI covers modelling website traffic and conversions, and for retailers using retail data in Power BI describes how to put store, staffing and weekly-report data next to revenue.
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.
Want to see these KPIs on your own data? Open the live KPI dashboard and see how the AI agent builds it for you.
Sources
About Auke Westra
Founder of DigiData
Auke Westra is Founder of DigiData. He was responsible for clients' data and reporting and in 2025 began building an in-house data platform with his team. He writes about AI on business data, data definitions, Power BI and integrations.
Ready to start?
Try DigiData free for 14 days. Connect your software and let AI build a dashboard on your own figures.
Related articles
Operating budget template: a budgeted profit and loss with free Excel
Build a monthly operating budget with the free Excel template. With a worked example, every line item and how it differs from a cash flow forecast.
Power BI Desktop or Power BI Service: what do you do where?
Power BI Desktop builds, Power BI Service shares and refreshes. What you do where, when you need a gateway and how to use Power BI on a Mac, step by step.
Connect Exact Online to ChatGPT or Claude: step by step
Ask questions about your Exact Online data in ChatGPT or Claude. Connect in four read-only steps, with five starter questions and tips for checking the answers.
How to build a cash flow forecast from your accounting data
Build a 13-week cash flow forecast from open invoices, fixed costs and VAT. Includes a free Excel template, a worked example and common pitfalls.
