Wauvel
Toolkit

The one KPI that matters most for your business model

← All posts
By Blake EkelundOctober 19, 2026 · 6 min read

There is a version of financial discipline that consists of watching thirty numbers equally. It feels rigorous and produces nothing, because attention spread evenly is attention spent on whatever happens to move.

Every business model has one metric that sits upstream of the others — move it and revenue, margin and cash all follow. Finding yours is worth more than any dashboard.

Your engine picks your metric

The upstream number, by model
ModelThe one metricBecause
SubscriptionNet revenue retentionSets the ceiling on size
Capacity (salon, clinic, fleet)UtilizationAn unsold slot is gone forever
Paid acquisition / DTCContribution margin per orderDecides what you can bid
Professional servicesBillable rate realizationWhere quoted margin leaks away
Retail / distributionInventory turnsCash is stuck in stock
Contracting / projectGross margin per job vs. bidEstimating errors compound
Each of these sits upstream of revenue rather than being a restatement of it. That is the test: moving it changes the outcome, rather than describing an outcome that already happened.

Test whether it is really upstream

The distinction that matters is between a driver and a result. Revenue is a result. Profit is a result. Both are consequences, and watching them tells you what already happened.

A driver is something you can act on this week that changes a result later. Utilization is a driver — you can move it with scheduling. Net revenue retention is a driver — onboarding and support move it. Revenue is what those produce.

Two questions settle it. Can somebody do something on Monday that moves this? And if it moves, does revenue or margin follow? If the answer to either is no, you have picked a scoreboard, not a lever.

Utilization

68%

the lever

At 76%

+12%

revenue, no new staff or space

Cost to move it

$0

scheduling, not spending

Free · no account · no card

Get your 2027 budget built from your QuickBooks — P&L, balance sheet and cash flow, in Excel.

Build my 2027 budget →

What the wrong choice does

Picking badly is worse than picking nothing, because a headline metric directs behaviour. A services firm managing to utilization will push people to 95% billable and quietly destroy the sales and training that fill next quarter. A DTC brand managing to revenue will buy unprofitable traffic and grow itself broke.

The safeguard is a counterweight: one metric you are optimising and one you are protecting. Utilization against realized rate. Growth against contribution margin. New customers against retention. The pair is much harder to game than either number alone.

Put it somewhere you cannot avoid it

One number, updated weekly, with a threshold written down in advance for what would make you act. That is the whole system. The other twenty-nine metrics stay on the monthly report, where they belong.

Revisit the choice annually, because it changes as the business does. A young business is usually constrained by demand, so acquisition is the lever. A maturing one is usually constrained by capacity or retention, and by then acquisition is no longer the thing worth watching every week.

The ten KPIs worth a weekly look covers the supporting cast, and the KPI tracker keeps the trend for you.

Need your financials for a lender, a buyer or your accountant? Get the free financials pack →

See what an AI CFO says about your own numbers.

$99/mo, everything included. Free for 14 days, no card.

Meet your AI CFO →

Keep reading

ToolkitOctober 5, 2026 · 6 min read

The 13-week cash flow, rebuilt every Monday

Most cash forecasts are built once, admired, and never opened again. The value isn't in the model - it's in the twenty-minute weekly habit of rolling it forward and comparing what you predicted to what happened.

Read it →
ToolkitSeptember 27, 2026 · 8 min read

How to build a small business pro forma a lender will believe

A bank, a landlord, or a seller asks for a pro forma and most owners start from a blank spreadsheet. Start from your last twelve months instead, add the one change you're asking about, and check the number the lender will check first.

Read it →
ToolkitSeptember 9, 2026 · 7 min read

The month-end close that takes four hours, not four days

A slow close is almost never a bookkeeping speed problem - it's a sequencing problem. Here's the order that removes the waiting, the four reconciliations that catch nearly every error, and the rule that decides when the month is actually done.

Read it →
ToolkitSeptember 7, 2026 · 8 min read

Building next year's operating plan (start now, not in December)

An annual plan built in the last week of December is a wish list. Built in September, it is a decision you have time to act on. Here's the order to build one in, how long each layer takes, and the difference between a plan and a forecast.

Read it →
ToolkitSeptember 3, 2026 · 7 min read

The 10 KPIs worth watching weekly (and the 40 that aren't)

Most dashboards fail because they show everything, which is the same as showing nothing. Here are the ten numbers that earn a weekly look for a small business, why each one is on the list, and the test for whether a metric deserves your attention at all.

Read it →
ToolkitAugust 24, 2026 · 7 min read

Recurring, capacity, or funnel: which revenue engine are you?

Almost every business makes money in one of three shapes, and the shape determines which numbers you should be forecasting. Pick yours and you stop guessing at revenue - you start building it from drivers you can actually influence.

Read it →
ToolkitJuly 7, 2026 · 8 min read

SUMIFS: turn a raw QuickBooks export into a P&L with one formula

Export your general ledger and you get a flat list of every transaction — not a report. SUMIFS is the one formula that rolls that list up into a P&L: revenue by month, opex by category, all of it. Here's exactly how, plus the traps that quietly return a wrong number.

Read it →
ToolkitJuly 3, 2026 · 8 min read

Cleaning messy data in Excel: the six functions that do it

Exported data almost never arrives clean — names in three different cases, addresses jammed in one cell, trailing spaces that quietly break your lookups. Here are the six Excel functions that turn a messy paste into data you can actually total, match, and trust.

Read it →
ToolkitJuly 1, 2026 · 7 min read

XLOOKUP vs VLOOKUP vs INDEX/MATCH: which lookup should you use?

The one-line answer is XLOOKUP — but VLOOKUP and INDEX/MATCH still earn their keep, and INDEX MATCH MATCH does something none of the others can. Here's each one, side by side, with the exact moment you'd reach for it.

Read it →