Financial KPI Dashboard: One Trusted View of Margin, Burn, Runway & the Ratios

The problem this kills

Ask three people in your company what "gross margin" was last quarter and you'll often get three answers — because each of them computed it from a slightly different spreadsheet, with a slightly different definition, pulling from a slightly different export. The CFO quotes one runway number to the board; the founder quotes another to a candidate; the controller's model says a third. None of them is lying. They just never agreed, in writing, on what each metric means and where the inputs come from.

So every board meeting and every investor update starts with a tax nobody budgeted for: an hour of reconciling whose number is right. Burn is computed net of a one-off this month but not last month. DSO uses period-end AR one quarter and average AR the next. The "current ratio" quietly includes a long-term item someone miscoded. And because the metrics live in a workbook on one laptop, last period's figures get overwritten and the trend — the single most useful thing — is lost.

Your core financial KPIs deserve one trusted home: locked definitions so the numbers are comparable period over period, a target on each metric so "good" and "bad" are objective, and a human who signs off before the figures are shared. That's a real application, not a spreadsheet held together with hope.

What you'll build

A simple internal web app for your finance team and leadership. Each period (monthly, quarterly, whatever you close on) you import your trial balance and any supporting CSVs — an AR aging for DSO, an AP aging for DPO, a cash balance for runway. The tool computes your core KPIs from a set of locked definitions you control: gross and operating margin, net burn, runway, DSO and DPO, current and quick ratio, revenue growth — plus whatever else matters to your business.

Every metric is shown three ways at once: the value this period, the target you set, and a trend sparkline across recent periods so you can see direction at a glance. Anything off target is flagged. The finance lead reviews the computed figures, fixes any input that looks wrong, and approves them before the dashboard is published or shared. Nothing goes out as "the number" until a person signs off. Then you export a KPI CSV and a one-page snapshot for the board pack.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — which KPIs you actually report, exactly how each one is defined (numerator, denominator, period-end vs. average, what's excluded from burn), the real shape and account-code conventions of your trial balance, your close cadence and volumes, your targets, and the messy exceptions that have caused arguments before. It reflects a short tailored spec back to you and waits for your thumbs-up before it builds anything, so the dashboard computes your metrics by your definitions — not a generic template.

From there it walks the agent through the data model, the period import, the locked-definition engine that computes each KPI, the off-target flagging, the trend sparklines, the finance-lead approval gate, and the CSV + one-page snapshot export. Every step ends with a ready-to-copy prompt. There's a full "No API yet?" path that uses Google Sheet / CSV imports as the data source and produces clean exports — so you can build and run the whole thing this afternoon, no accounting integration required.

The governance it includes (this is the point)

This is the number leadership and the board will act on, so the controls aren't optional. The plan builds in login so only your team can use the tool, row-level security so you only ever see your own organization's financials, a complete audit trail of who changed which input and who approved which period's figures, locked metric definitions so a KPI can't silently change shape between periods, a hard human-approval gate so no figures are published until the finance lead signs off, and duplicate guards so the same metric-and-period can't be imported or computed twice.

Who it's for

CFOs, controllers, FP&A staff, and finance-owning founders — anyone who needs one trusted, comparable view of the company's core financial KPIs and is tired of the "whose number is right?" argument before every board meeting. If you can write down how each of your metrics is defined and where its inputs come from, you can build this.

You've got this — start with the plan, paste the first prompt, and answer the interview. You'll have your first governed KPI dashboard on screen before the afternoon's out.