Most small business owners we work with fall into one of two camps. Camp one has no numbers: they know the bank balance and a gut feeling, and that's the dashboard. Camp two has too many: a BI tool with forty charts that nobody has opened since the demo. Both camps make decisions late, because the number that would have warned them was either never tracked or buried on page three.
The fix is the same for both: pick five numbers, put them on one page, update them weekly, and actually look at them. Here are the five we'd pick for almost any small business, and why.
1. Cash position, with a horizon
Not just the bank balance. The balance plus what's coming in (invoices due to you, expected receipts) minus what's going out (payroll, rent, bills due) over the next 8 to 13 weeks. Businesses rarely die of low profit in a single month; they die of running out of cash on a specific Friday. A simple rolling cash forecast, even a rough one in a spreadsheet, turns "we're suddenly short for payroll" into "we'll be tight in week 9, let's chase those two big invoices now." If you track only one number from this list, track this one.
2. Sales pipeline
The dollar value of deals or expected work in progress, weighted by how likely they are to close if you can manage it, raw if you can't. Revenue is a lagging indicator: by the time it drops, the problem started months ago. Pipeline is the early warning. A contractor who sees quoted-but-unsigned work shrink in March knows July will be slow while there's still time to do something about it. Track the total, and track how it moved since last week: what came in, what closed, what died.
3. Utilization (or its equivalent for your model)
For service businesses: what share of your team's available hours got billed or spent on revenue-producing work. For retail or product businesses, the sibling metric is inventory turnover or sell-through. Either way, this is the "are we using what we're paying for" number. Payroll is usually the biggest expense in a small business, and utilization tells you whether that expense is producing revenue or overhead. If utilization is high and profit is still thin, your pricing is the problem, and that's worth knowing too.
4. Churn, or repeat rate
Are the customers you already won coming back? For subscription and contract businesses, track churn: how many customers or dollars you lost this period. For everyone else, track repeat rate: what share of this month's revenue came from existing customers. Winning a new customer costs a multiple of keeping one, and a slow leak of regulars is invisible in the monthly revenue total for a surprisingly long time, because new sales mask it. This number makes the leak visible while it's still small.
5. Margin by job (or by product, or by customer)
Not overall margin. Margin broken out. Overall margin is an average, and averages hide the thing you most need to see: the job type, product line, or customer that loses money on every order while the rest of the business subsidizes it. Almost every business we've done this exercise with finds at least one surprise: the service everyone assumed was the bread and butter turns out to be break-even, and the boring side line is quietly carrying the company. You can't fix pricing, fire a bad-fit customer, or double down on winners until you can see which is which.
One page, updated weekly
The format matters as much as the metrics. Some rules that make this work in practice:
- One page. Literally. Five numbers, each with the current value, last week's value, and the trend. If it doesn't fit on one page, you're tracking too much.
- Weekly, on a schedule. Monthly is too slow; a bad month is over before you see it. Daily is noise. Pick a morning, same time every week, and look at the page. Fifteen minutes.
- Same definitions every week. If "pipeline" means something different in March than it did in January, the trend is meaningless. Write down how each number is calculated, once, and don't fiddle with it.
- Each number needs an owner and a trigger. Who updates it, and what reading makes you act? "If cash horizon drops under 8 weeks, we pause hiring" is a system. A number nobody acts on is decoration.
Where the numbers come from
Start manual. A spreadsheet filled in by hand every Monday is a perfectly good version one, and it forces you to learn where each number actually lives. Cash and margin come from your accounting system, pipeline from your CRM or quote log, utilization from timesheets, repeat rate from sales records.
Once the manual version proves useful, the Monday data-gathering is worth automating: pulling the numbers from QuickBooks, your CRM, and your job system into the page automatically, so the fifteen minutes goes to thinking instead of copying. That's a small data project, not a big one, and it's the kind we build often.
How to know it's working
Simple test: three months in, can you name a decision you made because of the page? Chased an invoice early, raised a price, dropped a money-losing service, slowed hiring before a soft quarter. If yes, it's working. If the page gets updated but never changes what you do, revisit the five numbers, because at least one of them isn't the right one for your business. The goal was never the dashboard. It was seeing trouble while it's still cheap to fix.
Stuck on this, or want it done for you? That's the job.
Email us →