8 KPIs Your SMB Should Track (But Almost Nobody Does)

Most SMBs we consult measure the same thing: revenue, expenses, margins. It's like driving a car looking only at the speedometer. You see you're going 100 km/h, but you don't know if the engine is overheating, fuel consumption is high, or the brakes are failing.

The right KPIs tell you where cash is trapped, which customer burns more resources than revenue they bring, and why your invoicing rises but profit stalls. Here are 8 metrics that transform how you manage an SMB.

1. CAC (Customer Acquisition Cost): What You Spend to Win a Customer

CAC is total marketing and sales spending divided by new customers gained in a period. If you spent 5,000 USD on campaigns and sales contracts in one month and won 10 new customers, your CAC is 500 USD per customer.

Why does it matter? Because many SMBs grow revenue but lose money on each new customer. High CAC only makes sense if the customer generates revenue that justifies that initial expense.

In Excel: (Marketing spend + Sales salaries) / New customers in period = CAC

2. LTV (Lifetime Value): Net Money a Customer Gives You Over Their Lifetime

It's average revenue per customer minus service costs, multiplied by average customer tenure. If a customer generates 100 USD monthly revenue but costs 30 USD to serve (support, resources), the gain is 70 USD. If they stay 24 months, LTV is 1,680 USD.

Here's the critical insight: if CAC is 500 USD and LTV is 1,680 USD, you're winning. But if CAC is 500 and LTV is 400, you're breaking even or losing.

In Excel: (Average revenue per customer - Cost to serve) × Average relationship length in months = LTV

3. Throughput: Real Money-Making Speed

A Theory of Constraints metric. It measures money in minus fully variable costs (raw materials, sales commissions). Unlike traditional margin, throughput shows you how much 'pure' cash is available to cover fixed costs and profit.

A customer generating 1,000 USD revenue but costing 200 USD in materials has 800 USD throughput. That money pays salaries, rent, and profit.

In Excel: Total revenue - Variable costs (materials, commissions, delivery cost of sale) = Throughput

4. OTIF (On Time In Full): Delivery Fulfillment Rate

What percentage of orders do you deliver on the promised date with the correct quantity? If you promise 10 units Thursday and deliver 8 Friday, that's not OTIF.

Why is it a KPI? Because low OTIF costs customers, increases returns, and generates hidden costs (rework, expediting, reputation damage). Consistent OTIF above 95% signals solid operations.

In Excel: (Orders delivered on time and in full / Total orders) × 100 = OTIF %

5. Internal NPS (Employee Net Promoter Score): Who Really Stays

A simplified version: ask your team 'How likely are you to recommend this place to work?' on a 0-10 scale. Then: % promoters (9-10) minus % detractors (0-6) = NPS.

Low internal NPS signals future turnover, operational errors, and dissatisfied customers. Uncommitted employees deliver mediocre work. SMBs ignoring this lose talent mid-year.

In Excel: Create a brief survey, sum percentages, and subtract. An NPS above 30 is already positive for SMBs.

6. Retention Cost vs. Acquisition Cost

Compare directly: how much does it cost to keep an existing customer happy versus bringing a new one? Typically, retention costs 5-25 times less than acquisition.

If your CAC is 500 USD but keeping a customer costs only 50 USD yearly in personalized attention, why prioritize new customer marketing over retention in your budget?

In Excel: Annual retention spending / Active customers = Retention cost per customer. Compare to CAC.

7. Cash Conversion Cycle

The number of days between paying suppliers and receiving customer cash. If you buy materials today, transform them into product, sell in 30 days, but customer pays in 45 days, your cycle is long and cash flow suffers.

Many SMBs fail not from low profit but poor cash cycle management. A negative cycle (you collect before you pay) is pure gold.

In Excel: (Average days in inventory + Average days to collect) - Average days to pay suppliers = Cash cycle

8. Capacity Utilization Rate

What percentage of your maximum capacity are you using? If you have 10 machines but use 6, or 20 employees working at 60%, you're paying for idle capacity.

Utilization below 70% signals either growth ahead (opportunity) or over-sizing (problem). Knowing which is critical.

In Excel: (Hours/resources used / Hours/resources available) × 100 = % utilization

Start Today: Build a Simple Excel Dashboard

You don't need expensive software. Create a sheet with columns: Period | CAC | LTV | OTIF | Internal NPS | Cash Cycle | Throughput. Update monthly with real numbers.

The magic isn't having KPIs: it's comparing them month to month. If CAC rises but LTV drops, you have a problem. If cash cycle lengthens, you need to renegotiate with customers or suppliers.

Next Steps

Pick two of these eight metrics that hurt your business today (e.g., employee turnover + slow cash cycle). Calculate where you are now. Then set a realistic goal for 90 days. That initial shift will reveal where the real money is. Want a free KPI audit for your SMB? Contact COBIZ for an initial consultation at no obligation.