Financial dashboard KPIs: what a finance dashboard should show

Financial dashboard KPIs are the numbers that tell an operator whether the company is solvent, collecting, and on plan: cash position, runway, DSO, margin, and budget variance. A finance dashboard computes them from bank, ledger, and invoice data on one screen.

Finance dashboards differ from sales dashboards in one important way: the questions repeat weekly, not quarterly. Can we make payroll? Who owes us money, and how late is it? What does the next 13 weeks of cash look like? The KPI set below answers those questions, and every example comes from live templates in our catalogue.

Which KPIs belong on a financial dashboard?

A financial dashboard should carry 4 groups of KPIs: cash (position and runway), receivables (DSO and aging), payables (upcoming runs and aging), and P&L (actuals versus budget and margin). Each group answers a different operator question, and each maps to a decision.

KPI	Formula	Decision it feeds
Cash position	Sum of bank balances, as of last close	Can we fund this week's obligations?
Runway	Cash ÷ net monthly burn, or projected weekly balance	When do we need to cut spend or raise?
Net burn	Cash out minus cash in, per month	Is the cost structure sustainable?
DSO	(Receivables ÷ revenue) × days in period	Are customers paying slower than terms?
Receivables aging	Open invoices bucketed by days outstanding	Which accounts need a collections call?
Payables aging	Open bills bucketed by days outstanding	Which payments can wait, which cannot?
Budget variance	Actual minus budget, by line, per month	Where is the plan wrong?
Gross margin	(Revenue − cost of goods) ÷ revenue	Is each sale contributing enough?
Covenant headroom	Actual ratio minus covenant threshold	How close is the facility to a breach?

What do the cash KPIs tell you?

The cash KPIs answer 2 questions: where the cash stands today, and where it stands 13 weeks from now. The first is a sum of bank balances. The second is a rolling forecast that extends the current position with expected receipts and payments, week by week.

Ledgerline, our treasury dashboard, is built around exactly this pair. Its Weekly cash position section opens with a Cash waterfall chart for week 27 that walks the opening balance through receipts and payments to the close, and a 13-week runway chart plotting the projected closing balance for each week ahead. A Bank accounts panel lists balances as of the Jun 30 close of business. The 13-week horizon is the standard for a reason: it is long enough to see a crunch forming and short enough that the receipts side stays honest.

How do receivables and payables KPIs work?

Receivables KPIs measure how fast customers pay; payables KPIs measure how the company schedules its own outflows. The headline receivables metric is DSO, days sales outstanding: receivables divided by revenue, times the days in the period. A DSO of 45 against 30-day terms means the average customer pays 15 days late.

DSO as a single number hides the shape of the problem, so the dashboard pairs it with an aging ladder: open invoices bucketed into current, 1 to 30 days late, 31 to 60, and beyond. Ledgerline shows both, an Aging ladder of open invoices by age and a DSO trend chart over the trailing 12 months, plus a Top open balances table naming the 5 largest debtors. The payables side mirrors it: upcoming payment runs on a Wednesday release cycle, AP aging by bucket, and an early-payment discount panel that shows what taking each discount by its date is worth. The collection call list and the payment run come straight off these panels.

Which P&L KPIs close the loop?

The P&L KPIs are budget variance by line and gross margin, and at companies with bank facilities, covenant headroom. Variance is actual minus budget, shown monthly, with unfavorable lines flagged. Ledgerline renders this as a Monthly P&L vs budget chart with unfavorable variance in orange, and a Gross margin bridge that walks the margin from May to June in basis points so you can see which cost line moved it.

Covenant headroom deserves a permanent panel wherever debt exists. It is the distance between the actual tested ratio and the threshold in the facility agreement. Ledgerline shows it for a facility tested quarterly, next test Sep 30. This KPI has no variance tolerance: crossing the line once is an event, and the dashboard exists so the event never arrives as a surprise.

Smaller operations need the same logic at a simpler scale. Vault, our free finance dashboard, carries Total income, Total expenses, and Net profit cards, an Income vs expenses monthly chart, a Year-end cash projection with scenario switching, and a Budget health panel tracking spend against plan for the quarter.

Who reads a financial dashboard?

The readers of a financial dashboard are founders, finance leads, bookkeepers, and department heads, and each one enters through a different panel. The founder opens on the runway chart and the cash position, because those 2 numbers set the planning horizon. The finance lead works the receivables aging and the DSO trend, turning the ladder into a call list. The bookkeeper lives in the payables section, checking the next payment run against the bank balances. Department heads read the budget variance lines for their own cost centers. A single screen serves all 4 because the KPIs are layered from headline to ledger, and each reader stops at the depth their decision needs.

Where can you see these KPIs on a working screen?

Both examples above are live files. Ledgerline, the treasury dashboard, covers cash, receivables, payables, P&L, and covenant headroom. Vault is free on the free templates page. For receivables-heavy operations, Remit focuses on invoicing and collections. All of them sit in the finance dashboard templates hub, and every preview is the working file.

Open the free Vault finance template → · Browse all dashboard templates