Fewer numbers, chosen deliberately
Choose a small set of measures with clear definitions, an accountable owner, and a reason to review them. The useful number of charts depends on the decisions and risks involved. A collections manager and a board may need different views of the same underlying records.
A starting set
Start by considering unrestricted cash, recognized revenue, cost of sales, operating expenses, overdue receivables, and liabilities due soon. Add payroll as a share of revenue where it explains the operating model; it is less useful as a standalone comparison for a business with little or no current revenue. Choose further measures according to how the business earns and collects money.
- A service business: billable utilization, revenue per employee, and backlog.
- A store or online seller: revenue by channel, inventory turns, and return rate.
- A subscription business: monthly recurring revenue, churn, and customer acquisition cost.
- A contractor: margin by job, work in progress, and open change orders.
Define each one
Record the formula, source, reporting period, exclusions, and owner for each metric. For example, gross margin is net revenue minus cost of sales, divided by net revenue; the note should specify which delivery and support accounts your accounting policy includes. For an overdue-receivables measure, identify the due-date basis. Show an unavailable or unreliable measure as such instead of filling it with an estimate that looks final.
Include a target and a trend
A number on its own is hard to read. Show the same metric for recent months, and next to it a target or last year's result. A trend shows direction, and a target shows what is acceptable.
Set a rhythm
Use a review rhythm that matches how quickly each risk changes. Cash and collections may need weekly attention, while margin is more reliable after the monthly close. Record action owners and due dates when intervention is needed. Keep necessary guardrails even when they remain stable; remove a metric when it has no decision, monitoring, or reporting purpose.
A sample layout
Here is one way to arrange a first dashboard for a service or product business. Adapt the rows to how you earn money.
| Metric | How it is calculated | Review |
|---|---|---|
| Available cash | Unrestricted cash on the reporting date; show other cash separately | Weekly |
| Indicative runway | Unrestricted cash divided by positive average monthly net burn; compare with a dated forecast | Monthly |
| Revenue | Recognized revenue, compared with the prior month and the same month last year | Monthly |
| Gross margin | Net revenue minus cost of sales, divided by net revenue | Monthly |
| Receivables over 60 days overdue | Open invoice balances more than 60 days past the contractual due date | Weekly |
| Payroll as a share of revenue | Total payroll cost divided by revenue | Monthly |
Mistakes that make dashboards useless
Tracking vanity numbers that look good and change nothing. Changing a definition without restating earlier months, so a trend is really a new formula. Building a dashboard on books that are not reconciled. And giving every metric no owner, so nobody acts when it moves.
Frequently asked questions
How many KPIs should a dashboard have?
Use the smallest set that covers the decisions, commitments, and risks you need to monitor. Every measure needs a definition and owner. Stable cash or covenant guardrails can remain useful even when they do not trigger an intervention.
Where should the numbers come from?
Financial metrics should come from reconciled books. Operating metrics such as orders, hours, or churn come from the system that records them, with a note on how they tie to the ledger.
How often should we review them?
Cash and collections weekly, and the full set monthly after the close. Quarterly, step back and ask whether the list still matches how the business makes money.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.