Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Financial KPI dashboard: what to track without drowning in charts

Define a manageable set of finance metrics with reliable sources, clear owners, consistent formulas, and a useful review cadence.

By Institution3 minute readUpdated View sources
In this guide

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.

A sample layout
MetricHow it is calculatedReview
Available cashUnrestricted cash on the reporting date; show other cash separatelyWeekly
Indicative runwayUnrestricted cash divided by positive average monthly net burn; compare with a dated forecastMonthly
RevenueRecognized revenue, compared with the prior month and the same month last yearMonthly
Gross marginNet revenue minus cost of sales, divided by net revenueMonthly
Receivables over 60 days overdueOpen invoice balances more than 60 days past the contractual due dateWeekly
Payroll as a share of revenueTotal payroll cost divided by revenueMonthly

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.