Your finance KPI dashboard
Six numbers to watch
By the wpdailylive editorial team · Part of Accounting and bookkeeping, the complete guide
Key takeaways
- Few numbers: Track five or six KPIs, not fifty.
- The essentials: Revenue, gross margin, net profit, cash runway, debtor days and overdue invoices.
- Healthy targets: Aim for 3–6 months of costs in cash and under 45 days to get paid.
- Set targets: A KPI without a target can’t tell you anything.
- Watch the trend: Plot 12 months and look at the direction, not one month.
Six numbers, checked monthly, tell you almost everything about the financial health of a small business.
| KPI | WHAT IT SHOWS | HOW TO CALCULATE |
|---|---|---|
| Revenue | Growth | Total sales for the month |
| Gross margin | Pricing and delivery costs | (Revenue − cost of sales) ÷ revenue |
| Net profit | Overall profitability | Revenue − all expenses |
| Cash runway | How long cash lasts | Cash ÷ average monthly net burn |
| Debtor days | How fast you get paid | Receivables ÷ revenue × 30 |
| Overdue invoices | Collection problems | Total overdue at month end |
Formulas and a worked example
| KPI | FORMULA | EXAMPLE |
|---|---|---|
| Gross margin | (Revenue − direct costs) ÷ revenue | (£20,000 − £8,000) ÷ £20,000 = 60% |
| Net profit margin | Net profit ÷ revenue | £3,000 ÷ £20,000 = 15% |
| Cash runway | Cash ÷ average monthly costs | £30,000 ÷ £10,000 = 3 months |
| Debtor days (DSO) | Receivables ÷ revenue × days in period | £12,000 ÷ £20,000 × 30 = 18 days |
| Current ratio | Current assets ÷ current liabilities | £45,000 ÷ £25,000 = 1.8 |
Build it in your accounting software
- 01Use the built-in dashboardMost apps show cash, receivables and profit.
- 02Add a monthly spreadsheetPaste five numbers from your reports each month.
- 03Chart 12 monthsA simple line chart per KPI.
- 04Review on the same day monthlyWrite one action for any KPI moving the wrong way.
Financial KPIs for small business
| KPI | FORMULA | WATCH FOR |
|---|---|---|
| Revenue growth | (This period − last period) ÷ last period | Trend over 3–6 months |
| Gross margin | Gross profit ÷ revenue | Falling margin |
| Net profit margin | Net profit ÷ revenue | Below your target |
| Cash runway | Cash ÷ average monthly net outflow | Under 3 months |
| Debtor days | Receivables ÷ revenue × days in period | Rising |
| Current ratio | Current assets ÷ current liabilities | Below 1 |
Worked example
Revenue $40,000, gross profit $24,000, net profit $6,000, receivables $18,000 for a 30-day month: gross margin 60%, net margin 15%, debtor days 18,000 ÷ 40,000 × 30 = 13.5 days.
Review rhythm
- •Weekly: cash balance and forecast
- •Monthly: all six KPIs after reconciling
- •Quarterly: trends and targets with your accountant
Common mistakes to avoid
What financial KPIs should a small business track?
Revenue growth, gross margin, net profit margin, cash runway, debtor days and current ratio.
How do I calculate gross margin?
Gross profit divided by revenue, as a percentage.
What is cash runway?
How many months your cash lasts at the current average net outflow.
What are debtor days?
How long customers take to pay on average: receivables ÷ revenue × days in the period.
How often should I review financial KPIs?
Monthly, with cash checked weekly.
Tools we recommend for this stage
Some links are partner links: we may earn a commission at no cost to you. It never changes what we recommend. How we make money















