How to understand a Key Metrics Dashboard

Definition

A Key Metrics Dashboard is a short, repeating list of the operating numbers leadership checks between month-end closes. It is a watch list, not a full set of financial statements.

On the books, the dashboard is not its own account. Each metric is pulled from the P&L, the Balance Sheet, or a simple count such as headcount or subscriber total.

The Management Reporting Package is the fuller pack that goes out after the close. The dashboard is the thinner set someone can open on a Tuesday without waiting for the books to finish.

Keep the list small on purpose. A page of twenty charts is a report; a dashboard is the handful that would change a decision this week.

Where it shows up

Balance Sheet: Related to cash and working-capital metrics pulled from it.

P&L: Related to revenue and gross margin.

Cash flow: Related to cash runway.

See also: Management Reporting Package · Gross Margin · Cash Runway

When you look at your Balance Sheet, the dashboard is not a line. Cash, receivables, and payables from that snapshot often feed metrics such as cash runway and days sales outstanding.

The profit and loss statement supplies revenue and gross margin. Those two are the P&L numbers most owners want on a dashboard even when the rest of the close is still in progress.

Cash runway comes from cash on hand and the recent burn. It is a cash-flow idea, even when you compute it off the bank balance rather than the full Statement of Cash Flows.

A useful dashboard is the same handful of numbers, in the same order, every week. A noisy dashboard changes its list each time, so nobody can tell what improved.

How it works

Pick the few numbers that would actually change a decision. Revenue, gross margin, cash runway, and days sales outstanding are common; a software shop often adds monthly recurring revenue and headcount.

Each metric needs a source. Revenue and gross margin come from the P&L; cash and receivables come from the Balance Sheet; headcount is a people count, not a ledger total.

Decide the cadence next. Weekly is typical between closes; monthly is enough when the business does not move that fast.

Write down the formula so two people cannot compute two different answers. Days sales outstanding, for example, is average receivables divided by average daily sales, not a guess from the aging report.

Then compare each number to a target or to last period. Budget versus actual on the dashboard is the same idea as on the full pack, just limited to those few lines.

When a metric jumps, go back to the source account. The dashboard tells you something moved; the books tell you why.

Do not wait for a perfect close to update the list. Flash numbers are fine if you label them as flash, then replace them when the month is issued.

A dashboard that disagrees with the issued statements is a problem. Reconcile it, or stop sending it until it ties.

Example

A subscription software shop watches five numbers every Monday: monthly recurring revenue, gross margin, days sales outstanding, cash runway, and headcount. Late March the dashboard shows $80,000 of monthly recurring revenue, 78% gross margin, 42 days sales outstanding, nine months of cash runway, and 12 people.

March subscription invoices have not been recorded yet. The bookkeeper enters the month of revenue:

Debit: Accounts receivable $80,000

Credit: Subscription revenue $80,000

Accounts receivable and revenue both go up by $80,000. Cash has not moved, so cash runway does not change, but the revenue and days-sales-outstanding figures on next week's dashboard will.

The owner can now see that collections, not sales, are the slow number. The dashboard did its job: it pointed at one metric to investigate before the full pack arrives.

Common mix-ups

A Key Metrics Dashboard is not the Management Reporting Package. The dashboard is the short watch list between closes; the pack is the statements, budget pages, and flux note after the close.

A metric is not a target. Gross margin on the dashboard is the actual rate; the budget is the rate you planned.

The dashboard is also not the P&L. Revenue and gross margin appear on both, but the P&L still holds every other income and expense line the dashboard leaves off.

Related terms

• Management Reporting Package: The internal reporting set that pairs financial statements with operating metrics and commentary.
• Revenue: The total value of goods and services the business earned in a period.
• Gross Margin: Gross profit expressed as a percentage of revenue.
• Cash Runway: How many months current cash will last at the present burn rate.
• Days Sales Outstanding: The average number of days it takes to collect an invoice.
• Headcount: The number of people employed, tracked as a cost driver.
• Monthly Recurring Revenue: Normalized subscription revenue for a single month.
• Budget Versus Actual: The comparison of planned amounts to what actually happened.