A business dashboard is a single view of the numbers you check most often — sales, costs, cash waiting to arrive, stock on hand, or orders in progress. It does not need charts on every tab; clarity beats decoration.
This guide explains practical KPIs for small businesses and how to build a dashboard in plain English without treating it as accounting advice or a promise of results.
What a dashboard is — and is not
It is a summary layer fed by reliable underlying trackers. It is not a substitute for bank reconciliation, tax returns, or professional accounts. Think of it as the page you open before a weekly review, not the only record you keep.
KPIs many small businesses find useful
| KPI | Plain-English meaning | Typical source tab |
|---|---|---|
| Sales (month to date) | Revenue recorded this month | Sales tracker |
| Income vs expenses | Money in compared to money out | Income/expense tracker |
| Estimated profit | Income minus expenses for the period — a planning figure | Combined tracker |
| Outstanding payments | Unpaid invoice balances | Invoice tracker |
| Stock value | Estimated value of on-hand inventory | Inventory sheet |
| Open orders | Orders not yet fulfilled or paid | Sales or fulfilment log |
| Monthly trend | This month vs previous month on key lines | Summary formulas |
Building the dashboard layer
Use references or summary formulas pointing to detail tabs — avoid retyping numbers. When detail tabs update, the dashboard should refresh automatically.
Keep one screenful of KPIs. If everything is important, nothing stands out. Rotate secondary metrics monthly if you outgrow the space.
Design tips for non-accountants
- Label periods clearly (month, quarter, year to date)
- Use the same currency format throughout (GBP for UK businesses)
- Separate cash received from invoiced-but-unpaid amounts
- Add a “last updated” cell you change after each review
- Include a short note on what action each KPI triggers
Review rhythm
A dashboard helps only when you look at it. Schedule a monthly review: compare trends, note outliers, and assign one follow-up task — chase an invoice, adjust reorder, or pause a costly subscription.
Do not infer guaranteed growth from upward lines. Markets shift; the dashboard informs questions, not certainty.
When to graduate beyond a spreadsheet dashboard
Consider dedicated BI or accounting dashboards when data comes from many automated sources, multiple users need role-based views, or history spans years with complex dimensions.
Until then, a well-fed spreadsheet summary is often enough.
Example: a Leeds café reading the week in six numbers
A small café owner does not need a wall of charts — they need to know whether this week covers rent. Their dashboard tab shows six cells: sales month-to-date, average daily takings this week versus last week, food and drink COGS estimate from the expense tracker, outstanding supplier invoices, hours scheduled versus hours actually worked, and float plus till cash expected before the next bank deposit.
Each figure links to a detail tab — never retyped. Monday morning they spend five minutes scanning for red flags: sales down fifteen percent with unchanged hours might mean a local road closure; COGS creeping up might mean the wholesale coffee price rise finally hit every row in expenses.
They do not confuse dashboard profit with tax profit. The “Estimated margin” row is explicitly labelled planning only. Their accountant produces statutory numbers quarterly; the dashboard drives weekly operational choices — staff rota, weekend specials, whether to accept a catering enquiry.
Example red, amber and green thresholds
| KPI | Green (healthy) | Amber (watch) | Red (act this week) |
|---|---|---|---|
| Outstanding invoices | Under 5% of monthly sales | 5–15% of monthly sales | Over 15% or any invoice 30+ days overdue |
| Stock value vs monthly sales | Roughly 4–8 weeks of COGS | Above 10 weeks — cash tied up | Below 1 week on A-class SKUs — stock-out risk |
| Monthly expenses vs budget | Within 5% of plan | 5–15% over plan | More than 15% over without known cause |
| Pending sales (unpaid orders) | Normal settlement window | Older than usual platform delay | Any large B2B order unpaid past terms |
| Dashboard last updated | Within 7 days | 8–14 days | Over 14 days — data may mislead |
Feeding the dashboard reliably
Broken dashboards usually trace to broken inputs — duplicate expense rows, sales logged net in one month and gross the next, or inventory values left stale after a stocktake. Assign one person as owner of the “last updated” cell and treat empty detail tabs as a blocker: hide KPIs that would lie rather than showing last month’s numbers without a warning.
Use simple cell references rather than hard-coded numbers. =SUM(Sales!E:E) for month-to-date with a date filter row beats copying totals from memory. If you use Google Sheets, IMPORTRANGE between workbooks adds failure points — many micro-businesses keep one workbook with tabs instead.
Conditional formatting helps — amber when outstanding invoices exceed a threshold you set — but label the thresholds on the Settings tab so a future you remembers why £3,000 triggers red.
Dashboard layouts that stay readable on a phone
Owners often check numbers on a phone between jobs. Put the five most important KPIs in the top-left block — large labels, no merged cells that break mobile layout. Avoid ten-column wide tables; stack metrics vertically if you screenshot the dashboard to share with a partner on WhatsApp.
Print or PDF a one-page monthly snapshot for advisers who prefer paper in review meetings. The act of exporting also forces you to notice stale cells — if “last updated” is six weeks ago, the PDF habit catches neglect before a decision goes wrong.
Monthly dashboard review meeting (solo or team)
- Confirm each KPI refreshed from detail tabs since last review
- Compare month-to-date to same point last month and note why gaps exist
- Pick one amber metric and assign a single corrective action with a date
- Verify outstanding payments list matches invoice tracker open balances
- Check inventory value moved sensibly after any large delivery or clearance
- Archive a PDF or static copy of the dashboard if you track history visually
- Update next month’s budget or target row on the Settings tab if plans changed