Cash Runway, Burn Rate, AR Aging, Budget vs Actual
Most finance dashboards fail the same way: too many numbers, not enough of the ones that actually drive a decision. Before building anything, it's worth being precise about which KPIs earn a spot on a leadership dashboard — because the value of a dashboard is inversely related to how much you have to scroll to find the number that matters.
Cash runway. How many months of operation remain at current spending, given current cash on hand. This is the single most important number for any org watching its cash position closely — it answers "how much time do we have" in one figure. Calculated simply as: cash on hand ÷ average monthly net burn. It's simple arithmetic, which means it's a number you can and should verify by hand every time — no reason for imprecision here.
Burn rate. How much cash the org is spending, net, per month — expenses minus revenue, if revenue doesn't yet cover costs. Gross burn (total spend) and net burn (spend minus incoming revenue) tell different stories; a dashboard should be explicit about which one it's showing, because conflating them is one of the most common ways a KPI dashboard misleads the people reading it.
AR aging (Accounts Receivable aging). How much money customers owe you, broken into buckets by how overdue it is — typically current, 30 days, 60 days, 90+ days overdue. This KPI matters because it's an early warning system: a growing 90+ day bucket often signals collection problems or customer financial trouble well before it shows up anywhere else in your numbers.
Budget vs. actual. For each major spending category, how much was budgeted versus how much was actually spent, and the variance between them. This is the KPI leadership uses to catch spending drift early — a category running 40% over budget in month three of a quarter is a very different conversation than discovering it at quarter-end.
Why these four, specifically, and not a longer list. Each of these four answers a different, distinct leadership question: how much runway do we have (cash runway), how fast are we spending it (burn rate), are customers paying us (AR aging), are we spending according to plan (budget vs actual). A dashboard built around a handful of KPIs that each answer a genuinely different question is more useful than one crammed with twenty metrics that overlap. Your org may have additional KPIs that matter for your specific business — but start from this core four and add deliberately, not by default.
Where AI fits here — and where the arithmetic still has to be real. AI is excellent at helping you pull the right figures from raw exports and structure them into a rollup (the next lesson), and at explaining what a KPI means in plain language to someone unfamiliar with it. AI is not the thing computing cash runway or burn rate for real — that math happens in a spreadsheet formula or script you can inspect, using numbers from a source export you can point to. AI helps you build and explain the dashboard; it doesn't quietly become the calculator.
▶️ Try this
For your own org (or a hypothetical one, if you don't have real figures handy), write down what you believe the current cash runway, monthly net burn, largest AR aging bucket, and biggest budget variance actually are — even rough estimates. Then note which of the four you're least confident about. That's the KPI to prioritize getting a reliable, verified number for first.