Why most SMB dashboards fail.
Three failure modes. One: too many metrics. Owners drown in 30 KPIs and stop looking. Two: lagging metrics only. By the time net profit drops, the cause has been festering for two months. Three: no targets and no alarms. Numbers without context tell you nothing about whether they are good or bad. The fix is fewer KPIs, mostly leading indicators, with explicit targets and threshold alarms.
The five KPIs below cover financial health (cash runway), profitability (gross margin, COGS percent), working capital (AR days), and operational performance (branch contribution). Together they answer the four questions every SMB owner should be able to answer in 30 seconds: are we making money, can we keep making money, are we collecting money, and which parts of the business are pulling weight.
KPI 1: Gross margin percent.
Definition: (revenue - direct COGS) / revenue. Targets vary by industry: retail 30-45 percent, distribution 12-22 percent, services 50-70 percent, manufacturing 25-40 percent. Watch it weekly, not monthly. A 2-point drop sustained over 4 weeks usually means a pricing problem, a sourcing problem, or a discount-policy problem.
Worked example. A 6-branch Toronto pharmacy chain had gross margin of 28 percent for 18 months, then dropped to 25 percent over 6 weeks. The dashboard alarm fired in week 3. Investigation found two of six branches had stopped following the markup policy on imported items because a competitor had opened nearby. Fix: targeted price defense in those branches plus better signage on owned-brand alternatives. Gross margin recovered to 27.4 percent in two months.
KPI 2: AR days (DSO).
Definition: (accounts receivable / revenue) * days in period. Target depends on credit terms: 30-day terms should give DSO of 35-45 days in a healthy business. Watch monthly, alarm if it drifts more than 7 days from target. Rising DSO is the leading indicator of collection problems and customer financial distress.
A subtle point: DSO can rise even when collections are fine, if revenue is dropping. Always look at AR days alongside revenue trend. The clean version: aged AR as a percent of trailing 90-day revenue. If 30+ days past due is more than 15 percent of trailing 90-day revenue, you have a real problem and dunning automation should already be active.
KPI 3: Cash runway (months).
Definition: cash on hand / monthly net cash burn. For profitable SMBs this should be 6+ months at minimum, ideally 12. For growth-stage SMBs reinvesting heavily, 6 months is the floor below which decisions get cramped. Watch weekly. Below 4 months, escalate every cash decision to the owner. Below 2 months, declare a cash crisis and stop discretionary spend.
A common mistake is using bank balance as a proxy for runway. It is not. Runway requires forecasting incoming AR collections, scheduled AP payments, payroll, taxes, and capex commitments. A £400K bank balance with £290K of payments due in 30 days is a 1-month runway, not a comfortable cushion. Nonari builds the rolling 13-week cash forecast from the same ledger, so runway is a real number, not an estimate.
KPI 4: COGS percent of revenue.
Definition: total COGS / revenue, watched as a trend rather than a snapshot. The complement of gross margin, but useful to track separately because it surfaces input cost pressure. If COGS percent is rising while gross margin is flat, you are passing cost increases through to customers. If COGS percent is rising while gross margin is dropping, you are absorbing cost increases. Different responses needed.
For multi-branch operations, watch COGS percent by branch. Variance between branches usually means inventory transfer pricing issues, theft, waste, or pricing inconsistency. A 3-point variance between best and worst branch is normal. A 7-point variance is a red flag that needs investigation.
KPI 5: Branch contribution margin.
For multi-branch SMBs, this is the most action-oriented KPI. Definition: revenue minus direct COGS minus direct expenses, by branch. It tells you which branches can stand on their own and which are subsidized by stronger ones. Watch monthly per branch with trailing 6-month trend.
Single-branch SMBs do not need this one — substitute net margin instead. But if you have 3+ locations and you are not watching branch contribution monthly, you are managing blind. The branch P&L conversation with branch managers should be monthly and based on this number.
- Gross margin: weekly, alarm on 2-point drop over 4 weeks
- AR days: monthly, alarm on 7-day drift from target
- Cash runway: weekly, alarm below 4 months
- COGS percent: weekly, alarm on rising trend without margin recovery
- Branch contribution margin: monthly per branch, 6-month trend
How Nonari builds these.
All five KPIs come from the same ledger as your operational data. No separate forecasting tool, no manual Excel pull. The dashboard updates whenever a transaction posts. Alarms fire by email, WhatsApp, or SMS when thresholds are crossed. Targets are configurable per branch and per product line.
The point is not having a beautiful dashboard. The point is having decision-grade numbers in front of you on Monday morning. Nonari handles the plumbing so you spend your time on the decisions, not the data extraction.