Almost every SME has a management dashboard. The problem is rarely that it doesn't exist: it's that it arrives too late, depends on one person to update it, or comes in two versions with two different totals.
A good dashboard comes down to two requirements: few indicators, clearly defined, and a data feed that doesn't ask anyone to copy and paste. Here is how to get there.
Start with decisions, not data
The question is not "what data do we have?" but "what decisions do we make every week or month?". Hiring, chasing a customer, holding back on a spend, pushing an offer: every indicator should support at least one of these decisions.
If a number gets looked at without ever changing an action, it doesn't belong on the front page.
The indicators most SMEs end up tracking
There is no universal list, but a few families come up almost every time:
| Family | Example indicators | The decision they inform |
|---|---|---|
| Cash | Bank balance, expected receipts over 30 days | Can we commit to this spend? |
| Sales activity | Quotes sent, conversion rate, open pipeline | Do we need to step up prospecting? |
| Invoicing | Revenue invoiced, overdue invoices | Who needs a reminder? |
| Profitability | Margin by offer or by customer | Which offer to push, which to rethink? |
| Operations | Processing time, files on hold | Where is the bottleneck? |
One simple rule: around ten indicators at most on the main view. Detail can live on secondary pages.
Write every indicator down
This is the step everyone skips, and the cause of most arguments in meetings. For each indicator, write down:
- the formula: is revenue invoiced or collected? Before or after tax?
- the source: which tool the data comes from (accounting software, bank, CRM, invoicing tool)?
- the scope: which entities, which period, which exclusions?
- the owner: who can explain the number if it looks odd?
One page is enough. It stops two people from calculating two different numbers from the same data.
Feed the dashboard without manual work
Once the indicators are defined, the feed can be automated in four building blocks:
- Connect the sources. Accounting, bank, invoicing, CRM: most offer an API or a scheduled export. Data arrives on its own instead of being copied.
- Consolidate with checks. If an export is incomplete or a total doesn't match, the tool flags it rather than showing a wrong number.
- Calculate from the written definitions. Formulas live in one place, not in ten Excel tabs.
- Deliver in the right format. A dashboard to browse, a PDF sent on Monday morning, or an alert when a threshold is crossed.
Frequency depends on the decision: cash can be tracked weekly, margin by offer monthly.
The most common mistakes
- Too many indicators. An overloaded screen stops being read.
- A visualisation tool before clean data. A nice chart on hand-copied data is still fragile.
- No checks. A broken formula can circulate for weeks before anyone notices.
- A single gatekeeper. If only one person knows how to update the file, the dashboard stops when they go on holiday.
Where to start
Pick the five indicators that really drive your decisions, write their definitions, and note where each piece of data comes from. If the same person still spends hours every week consolidating exports, it's often time to move to automated financial reporting. And if your dashboard lives in an Excel file that has become unmanageable, read the signs it's time to replace it with an internal tool.
Frequently asked questions
There is no universal list, but the families that come up most are cash, sales activity, invoicing, profitability and operations. Keep to about ten indicators at most on the main view, each serving at least one decision.
By writing each indicator down in black and white: the formula, the data source, the scope and the owner. One page is enough.
With four building blocks: connect the sources (accounting, bank, invoicing, CRM), consolidate with checks, calculate according to the written definitions, then deliver in the right format, for example a dashboard to consult, a PDF sent on Monday morning or an alert when a threshold is crossed.
Related service · Financial reporting
Let's look at your dashboard in 30 minutes.
A free, no-commitment call: we tell you what can feed itself, and honestly if now is not the right time.