Small business KPI dashboard template

What a KPI dashboard is for

A KPI dashboard is a single view of the handful of measures that tell you whether your business is healthy and heading where you want it to go. The discipline is choosing few metrics, not many. A director who tracks twelve numbers every Monday makes faster, better decisions than one who downloads forty reports nobody reads.

Good KPIs share three traits: they are measurable from data you already hold, they are leading or near-real-time rather than a year out of date, and someone owns each one. If a number cannot trigger an action, it is reporting, not a KPI. Build the dashboard once, then keep the structure stable so trends are comparable month to month.

The core KPIs to include

Start with these and adapt to your model. Most UK SMEs can populate all of them from their accounting software and bank feed.

KPI	What it tells you	Source
Revenue (period & YTD)	Top-line momentum	Sales ledger
Gross margin %	Pricing & cost control	P&L
Cash in bank	Survival runway	Bank feed
Cash runway (months)	How long cash lasts	Cash ÷ monthly burn
Debtor days (DSO)	Speed of collection	Sales ledger
Creditor days (DPO)	Supplier payment pace	Purchase ledger
Order book / pipeline	Forward revenue	CRM / quotes
New vs returning customers	Growth quality	Sales data

Service businesses should add utilisation; product businesses should add stock turn and units sold.

How to lay out the spreadsheet

Use one tab as the dashboard and supporting tabs for the raw data. Down the left, list each KPI. Across the top, run the last six to twelve periods so trend is visible at a glance. Add three columns on the right:

• This period — the latest actual figure.
• Target — the number you committed to.
• RAG — a red/amber/green flag using conditional formatting against target.

Keep formatting plain: no decoration, consistent units, and a clear date stamp showing when it was last updated. A dashboard that takes ten minutes to refresh gets refreshed; one that takes two hours does not. Where possible, link cells to your raw-data tabs so the page recalculates itself.

Setting targets and a review rhythm

A KPI without a target is just a fact. Set a target for each line — ideally tied to your annual budget — and colour the cell against it. Targets should be realistic but stretching; revisit them quarterly, not weekly.

Then fix the rhythm. Pick one day, refresh the dashboard, and spend fifteen minutes reading it before the working week starts. Look first at anything red, then at any green that is trending the wrong way. The point is the conversation the dashboard prompts, not the document itself. Over a quarter you will see which two or three KPIs genuinely predict your results — those become your headline numbers.

Using the dashboard in funding conversations

A maintained KPI dashboard is also one of the strongest signals you can show a lender. It demonstrates that you understand your own numbers and run the business on data rather than instinct. When you apply for working capital, being able to show margin, debtor days and cash runway at a glance speeds up the conversation considerably.

If a short-term gap appears between billing and collection, your debtor-days and cash-runway lines will flag it early — often weeks before it becomes urgent. That is the moment to look at options such as a flexible credit facility rather than waiting until cash is already tight. See our loan readiness checklist to prepare the rest.