How to create a CFO dashboard that actually drives decisions

Most CFO dashboards report numbers. Very few drive decisions. The difference isn’t in the software behind it, but in what’s on the screen and how it’s designed: A dashboard that lists twenty metrics without context tells a CFO what happened, but not what to do about it.

For CFOs, FDs and FP&A leaders in UK mid-market companies creating or updating a board-level dashboard, the temptation is to include everything the financial system can produce. The better question is narrower: What does the person looking at this dashboard need to decide, and does each metric help them make that decision?

Key insights

  • A CFO dashboard should lead to a decision, not just report a number. If a metric doesn’t change what someone does next, it doesn’t belong at the CFO level.
  • Five metric categories cover most decisions: cash, revenue by company, pipeline, working capital and deviation from budget.
  • Structure is just as important as content. Trend, threshold and context turn a number into a signal.
  • This is a design problem, not a tooling problem. Depending on how they are phrased, the same metrics can be really useful or really useless.

Each of the following sections covers one of the five metric categories and what makes them actionable, followed by how to structure the dashboard as a whole.

Here’s what we cover:

Why most CFO dashboards don’t make decisions

Operational dashboards and CFO dashboards answer different questions, and many CFO-level reports fail because they adopt the instinct of the operational dashboard: more detail, more granularity, more charts. A department manager needs to see the transactions behind a number. A CFO must see whether the company can make payroll in eight weeks, whether a company is quietly eroding corporate margins, and whether the quarter is planned so well that the forecast remains unchanged.

This is a smaller, sharper set of questions, and a dashboard built to answer these questions will look different than one that shows everything the financial system can produce. The starting point is not a list of available metrics. It’s a list of the decisions the CFO actually makes, processed backwards into the numbers that inform them.

The five key figure categories that belong to the CFO level

Five categories cover most of the decisions a CFO dashboard needs to support. The table summarizes them all; The following sections explain what makes them decision-making, not just informative.

category decision that supports it What makes it decision-making?
Checkout Can we finance the next 90 days without taking action? A progressive view, not just the current balance sheet.
Sales by company Which areas of the company are increasing or hindering performance? Consistent definitions across all entities, no entity-specific interpretations.
pipeline Is it actually likely that the forecast revenue will materialize? Weighted by stage and conversion history, not a raw total.
Working capital Does growth consume more money than it should? Trending along sales growth, not shown in isolation.
Deviation from budget Where does the forecast need to change? Only marked if the deviation is significant and permanent.

Cash: a foresight, not a balance

A single cash balance alone solves almost nothing. What matters at the CFO level is an ongoing review, typically lasting 13 weeks, that shows whether the company can finance payroll, supplier payments and debt service without intervention. The dashboard should also make it clear how current this number actually is: a cash balance that is five days old because the closing price is still catching up is a different signal than one updated this morning.

This is one reason why closing speed is important beyond the finance team. Find out why UK finance teams can’t close faster, even though this usually results in a slowdown.

Sales by company: comparable, not just visible

Once a company operates across more than one entity, total revenue hides more than it reveals. A CFO dashboard requires revenue to be broken down by unit, using a consistent definition of revenue recognition and reporting period across all units. Without this consistency, an entity comparison looks like insight but is actually noise because each entity may report on a slightly different basis.

This becomes more difficult when a group adds units through acquisition or expansion. Check out Multi-Entity Financing: Acquisition and Expansion to learn how these complexities typically arise.

Pipeline: weighted, not raw

The raw pipeline total tells a CFO almost nothing about how much of it is actually converted into revenue. An actionable pipeline metric is weighted by stage and adjusted by segment based on historical conversion rates, so the number on the dashboard reflects a realistic range rather than an optimistic ceiling. If sales and finance don’t agree on what the pipeline is worth, it’s worth bringing that gap to the surface rather than quietly resolving it before it hits the dashboard.

Working capital: opposite growth

Working capital presented as a single number rarely leads to action. As a trend alongside revenue growth, it answers a much sharper question: Is growth consuming a fair amount of cash, or is the company quietly funding its own expansion through slower supplier payments and looser credit controls? A large part of this pressure is initially evident in the processes of accounts payable and accounts receivable.

To learn what working capital strain tends to cause in growing businesses, check out our guides to best practices for accounts payable management and what accounts payable automation actually does.

Deviation from budget: significant and permanent, not in every line

The line-by-line reporting of budget deviations overwhelms rather than informs. At the CFO level, the useful version only flags deviations that are both significant in magnitude and persist for more than one period of time, as a one-off time difference rarely requires board attention, whereas a deviation that increases over three consecutive months usually does.

This is directly related to how the forecast itself is created and managed. Read our budget and forecasting guide for the process behind a trustworthy variance number.

Structuring the narrative, not just the numbers

The same five metrics can be stored as a data dump or as a series of signals on a dashboard, and the difference is almost entirely structural. Three elements transform a number into something a CFO can act on: Trend, so that a single data point runs contrary to its current trajectory rather than standing alone; Threshold, so it is visually clear when a metric has moved from normal to a range that requires attention; and a short line of context that explains why a number shifted rather than leaving the reader guessing.

By integrating reports and analytics into the core financial platform, rather than exporting and recreating them into a separate tool, maintaining this structure consistently is much easier. Learn how Sage Intacct’s financial reporting capabilities and platform capabilities support this type of reporting.

Common mistakes that turn a dashboard into a data dump

Here’s what people do wrong and how to fix the problem.

Mistake fix
Including all metrics the system can produce Start with the decisions the CFO makes and then work your way back to the metrics that inform them.
Displays a number without a trend line Map each number to its current trajectory, not just its current value.
Report variances in each budget line Only mark deviations that are significant and persist over several periods.
Mixing operational and CFO level details Keep departmental granularity out of the equation; link instead of displaying it.
Update on a monthly cycle regardless of the metric Update cash and pipeline more frequently than slower moving metrics such as working capital development.

Final thoughts

Companies that get the most out of a CFO dashboard tend to treat it like a living document that they revise and clean up whenever the questions the company answers change, rather than a template that is created once and left alone.

For a more comprehensive look at finance leaders’ considerations when choosing a platform that supports this type of reporting, see why finance leaders choose Sage Intacct and explore Sage Intacct more broadly.

CFO Dashboard FAQs

What metrics should be included in a CFO dashboard?

Most CFO dashboards are well served by five categories: Cash (a progressive view), Sales by Unit (defined consistently across the group), Pipeline (weighted by stage and conversion history), Working Capital (trending against growth), and Deviation from Budget (marked only if material and persistent). In addition, other metrics should earn their place by supporting a specific decision.

How is a CFO dashboard different from an operational finance dashboard?

An operational dashboard supports day-to-day management, department by department, and typically includes transaction-level details. A CFO dashboard supports enterprise-level decisions and therefore requires fewer metrics, more context per metric, and a structure that highlights what has changed rather than everything that exists.

How often should a CFO dashboard be updated?

Different metrics require different refresh cycles. Cash and pipelines tend to be most useful when updated regularly as they influence short-term decisions, while trend metrics such as working capital or variance from budget are typically reviewed on a monthly or quarterly cycle without losing value.

Why are CFO dashboards often unable to take action?

Typically because they are based on what the financial system can produce, rather than the decisions the CFO actually has to make. A dashboard with fewer, better-formulated metrics, each paired with trends and context, tends to drive more action than one with a larger number of raw numbers.

Browse other topics from this article

Leave a Comment