By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 12, 2026
Most small businesses need only four to six KPIs. Pick them from your goals, and calculate them the same way every month. For nearly every business, the shortlist starts with cash flow, gross profit margin, net profit margin and one or two customer or sales measures. This guide gives you 12 KPIs with formulas, shows how to choose among them, and explains how to track them in a spreadsheet you already know.
TL;DR
- A KPI is a metric you have tied to a goal, a target and an owner. Not every number you can measure qualifies.
- Start with four to six KPIs. Add more only as the business grows.
- Cover four areas: cash, profitability, sales and customers, and operations.
- Check cash weekly or every two weeks, profit monthly and customer measures monthly or quarterly.
- Excel or Google Sheets is enough for tracking: one data tab, one KPI tab with targets, and a simple dashboard.
Table of Contents
- What a KPI is, and how it differs from a metric
- How many KPIs a small business should track
- Financial KPIs every small business should know
- Customer, sales and operations KPIs
- Which KPIs fit your type of business
- How to set up a KPI tracking spreadsheet
- How often to review KPIs and what to do when you miss
- Our perspective
- Get your KPIs built for you
- FAQ
- Sources
What a KPI is, and how it differs from a metric
A metric is any number you can measure, such as website visits or invoices sent. A KPI is a metric you have singled out because it tracks progress toward a specific goal. As one guide puts it, all KPIs are metrics, but not all metrics are KPIs.
The professional bodies agree on the shape. APQC describes a metric as the numeric value of a measure, while a KPI is a high-level measure tied to critical success factors and business goals. The IEEE Technology Navigator adds that a well-formed KPI is specific, tied to a target value, produced on a cadence that matches decisions, and owned by someone who can act.
That last part is where small teams slip. A number with no target and no owner is just a number. Before a metric goes on your dashboard, write down the target and name the person who will act when it moves.
It also helps to know the neighboring idea of risk indicators, which warn you about threats rather than measure performance. This explanation of how KPIs and risk indicators differ shows why the two sit side by side in a mature reporting pack.
How many KPIs a small business should track
Fewer than you think. One guide for U.S. small businesses recommends four to six KPIs for small businesses, six to eight for growing ones and eight to 12 for established ones. HubSpot suggests two to four KPIs per goal instead of dozens of metrics.
A simple way to land on your list:
- Write down one to three goals for the next 12 months. Examples: stop running short of cash, lift margin, grow repeat customers.
- Match each goal to a KPI that measures it directly. If the goal is margin, gross profit margin is the KPI. Website traffic is not.
- Mix leading and lagging indicators. Lagging indicators, like profit, confirm results but arrive late. Leading indicators, like pipeline or the cash forecast, give early warning but may not reliably predict the outcome. You want both.
- Fit the stage of the business. HubSpot notes that early-stage companies focus on validating the business model, while established ones look at costs of acquiring customers and customer lifetime value.
- Set a target and an owner for each. Use the SMART test: specific, measurable, achievable, relevant, time-bound.
Financial KPIs every small business should know
These are the numbers lenders, investors and your own bookkeeper will ask about first. All of them can be built from your profit and loss statement, balance sheet and bank activity.
1. Cash flow and the cash forecast
Cash flow is the movement of money in and out. In a spreadsheet, net cash flow is total inflows minus total outflows, and ending cash is opening cash plus net cash flow. A forecast shows what is going in and out, helps you spot shortfalls and confirm you can pay suppliers and staff, and should be updated as circumstances change.

A 13-week rolling view is the most practical horizon for most owners. See our walkthrough on building a 13-week cash flow forecast in Excel, or the longer view in rolling cash flow in Excel.
2. Cash runway
Runway is current cash divided by monthly burn, where burn is cash outflows minus cash inflows. If you hold $60,000 and burn $10,000 a month, you have six months. This matters most for startups and any business with lumpy revenue.
3. Gross profit margin
SCORE gives the formula as (net sales minus cost of goods) divided by net sales, times 100. If you sell $50,000 and your direct costs are $30,000, gross margin is 40%. It tells you whether your pricing and product costs leave enough room to pay for everything else.
4. Net profit margin
Net profit divided by revenue, times 100. Gross margin shows the product economics, and net margin shows what is left after rent, payroll, software and taxes. A business can have a healthy gross margin and a thin net margin if overhead has crept up.
5. Break-even point
Fixed costs divided by contribution margin per unit (price minus variable cost per unit). It tells you how many units or dollars of sales you need before you earn a profit, which makes it useful when you are setting prices or taking on a lease.
6. Days sales outstanding (DSO)
Accounts receivable divided by revenue, times the number of days in the period. If you invoice on terms of 30 days and your DSO is 55, customers are paying late and your cash forecast is too optimistic. This is the KPI that most often explains why a profitable service business feels broke.
7. Inventory turnover
SCORE gives it as sales divided by inventory. Low turnover means cash is sitting on shelves. It matters for retail and ecommerce.
Customer, sales and operations KPIs
8. Revenue growth
This month’s revenue minus last month’s, divided by last month’s. Compare against the same month last year too, so seasonality does not fool you.
9. Customer acquisition cost (CAC)
Total sales and marketing spend divided by new customers won in the same period. Track it by channel if you can.
10. Customer retention rate
Customers at the end of the period, minus new customers acquired, divided by customers at the start, times 100. Repeat customers cost less to serve than new ones, so this number often moves profit more than another ad campaign.
11. Customer lifetime value (CLV)
The average gross profit a customer generates over the relationship. Compare it with CAC. Many operators look for CLV to be a multiple of CAC, and the right ratio depends on your margins and payback period.
12. A capacity or efficiency measure
Pick the one that matches how you deliver: billable utilization for a service firm, order fulfillment rate for a retailer, or labor cost as a share of revenue for a shop with hourly staff. A restaurant owner, for example, will find a useful set in these restaurant analytics metrics that predict profit.
Which KPIs fit your type of business
The right shortlist depends on how you make money. A SaaS company and a retail store have very different KPI priorities. A starting point:
| Business type | Core KPIs | Why they fit |
|---|---|---|
| Service business | Cash forecast, DSO, gross margin, utilization, retention | Cash depends on how fast clients pay and how full your calendar is |
| Ecommerce | Gross margin, CAC, repeat purchase rate, average order value, inventory turnover | Margin is squeezed by ads, shipping and stock |
| Retail | Gross margin, inventory turnover, sales per day, labor cost % | Stock and staffing drive most of the cost |
| Startup | Cash runway, burn, revenue growth, CAC, CLV | Survival and proof of the model come first |
For online sellers, we cover this in depth in 12 ecommerce KPIs to track and how to calculate them. SaaS founders can start from a SaaS metrics dashboard template.
How to set up a KPI tracking spreadsheet
You do not need new software. A well-organized Excel or Google Sheets file does the job, and you keep full control of your data. Here is a structure that works.
- Data tab. Months across the columns and line items down the rows: revenue, cost of goods, payroll, rent, ad spend, receivables, inventory. Paste in or link your monthly numbers from your accounting export or bank records.
- Assumptions tab. Growth rates, payment timing and any figure that drives the forecast. Keeping these in one place means you change a number once.
- Opening and closing balances. Link each month’s opening cash to the prior month’s ending cash so the file never needs manual re-entry.
- KPI tab. One row per KPI with columns for name, type (leading or lagging), owner, cadence, target, actual, variance and status. A published KPI tracking template uses this same layout, with a green, yellow or red status and a notes column.
- Registry of definitions. Write down where each number comes from and exactly how it is calculated. When someone new takes over the file, this prevents arguments about what “margin” means.
- Dashboard. A single page with the six or so KPIs, a trend line for each and the status color. If you cannot read it in two minutes, it has too much on it.
To keep the file honest, use conditional formatting for status, lock formula cells and keep one version. If you want to start from working structures, our budgeting and cash flow templates and profit and loss Excel templates are built for exactly this.
How often to review KPIs and what to do when you miss
Match the review to how fast the number can change and how fast you can respond. Cash moves daily, so look at it weekly or every two weeks. Margins and revenue need a monthly close. Retention and CLV change slowly, so a quarterly look is enough. One U.S. small business KPI guide pairs operating cash flow with a weekly check and retention with a quarterly one.
When a KPI misses its target:
- Check the definition and the data first. A late invoice entry or a changed formula often explains the gap.
- Find the driver. Break the miss into price, volume, cost and timing. A margin drop might come from supplier prices, discounts or product mix.
- Look at the leading indicator. If net profit fell, the leading signals (pipeline, DSO, forecast) usually moved a month or two earlier.
- Assign one action and one date. The owner named on the KPI decides what changes, and you check it at the next review.
- Change the target only with a reason. Moving the goal to match the result teaches the team that targets are optional.
Our perspective
We work with owners who run their business in spreadsheets, and most of them do not have a data problem. They have a clarity problem. The numbers exist in five tabs, three exports and someone’s head.
Our view is that the best KPI system is the one you will open every week. For many small and midsize businesses, that is the spreadsheet they already know. Our approach is to build KPIs, forecasts and dashboards inside Excel and Google Sheets, so you keep control and understand every formula.
We would rather see you track five KPIs with targets and owners than 30 without. Start with cash, margin and one customer measure. Once those are reliable and reviewed on a schedule, add more.
frac
Get your KPIs built for you
If you would rather not build the file yourself, we can do it. Our KPI Dashboard Build is a one-time project that turns your existing spreadsheets into a clear dashboard. If you want ongoing help with forecasting and reporting, our fractional CFO plans start with the Starter plan at $600 per month or $7,200 per year. For a first step, the Launch Kit is $650 one-off. You can also browse our Excel templates or see all one-time finance projects.
Onboarding is hands-on and email support is included, so you are not left to work out the formulas alone.
FAQ
What are the best KPIs for a small business?
Start with cash flow, gross profit margin, net profit margin and one customer measure such as retention or customer acquisition cost. Add a measure that fits how you deliver, like inventory turnover for retail or utilization for services. Keep the list to four to six at first.
How do I track KPIs in Excel or Google Sheets?
Keep raw monthly data on one tab and calculate KPIs on another, with columns for target, actual, variance and status. Add a dashboard tab with charts and a defined owner for each measure. Update on a fixed schedule, weekly for cash and monthly for the rest.
What is the difference between a KPI and a metric?
A metric is any measurable number. A KPI is a metric tied to a specific goal, a target and an owner. Total site visits is a metric. Repeat purchase rate against a 30% target is a KPI.
How often should I review my KPIs?
Review cash weekly or every two weeks, profit and revenue monthly, and slower-moving measures like retention quarterly. Reassess the KPI list itself once a year, or when your goals or business stage change.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources
- Shopify: What is a KPI
- APQC: KPI, measure and metric
- IEEE Technology Navigator: Key performance indicator
- KRI vs KPI: the real difference
- KPIs for business: a guide for small business
- HubSpot: How to choose the best KPIs
- FSB: How to prepare a cash flow forecast
- SCORE: Measuring success with key small business metrics
- Restaurant analytics metrics that predict profit
- Key performance indicators every small business should track
- KPI tracking spreadsheet template guide
- 10 essential KPIs every small business should track



One Response