In this article
Imagine this – an invented business, not a real one.
It's Sunday night in Pinetown, outside Durban, and the owner of a family hardware store has three spreadsheets open, a curl of till slips on the desk and a cold cup of rooibos at her elbow. One file tracks stock, one tracks sales, one tracks what the builders on account still owe. None of them agree. By the time she has stitched together last month's picture, the middle of this month has already arrived.
She isn't short of data. She's short of a view.
The spreadsheet ceiling
Spreadsheets are brilliant: flexible, familiar and already on every laptop. But they were built for calculating, not for watching a business move. Paste one column a row too low and the mistake quietly travels into every total after it. Add a second person editing a copy sent over WhatsApp and you have two versions of the truth.
Many South African owners are already moving on. In Xero's 2024 small business report, 62% said they manage their finances with cloud accounting software, up from 39% the year before, while 19% still relied on spreadsheets or paper records.1 Among businesses using cloud tools in Xero's 2025 survey, 58% said the technology helps them manage finances or simplifies financial processes, and 40% said it lets them reduce admin or automate tasks.2
Chart
What cloud tools give owners
Share of small businesses that use cloud-based technology
| Measure | Share |
|---|---|
| It helps me better manage finances or simplifies financial processes | 58% |
| We can work from anywhere | 46% |
| It's improved my business operations | 42% |
| It allows us to reduce admin / automate certain tasks, saving us time | 40% |
That matters. If your invoices, bank feeds and sales already live in a system, the hard part, capturing the data, is largely done. What's missing is the layer that turns it into a picture.
Believing in it versus using it
Owners don't need convincing that digital tools matter. Sage's 2024 Small Business, Big Opportunity research found that 92% of South African SMBs see digital technologies as vital for boosting revenue. Yet only 26% turn to digital technology to get past business barriers, compared with 37% globally; the most common local response is to cut costs (43%).3
A dashboard is one of the gentlest ways to close that gap. It doesn't change how you sell, who you hire or which supplier you use. It simply puts the numbers you already have where you can see them: on a laptop at the counter, or on your phone in the queue at the bank.
Four steps to your first dashboard
You don't need a data team to start. You need an afternoon, your accounting login and a willingness to leave things out.
Choose five to seven numbers, not fifty
Start with the questions you ask every week. What did we sell? What's in the bank? Who owes us? Which lines are running low? Each question earns one tile. If a number wouldn't change a decision, it doesn't make the cut.
Illustrative exampleFor the Pinetown store: sales this week · cash in the bank · builders' accounts over 60 days · fast-moving lines below reorder level · margin by department.
Connect what you already have
Your accounting software (Xero, Sage, QuickBooks or a well-kept Excel workbook), bank feed, point-of-sale system and stock list are the raw material. Link them once, so the dashboard refreshes itself instead of waiting for Sunday-night copy-and-paste. Where a source can't connect, agree on one tidy spreadsheet that feeds it.
Show the trend, not just today
A single figure tells you where you are; a 12-week line tells you where you're heading. Put this month next to the same month last year so the December rush and the January lull don't fool you, and save red for things that genuinely need you.
Make it a Monday ritual
Open it at the same time every week, say Monday at 8am, before the phones start. Five minutes, three questions: what changed, why, and what are we doing about it? A dashboard nobody opens is just wallpaper.
If a number wouldn't change a decision, leave it off the screen.
What good looks like
A good small-business dashboard fits on one screen, phone included. Big numbers across the top, a few trend lines underneath, colour only where something needs attention. It should take less time to read than a WhatsApp voice note.
It should also be honest. Every tile needs a clear definition – does “sales” include VAT? are refunds netted off? – and a date showing when it last refreshed. Once your team trusts the numbers, the arguments move from “whose spreadsheet is right?” to “what do we do about it?”
Back in Pinetown, our imaginary owner now gets her view before the first bakkie pulls in: sales by department, the builders' accounts that have slipped past 60 days and the cement and paint lines about to run out. Same data as before. Very different Sunday nights.