A good small business dashboard fits on one page, shows five to eight numbers the owner genuinely looks at every week, compares each one with something (a target, last month, the same week last year), and updates itself from the systems the business already uses. That's it. The examples below are what those five to eight numbers tend to be for eight common kinds of UK business, and the reason they're worth listing is that the numbers differ far more between business types than dashboard templates would have you believe.
The best dashboards I've seen in small businesses are almost boring. They're the same page every Monday, the owner reads it in three minutes, and one number occasionally makes them pick up the phone. That's the whole ambition.
What should a small business dashboard show?
Before the examples, the shape they share. Every one of these has:
- A money number. Sales, revenue, takings, billings. Weekly, with last year's same week alongside.
- A margin or cost number. Because sales going up while margin goes down is the most common way a growing business gets into trouble.
- A cash number. Bank balance and, ideally, what's owed to you and by whom.
- A demand number. Enquiries, quotes, bookings, pipeline. The thing that becomes next month's sales.
- An engine number. The one operational figure that describes whether the business is working: utilisation, stock days, jobs completed, table turns.
- One number the owner worries about. Every business has one. Overdue debt, staff hours, a big customer's share of sales. Put it on the page so it stops being a worry and becomes a fact.
Six is a good count. Eight is the ceiling. Past that the page becomes a report, and reports get read monthly rather than weekly.
Dashboard examples by business type
| Business | The numbers on the page | The one that matters most |
|---|---|---|
| Trades and contractors (electrical, plumbing, building) | Quoted vs won this month, jobs booked ahead (weeks), revenue this week vs last year, gross margin by job type, overdue invoices, van/engineer utilisation | Weeks of work booked ahead |
| Professional services (accountants, consultants, agencies) | Billable utilisation by person, work in progress not yet billed, billings vs target, debtor days, pipeline value by stage, revenue per client top 10 | Utilisation, because it's both the sales and the cost number |
| Retail (shop or online) | Sales by day vs last year, gross margin, stock value and stock days, sell-through of new lines, conversion (visitors to sales), returns rate | Stock days: too high is cash tied up, too low is lost sales |
| Hospitality (café, restaurant, pub) | Covers and spend per head by day, wet vs dry split, gross profit on food and drink, staff cost as a percentage of sales, bookings ahead, review score | Staff cost percentage, weekly, because it moves fast |
| Wholesale and distribution | Order intake vs despatched, back orders, gross margin by customer and product group, stock turn, on-time-in-full delivery, top 10 customers' share of sales | Back orders and OTIF together: are we able to sell what we're selling? |
| Manufacturing (small batch) | Order book in weeks, output vs plan, scrap or rework rate, material cost vs standard, on-time delivery, machine or cell utilisation | Order book in weeks, because it's the early warning for everything else |
| Recruitment | Placements and fees this month vs target, live roles, candidates in process by stage, time to fill, temp hours billed, consultant revenue vs target | Fees vs target by consultant, weekly |
| Membership and subscription (gyms, clubs, software) | Active members, joiners and leavers this month, churn rate, monthly recurring revenue, average revenue per member, visits or usage per member | Churn, because a joiner costs money and a leaver was free to keep |
A few things worth noticing across the table.
The money number is never alone. Every example pairs revenue with a margin or cost figure, because the failure mode of a busy small business is being busy at the wrong price.
The demand number is always forward-looking. Quotes, bookings ahead, pipeline, live roles. A dashboard that only shows what has happened tells you the score after the match; the demand number is the one that lets you change the result.
The "matters most" column is usually operational rather than financial. Weeks booked ahead, utilisation, stock days, churn. These are the numbers that predict next quarter's P&L, which is why the owner should see them weekly rather than waiting for the accounts.
Where does the data for a small business dashboard come from?
Usually three or four places, and this is where small businesses stall: the sales are in the accounting system or the till, the pipeline is in a CRM or a spreadsheet, the bookings are in a scheduling tool, and the stock is in a different system again. The dashboard needs all of them, so the usual first attempt is a spreadsheet someone updates by hand on Monday morning, which works for about six weeks.
The version that lasts connects to the systems directly. Xero, Sage, QuickBooks and Business Central all have routes into Power BI. Most CRMs, booking tools and e-commerce platforms do too, and the ones that don't can usually export on a schedule. The model joins them on the things they share (customer, product, date) and the dashboard reads from the model. Refresh runs overnight. Monday's page is Monday's page without anyone building it.
What that costs depends on how many systems and how tidy they are. Microsoft's published UK price for Power BI Pro is £10.80 per user per month as of September 2026, paid yearly, and a small business often needs one or two licences. The build is the larger cost; the cost guide has the UK range. If you'd rather build it yourself and want a start, the Setup Hour is £195 for an hour on your own data, and my training runs from £100 unblocking sessions to full days.
How do you keep a small business dashboard useful?
Three habits, all cheap.
Read it at the same time every week. Monday morning, ten minutes, before the week starts. A dashboard that's read whenever someone remembers is a dashboard that gets forgotten.
Compare, don't just display. Every number next to a target, last month, or the same week last year. "Sales £14,200" is a fact. "Sales £14,200, last year £12,900" is a story. The comparison is what turns a glance into a decision.
Change it slowly. When a number stops being interesting, replace it. When a new worry appears, add it. But not every week: a dashboard that changes constantly can't be read at a glance because there's nothing familiar to glance at. Review the page every quarter and leave it alone in between.
And one habit that costs something: check the data before you trust the dashboard. A beautiful page on messy data produces confident wrong numbers, which are worse than no numbers. I give away a free Data Quality dashboard that scores your data out of 100 and ranks the problems, and it's worth running before building anything on top.
Common questions
What is a small business dashboard?
A small business dashboard is a single page that shows the handful of numbers an owner or manager needs to see regularly (usually weekly) to know whether the business is on track: sales, margin, cash, demand, and one or two operational figures, each compared with a target or a prior period. It's built from the systems the business already uses so it updates without manual work.
How many KPIs should a small business dashboard have?
Five to eight. Fewer than five usually misses either the cash or the demand picture; more than eight turns the page into a report that gets read monthly instead of weekly. The list should be stable for months at a time and reviewed quarterly.
What are the most important KPIs for a small business?
Revenue against the same period last year, gross margin, cash in the bank with overdue debtors, a forward-looking demand number (quotes, bookings, pipeline), and one operational number specific to the business (utilisation, stock days, order book, churn). The operational number is usually the best early warning, because it predicts the financial ones.
Can I build a small business dashboard in Excel?
Yes, and for a single-source business (everything in the till or the accounting system) it can be enough. The limit is combining sources: once sales, pipeline and bookings live in different systems, the Excel version needs weekly manual updates and tends to fall behind. A tool that connects to the sources directly, such as Power BI, removes that weekly job.
How much does a small business dashboard cost?
Power BI Pro licensing is £10.80 per user per month at Microsoft's published UK price as of September 2026, and a small business often needs only one or two licences. The build cost depends on how many systems feed it: a one-source dashboard is a small job, a three-source one is larger. The cost guide sets out the UK range, and the Setup Hour at £195 is a low-cost way to start on your own data.
Which software is best for a small business dashboard?
For a business already using Microsoft 365, Power BI is the natural fit: it connects to the common UK accounting systems, most CRMs and booking tools, and its licensing is per user at a modest monthly price. Other tools exist and some are free for basic use; what matters more than the tool is connecting to the real systems rather than maintaining a spreadsheet by hand.
How often should a small business dashboard update?
Daily overnight is the practical standard: the numbers are current each morning without anyone doing anything. Weekly reading is the useful rhythm for the owner, even when the data updates daily. Real-time updates are rarely worth the cost for a small business, because the decisions being made from the dashboard are weekly decisions.