The 8 KPIs Every Small Business Dashboard Should Track

A KPI dashboard for small business owners should answer four questions on one screen: are we selling, are we pricing right, are we collecting, and how long can we run on the cash we have? Most owners already have the data to answer them. It is just scattered across the accounting system, a CRM and a few spreadsheets.

Below are the eight small business KPIs we put on almost every dashboard we build, with the formula for each, a worked example, a three-tab spreadsheet layout and a weekly review routine.

The 8 Small Business KPIs and Their Formulas

KPI	Formula	What it tells you
1. Revenue	Total invoiced sales for the period	Whether volume is growing
2. Gross margin %	(Revenue − Cost of goods sold) ÷ Revenue × 100	Whether pricing covers direct costs
3. Net profit margin %	Net profit ÷ Revenue × 100	What is left after every expense
4. Cash runway (months)	Cash on hand ÷ Average monthly operating expenses	How long you could cover costs with no new cash in
5. Accounts receivable days	Accounts receivable ÷ Revenue for the period × Days in the period	How long customers take to pay
6. Lead-to-close rate	Jobs won ÷ Qualified leads × 100	How well you convert interest into work
7. Average job or order value	Revenue ÷ Number of jobs or orders	Whether you are winning the right size of work
8. Inventory turns or utilization	Turns: COGS ÷ Average inventory. Utilization: Billable hours ÷ Available hours × 100	How hard your stock or your crew is working

What Each KPI Means and When to Worry

Revenue. Track it by month and compare to the same month last year, since many businesses are seasonal. Split it by service line if you have more than one, because a total can hide a shrinking core business.

Gross margin. Gross margin is the clearest test of pricing. Cost of goods sold should include direct materials and direct labor for the work you delivered. If gross margin slides while revenue grows, you are buying growth with discounts or underestimated jobs.

Net profit margin. This captures overhead: rent, admin salaries, software, insurance. A healthy gross margin with a thin net margin points to overhead that has grown faster than sales.

Cash runway. Profit and cash are different things. A business can be profitable on paper and still run short because customers pay late or inventory ties up cash. Runway turns your bank balance into a number of months that is easy to act on.

Accounts receivable days. Often called days sales outstanding. If your terms are net 30 and this number keeps climbing past 30, collections need attention before cash does.

Lead-to-close rate. If you spend on ads, you could track customer acquisition cost (marketing spend ÷ new customers) instead or alongside it. For most service businesses, lead-to-close rate is easier to measure and more useful week to week. Define “qualified lead” once and keep it consistent.

Average job or order value. Watch this alongside lead-to-close. A rising close rate paired with a falling job value can mean you are winning more of the small, low-margin work.

Inventory turns or utilization. Pick the one that fits your model. Product businesses track inventory turns to spot slow stock. Service businesses track labor utilization to see whether crews are billing their available hours or waiting between jobs.

A Worked Example

Here is an illustrative month for a small service company. These numbers are an example only.

• Revenue: $80,000. Cost of goods sold: $52,000. Gross margin: ($80,000 − $52,000) ÷ $80,000 = 35%.
• Net profit: $6,400. Net profit margin: $6,400 ÷ $80,000 = 8%.
• Cash on hand: $60,000. Average monthly operating expenses: $25,000. Cash runway: 2.4 months.
• Accounts receivable: $40,000. AR days: $40,000 ÷ $80,000 × 30 = 15 days.
• Qualified leads: 40. Jobs won: 10. Lead-to-close rate: 25%. Average job value: $80,000 ÷ 10 = $8,000.

Seen together, this business prices reasonably and collects quickly, but its runway is short. That points the owner toward building a cash reserve before adding overhead.

No single KPI tells the whole story. Gross margin without cash runway can hide a cash crunch, and revenue without lead-to-close rate can hide a sales process that only works because of one big referral source. Read the eight as a set, and look at the trend over several months before acting on one month that looks unusual.

How to Build a KPI Dashboard for Small Business in Google Sheets or Excel

A KPI dashboard in Google Sheets or Excel works best with three tabs. Keeping them separate is what makes every number traceable to its source.

Tab 1: Raw Data

Paste or import exports here exactly as they come out of your systems: invoices, expenses, leads, jobs, bank balance. One row per transaction, one column per field, with a date on every row. Never type calculations or notes into this tab. Add a cell recording the date and source of each export.

Tab 2: Calculations

This tab turns raw rows into monthly totals using formulas such as SUMIFS and COUNTIFS, keyed to a month column. For example, monthly revenue can be =SUMIFS(Raw!D:D, Raw!A:A, ">="&B1, Raw!A:A, "<"&EDATE(B1,1)), where B1 holds the first day of the month. Wrap ratios in IFERROR so an empty month shows zero instead of an error. Lock this tab once it is tested.

Tab 3: Dashboard

The dashboard tab only references the calculations tab. Show each KPI for the current month, the prior month and the same month last year, with a simple trend chart for revenue, gross margin and cash. Add a target column and conditional formatting so anything off target turns a single warning color. If you would rather start from an Excel dashboard template, use this same three-tab structure to judge whether the template keeps data and calculations apart.

A Weekly KPI Review Routine

A dashboard only helps if someone looks at it on a schedule. We suggest a 20-minute review at the same time each week:

1. Refresh the data. Drop in new exports or confirm the automated import ran.
2. Check the weekly numbers. Leads, jobs won, revenue booked and cash balance.
3. Flag anything off target. Write one sentence on why for each red cell.
4. Assign one action. One owner, one due date. Example: call the three oldest open invoices by Friday.
5. Review monthly KPIs after close. Margin, net profit and AR days are only reliable once the month’s books are complete. Our month-end close checklist covers how to get there.

How We Help

Our team cleans up existing spreadsheets and builds KPI dashboards, weekly reports and margin views where every number traces back to its source. Visit our reporting and data services page to see how we work.

Frequently Asked Questions