Wauvel
Toolkit

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

← All posts
By Blake EkelundSeptember 3, 2026 · 7 min read

Every dashboard starts the same way. Someone asks what we should track, everyone contributes a metric, and you end up with fifty tiles nobody reads. Within a month it is decoration.

The failure is not the tooling. It is that a metric was never asked to justify itself. A number earns a place on a weekly review only if it passes one test: if it moved, would you do something differently this week? If the honest answer is no, it belongs on a monthly report or nowhere.

The four that keep you solvent

Cash problems are the only ones that end a business quickly, so they get the weekly slot regardless of what else is going on:

  • Cash on hand.The balance, today, across all accounts. Not a ratio, not a trend — the number.
  • Projected low point. The lowest balance in the next thirteen weeks, and the week it happens. This is the single most useful number a small business can look at, because it turns a vague worry into a date.
  • A/R overdue. What you are owed past terms, not total receivables. Total A/R includes invoices that are simply young; overdue is the part that needs a phone call.
  • A/P due in 14 days. What has to go out shortly. Paired with the first two, this is the entire short-term liquidity picture in three glances.

The three that tell you if you are growing

Weekly revenue on its own is noise — it swings on which day an invoice was cut. What you want is the leading edge, the thing that becomes revenue later:

  • Bookings or new orders this week. Work sold, whenever it gets invoiced. This moves before revenue does, which is the whole point.
  • Pipeline or backlog. Committed work not yet delivered. A shrinking backlog is the earliest reliable warning a service business gets.
  • The one driver of your revenue engine. Utilization if you sell capacity, net new customers if you sell subscriptions, conversion rate if you run a funnel. One number, chosen because it is the term you can actually move.

The three that tell you if it is working

  • Gross margin. Weekly if you can get it, monthly if you cannot. Margin drift is slow, quiet, and the most common way a growing business becomes a struggling one.
  • Labor as a share of gross profit. Your largest controllable cost measured against the thing it is supposed to produce.
  • Days sales outstanding. How long customers take to pay. It moves before your cash problems do, which makes it a leading indicator rather than a postmortem.
A weekly page · ten numbers
MetricThis weekvs lastAct if
Cash on hand$148,200+$6,400Below floor
13-week low point$31,000Week 9Below floor
A/R overdue$62,800+$9,100Rising 2 weeks
A/P due in 14 days$44,300−$2,000Exceeds cash
Bookings this week$38,500+$4,200Two weeks light
Backlog$212,000−$14,000Falling trend
Utilization71%+3 ptsBelow 65%
Gross margin38.4%−0.9 ptsDown 2 months
Labor / gross profit42%+1 ptAbove 50%
DSO47 days+3 daysAbove terms +15
Everything here answers a question you might act on this week. Anything that would not change a decision belongs on the monthly report instead - which is where the other forty metrics live perfectly happily.

Give every metric a trigger

Notice the last column. A metric without a threshold is trivia — you look at it, think "huh," and move on. Deciding in advance what level would cause you to act is what converts a dashboard into a control system.

Write the trigger when you add the metric, while you are calm and nothing is on fire. "Act if cash dips below $60,000." "Act if gross margin falls two months running." Then the weekly review becomes a scan for breached thresholds rather than an act of interpretation, which is the only version that survives a busy quarter.

What to do with the other forty

Keep them. They are not worthless — they are just not weekly. Site traffic, customer counts, expense detail, cohort retention: all genuinely useful, all better reviewed monthly when you have enough data for the movement to mean anything.

The point of a short weekly list is not that the other numbers do not matter. It is that attention is the scarcest thing you have, and ten numbers you actually look at beat fifty you have stopped seeing.

The financial health KPI tracker is a free Excel version of this page — the vital signs on one sheet, month over month, formulas already in.

See what a report like this looks like on your own numbers.

Meet your AI CFO →

Prefer to run the numbers yourself? Try the free Financial Health KPI Tracker — no signup needed.

Keep reading

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 →
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 →
ToolkitJune 26, 2026 · 9 min read

The case of the missing cash: a CFO's afternoon in Excel

A wholesale distributor turns a profit every month and still can't make its credit line breathe. Here's the afternoon a fractional CFO spent cracking it — and the dozen Excel formulas she reached for, what each one does, and exactly when you'd use it.

Read it →
ToolkitJune 26, 2026 · 9 min read

Financial modeling best practices: building a model that doesn't break

Models almost never fail on the math — they fail on structure, trust, and rot. Here are the practices CFOs use to build a model a banker (or your future self) can actually follow and believe.

Read it →
Finance 101September 5, 2026 · 8 min read

Can you service the loan? DSCR and covenants in plain English

Before a bank lends you anything it computes one ratio, and you can compute it yourself in about five minutes. Here's what DSCR is, what number you need, and what the covenants buried in your loan agreement can actually do to you.

Read it →
Finance 101September 1, 2026 · 7 min read

Payroll as a percentage of revenue: what's normal?

Payroll is the largest cost in most small businesses and the one owners are least sure about. Here's how to measure it so the number means something, what the ranges look like by business type, and the two ratios that matter more than the headline percentage.

Read it →