Self-EmploymentIntermediate5 min read

Building a KPI dashboard for a solo business

A handful of numbers, checked on a schedule, that tell you how the business is really doing — beyond the bank balance and gut feel.

Most solo owners run their business on two signals: the bank balance and a general feeling. Both mislead. The bank balance reflects timing, not health, and gut feel lags reality by months. A KPI dashboard — a handful of key numbers reviewed on a schedule — replaces vibes with a small set of honest indicators. It does not need to be fancy; a one-page spreadsheet updated monthly beats an elaborate system you never look at.

What a KPI actually is

A key performance indicator is a number that reliably tells you something important about the business's direction. The art is choosing few enough to actually track and meaningful enough to act on. A dashboard with thirty metrics is noise; five to eight well-chosen numbers, watched over time, is signal. What matters is the trend across months, not any single reading.

The core numbers for a solo business

KPI	What it tells you	Watch for
Monthly revenue	Top-line direction	Sustained decline or plateau
Net profit / margin	Real profitability	Revenue up but margin down
Cash runway	Months you can operate	Dropping below your comfort floor
Pipeline / booked work	Future revenue	An empty next quarter
Utilization / billable hours	Capacity used	Too low (idle) or maxed out (no room to grow)
Average revenue per client	Client quality	Over-reliance on tiny clients

A starter dashboard for a service-based solo business. Track the trend, not just the latest value.

Leading vs. lagging indicators

Revenue is a lagging indicator — it tells you what already happened. Pipeline and booked work are leading indicators — they predict what is coming. A dashboard with only lagging metrics tells you about a fire after it started; adding a leading metric like pipeline lets you see the empty quarter while you can still fill it.

Building and using it

Pick five to eight KPIs that map to what actually drives your business — for a service firm, revenue, margin, cash runway, pipeline, and utilization are a strong core.
Put them on one page with a column per month, so the trend is visible at a glance.
Update it on a fixed schedule — monthly is right for most solo businesses — right after you reconcile your books.
Set thresholds that trigger action: 'if pipeline drops below X weeks of work, spend time on business development this month.' The dashboard is only useful if a bad number changes your behavior.

Vanity metrics feel good and decide nothing

Followers, website visits, and total lifetime revenue are easy to track and rarely change a decision. A real KPI is one where a bad reading tells you to do something specific. If you cannot name the action a metric would trigger, it does not belong on the dashboard.

The bottom line

A KPI dashboard turns running your business from gut feel into a monthly fifteen-minute review of a few numbers that matter — revenue, margin, cash runway, pipeline, utilization, and client concentration for most solo firms. Mix leading indicators with lagging ones so you see problems early, set thresholds that trigger specific action, and keep it to a page you will actually update. The value is not in the chart; it is in catching a shrinking margin or an empty pipeline while there is still time to respond.

Check your understanding

1 of 3

A consultant's dashboard shows only monthly revenue, which looks fine. Why is that risky?

Not quite — try again.

The Worth letter

Get smarter about money every week

One email, no spam — practical guides and Worth updates. Unsubscribe anytime.

Put this into practice

Worth tracks your accounts, budgets, and goals — so the concepts in this article aren't just theory.

Start free trial