Before you copy any KPI dashboard examples, consider this: most SME owners don’t have a shortage of numbers. They have a shortage of the right numbers, on one page, at the same time every week. The bank balance lives in the banking app, sales sit in the CRM and stock is in someone’s spreadsheet. As a result, the real picture only comes together when the management accounts arrive three weeks after month-end.
By then it’s history. You can’t change last month’s margin. Instead, you can only explain it.
This guide gives you practical KPI dashboard examples you can copy: an executive one-page view, plus financial, sales, operations and people dashboards. Each one lists the metric, why it matters, an example target and how often to look at it. You’ll also get the design rules that make a dashboard useful, an honest take on Excel versus software, and the mistakes that turn dashboards into wallpaper.
What a KPI dashboard is (and what it isn’t)
A KPI dashboard is a single view of the handful of measures that tell you whether your business is on track. In the KPI dashboard examples below, each metric shows the current number, target, trend and owner.
It isn’t a report pack. It isn’t a data dump of every figure your accounting system can produce. And it isn’t a strategy on its own. KPIs tell you how the business is running. Goals and OKRs, on the other hand, tell you where you’re trying to take it. If you’re unclear on the difference, our guide to KPIs vs OKRs and when to use each explains how the two work together.
The point of a dashboard is to shorten the gap between something going wrong and someone doing something about it. If your dashboard doesn’t change what anyone does on a Monday, it isn’t doing its job.
Why owners need one: the visibility gap
In a business of 10 to 200 people, the owner usually carries the true status of everything in their head. That works until it doesn’t. Then you become the bottleneck, and your team waits for you to tell them whether things are going well.
The research shows how common this is. A Harvard Business Review study on strategy execution found that only 55% of middle managers could name even one of their company’s top five priorities. Gallup found that only about half of employees strongly agree they know what is expected of them at work, and just 32% strongly agree their manager helps them set performance goals.
A shared KPI dashboard, like the examples below, fixes part of that. When the same eight numbers are on the screen every week, people stop guessing what matters.
Cash is the other reason. The QuickBooks 2025 Small Business Late Payments Report found that 56% of small businesses surveyed were owed money on unpaid invoices, and 47% had invoices more than 30 days overdue. Businesses with more overdue invoices were more likely to report cash-flow problems (50% versus 34%). You can’t manage that from a monthly report alone. Instead, you need debtors on the weekly view.
KPI dashboard examples you can copy
The five KPI dashboard examples below are starting points. The targets in these KPI dashboard examples are illustrative. So set your own from your history, your budget and your industry. Pick the dashboard that fits your biggest problem first, rather than building all five at once.
1. Executive KPI dashboard (one page)
Of all the KPI dashboard examples here, this is the page the owner and leadership team look at every week. Eight to ten numbers, drawn from the other dashboards. Picture a Joburg distributor with 45 staff: this is the page on the boardroom screen at the Monday meeting.
| Metric | Why it matters | Example target | Frequency |
|---|---|---|---|
| Cash in bank vs 13-week forecast | Early warning of a squeeze before it hits payroll | Never below 6 weeks of fixed costs | Weekly |
| Sales invoiced month-to-date vs budget | Shows whether the month is on track while you can still act | 100% of pro-rata budget | Weekly |
| Gross profit margin % | Catches discounting, cost creep and bad pricing | Your budgeted margin, e.g. 32% | Monthly (weekly estimate) |
| Debtor days | How fast sales turn into cash | At or below your payment terms, e.g. 45 days | Weekly |
| Weighted sales pipeline | Tells you what next month’s revenue will look like | 3x next month’s sales target | Weekly |
| On-time delivery % | Customer promise kept or broken | 95%+ | Weekly |
| Top 3 strategic priorities (RAG) | Keeps strategy on the same page as operations | All green or amber with a plan | Weekly |
| Staff turnover (rolling 12 months) | Losing good people is expensive and slow to fix | Below 15% | Monthly |
2. Financial KPI dashboard
Like all the KPI dashboard examples here, this one needs an owner: your finance manager, bookkeeper or fractional CFO. It feeds the executive page and goes deeper once a month when the management accounts land.
| Metric | Why it matters | Example target | Frequency |
|---|---|---|---|
| Cash balance and 13-week cash forecast | The number that keeps the lights on | No forecast week below your minimum cash buffer | Weekly |
| Revenue vs budget and prior year | Growth measured against a plan, not a feeling | Budget +/- 5% | Monthly |
| Gross profit margin % by product or service line | Shows which lines earn their keep | Line-specific targets | Monthly |
| Overheads as % of revenue | Stops fixed costs quietly outgrowing sales | Flat or falling as you grow | Monthly |
| Net profit before tax % | What’s left after everything | Budgeted %, e.g. 10% | Monthly |
| Debtor days and aged debtors over 60 days | Cash stuck with customers | Over-60s below 5% of the book | Weekly |
| Creditor days | Shows if you’re stretching suppliers too far | Within agreed terms | Monthly |
| Stock days (if you hold stock) | Cash sitting on shelves | Industry and product specific | Monthly |
If you’re not sure what margin to aim for, our guide on what a good gross profit margin looks like gives you ranges by sector and how to work out your own.
3. Sales KPI dashboard
| Metric | Why it matters | Example target | Frequency |
|---|---|---|---|
| New leads or enquiries | The top of the funnel drives everything below it | e.g. 40 qualified leads a month | Weekly |
| Quotes issued (number and Rand value) | A lead indicator you can act on this week | e.g. R1.2m quoted per month | Weekly |
| Quote-to-win conversion % | Tests pricing, follow-up and fit | Your 12-month average plus 5 points | Monthly |
| Average deal size | Shows whether you’re selling up or discounting down | Growing quarter on quarter | Monthly |
| Sales by rep vs target | Accountability at person level | 100% of individual target | Weekly |
| Revenue from top 5 customers % | Concentration risk | Below 40% | Quarterly |
As with the other KPI dashboard examples, pair this one with a proper forecast. Our guide on how to build a sales forecast shows you how to turn pipeline into a number you can plan cash around.
4. Operations KPI dashboard
Take a typical Durban engineering firm with a workshop and site teams. The owner doesn’t need 30 production metrics. They need the five that predict whether customers will be happy and jobs will make money.
| Metric | Why it matters | Example target | Frequency |
|---|---|---|---|
| On-time delivery or completion % | The customer’s first measure of you | 95%+ | Weekly |
| Rework or returns % | Quality problems eat margin twice | Below 2% | Weekly |
| Job profitability (actual vs quoted) | Shows where quoting or execution is off | Actual margin within 3 points of quoted | Per job, reviewed monthly |
| Capacity utilisation % | Too low wastes cost; too high breaks service | 75–85% | Weekly |
| Backlog (weeks of work booked) | Tells you when to hire or when to sell harder | 4–8 weeks | Weekly |
| Safety incidents | Non-negotiable, and a leading sign of sloppy process | Zero lost-time injuries | Weekly |
5. People KPI dashboard
| Metric | Why it matters | Example target | Frequency |
|---|---|---|---|
| Headcount vs plan | Keeps hiring tied to the budget | Within approved plan | Monthly |
| Staff turnover % (rolling 12 months) | Hidden cost of recruitment and lost knowledge | Below 15% | Monthly |
| Absenteeism % | Early sign of morale or management issues | Below 3% | Monthly |
| Revenue per employee | Productivity check as you grow | Rising year on year | Quarterly |
| Open vacancies and days to fill | Unfilled roles stall delivery | Key roles filled within 45 days | Monthly |
| Check-ins or reviews completed % | Shows whether managers are managing | 100% on schedule | Monthly |
Not sure which dashboard to build first? Take the free Business Health Check. It takes about 3 minutes (10 questions) and shows where your visibility gaps are, so you start with the numbers that matter most for your business.
Design principles for an executive KPI dashboard that gets used
The most useful KPI dashboard examples are boring in the best way. Same layout, same numbers, same time every week.
Keep it to 8–12 metrics per page
If everything is important, nothing is. As the KPI dashboard examples above show, every extra metric dilutes attention on the others. Start with fewer than you think you need and add only when a gap shows up.
Show the trend, not only the number
“Debtor days: 52” means little on its own. “52, up from 41 three months ago” tells you something is going wrong. Show at least the last 6 to 13 periods as a small line or a row of numbers.
Use RAG colours with clear thresholds
Red, amber and green let people see where to look in two seconds. Define the thresholds upfront, in numbers, so nobody argues about colour in the meeting. Our guide to RAG status reporting shows how to set them and how to avoid “watermelon” reports that look green but are red inside.
Give every metric one owner
Not a department. A named person. When a number turns red, everyone should know who explains it and who brings the recovery plan. That’s how a dashboard becomes an accountability tool rather than a scoreboard.
Mix lag and lead measures
Lag measures (revenue, profit) tell you what happened. Lead measures (quotes issued, pipeline, backlog) tell you what’s about to happen, and you can still influence them. A dashboard with only lag measures is a rear-view mirror.
KPI dashboard in Excel vs dashboard software
Plenty of owners start with a KPI dashboard in Excel, and that’s fine. It’s cheap, flexible and everyone knows it. The trouble starts when the business depends on it.
Spreadsheets are fragile. Research by Raymond Panko at the University of Hawaii, reviewing field audits of real business spreadsheets, found that the more recent audits found errors in at least 86% of the spreadsheets examined. Add manual copy-and-paste from three systems every Monday and you have a dashboard that’s late, wrong, or both.
| Excel or Google Sheets | Dashboard or performance software | |
|---|---|---|
| Cost | Low or none | Monthly subscription |
| Set-up | Fast to start, slow to maintain | Some set-up, then largely automatic |
| Data updates | Manual, dependent on one person | Connected to accounting and other systems |
| Error risk | High, especially with many formulas | Lower, fewer manual steps |
| Ownership and actions | Usually tracked elsewhere, if at all | Owners, comments and actions sit with the metric |
| Best for | Testing which metrics matter; businesses under ~15 staff | Teams that meet weekly and need one version of the truth |
A sensible path: prove the metrics from these KPI dashboard examples in Excel for two or three months. Once the list stops changing and the team relies on it, move it to a system so it updates itself and nobody spends Monday morning rebuilding it.
Common KPI dashboard mistakes
- Too many metrics. Forty numbers on a page means nobody reads any of them.
- No targets. A number without a target can’t be red or green. It’s trivia.
- Vanity metrics. Website visits and social followers feel good but rarely change a decision. Track enquiries and conversions instead.
- Monthly-only data. If the only numbers you see come from the management accounts, you’re always four to six weeks behind.
- No meeting rhythm. A dashboard nobody discusses is decoration. So review it at a fixed weekly slot, 30 to 45 minutes.
- Red without action. Every red metric needs an owner, a cause and a next step with a date. Our guide on how to hold employees accountable also covers how to run that conversation.
- One person holds the spreadsheet. When they go on leave, the dashboard goes with them.
Frequently asked questions
What should be on a KPI dashboard?
A KPI dashboard should show 8 to 12 metrics that tell you whether the business is on track: typically cash, sales against budget, gross margin, debtor days, pipeline, delivery performance and one or two people measures. Each should show the current value, target, trend and a named owner, with red, amber and green thresholds agreed upfront.
How many KPIs should a dashboard have?
For an executive dashboard, aim for 8 to 12. Functional dashboards for finance, sales or operations can carry a few more, but rarely more than 15. If a metric hasn’t prompted a decision or a question in three months, drop it. Fewer metrics get more attention and faster action.
Can I build a KPI dashboard in Excel?
Yes, and it’s a good way to start. Put your metrics in rows, periods in columns, add targets and conditional formatting for RAG colours, and a small trend chart. The risk is manual updating and formula errors, so once the metrics settle, consider software that pulls data directly from your accounting system.
How often should I review my KPI dashboard?
Review the executive dashboard weekly in a short, fixed leadership meeting, and go deeper monthly when management accounts arrive. Cash, sales and debtors need weekly attention. Margin, overheads and people metrics can be monthly. Quarterly, check whether you’re still measuring the right things.
Your next step: turn these KPI dashboard examples into one page you’ll use
Start small. Take the executive KPI dashboard from the examples above, cut it down to the eight metrics that matter most in your business, set a target and owner for each, and review it every Monday for a month. You’ll learn more about your business in those four meetings than from a year of reports.
If you’d like a clearer view of where to start, take the free Business Health Check. It takes about 3 minutes and highlights the areas where better visibility would make the biggest difference.
And if you want your KPIs, priorities, owners and RAG status in one place that updates without the Monday spreadsheet scramble, have a look at Edvysor for SMEs or book a 30-minute call and we’ll walk through what your dashboard should look like.
