The problem is not a shortage of numbers
A small business produces far more data than people think: the till, the bank account, the invoicing software, the booking platform, sometimes a spreadsheet kept by hand. So the problem is never the absence of numbers, it is how scattered they are. Nobody has time to open five tools on a Friday evening to piece together an overall view, and a dashboard that needs half an hour of preparation is never consulted for more than three weeks. A useful dashboard fits on one page, reads in two minutes, and holds five numbers. Not fifteen.
The opposite reflex is just as common: asking for a complete dashboard, with curves by product, by channel and by salesperson. It gets built, it looks good, and it stops being opened after a month. An indicator is only worth having if it triggers a decision. If you cannot say what you would do differently depending on whether it goes up or down, it has no business being on the page.
Number 1: revenue compared with the same period last year
Revenue on its own means nothing. Compared with last month, it mostly teaches you that February has fewer days than January. Compared with the same week or the same month a year earlier, it becomes readable: seasonality is cancelled out, and the gap that remains is yours. It is the only indicator that answers the question you are actually asking, which is whether the business is growing or not.
Number 2: cash received, not cash invoiced
Invoicing is not collecting. A business can post an excellent sales month and still be unable to pay its suppliers, simply because the money has not arrived yet. So track what has genuinely landed in the account, and look at the gap with what was invoiced over the same period. That gap is your real measure of cash tension, and it widens well before the problem becomes visible.
Number 3: what is overdue
Two figures are enough: the total owed past its due date, and the age of the oldest unpaid invoice. If that age passes two months, you do not have a cash flow problem, you have a chasing problem. The difference matters, because the fix is different: not waiting, but following up systematically, at the same rhythm, without having to think about it.
Number 4: what is sold but not yet delivered
Accepted quotes not yet invoiced, orders waiting to be delivered, appointments already booked for the coming weeks: call it what you like, it is your order book. It is the only one of the five numbers that looks forward. The other four tell you what has happened; this one announces what is about to happen, and it falls several weeks before revenue falls. It is your earliest warning.
Number 5: average sale, or average job value
This number moves slowly, which is why it gets forgotten. It still deserves a place, because it is the cheapest lever you have: raising it does not require one more customer, just an option offered, a product better displayed, an extra service mentioned at the right moment. Divide the month's revenue by the number of tickets or jobs, and follow the line over twelve months rather than from one month to the next.
How often to look at what
Once a week, always on the same day, you look at the first three: revenue, cash received, overdue. Once a month, you add the order book and the average sale. Never daily: day to day variation is noise, and watching it will have you making decisions about the weather. The fixed appointment matters as much as the numbers themselves, because a dashboard consulted at random only ever confirms what you already thought.
What actually makes the exercise fail
Almost nobody abandons their dashboard because they picked the wrong indicators. They abandon it because filling it in takes time. Export the till, open the bank, reopen the invoicing software, copy across, recalculate: half an hour that gets skipped in the first busy week, and then for good. The answer is not more discipline, it is not having to do it at all.
The dashboard that fills itself in
That is exactly what automated reporting sets up: the numbers are collected inside the tools you already use, consolidated, and they arrive every Monday morning by email or on a page you open in ten seconds. You fill in nothing, you read. And if your invoicing is still keyed in by hand, start there: automating invoicing feeds the dashboard along the way, since the same data serves both.