What to measure in a small business: seven indicators that actually help
Most dashboards measure what is easy to measure, not what decides. Seven indicators that change decisions, how each is calculated and what to do when one turns red.
· Data and BI
There is a simple test for whether an indicator is any use: what would you do differently if it changed? If the answer is «nothing», it is not an indicator, it is decoration. Under that filter most dashboards halve in size — and work better.
These are the seven that, for a small business, genuinely change decisions.
1. Cash available and the thirteen-week forecast
It is not today's balance: it is the projected balance week by week over the next quarter, counting expected receipts and committed payments.
Why it outranks all the others: a profitable business can close for lack of cash, and the warning arrives weeks ahead if somebody is watching. Thirteen weeks is the standard horizon because it is long enough to react and short enough to be reliable.
What you do if it turns red: pull receipts forward, defer non-critical payments, negotiate a facility before you need it — not on the day you do.
2. Average collection period
How many days on average you take to get paid from the moment you invoice. It is calculated by dividing the receivables balance by the period's sales and multiplying by the days in the period.
It is the indicator that can be improved fastest without selling more: cutting fifteen days off the average collection period frees up cash immediately, and it is achieved with a systematic chasing routine.
3. Margin by line, not overall margin
The total margin hides what matters. What you need to see is the margin of each product, service or customer type, with direct costs properly allocated.
The usual surprise the first time it is done: there is a line that bills a lot and contributes little or nothing, and a small one that carries the result. It shows up in the first analysis and changes the sales strategy that same week.
4. Monthly break-even point
How much you have to bill each month not to lose money. It is a single number, calculated once and revised when the fixed costs change.
Its usefulness is not accounting, it is psychological: it turns «we are tight» into «we are 4.000 € short this month». We explain it in the break-even point.
5. Customer concentration
What percentage of your revenue depends on your largest customer, and on the three largest.
Above a certain threshold — every business has its own, but 30 % in a single customer is already a lot — you do not have a business: you have a job with more risk and no rights. It is an indicator nobody ever looks at and it explains most sudden crises.
What you do if it turns red: diversify before the big customer leaves, not afterwards.
6. Acquisition cost against customer value
What it costs you to win a new customer, compared with what that customer leaves behind over the whole relationship.
Academic precision is not needed: an honest approximation is already enough to decide whether it is worth investing more in acquisition or in retention. And it nearly always reveals the same thing: retaining costs far less than acquiring, and almost nobody allocates budget to retaining.
7. Billable hours against hours worked
For any services business, this is the indicator that decides real profitability. If the team works 160 hours a month and only 90 are billable, the problem is not the hourly rate: it is that 70 hours go on internal work nobody has looked at.
When it is measured for the first time, it is common to discover that a good part of those hours goes on repetitive, automatable tasks. That is nearly always where the best possible automation project comes from — the one that justifies itself. It is in what to automate first.
The three rules for making this work
- Start with three, not seven. A dashboard with three indicators that get looked at is worth infinitely more than one with twenty that nobody opens.
- They have to update themselves. An indicator that requires exporting and pasting every Monday is dead by the second month. No exceptions.
- Every indicator with its threshold and its written action. «If the collection period goes past 60 days, escalated chasing kicks in.» Without that sentence, the number only informs.
What almost nobody measures and should
The time from a customer asking to a customer getting an answer. It is easy to measure, it never appears on dashboards, and it correlates with sales more than almost anything else.
If this sounds like you
Building the dashboard with the data connected — from the accounts, from the bank, from the invoicing system — rather than from manual exports is data analysis and BI. If what you need first is to see the cash, the fixed-scope job is the treasury dashboard.
And to pick the tool without going wrong, Power BI or Looker Studio.
We are Mindset & Code: automation, data and development for small businesses. We connect the dashboard to your real data — the bank, the shop, your management software — so the indicators do not come out of an estimate. You can see what we do and what it costs.
General guidance. The thresholds for each indicator depend on the sector and the size; the ones here are orders of magnitude to orient you, not sector benchmarks.