Fazley Rabbi"I know roughly how we are doing"
Ask many owners how last month went and the answer is "fairly good" or "slow, I think". Sales are in one notebook, expenses in another, stock in the manager's head, and the bank and mobile payment balances somewhere else. Gut feeling has real value, and experienced owners are often right. But it is slow to notice problems: a product that has quietly stopped making money, a branch whose costs keep creeping up, a group of customers who have stopped buying. By the time you feel it, it has already cost you.
A KPI dashboard is simply a short list of numbers, your key performance indicators, that tell you whether the business is healthy, reviewed on a fixed day. You do not need special software to start.
Choose a handful of numbers
Fewer is better. Pick around five to eight numbers that you would actually act on. Typical ones:
- Sales: the total, and by main product or branch.
- Gross margin: what is left after the cost of goods. Sales can grow while profit falls.
- Cash position: money in hand, in the bank and in mobile accounts, against bills due soon.
- Receivables: how much customers and dealers owe you, and how old those dues are.
- Stock: the value on hand, and items that have not moved for a long time.
- New versus returning customers.
- Enquiries and conversion: how many enquiries came in and how many became orders.
- One operational number that matters in your type of business: delivery returns for an online seller, machine downtime for a factory, table turnover for a restaurant.
For each one, write down exactly how it is calculated and where the data comes from. If two people would calculate it differently, it is not ready yet.
Collect the data reliably
A dashboard is only as good as what goes into it. Start where the data already lives: POS or accounting software, the sales register, courier reports, bank statements. Agree who updates each number, by when, and in what format. A shared Google Sheet with one tab per data source and one summary tab is enough for most small businesses. Later, much of the collection can be automated, for example with a daily sales report that builds itself.
Review it, and decide something
Set a fixed weekly time: half an hour with the people responsible. Compare each number with last week, the same period last month and your target. Ask only three questions: what changed, why, and what will we do about it? Note the decisions and check on them the following week. A dashboard that nobody discusses is just decoration.
Mistakes to avoid
- Tracking everything because you can. Too many numbers hide the important ones.
- Watching sales only, and not margin and cash.
- Building an expensive dashboard before the underlying records are clean.
- Using the numbers to blame staff. People then start adjusting the numbers instead of the work.
You can build the first version yourself in a spreadsheet. An outside view helps with choosing the right indicators for your type of business, setting realistic targets and connecting data sources so the dashboard updates itself. That is part of my business development work.
The first page you can make this week
Take a blank sheet and write down five numbers you wish you knew at the start of every week. Next to each, write where it would come from and who could fill it in. Fill it in by hand for a month before you invest in anything bigger. If you want help setting it up properly, get in touch.