Why a few numbers beat a full spreadsheet

Most small business owners I work with are not short of information. They have a bank feed, an accounting package, a card machine that emails a daily total, and a shoebox of receipts they mean to deal with. What they often lack is clarity. When everything is available, nothing stands out, and decisions get made on gut feel and whatever was worrying them at 11pm.

The fix is not more reporting. It is fewer, better-chosen measures, looked at on a regular rhythm, and actually used to change something. A handful of numbers you understand deeply will always beat a dashboard you avoid opening.

Begin with the goal, not the metric

Numbers are only useful in relation to something. Before choosing what to track, write down two or three things you want to be true of the business twelve months from now. Be concrete. "Grow profit" is a wish; "add £40,000 of gross profit without buying a second van" is a target you can measure against.

Once the goals are on paper, the measures tend to choose themselves. A business trying to reduce its reliance on one large customer will track something quite different from one trying to make its existing customers buy more often. Ask yourself: if this number moved by 10 per cent, would it tell me whether I am closer to my goal? If the answer is no, leave it out.

The three families of numbers that matter most

Almost every small business can be understood through sales, costs and customer retention. Within those three, pick one or two specifics rather than tracking everything.

• Sales: total revenue is a start, but it hides more than it reveals. Track the number of new customers or jobs won, the average value of each sale, and your conversion rate from enquiry to order. If your enquiry volume is steady but conversion has slipped, that is a very different problem from a quiet month of enquiries, and the two need different responses.
• Costs: watch your gross margin percentage, not just your total spend. A month where costs rise because you sold more is a good month. Also keep an eye on two or three costs that creep — subcontractor hours, software subscriptions, vehicle running costs. Creeping costs are rarely dramatic; they simply never come back down.
• Customer retention: the percentage of customers who buy again within a set period, your repeat purchase rate, and how many customers you lose. A business that keeps 80 per cent of its customers can grow on a modest flow of new enquiries. One that keeps 50 per cent is running up a down escalator.

Two other measures deserve an honourable mention for many small firms: how long it takes to get paid, and how much cash you have available. Profitable businesses get into trouble because of cash timing, so if you track nothing else beyond the profit and loss account, track those two.

Build a monthly review you will actually keep

Monthly is the right rhythm for most small businesses. Weekly is too noisy, and a quiet week can send you chasing shadows. Quarterly is too slow to catch a problem while it is still small. Pick a fixed date and time, put it in the diary as a proper appointment, and protect it.

Lay the numbers out on a single page, with the last twelve months in columns so you can see direction of travel rather than a single figure. Then work through three questions:

• What has changed since last month? Look for movement, not just levels.
• Why has it changed? A price rise, a lost contract, a new marketing push, a seasonal dip. Write the reason down while you still remember it.
• What will we do about it? One or two actions, each with a name and a date against it. If nothing needs doing, say so and move on.

That last question is what separates a review from a ritual. If your monthly meeting never changes a decision, the numbers are decoration.

When the figures make uncomfortable reading

They will, sooner or later. The instinct is to stop looking, or to explain the number away. Resist both. A falling margin or a rising churn rate is information arriving early, and early is when it is cheapest to act on.

Try to establish whether the movement is a blip or a trend. One poor month is usually weather; three in a row is a pattern. Compare against the same month last year as well as last month, because many businesses are seasonal and a February dip may be entirely normal.

It also helps to share the numbers with the people who can influence them. If the team knows that repeat custom is the priority this quarter, they will make different choices at the counter, on the phone, and in how they follow up afterwards. Numbers kept secret in the owner's head cannot guide anyone.

Keep it small enough to survive a busy month

The best measurement system is the one still running in six months' time. Start with three numbers — one for sales, one for costs, one for retention — and add a fourth only when the first three feel routine. Review them on the same day each month, write a short note about what you have learned, and commit to one action.

Over a year, that is twelve small course corrections. In my experience, that is how most healthy small businesses get healthier: not through a grand plan, but through paying attention to a few things that matter, consistently, and being willing to change when the numbers say so. Choose your measures carefully, keep them visible, and let them do the arguing for you.