A four-step framework for CFOs to control AI token costs.

Read Now

CFO Dashboards Masterclass ft. The FP&A Guy

Last updated: November 202661 min watch

Speakers

  • Paul Barnhurst, Founder of The FP&A Guy

  • Kirk Kappelhoff, Senior Director of Strategic Finance, Drivetrain

The CFO has promised the board that churn will drop from 15% to 10% this year. At the quarterly review, he asks which accounts are at risk. Your dashboard tracks every customer you’ve lost, but nothing on it flags the next one. Then the head of Customer Success says her churn rate is three points lower than yours. After 20 minutes of trying to reconcile that, the CFO asks you to “take it offline,” and the meeting ends without any plans for how to keep even a single customer.

Leaders act on financial information when it reaches them with clarity and context.

Paul Barnhurst, founder of The FP&A Guy, learned this the hard way. He explained how when he joined Kirk Kappelhoff, Drivetrain’s Director of Strategic Finance, for a webinar on CFO dashboards.

Paul had spent six months on a project. His leadership team was fully aligned behind it. Then he presented it to the company’s global CFO. Ten minutes into the presentation, the CFO said, "This is a terrible idea. Why would we do this?" Paul was flabbergasted. Then, the CFO brought in the general manager, talked with him for five minutes, and approved the project after all.

Afterward, I asked my boss what happened, and he said: “Paul, your analysis was brilliant, your presentation lacked.” ~ Paul Barnhurst, Founder, The FP&A Guy

Paul had spent so much time on the data that he only shared what he thought the CFO needed, leaving out most of the story behind the numbers. In hindsight, he realized that “too much data, not enough context” is a common mistake. Today, it’s at the top of his list of the mistakes he sees most often, followed by no clear takeaway, KPIs that don’t match the business goals, and dashboards that are overdesigned or underexplained.

His webinar with Kirk is a masterclass in how to avoid those mistakes and how to build a CFO dashboard that a leadership team can act on.

No time to watch? This article walks through the framework Paul uses, with the audience Q&A and the full transcript at the end.

61:22

The short version

An FP&A dashboard built for the CFO and leadership team isn’t worth much if the people reading it can act on what it shows. Here's how Paul's method takes you from a page nobody can actually use to a handful of numbers that support sound decision-making:

The core CFO dashboards: financial and operational

Kirk asked Paul which CFO dashboards every CFO should have as a baseline. Paul said the core dashboards fall into two groups: financial and operational.

The financial side gives the CFO visibility into cash flow and the core financials. The operational side covers sales and marketing, which are critical to nearly every business, along with an expense analysis and operational metrics. Paul added that department-specific dashboards are especially useful when the CFO needs a targeted conversation with one department or FP&A lead.

Kirk then walked through four CFO dashboards in Drivetrain, starting with the 13-week cash flow. He said it had recently emerged as one of the most important dashboards for Drivetrain’s customers for a couple of reasons. One is that companies are concerned about liquidity, and the other is that the view itself is simple, showing forecast vs. actuals and the variance between them. The other three dashboards showed budget versus actuals, the P&L, and headcount.

The mistakes that stop leaders from acting on a dashboard

Choosing the right dashboards is just the first step. Most of the advice Paul offered in the masterclass was about what keeps leaders from acting on them: the “killer mistakes.” The first is what he learned the hard way: too much data and not enough context. Here are the other four, along with Paul’s fix for each.

KPIs that don’t match the business goals

Paul’s starting point is the strategy. Companies typically have OKRs or a few key goals, and the question is whether each metric actually lets you influence them. Dashboards often try to “boil the ocean,” he said, so measure only what can actually be impacted and what matters to the business. If the goal is reducing churn from 15% to 10%, you’d watch NPS and time-on-product

Kirk added that a metric nobody can influence can still live in a report somewhere else.

Once the metrics match the goals, they should last as long as the goals do. Paul counts changing tracked metrics too often as a related mistake.

You don't change strategy and goals monthly, or if you do, you're probably not very successful. Set them for a year, revisit once or twice, adjust as needed.
Paul BarnhurstFounder, The FP&A Guy

Metrics should follow the same discipline, Paul said, so people have time to influence them. “If you picked them for the right reason in the first place, why keep changing them?”

Underexplained numbers

"I'd bet everyone listening has been in a meeting where someone says 'my number's different,'" Paul said. He explained that this happens when the methodology isn't agreed upfront. Paul's fix is a clear explanation of data sources, metric definitions, and visible formulas, so everyone works from the same page. In one of his previous roles, the CFO, CRO, and others couldn’t agree on what a booking was, and that had to be settled before any reporting could proceed.

Paul also said to show actuals beside the budget and latest forecast and the prior period, so it’s easy to see how the business is performing against a target. Last year gives you the baseline.

He said more teams now compare the budget directly with the latest forecast, too. The variance between them shows how far expectations have moved since the budget was set. Tracked over a full year, it helps explain a miss: Was the original budget unrealistic, or was the forecast off?

Overdesigned dashboards

"I've built some horrible dashboards over the years myself," Paul said. The principles he leans on come from Storytelling with Data by Cole Nussbaumer Knaflic: Think like a designer, keep it simple, use contrast effectively, make context clear, and ruthlessly reduce clutter.

If an element isn't adding to the story, it's just adding cognitive load. Every element should justify its presence. If it doesn't add value, the reader shouldn't have to look at it.
Paul BarnhurstFounder, The FP&A Guy

To illustrate the point, Paul put up a screen of digits and asked Kirk how many eights were on it. Kirk estimated that there were sixteen and was way off. The answer was nine, and even confirming it took a couple of seconds. The next version bolded the eights with a bit of shading, which made them much easier to spot. The last one used color, and that was easier still.

Cut anything that doesn't help the reader, and use bold, shading or color only to highlight the numbers that matter most.

No clear takeaway

Paul said a dashboard with no focal point or takeaway is the flip side of having a clear, solution-aligned recommendation.

Kirk made a related point: Storytelling gets skipped a lot, and people just jump into a report and read the numbers off the screen. He then quoted a favorite saying: “Never tell a number without a story, never tell a story without a number.”

Paul pointed to a framework that dates back to the 1970s: “what, so what, now what.” He said most of FP&A is good at the “what,” such as reporting that revenue missed by $200,000 because volume was down. The “so what” is why that matters. The piece people want most is the “now what,” meaning, what are we going to do about it?

The key in "now what" is offering an actual recommendation. Data storytelling in finance is fundamentally about driving decisions, giving calls to action. If all you do is present data, you're falling short on that piece.
Paul BarnhurstFounder, The FP&A Guy

Paul tied the recommendation to the tone you take with bad news. Piling onto bad news doesn’t help anyone, he said, while telling people where things stand and how you plan to address it lands very differently. His overarching rule is to “just tell it how it is.” If the problem is a model error, own it and fix it. A missed revenue target or a department overspend is something finance tracks, and most of the time, it isn’t finance’s fault.

“Our job in finance is to present numbers and own them alongside the business, not "you missed your numbers, what did you do wrong" but "we missed our numbers, here's what happened, here's an issue we found."
Kirk KappelhoffDirector of Strategic Finance, Drivetrain

Getting the dashboard to the people who can act on it

When Paul talked about presenting the right numbers to the right stakeholders, two of his points were about delivery. The right people, meaning those who can actually influence the numbers, need to be the ones looking. And people don't need to see a number a month after it happened. It has to be timely enough to influence what is going on.

People won't look at reports they have to go hunting for; you want to push it to them and alert them to what matters.
Paul BarnhurstFounder, The FP&A Guy

Before a meeting, Paul often sets the agenda and gives* access in advance to the report itself or to the stakeholders who need to understand its assumptions. That way, the story has started before the meeting does, a habit that matters just as much for board presentations.

On cadence, Paul said it depends on the business. "Weekly is often fine; sometimes monthly." He added: "Don't assume everything needs to be real-time. There's a real cost to that."

Answering follow-up questions without leaving the dashboard

Many financial reporting tools offer dynamic dashboards that link the numbers on a dashboard to the detail behind them so a follow-up question can be answered in the same place it came up.

Kirk demonstrated this in Drivetrain’s executive overview dashboard. One click switches the timeframe (last quarter, current quarter, year to date), and every chart updates with it. From a month’s total, you can jump straight to the transactions behind it, then sort, filter, or export them to Excel. Or you can drill down one level at a time, from region to country to individual contracts. Kirk said this bifurcation “is really where the insight lives.” If a number still looks off, a comment box lets you tag a colleague on that chart or cell, and they’re pinged in Slack, Teams or email.

Paul agreed that this is what good drill-down and commenting should look like. Line-item commenting is especially valuable, he said, along with free-form notes, and the view resembles the pivot tables people already know. The easier that is, he said, the easier real analysis becomes.

Dynamics dashboards are just one of a robust set of reporting features Drivetrain offers as a comprehensive, AI-native FP&A platform.

To see how a dynamic dashboard works with your own numbers, book a demo.

Summary

  • Track a few metrics tied to the strategy, with leading indicators first: Choose metrics the people reviewing the dashboard can influence. Set them for the year and revisit them once or twice, so the people responsible have time to improve the results.
  • Agree on one definition for every metric, and show each one against a benchmark: Document the data sources, definitions, and formulas so everyone works from the same numbers. Show actuals beside budget, the latest forecast, and the prior period.
  • Send the dashboard to the people who can act on it, as often as they need it: Flag what matters before you deliver it to them, because people won’t go hunting for reports. Set the cadence by how often they make decisions. Weekly is often enough, sometimes monthly. Real-time has a real cost, so don’t assume every metric needs it.
  • Cut everything on the dashboard that doesn’t help the reader see the point: Remove gridlines, borders, and anything else that doesn’t help the reader. Save bold, shading, and color for the numbers that matter most.
  • Present the numbers as a story that ends in a recommendation: Explain what happened, why it matters, and what to do next.
Summarize with AI:

Questions from the webinar

How do you balance leading and lagging metrics on a sales or revenue dashboard?

Paul said to "start with the leading indicators people can act on, then layer in the lagging metrics that complete the picture," and to keep asking what people actually need to make a decision. On a sales or revenue dashboard, you'll generally want some lagging metrics, since you'll likely need the P&L figure alongside bookings and billings.

How do you get senior leaders to engage with the dashboard?

One principle that has stuck with Paul is BLUF, or bottom line up front. Lead with what people need to know plus any recommendations, then put the detail below. He recounted someone whose monthly Excel reports nobody opened until they led with the bottom line and stopped sending the full report. Then people started asking for the full report.

How should you analyze cohorts?

Paul said cohort analysis is critical, and the key is understanding what actually distinguishes one cohort from another. People often default to date-based cohorts, and that’s fine, but customer size or geography may be the real driver. So, dig into the data, then show the driver clearly.

What do you do when the data says one thing and leadership's gut says another?

Paul quoted the old joke, "in God we trust, all others bring data", but said there is genuinely something to intuition too. Most of the time, lean toward the data, but there are moments where going against it is right. Either way, know when to stop the analysis-paralysis loop: ive yourself a window, say two weeks or forty hours, then make the call.

Speaker spotlight

Paul Barnhurst

Founder of The FP&A Guy

Paul Barnhurst is the founder of The FP&A Guy and a leading voice in the FP&A and CFO Tech space. With over a decade of finance experience across travel, banking, and SaaS, Paul has engaged with 100+ CFOTech companies in the past two years. He’s the host of popular FP&A podcasts, an advisor at Born Capital, and a seasoned trainer and consultant for finance teams worldwide.

Kirk Kappelhoff

Senior Director of Strategic Finance, Drivetrain

Kirk Kappelhoff is a financial modeling expert with a BBA in Finance & Accounting and nearly a decade of experience at Deloitte, EY, and KPMG, where he built models for pre-IPO companies, M&A transactions, and strategic planning initiatives. At KPMG, he led the Business Modeling Services team, specializing in equity stories and financial forecasts that help high-growth companies communicate their value to investors. At Drivetrain, Kirk writes about strategic planning, granular reporting, and modern FP&A best practices for rapidly scaling finance teams.

Ready to start your journey?

Fewer spreadsheets, faster planning, better decisions.

Book a Demo