10 KPIs an SME Owner Should See Without Asking for an Excel File

Why an owner ends up asking for a file

It's almost never a skills problem. It's a distance problem: sales live in one tool, stock in another, accounting with an outside bookkeeper, and nobody has time to make them talk to each other outside the monthly close. The owner, meanwhile, needs an answer on Tuesday, not at month-end.

The result is predictable: an email to the sales manager, another to the accountant, a few days' wait, a file that's already partly stale by the time it lands. It isn't a lack of discipline — it's the absence of one place where these ten pieces of information can be read directly.

The ten indicators worth keeping in view

1. Revenue

Total invoiced for the current period, compared with the prior one — not just an isolated figure, but a trend.

2. Gross margin

What's left after the cost of the goods or services sold. Rising revenue alongside falling margin is a warning sign the invoiced amount alone never shows.

3. Overall profitability

A broader view that sets revenue against the period's actual costs, beyond gross margin line by line.

4. Payments — due dates and cash collected

What's expected in the coming days, and what has actually been collected — two different figures, both needed to plan cash flow.

5. Deliveries — rate and lead times

The share of orders delivered within the promised timeframe. An operational indicator with a direct line to customer satisfaction, often invisible until it becomes a problem.

6. Stock — level and turnover

What's available to sell, and how fast it turns over. High stock that turns slowly ties up cash without that showing up anywhere else.

7. Purchasing — amount and volume

Commitments made to suppliers over the period, set against stock levels and expected sales.

8. Orders in progress

What has been sold but not yet delivered or invoiced — a view of committed work that hasn't yet flowed into revenue.

9. Balances — receivables and payables

What customers owe, and what the business owes its suppliers, at a given moment — the basis for any short-term cash decision.

10. Cash position and forecast

The most direct snapshot of the business's immediate financial health, and the fastest answer to "can we pay what's due this month."

Reading these indicators together, not in isolation

None of these ten figures says much on its own. Rising revenue alongside receivables growing at the same pace tells a different story than a rise paired with steady collections. High stock can be a deliberate call ahead of an expected sales peak, or a sign of poorly calibrated purchasing. The value of these indicators comes from reading them together, not from checking each one in isolation once a month.

How often these figures need to be current

The ideal frequency depends on the indicator, not on one blanket rule. Cash and payments deserve near-continuous visibility; overall profitability or stock turnover work well checked weekly. What matters isn't the exact frequency but the absence of a reconstruction lag: the figure should reflect actual activity, not the state of things at the last export.

A practical checklist

• Can you check these ten indicators without emailing anyone?
• Do the figures shown reflect today's activity, or the last manual export?
• Is the same indicator calculated the same way everywhere it appears?
• Can you cross-reference two indicators (say, margin and receivables) without rebuilding a spreadsheet?
• How much time currently passes between your question and the answer?

A good dashboard doesn't replace an owner's judgment. It simply removes the delay that keeps you from exercising it in time.