IIIOrganization & Project ManagementGuide
A One-Page KPI Dashboard: Structure, Metrics, Rhythm
Accounting delivers twenty pages of reports every month, the CRM has its own reports, and the account balance is in the banking app. Still, on Monday morning the owner cannot tell in two minutes how the business is doing. A one-page dashboard solves exactly that.
Key takeaways
- A KPI dashboard is a single page with about ten metrics that shows whether the business is on track and where action is needed.
- The balanced scorecard provides the framework: finance, customers, processes, and team. For small companies, a few metrics per area are enough.
- Every metric on the dashboard needs a question it answers and a threshold at which action is taken. Otherwise it is decoration.
- Metrics have different rhythms: liquidity and pipeline weekly, most others monthly, a few quarterly.
Why is there no overview despite all the numbers?
Hardly any company has too few numbers. The tax advisor sends the monthly management report, the inventory system shows sales by item, the CRM counts quotes. The problem is a different one. The numbers sit in five places, arrive at different times, and answer questions nobody asked. Whoever wants to know whether to intervene has to search and calculate.
The article on sales KPIs for small businesses describes the five-metric compass for sales, and the essay on data-driven decisions describes the question, number, threshold method. This article brings both together on one page and asks: How does an owner build a KPI dashboard that fits on one page, covers the entire business, and is actually used in daily work?
To answer it, we first introduce the balanced scorecard as a thinking model. Then we weigh how many metrics a small company needs and move on to the structure in four areas with an example. At the end we look at the rhythm in which the dashboard is read and give an answer to the guiding question.
A dashboard you have to study is a report. A dashboard you can read in two minutes is a tool.
The thinking model: the balanced scorecard
A KPI dashboard is an overview that shows a few selected key figures of a company with their targets and thresholds on one page. A key figure or KPI is a number that condenses a fact, such as the close rate or outstanding receivables. The name dashboard refers to the instruments in a cockpit: the pilot does not see all of the aircraft’s data, only the few that determine the course.
The best-known framework for such a selection is the balanced scorecard by Kaplan and Norton (1992). Its basic idea: financial figures alone show the past. Whoever wants to steer also needs figures that indicate in advance where the finances are heading. Kaplan and Norton proposed four perspectives for this that stand side by side in balance.
| Perspective | Guiding question in Kaplan and Norton | Translation for the small company |
|---|---|---|
| Finance | How do shareholders see us? | Are we making money, and is liquidity sufficient? |
| Customers | How do customers see us? | Are we winning and keeping the right customers? |
| Internal processes | What must we excel at? | Do we deliver on time and without rework? |
| Learning and growth | Can we continue to improve? | Does the team have the time and people it needs? |
The balanced scorecard was developed for large companies and has often been expanded there into extensive systems of metrics. For a small company, it is more useful as a thinking model than as a procedure. It ensures that the dashboard does not consist only of revenue and the account balance but also contains early warning signs from sales, processes, and the team.
How many metrics does a dashboard need? Two perspectives
The first perspective says: the more a company measures, the more precisely it can steer. It has support in research. Reynolds, Fourie, and Erasmus (2019) used a multi-round expert survey to develop a generic balanced scorecard for small and medium-sized manufacturers in South Africa. The result comprised 12 generic and 104 specific metrics, with an emphasis on the finance and customer perspectives.
The second perspective says: few metrics get read, many do not. There is evidence for this too, even in the same study. Reynolds and colleagues refer to Fernandes and colleagues (2006), according to whom small and medium-sized companies should limit themselves to the essential metrics when using the balanced scorecard: quality over quantity. Sipos, Bányai, and Venczel-Szakó (2024) analyzed data from 784 small and medium-sized enterprises in eight countries and note that merely imitating the information sources of larger role models does not necessarily lead to the desired result.
Source: Reynolds, Fourie, Erasmus (2019); Nita (2026); Sipos, Bányai, Venczel-Szakó (2024)
That mature measurement systems pay off is shown by a survey of 218 Polish small and medium-sized enterprises: it links mature performance measurement systems with better decision quality and greater financial resilience (Nita 2026). Mature does not mean extensive here, but regularly used and tied to decisions.
I consider both perspectives compatible if two levels are separated. The 104 metrics of Reynolds and colleagues are a catalog from which a company selects. The dashboard is the selection. For the page the owner reads every week, about ten metrics are a good upper limit. Everything else belongs in reports you open when needed.
Four areas, ten metrics: how is the dashboard structured?
The dashboard follows the four perspectives of the balanced scorecard. Each area contains two to three metrics. Each metric has three entries: the current value, the target, and the threshold at which action is taken. The following example shows a dashboard for a service company with 25 employees. The figures and thresholds are an example.
| Area | Metric | Value | Threshold | Rhythm |
|---|---|---|---|---|
| Finance | Liquidity in weeks (account balance and secure receipts ÷ weekly expenses) | 7 weeks | below 4 weeks | weekly |
| Finance | Contribution margin for the month | €62,000 | below €50,000 | monthly |
| Finance | Receivables older than 30 days | €18,000 | above €25,000 | weekly |
| Customers | Pipeline value | €210,000 | below €150,000 | weekly |
| Customers | Close rate over the last three months | 31% | below 25% | monthly |
| Customers | Repeat purchase rate | 64% | below 55% | quarterly |
| Processes | Days from inquiry to quote | 4 days | above 7 days | monthly |
| Processes | On-time delivery of orders | 88% | below 80% | monthly |
| Team | Team utilization | 86% | above 95% or below 70% | monthly |
| Team | Positions open longer than 60 days | 1 | more than 1 | quarterly |
Worked example
Three of the five sales metrics from the five-metric compass appear in the customers area: pipeline value, close rate, and repeat purchase rate. Quote turnaround appears in the processes area, because it depends on your own workflow. The contribution margin, meaning revenue minus directly attributable costs, appears instead of revenue, because revenue without margin can be misleading. How to determine it per order is shown in the article on contribution margin per order.
Liquidity comes first. Reynolds and colleagues (2019) explicitly name cash flow management as a success factor for small companies. Why growing companies in particular run into liquidity bottlenecks is described in the article on why growth costs liquidity. And how to bring receivables down is shown in the article on late payments and receivables management.
How do you build your dashboard in five steps?
Collect questions
Write down the questions you regularly ask yourself about the business. “Will the money last until the end of the quarter?” “Are enough orders coming in?” No question, no metric.
Choose one number per question
Choose the simplest number that answers the question and that you can collect without much effort. A spreadsheet is enough as a source.
Assign them to the four areas
Check whether each area has at least one metric. If the team or processes area is missing, you lack the early warning signs.
Set thresholds
For each metric, the value at which you act. Use the values of the last twelve months as a guide.
Cut
Remove everything beyond ten metrics, or move it into a report you open when needed.
The fifth step is the hardest. Whoever starts collecting questions quickly finds thirty. The following worked example shows how the number of metrics shrinks over three passes.
Worked example: of 34 collected numbers, 16 answered a question that is asked regularly. For 12, a meaningful threshold could be set. Two more moved into the monthly report.
A single-sheet spreadsheet is enough to start. Vieira, Soares, and Sousa (2017) showed that a balanced scorecard for small and medium-sized companies can be implemented in a spreadsheet without expensive software. Whoever wants to keep the dashboard where the team already maintains goals and tasks can also run it in a work platform such as quik OS, a tool from a business partner of Owners Council for tasks, knowledge, and strategy. What determines the benefit is not the tool but that the page lives in a fixed place and is read at a fixed rhythm.
At what rhythm do you read the dashboard?
Not every metric changes at the same speed. Whoever checks all metrics weekly mostly sees noise. Whoever checks them all only monthly notices a liquidity bottleneck too late. The dashboard therefore has three rhythms.
Weekly, 10 minutes
- liquidity in weeks
- receivables older than 30 days
- pipeline value
- check only: has a threshold been crossed?
Monthly, 30 minutes
- all metrics on the dashboard
- comparison with previous month and same month last year
- one action with an owner for each crossed threshold
- quarterly in addition: repeat purchase rate, team, review thresholds
The weekly check can be attached to weekly planning as described in the article on weekly team planning. The monthly review is a separate appointment for the owner, ideally with the person who handles accounting. Each quarter, the additional questions are whether the thresholds are still right and whether a metric should be replaced. Whoever sets quarterly goals with OKRs will find the connection in the article on OKRs for small and midsize companies: the dashboard shows the state, the goals show the change.
Which mistakes make a dashboard worthless?
Most dashboards fail not because of the choice of metrics but because of how they are used. Five mistakes occur particularly often.
- Numbers without a question: A metric is on the dashboard because it is available, not because it prepares a decision.
- Thresholds after the fact: The limit is set after the value is known. Then the dashboard only confirms what you already thought.
- Finance only: Revenue and the account balance show the past. Without pipeline and processes, every warning comes too late.
- No appointment: The dashboard is read when there is time, which means rarely and usually only when things are on fire.
- No consequence: A crossed threshold leads to no action with an owner and a date. Then the team gets used to red fields.
One limitation applies to the research. The studies cited come from South Africa, Poland, and Bosnia and Herzegovina, and from a comparison of eight countries, and they mostly measure respondents’ assessments. A survey of 234 small and medium-sized enterprises in Bosnia and Herzegovina, for example, used the four perspectives to capture business success (Klepić 2022). Whether a dashboard makes a company more successful cannot be derived from these studies. But they show that the four perspectives work as a framework in small companies too.
Conclusion: what a KPI dashboard must achieve
The opening question was an owner builds a dashboard that fits on one page, covers the entire business, and is used. The answer has three parts. The structure follows the four perspectives of the balanced scorecard so that customers, processes, and the team are visible alongside finance. The selection stays at about ten metrics, each with a question and a threshold set in advance. And use follows fixed rhythms: the fast metrics weekly, all of them monthly, and the thresholds themselves quarterly.
As shown, more than a hundred sensible metrics can be found for small companies, but only a few are read regularly. Research links mature measurement systems with better decisions but warns against copying the reports of larger companies. This leads to a simple observation: the value of a dashboard lies not in the numbers it contains but in the numbers it leaves out.
What you can do this week
- Write down the five to eight questions you most often ask yourself about your business.
- Choose one simple number per question and assign it to the four areas.
- Set a threshold for each number before you look up the current value.
- Enter the values for the last three months on one page.
- Put a weekly ten-minute and a monthly thirty-minute appointment in your calendar.
After a quarter, you will know which numbers you actually need and which just take up space. That is the right time to cut the dashboard for the first time.
Frequently asked questions
What is a KPI dashboard?
A one-page overview that shows a few selected key figures of a company with target and threshold. It should make it possible to see within minutes whether the business is on track and where action is needed. For small companies, about ten metrics are a good upper limit.
Which metrics belong in a dashboard for small businesses?
Two to three metrics from each of four areas: finance (such as liquidity in weeks, contribution margin, outstanding receivables), customers (pipeline value, close rate, repeat purchase rate), processes (quote turnaround, on-time delivery), and team (utilization, open positions). The exact selection depends on the questions you regularly ask.
What is the balanced scorecard?
A framework by Kaplan and Norton (1992) that brings together metrics from four perspectives: finance, customers, internal processes, and learning and growth. The idea behind it: financial figures show the past, while the other perspectives show in advance where they are heading.
How often should I review my KPIs?
At different rhythms. Fast-changing figures such as liquidity, receivables, and pipeline weekly in ten minutes, the whole dashboard monthly in half an hour, and each quarter the thresholds and the selection of metrics themselves.
Do I need software for a KPI dashboard?
Not to start with. A one-page spreadsheet is enough, as studies on implementing the balanced scorecard in small companies also show. More important than the tool are a fixed place, a clear data source for each metric, and a fixed appointment.
Sources
- Kaplan, R. S.; Norton, D. P. (1992): The Balanced Scorecard: Measures That Drive Performance. Harvard Business Review, 70(1), 71-79.
- Reynolds, A.; Fourie, H.; Erasmus, L. (2019): A generic balanced scorecard for small and medium manufacturing enterprises in South Africa. The Southern African Journal of Entrepreneurship and Small Business Management, 11(1), a193.
- Nita, B. (2026): Performance measurement system maturity and financial resilience in SMEs: The mediating role of managerial decision quality. Zeszyty Teoretyczne Rachunkowości, 50(3), 257-280.
- Sipos, N.; Bányai, E.; Venczel-Szakó, T. (2024): An international empirical study on the relationship between decision-making information complexity and resource-based view in small and medium-sized enterprises. Systems Research & Behavioral Science, 41(3), 453-470.
- Vieira, A.; Soares, N.; Sousa, S. D. (2017): Implementing the balanced scorecard in excel for small and medium enterprises. IEEE International Conference on Industrial Engineering and Engineering Management (IEEM), 2361-2365.
- Klepić, I. (2022): The Influence of Human Resources Competency Management on the Business Success of Small and Medium Enterprises. Naše gospodarstvo/Our Economy, 68(4), 12-27.



