0 / 24 done on this device
Stage 6 · Lesson 4 of 4 · TEMPLATE · 6 min

Your finance KPI dashboard

Six numbers to watch

By the wpdailylive editorial team · Part of Accounting and bookkeeping, the complete guide

Key takeaways

  1. Few numbers: Track five or six KPIs, not fifty.
  2. The essentials: Revenue, gross margin, net profit, cash runway, debtor days and overdue invoices.
  3. Healthy targets: Aim for 3–6 months of costs in cash and under 45 days to get paid.
  4. Set targets: A KPI without a target can’t tell you anything.
  5. 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.

COMMON BENCHMARKS
3–6 moof costs held as cash reserve
< 45 daysaverage time to get paid (DSO)
> 1.5current ratio (current assets ÷ current liabilities)
Source: General small-business finance guidance; targets vary by industry
KPIWHAT IT SHOWSHOW TO CALCULATE
RevenueGrowthTotal sales for the month
Gross marginPricing and delivery costs(Revenue − cost of sales) ÷ revenue
Net profitOverall profitabilityRevenue − all expenses
Cash runwayHow long cash lastsCash ÷ average monthly net burn
Debtor daysHow fast you get paidReceivables ÷ revenue × 30
Overdue invoicesCollection problemsTotal overdue at month end

Formulas and a worked example

KPIFORMULAEXAMPLE
Gross margin(Revenue − direct costs) ÷ revenue(£20,000 − £8,000) ÷ £20,000 = 60%
Net profit marginNet profit ÷ revenue£3,000 ÷ £20,000 = 15%
Cash runwayCash ÷ 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 ratioCurrent assets ÷ current liabilities£45,000 ÷ £25,000 = 1.8

Build it in your accounting software

  1. 01Use the built-in dashboardMost apps show cash, receivables and profit.
  2. 02Add a monthly spreadsheetPaste five numbers from your reports each month.
  3. 03Chart 12 monthsA simple line chart per KPI.
  4. 04Review on the same day monthlyWrite one action for any KPI moving the wrong way.

Financial KPIs for small business

KPIFORMULAWATCH FOR
Revenue growth(This period − last period) ÷ last periodTrend over 3–6 months
Gross marginGross profit ÷ revenueFalling margin
Net profit marginNet profit ÷ revenueBelow your target
Cash runwayCash ÷ average monthly net outflowUnder 3 months
Debtor daysReceivables ÷ revenue × days in periodRising
Current ratioCurrent assets ÷ current liabilitiesBelow 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

✕ Too many metricsPick six.
✕ KPIs from unreconciled booksReconcile first.
✕ One-month conclusionsLook at trends.
PEOPLE ALSO ASK
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

Reviews of tools in this lesson