The Monthly CEO Dashboard: 12 Financial KPIs That Matter
Most chief executives I work with receive dozens of pages of monthly reporting and finish none of them. This note proposes a single page instead: twelve indicators with formulas, warning thresholds and management interpretation, all derivable from data that any ordinary accounting system already holds.
The rule to apply before choosing any indicator
A good KPI has three properties: it can be calculated from data you already have, it is influenceable by the management team, and it is tied to a specific decision. An indicator nobody can move is not information; it is anxiety. So keep the list short, and for each one write down what happens, and who does it, when the threshold is breached.
The twelve, in one table
| # | Indicator | Formula | Warning sign |
|---|---|---|---|
| 1 | Real revenue growth | Nominal growth less price and inflation effect | Volume falling while value rises |
| 2 | Gross margin | Gross profit divided by revenue | Two consecutive periods of decline |
| 3 | Operating margin | Operating profit divided by revenue | Gap to gross margin widening |
| 4 | Days sales outstanding | Receivables divided by daily revenue | Exceeds the credit terms you granted |
| 5 | Days inventory outstanding | Inventory divided by daily cost of sales | Rising while sales are flat |
| 6 | Days payable outstanding | Trade payables divided by daily purchases | A sudden drop, signalling supplier pressure |
| 7 | Cash conversion cycle | Indicator 4 plus 5 minus 6 | Three consecutive months of increase |
| 8 | Operating cash flow | Cash generated by operations in the month | Negative in a profitable month |
| 9 | Quick ratio | Current assets less inventory over current liabilities | Approaching one |
| 10 | Debt to equity | Total liabilities divided by equity | Growing faster than profit |
| 11 | Break-even and safety margin | Fixed costs divided by contribution margin | Safety margin below ten percent |
| 12 | Budget variance | Actual less budget divided by budget | Variance beyond your agreed tolerance |
The profitability group
Real revenue growth
In an inflationary economy nominal revenue growth is almost always positive, which makes it almost meaningless. Put three columns side by side: value, volume and average price. If volume is falling while value rises, you are losing market position, not growing.
Gross margin
This is the mirror of pricing accuracy and cost control. A gradual decline usually has one of three causes: input price increases not passed into selling prices, higher scrap and waste, or an error in the costing model itself. The correct method is covered in the note on product costing for manufacturers.
If inventory is carried at historical cost during a period of rapid inflation, gross margin will look better than reality. Profit that comes from holding inventory as prices rise is not operating profit and will not repeat.
Operating margin
The gap between gross and operating margin is the cost of your structure. If that gap is widening, the problem is not in production; it is in administrative and selling overhead.
The liquidity group
Cash conversion cycle
In my view this is the single most valuable number on the page. It tells you how many days your cash is trapped in the operating cycle. Shortening it is equivalent to raising interest-free finance; lengthening it starves even a profitable company. Practical ways to compress it are in the note on cash flow and working capital.
Operating cash flow
Profit is an accounting opinion; cash is a fact. If a company reports profit for several months while operating cash flow stays negative, then either receivables are not being collected, or inventory is accumulating, or the profit is not real. Investigate in that order.
Days sales outstanding
Always read this alongside an aged receivables report, never alone. An average of forty days can be produced by most customers paying in ten days and one balance sitting at three hundred. The management response in those two cases is completely different.
The risk group
The quick ratio and debt-to-equity are the two standard guards on financial structure. For Iranian companies I add a third that textbooks rarely mention: revenue concentration, the share of sales taken by the largest customer. If one customer represents more than a third of revenue, no set of healthy ratios compensates for that exposure.
Seven steps to build the dashboard
- Fix a monthly close date; without a disciplined close, no dashboard is reliable.
- Document the data source and the responsible person for every indicator.
- Set thresholds from your own history, not from textbook numbers.
- Show three comparisons: budget, same period last year, and the twelve-month trend.
- Write one sentence of interpretation per indicator; a number alone produces no decision.
- Publish by the tenth of the following month; an accurate report that arrives late is useless.
- Review the list quarterly and delete indicators nobody has acted on.
Apply the one-page, ten-minute rule: the dashboard must fit on a single page and let the CEO read it and ask three good questions within ten minutes. Anything beyond that is an appendix, not a dashboard.
The prerequisites people skip
A dashboard is the output of an information system, not a substitute for one. If the monthly close does not happen, cost centres are undefined or inventory is never counted, the indicators will still produce numbers — they just will not describe reality. Fix the close, the chart of accounts and the count first. The statement-reading fundamentals behind these ratios are in how to read financial statements.
Key takeaways
- A good indicator is influenceable and tied to a specific decision.
- Never interpret nominal growth without looking at volume.
- The cash conversion cycle carries the most information per number.
- Reported profit alongside negative operating cash flow always needs an explanation.
- Without a disciplined monthly close, a dashboard produces numbers but not insight.
Frequently asked questions
How many KPIs belong in a monthly report?
Which single KPI matters most in an inflationary economy?
Why is revenue growth misleading on its own?
What should KPIs be compared against?
Have a question? Just ask
One short call is usually enough to know where you stand. If I miss you, I will call back.