Most monthly management packs are too long to read and too historical to act on — 40 pages of last month's numbers, with the metric that actually mattered buried on page 27. A well-designed CFO dashboard inverts this: a handful of numbers, each one tied to a decision someone in the room can make.
Start With the Question, Not the Metric
Every KPI on a dashboard should answer a specific question that someone — the CEO, the board, a department head — actually asks. If a metric has been on the dashboard for a year and has never changed a decision or prompted a question, it's reference material, not a dashboard item, and belongs in an appendix rather than the top-level pack.
Four Core KPI Categories
| Category | Key Question | Example Metrics |
|---|
| Liquidity | Can we meet our obligations over the next 13 weeks? | Cash balance, runway (months), 13-week forecast variance, undrawn credit lines |
| Profitability | Are we making money, and is the trend improving? | Gross margin %, EBITDA margin %, net profit vs budget, contribution margin by product line |
| Efficiency | Is working capital tied up efficiently? | Days Sales Outstanding (DSO), Days Payable Outstanding (DPO), inventory days, cash conversion cycle |
| Leverage & Risk | Are we within covenant limits and not over-extended? | Debt-to-equity, DSCR, ICR, undrawn facility headroom |
This four-category structure maps directly onto the ratio families covered in the financial ratio cheat sheet — liquidity ratios, profitability ratios, efficiency/turnover ratios, and leverage ratios.
Leading vs Lagging Indicators
The core design tension: Lagging indicators (revenue, net profit, cash balance) tell you what happened. Leading indicators (pipeline coverage, DSO trend, order backlog) give you time to act before the lagging result lands. A dashboard that is 100% lagging indicators is a rear-view mirror; a dashboard that is 100% leading indicators has nothing to hold anyone accountable to. Aim for a mix.
| Type | Examples | Use |
|---|
| Lagging | Revenue, EBITDA, net profit, cash balance at month-end | Accountability, trend tracking, board reporting |
| Leading | Sales pipeline coverage ratio, DSO trending vs target, order backlog, headcount vs plan | Early warning, course-correction before the period closes |
A Template Structure for the Monthly Pack
- One-page summary ("the scorecard"): 8-15 KPIs across the four categories, each shown with current value, prior month, budget/target, and a simple status indicator (on track / watch / off track)
- Cash flow page: Actual vs forecast cash flow for the period, plus the rolling 13-week forecast update
- P&L variance page: Actual vs budget vs prior year, with commentary only on line items that vary by more than a defined threshold (e.g., ±10% or ±₹X lakh)
- Working capital page: DSO/DPO/inventory days trend, top receivables by age, and any covenant-relevant ratios
- Appendix: Department-level detail, customer/vendor-level detail, and anything else that supports the top-level numbers but doesn't need discussion every month
Common Dashboard Design Mistakes
- Too many metrics: Beyond ~15 top-level KPIs, dashboards become documents people skim rather than discuss
- No targets or thresholds: A number without a target ("DSO is 52 days") gives no signal — "DSO is 52 days vs a target of 45" does
- Inconsistent period comparisons: Mixing month-over-month, year-over-year, and budget comparisons inconsistently across metrics makes trends hard to read — pick a standard and apply it everywhere
- Vanity metrics: Metrics that always look good (e.g., gross revenue without any margin context) but don't inform any decision
Connecting the Dashboard to Forecasting
A dashboard works best when it's not just a historical record but feeds directly into the rolling forecast — variance commentary on the dashboard should drive the next forecast update, closing the loop between "what happened" and "what we now expect."
Frequently Asked Questions
What is the difference between a leading and a lagging KPI? ▼
Lagging indicators (revenue, net profit, cash balance) report outcomes that have already happened and can't be changed for that period. Leading indicators (pipeline coverage, DSO trend, order backlog) predict future outcomes and give management time to intervene. A balanced dashboard uses lagging indicators for accountability and leading indicators for course-correction.
How many KPIs should a monthly CFO dashboard contain? ▼
Most effective dashboards have 8-15 top-level KPIs across 3-4 categories (liquidity, profitability, efficiency, leverage). Beyond that, dashboards become reference documents rather than discussion tools. Supporting detail should live in appendix pages referenced only when a top-level metric flags an issue.
Should the CFO dashboard look the same every month? ▼
The core structure and KPI set should stay stable so trends remain comparable, but the dashboard should evolve when the business changes materially — new revenue streams, a growth phase where leverage matters more, or when a metric stops driving any discussion, which is itself a signal it doesn't belong at the top level.