Will AI Replace Enterprise Performance Management? | David den Boer
from FP&A Unlocked
49m 36s
The debate over the future of enterprise performance management (EPM) software centers on whether AI is rendering traditional tools obsolete or merely enhancing them. While Excel remains a foundational tool due to its universal format and ease of use, AI is dramatically lowering the cost of building custom solutions, enabling companies to create tailored, industry-specific models. Traditional EPM tools face challenges in operational context, accountability, and agility, especially when compared to modern BI platforms like Power BI or Fabric, which offer stronger governance, data integration, and planning capabilities. AI can improve forecasting accuracy and detect human biases, but full automation risks eroding ownership and transparency—making a "human-in-the-loop" model essential. Reproducibility and auditability are critical, requiring deterministic logic and robust data schemas. The future lies not in abandoning EPM tools, but in evolving them through AI integration to support innovation and operational agility. Both sides agree that data literacy and storytelling are foundational FP&A skills. Ultimately, organizations must adopt AI at a strategic pace, balancing innovation with governance, while recognizing that technical adoption is slower than marketing claims—driven by human readiness, organizational culture, and the need for trusted, transparent systems.
I think that with AI the cost to build in the past, you would buy any software package
because the cost to build was prohibitive. You would rather just buy something off the shelf
that just works for a specific purpose. It's supported and you can involve the vendor
in configuration and building out new features and all of that and you knew that by partnering
with the right vendor you were going on this journey and they were going to be investing in their
tool with AI, the bar, the cost of that is lowered to nearly zero and you can build your own.
Welcome to another episode of FPNA Unlocked where finance meets strategy.
On your host Paul Barnhurst, aka the FPNA guy. And each week we bring you thought leaders,
industry experts and practitioners who are reshaping the way we think about FPNA.
Today, I have with me David Denborg. David, welcome to the show. Hi Paul, thanks for having me.
Excited to have you. So just so everybody knows in this episode, David's been dealing with some
voice challenges. So if his voice sounds a little soft or a little scratchy, go with it.
We think the conversation will be worth it. So we're going to record anyway, but just so everybody's
aware up front and you're not wondering what's going on. So David, let's start with how might you give
us a little bit of your background. Tell our audience about yourself and then I'll set up the topic.
We're going to cover today. Sure. Long time ago, I started out as an EPM administrator at a
Fortune 500 company working with a tool that has been bought and sold numerous times now.
And I started out working with a software vendor with a company called
OutlookSoft, which was acquired by SAP to form BPC, one of the leading EPM tools for large enterprise.
BPC has come to the end of its life. And over 20 years ago, I started a consulting practice
called column five. And I also have a software business called Darwin Analytics.
The services side implements EPM primarily for large enterprise. We have a global customer base.
And on the software side, we build some practical solutions that help customers get more value
much easily, much more easily out of EPM. All right, perfect. Well, I appreciate that intro.
So our audience knows we're going to do a little different today. We're going to discuss enterprise
performance management. David's going to kind of take the position of the traditional players in
the space, you know, what's historically been out there, that that's what we need. That's where we're
going. I'm going to argue a little bit toward the AI side and why do we need these tools anymore,
is we see AI continuing to grow. And what we're hoping is you listen to us take each position.
You'll be able to form your own opinions of where we're going. We're not saying one
opinion is right or wrong, but we're going to take these two sides and have a little fun in this
debate. And the right answer is everything I say, just so people know. But with that, before
we get into the EPM discussion, I like to ask every guest this question. So it's kind of my go-to.
What does great F/P&A look like? I think great F/P&A gives you
transparency between the narrative and the details. I feel like some users produce a narrative,
and it doesn't necessarily tie directly the details. I like to see a seamless cascade
from the story down into the numbers as low as you want to go with everything corroborating
that narrative that you've produced. So narrative with the details so you can understand the full
buildup. That's right. And especially if you're looking at predictions or the future, you know,
EPM focuses. There's a lot of consolidation, of course, which has to be 100%. Accurate. We also
talk about the future plans. Where did you get these assumptions from? What is the thinking behind
it? And that has to corroborate as well. Got it. All right. That's helpful. And I can see where
the EPM background comes in because EPM often, you know, the detail has to match the top line number.
Right. At least be directionally accurate. And you have to have show your work behind the story.
Yeah. All righty. So let's jump into this EPM conversation.
So we've been hearing a lot of F/P&A software, SaaS software, EPM software, Excel. They're all dead.
Yeah. I think their death is a bit premature. Yeah. All right. So I'm going to ask kind of share
some of your thoughts there. Why, why do you think we hear that? Why are they not dead? Why is that
a premature statement? Are they dying? Give your take here. I think you're. I've heard Excel is dead
really for over 20 years now. I think, you know, that this tools in the next Excel are Excel on
the web. And yet Excel persists as the common language. I think that's really the need is to have
this common portable format that everyone can understand. It's kind of like this universal
language where one analyst, maybe from a partner, a bank, a customer, produces an output in
some format, hands it off to another group. And they can look at it and see exactly how they got
to the numbers, how it works, where the calculations are, and even inside a company, it's at same
universal acceptance of the same model that makes the most sense. I don't see anything else coming
close to challenging that. And you know, when I look at from my perspective, which might be a bit
unique, when we're implementing a tool, so many of these tools have kind of a proprietary syntax
or interface. It's, if you've been around a long time, you know, you have to ask yourself,
is it worth learning this unique interface? Or should I just do enough to get it into Excel?
And then I can work in my familiar environment. And I think that the greater the Excel compatibility,
lower the bar gets for more people to participate as developers, the more asoteric and specialized
and rare. The skill set is it just alienates users, cuts down on portability, and I don't see it
as adding rival functionality. I've yet to see a tool that has a larger function library
than Excel. There's really no benefit to avoiding Excel. It continues to grow. And if that's the
main output format, then that's pretty strong. Obviously, there's BI tools that have a different
purpose that are also strong and power BI is becoming ubiquitous there, somewhat for the same
reasons as Excel. So those tools are really the toolkit of your average FPNA worker these days.
Okay. So get the argument on Excel. What about the argument that FPNA EPM software is dead?
What's your position on that? I think that with AI, the cost to build in the past, you would
buy any software package because the cost to build was prohibitive. You would rather just buy
something off the shelf that just works for a specific purpose and supported. And you can
involve the vendor in configuration and building out new features and all of that. And you knew
that by partnering with the right vendor, you were going on this journey. And they were going
to be investing in their tool with AI. The bar, the cost of that is lowered to nearly zero. And you
could build your own. You can add your own features. You can do all these these great things that are
really specially tuned to your industry, to your models, to your culture, even. And have that be
exactly what you need. So it's very attractive to say, maybe building my own is something that is
better than buying off the shelf. We don't have to make as many compromises. But on the other
hand, you don't get support and all that. So I think that some companies are concluding that
building a custom solution where it might have been prohibitive before. They're not a software
shop. That's not their expertise. They don't have a huge group of developers sitting around.
That would have made them lean towards buying a product. Now they might be concluding. We'll
just make our own. So I would say that's why they would say it's dead. I know that
Microsoft CEO said a couple of years ago that sass is dead. Add that to the pile of quotes that
we've seen. I'm not so sure. I definitely think there's a place for it. I'm going to take the
different argument here. Let's let's break down Excel first and I'll get to the FPNA software.
The spreadsheet is not dead. I think Excel is dying. And here's the argument. I mean, we
make the spreadsheet ubiquitous with Excel. But it's a 40 year old architecture. It has limitations.
I think we're going to see Quad or ChatGPT or whoever the big anthropic, these big model winners
are released on spreadsheet. They have all the training data. They can copy every formula.
Nothing in the syntax of that formula is proprietary.
where somebody can't just create that we see it all the time in other tools.
They can create a better IDE, they can add like HTML dashboards,
better connectors because they can build it all native versus have to go to a separate
application like Power Query. So I think it's just a matter of time,
tell, especially to get more use to it, it's all right in that
cloud desktop and the cloud code. How about a third button that's spreadsheet and all your
connectors come in and it can allow you to do things switching back and forth easier.
So I don't think the spreadsheet goes away, I think it's a fabulous use case,
but I can easily see one of these AI tools and I wouldn't say easy, it would take time,
but I could see them, I could see them displacing the current version of Excel we have today.
Well, I think there's going to have to be a lot of work done on trust and transparency,
you know, being able to trace precedence and things like that, where you really trust exactly
what's happening with the familiar Excel environment, even though it can be challenging, is
that that level of familiarity and just swapping it out for anything new is going to be meet some
resistance. And I'm not denying that, but I think there's definitely a case to be made where
we could see it being replaced. You know, when it comes to EPM software, where are the
futures going in my mind is again, as long as we can have a governed data layer, we can have
that context, that schema, we can start to build within tools, there's more and more tools coming out
with saying, hey, we're going to manage your vibe coding. I have a friend who built an application
that's designed for finance people to help with the governed and the compliance and the security
and the OAuth all well vibe coding. So kind of checks for all those things and helps make sure in
that environment, you're building something. So, you know, the EPMs are limited in this new
world, I think many of them. And we're seeing them try to adjust that. They're all racing to change,
saying, hey, we're the decision layer, we're the intelligence layer, we have all that finance
context. The problem is the typical EPM doesn't have the operational context. So I think,
you know, you're going to see a governor, a governed layer and more and more AI and some vibe coding.
And I think EPM as it sits today is in trouble. Now, could it adjust? Sure. Will it change? Yes.
Are we seeing, I think, a growth in things like fabric planning? Because they are BI tool with
that semantic layer, kind of the warehouse, that whole thing that all the context is there to be
the decision layer and they're giving you planning on top. I think that grows along with the AI
and the vibe coding. And I think the traditional EPMs, if they don't adjust, start in trouble.
I have to agree with that. I do think that there is also a system of accountability where
as you're making a plan, you're kind of establishing a contract. Often compensation is tied to it.
And all these variables that are being controlled, like these are the assumptions as of the time
that you're committing to deliver whatever KPIs you own as part of your role. That has to be
sort of frozen in time so that I can go back and look at what those assumptions are to be able to
assign who is not necessarily delivering. I'm not saying these other tools can't do it, but as of now,
if you view the EPM function as primarily uploading data or, you know, just getting data into
the database rather than managing those contracts for performance with management and assigning
accountability, I think there's a lot more rigor that needs to be added to the data wrangling that
some of these data platforms like Fabric and even others are making progress. Snowflake is moving
in that direction. Databricks as well. All of them are blurring the lines for sure, but there's more
to it than that. I think EPM platforms have to do more to own the accountability part of it
and not rest on their laurels of being kind of the broadly accepted way of uploading data for
plans. So whoever can expand and own that area better, and I agree, operational data as well is
something that has not traditionally been a strength of EPM. And I know that some of the products are
expanding in that area, supply chain, SNOP, other things that they're doing. Whoever can get that
at one stop shop where you can get a full view of what's driving the enterprise will be very appealing
to the market. Today's sponsor is Linios. Most finance teams I've talked to have built something
impressive in Excel. Real models with years of institutional knowledge sitting in the formulas,
then the data underneath ghost style, the moment someone posts the journal entry, and somebody
spends a morning rebuilding it. Linios provides reporting intelligence by connecting your ERP data
directly to Excel. Reports refresh with current data, your formulas stay exactly as you built them,
and you can trace any number back to the transaction behind it. Everyone works from one version of
the numbers, including whoever is building the board deck. Your team moves from assembling reports
to analyzing them when you leave it to Linios. Learn more at www.insightsoftware.com/linios/solutions/reporting-intelligence.
In my argument here, come on, that is right, so I get it. It'd be great for the EPMs to do that,
but these are all bespoke tools. You've got to implement them. If they're already bespoke tools,
and we can build so cheaply with software now, why not just build a custom solution internally?
You've got great Excel, you've got BI, you've got data warehouses, you can get that governance and
security, why the additional cost and why a dedicated tool with AI and with where we're heading,
I think it becomes much easier for companies to say, it's bespoke, it takes months anyway.
I'd rather just cost me 100, 200,000, why don't I just put that toward developer right my own
requirements and build something internally that I own that's customized to my needs?
Well, I definitely think that there's, you know, it's possible to vibe code anything, as you know,
but I do have a considerable respect for the rigor in the system. The way that auditability is
handled, I think there's something about deterministic engines that are not just logic,
but it's also the mapping and the workflow and other things. You can't just vibe your way through
a planning process that has up to a thousand users collaborating working together. Some of our
customers have that many in different countries with currencies and different gap rules. There's
a lot of sophistication there. I'm not saying AI couldn't do it when you have transparency
questions about how AI gets there and a little bit of hallucination, making a lot of inference-based
assumptions along the way rather than working on static plumbing that has been established.
I think I have way more confidence in the EPM tool getting to a more precise result that I can
rely on than the vibe coded and answer your question about the implementation costs. Yes,
that is a problem. It's not only the cost for the initial implementation, but it's the cost of
ownership and expansion and even switching. It tends to lock customers in that they don't
appreciate, but huge strides have been made adding AI as a configuring agent that
configures these robust platforms that give you the precision, the reliability, the transparency
that the EPM tools are known for, but they give you that AI agility on the initial configuration,
but on the ownership and extension and perhaps switching. If you want to, you know,
my own market that I know very well, BPC is kind of end of life right now, and a lot of my customers
are switching by being able to apply AI to that. We can lower costs and build that independence
so that you can configure something cheaply initially and then adjust it very efficiently over time.
So AI is influencing every step of that process. I think we're both on the same page. There's
no question AI is going to change things. It's a question of how much does it disrupt the market?
And so we'll let our audience decide what they think, but I want to keep going on some other
things around this. We're starting to see more and more, you know, previously we saw some people
doing statistical modeling, machine learning modeling. Now we see, hey, I can give inputs AI and
it can really quickly build a mob. And even before all this, I still remember going to an AFP
conference where Microsoft was sharing, they had done a bunch of statistical modeling on their
revenue. I think they were using it for real estate. It was more accurate than the human.
So why do we continue to need the human to forecast it? Can't we just go to a default where AI
does all the forecasting maybe human reviews it versus it being human-led? What
would your argument be to that? Well, I'm certainly not going to argue that there's
no place for AI. I think the most prudent place for AI right now and I'll go
back to that accountability as long as we have human managers and unless you're
arguing that we don't need people and companies as long as we have people
owning the data and the responsibility to drive these numbers and being held
accountable they have to own the numbers. If you have a black box generating
what your targets are and it's landing in your lap hey this is what you have to
deliver Paul you're not going to feel that ownership that number came from you
where you said proactively I can deliver this number now you're on the hook
and that that accountability is at risk of being lost if we go completely AI. Now
where I would put AI is to challenge those human numbers because part of I think
you know when you say people are involved and it's more accurate there's two
sides to that coin. You have some people that are not incompetent but these are
complex workbooks and concepts and they make it oversight something doesn't get
updated there's just an error there's a darker side the darker side is the
motivation you have the ownership we have people that sandbag forecast they could
deliver a higher number if they stretched but they try to obscure what they can
do set expectations low over deliver so that they get a higher bonus where
have some other motivation and I expect AI to uncover some of those things to
work saying hey you're only putting in two-thirds of what I think you can do
that'll flag to leadership where to press for better performance it will help
that partnership between AI and human motivation elevate the company's
performance that would be a more positive use case I think. So I'll take the
devil's advocate position here you know a lot of studies have shown 50% of
people sometimes even more unhappy with their jobs 20% to 80% of the work we've
all seen the million dollar accelerers every budget and forecast has a
mistake of any in any company of real size so why is it not you know AI
creates it all you give it the inputs you still need that human they review it at
the end but you really remove the human doing probably 80% of the work I
don't I don't think we're quite autonomous I'm not gonna say hey it should be
100% I see no reason AI can't lead it with kind of having what you call the
human in the loop and thus moving much and much more toward an AI there are
some exceptions I'm not gonna I'm not ready to say the robot overlord should
run the whole company I'd love to take that position but I don't think I could
argue I'd be laughing but I'm trying to go as close as I can and I think that's
I think that's where we can go especially in stable mature companies where
there's not a lot of change well when you have a million dollar error on a
spreadsheet today you know who'd hold accountable when who'd you hold accountable
when AI hallucinates and I think you still not willing to find the finance
apartment still has to be accountable so what what kind of control and
transparency do they need to accept that accountability it's not zero but
they know I would agree with that it might be I couldn't argue that one yeah they
might need their own AI that they trust to double check the numbers on their
side it comes out of that transparency I would recommend that every model that's
built you're gonna have some kind of adversarial agent that goes through and
argues against everything that's been built and somebody's gonna need to
review that but I still think you can have AI lead the process in the sense of
doing doing the forecast doing the first round giving you everything there
still needs to be a human in the loop I'm not ready to say we see a lot of
companies claiming hey it's autonomous you don't need anyone involved in a lot
of things right now right we've all heard the autonomous finance I'm not to
that point yet I'm not ready to make that argument for sure I do think you know
you want agility but what is your risk tolerance for that level of agility
because you mean look at the headlines from this week alone and next week
spoiler alert AI is gonna be doing some crazy things with a high degree of
autonomy you know whether it's hacking arrival AI company or it's making
huge errors though we're gonna continue to see that so that human in the
loop that adversarial agent I think for some of the things we're building
building an LLM council that constantly is debating in fact checking and you
know looking for errors and checking for risk that's prudent and I think you
can add that to an EPM solution and get the combination of the ownership the
transparency the boost from AI for agility with the fact checking get that AI
hallucinations as low as possible get the human approvals as high as possible
and move with agility I think it's a combination yeah I was just thinking we
should have agreed to run the transcript for each of our different phases of
our argument through like three different LLMs and let them grade and see who
the winner is might have to do that on the back end just for fun okay do I get to
pick which one you're picking me out of the LMs I'll run the trend all right I
want to I want to provide my own prompt if that's all right oh I'm not sure you'd
get to do the prompt look when you're talking about planning there's gamesmanship
do you think that AI will ring out gamesmanship I don't think so I think I was
planning on gaining it with my prompt what are you kidding exactly all right so let's
talk I think some of the other areas that we're seeing a lot about so we've
obviously covered AI versus human everything is dead arguments let's talk
reproduce reproducibility this is a big thing we hear we hear the audit trail
all these discussions around it and it's one of the biggest arguments you
hear for the traditional players hey there's governance and there's auditability
and traceability so kind of what's your what's your what's your position there
talk to that well it comes down to this deterministic versus probabilistic if
you rely 100% on inference then you have a problem you can have two users asking
the same prompt getting different answers because you know it's opaque what
the assumptions are on either side you have to control it and I think you have
to not leave to inference things that are known so whether it's a formula that's
the most obvious example where a times b equals c you don't ask AI hey what
happens if I change b well if you run through a calculation engine you should
do that that's reproducible but then you get another areas where deterministic
concepts also apply mapping of dimension members workflow validation certain
things that need to be done that can be rules based and reproducible precisely
every time I think what you have to have is removing as much of that from the
inference engine and doing it in a very deterministic way for that
reproducibility and precision and I think that over time you're going to see AI
generating that deterministic rule on the fly and it'll make the decision that
you've asked me like five questions and you know four of them are the same I'm
just going to create a rule I'm going to run that rule for reproducible and
transparent execution of that same question in the fifth case I don't have
you know softer I don't have all the data that I need I'm going to run it
through the inference engine I'm going to tell you that I'm going to tell you
that I used AI to generate this one so it might not be exactly correct yeah I
think on this reproducibility I 100% agree with you that AI is going to write
deterministic we're seeing it today you know I'll I'll share an example it
did some training this morning with a company in Germany and shared an
example of I ask cloud to help me build something and it went through and said
hey for this I'm going to build Python script that's basically a
deterministic rule it's running the exact same thing every time it said that's
how I should do it it created a you know it's skills file but both reference
files that it asks you were scripts and they were Python scripts and so I think
we're already starting to see that so I think the reproducibility you know the
audit trail all this argument that it can't be transparent quickly going away I
think the key is if you want to have AI that's reproducible that's transparent
the logs you need to build that into how you build your agents and more
importantly well I'd say two there's three things you need to build that into
how you build your agents you need to build in deterministic to it
and you need a good data and schema layer.
If you do those three things,
I think you can get the reproducibility out of AI,
and you can get it close enough
that the cost savings and everything's a pretty worth,
not have to have maybe all the tools you have today.
Time will tell.
- Sure, you can reduce the tools,
but when you get into multi-user,
how do I know that your Python script
is gonna be called by some user in Australia
when they need the same answer?
I need that schema is gonna have to know where to find
that script.
And I think that's where the EPM tools have a strength.
They're designed for multi-user,
and it's regardless of how many users you have,
or where they're located,
or what the assumptions the same script's gonna run
in a very consistent way.
I think unless you have your AI,
it's gonna work great for one person,
but when you have it set up for multi-user,
you're gonna have to have more sophistication
than is averagely available today.
- I mean, you could have org-level skills,
and that could be a challenge,
but I think we'll get there.
I think it's where we're heading.
- You can engage closely close
to building your own platform then.
And it needs a lot of thought
to get that level of accuracy,
and I think the EPM tools delivered today.
- But I like building.
- That's you.
I think some customers would prefer for it to just work,
but yeah, that's built in.
- I can't even argue with that one.
I'll give you that one.
Score one for David there.
So the reproducibility is an interesting one.
All right, so a couple other areas,
and then we'll kind of, we're gonna wrap this up
with some thoughts in general.
So next position we're gonna argue about here is,
this whole idea of cost of change,
kind of moving fast versus slow,
is my position here is companies can't afford
not to be moving fast in this environment.
They're gonna get left behind.
EPMs are a lot of big companies that often move slow.
So I think the more and more you adopt AI,
the better off you're going to be,
to prepare yourself for the future,
and sure there might be a little bit of pain along the way,
but there always is with adoption.
That's just life.
So what's your argument to that?
Today's episode is brought to you by our sponsor, Linios.
Linios brings live ERP data directly into Excel,
allowing your team to build reports with fresh data.
No still files in sight.
More on that in a few minutes.
- Well, I'm not gonna argue for pain.
I will, I agree.
I think there's more to it when you talk about large enterprise,
and I don't wanna alienate any of my partners,
but I think that companies that have traditionally
relied on a high cost of change as a moat
to lock people in to a particular stack,
are gonna be most under attack.
Customers have never appreciated that.
Never felt that being held hostage was to their advantage.
And the more that companies have policies
that penalize companies for experimenting
on the outside and moving data that they should own
outside of that stack to experiment,
I think they're gonna get backlash.
And I think that's already started to happen.
I've seen AI definitely play a role with MCPs
and other connections that allow for flexibility.
But here again, the openness, plus AI,
inevitably will lower those switching costs
and will enable what I would call innovation agility,
which is a new skill that companies need to embrace
via AI.
In the old days, it would take six months or a year,
sometimes longer to implement an EPM and forget EPM.
It's just, let's say implemented change
in your finance process.
And you'd have this long process to implement it.
And I would argue that there's a long tail effect
where because it's changed, all the people
with their manual process had years to adapt
and get to the level of proficiency
for more than, wherever they came from,
whether it's Excel or a different version of an EPM tool.
Three-year adoption and proficiency cycle is intolerable now.
They need to have the ability to change much faster
and get to a level of proficiency within months
or even faster.
And I think that companies that, in the past,
would measure value based on operational agility,
automated, how many manual hours are needed
to execute a process are going to shift
and look at innovation agility,
where they say, I want to experiment with a new AI
that maybe I built.
I want to replace part of the process with something
and see if I can't speed up a painful aspect
of our process that handles it with more autonomy,
more agility and moves faster.
And I think once you understand that,
there's no argument for standing still
and staying on the sideline.
I think what gets in the way is the people.
You said 20% to 80% of the work.
I don't know that organizations are ready
to start calling the 80% of the people
that are delivering only 20% of the work
and relying heavily on AI.
But inevitably that's coming.
- So I say to that 80%, just keep pushing AI
for some long.
I mean, change is about technology.
And the reality is the cost to do nothing is too great.
Everybody hated the lock-in.
Everybody hated when you felt you had your strong arm
by the vendor I worked for a company
where we had a, I won't name the tool,
but insert big finance tool here, mitigation strategy.
The goal was to get ourselves completely off their tool.
We didn't quite accomplish it,
but it was because of the way they worked in this case.
And so just deal with a little bit of the challenges
in the pain and start adopting more and more
and as much AI as you can.
Make sure you have that good data layer,
you have a good context layer and start automating.
So that's what I'll say there on the change.
And I think in the long run it will pay for yourself,
but I can't, I'd be naive to say
there won't be bumps in the road.
There's gonna be bumps in the road if you go slow.
So why not just break a few eggs along the way and get there?
- That's kind of like up to each organization
with the risk tolerances.
And I don't think the answer is make no change
but the pace of change has to be an alignment
with their culture.
And but change is inevitable.
AI is inevitable and moving in that direction,
relying on highly governed AI, highly embedded
and maybe a familiar EPM tool that provides the audit
and all that, that's right for some personalities
of an organization.
And the Wild West with vibe coding
is maybe more acceptable in other organizations.
- We all romanticize the Wild West.
So why not just continue?
- I can think of a lot of million dollar spreadsheet errors
that are the downside of that Wild West.
- All right, so we've both taken a different position here.
And so we're gonna kind of wrap this up by talking about
a little more what I say a little more nuance.
I've been very much AI, AI, AI, AI.
David's probably been a little more nuanced
in his arguments here than I have.
So where does the crossover sit?
Let's just talk for a minute.
Ignore the positions we've taken.
I'd love to get your take.
I'll share mine and we'll wrap up here.
How should people, from your view,
how should they be thinking about AI, EPM software?
How do you think that sweet spot comes together?
- Well, I think that there have always been
something that bothered me about EPM
is when you lay out an ideal, say on the services side,
here's the ideal project with finance transformation
on implementing the tool with maximum automation,
training, support, all this.
You present that to the customer and the customer
gets out their red pen, says, okay, let's take this out,
let's take that out, let's cut these corners.
And inevitably, that would reduce the value that they would get.
I think at a minimum, AI allows us to not cut corners
and implement things the way they always should have been.
And I think that, if you accept that,
you would say that EPM by itself in its current state
is not something to be protected and unquestioned
that I wanna replicate what I'm doing today in AI
and replace it.
I think that there's a much higher level of proficiency
That is available now because of AI, even with this.
than EPM tools.
You mentioned statistical modeling,
and you talk about the depth of modeling,
most companies don't do that.
Most companies are just doing basic financial statement,
production, even now, even with EPM tools
that are capable of a lot more sophistication.
So let's use AI to expand the value
with the tools that you have as a starting point.
Before we start talking about switching,
switching to AI to me is often replicating the status quo.
The status quo is a product of corners that have been cut
and opportunities that have been missed.
So I think you gotta look at what is truly possible,
where to apply AI to get to a higher value state,
more agility, I mentioned operational
and innovation agility.
And then to decide how am I gonna get their best?
Is it by more fully exploiting the tools I already own
or could easily acquire?
Or is it something I need to build?
Or do I add something to the layout on the outside,
maybe with an MCP working to configure
and connect and orchestrate multiple components?
And I think that's what each organization needs
to understand.
Great points. And you know, as I think about this,
obviously I've argued all AI,
I think the EPMs are adjusting.
I think we're going through a changing time.
I think that data layer becomes more and more important.
I think small businesses in all honesty,
they'll be able to push out when they need a tool longer
and longer with AI, with Excel agents,
with ERPs that are much better at consolidation
with these newer ERPs and accounting tools
that are coming out.
I think it gives you more of a runaway before you need one.
Really large companies, the calculation,
the context, the governability, I think it's still needed.
But the tools are going to have to figure out
how to be more operational.
It's why we're seeing things like fabric planning,
K4 analytics, a lot of BI tools
that sit in the warehouse.
I'm seeing more and more tools designed
to be that government slayer.
And we're seeing things get combined.
And if the tools don't adjust, they're going to die.
I know one tool we just interviewed
a company comes out on future finance
will actually be out before this one.
So if you want to listen to it,
go listen to the CEO of Farsir.
Where their goal is, hey, we want our customers
to be able to build their own software within our tool.
And it's an EPF.
They're basically saying, we're going to open it up,
the JavaScript, we're opening it up to SQL,
and the technical people, you go build what you want.
We're going to give you the modularly picked ability
to have people build ESG solutions and other things.
And I think we'll see more of that.
So I think it's a blend and that context and schema
is going to be more important than ever.
So I think we're in a similar spot.
I don't think either of us honestly think it's all AI,
or that the EPMs are dead.
If the EPMs don't adjust, they will die.
I think we could both agree on that.
I think we both agree AI is not going anywhere.
I think the final thing that's critical all this,
the technology's moving much faster than the people.
You go to LinkedIn and you get this idea
that everybody's automating everything.
And that's just BS.
That's a bunch of marketing hype.
I do training.
And the reality is a lot of people,
oh, you could do that with AI.
Oh, I should be doing more than prompting, like agents, skills.
Most people are here at the beginner level.
The marketing's over here almost beyond what the tool could do.
And it takes time to move.
The prime example I give excels the default spreadsheet
in the world has been for 30 plus years now.
And yet, power core has been out for 15 years
and maybe 10% of people use it.
Fabulous tool.
The adoption rate's been horrible.
Yes, AI's quicker.
But this idea that I see people, we're
going to fire 50% of all people.
And everybody's going to be autonomous AI in 18 months.
Nothing moves that fast.
Are you kidding me?
These are big, huge organizations.
So I think we can both agree, there's time.
But don't just sleep on AI and think,
I don't need to change my tech stack.
I agree with a lot of that.
I do think you're touching on something
about ripping and replacing.
And are you better served by a monolithic tool or approach?
Or are you better served by phasing in, starting out
hybrid, phasing it in, and orchestrating
or connecting these various components?
I think that's what's more likely to happen.
And over time, AI will continue to expand.
And the tools will get better, obviously.
So I think everyone has to have an AI strategy
as far out as they can see, which might be six months.
And things are changing very quickly.
No question I think everybody has an AI strategy.
I think AI adoption should be owned by the CFL.
I agree with Glenn Hopper, his new book comes out arguing that.
We won't get into that today, but another episode we just did.
And so I think that's a fascinating subject.
But as we wrap up here, we just have a few minutes left.
I ask every guest these questions.
So just looking for some short answers,
kind of one, two sentences, why?
What do you think is the most important technical skill
in FPNA professional needs?
I think you have to understand the data.
It's something about almost like SQL skills,
but understand where data comes from and how to manipulate it.
A foundation of data, how it works, what good data
normalization is.
Do you have to be an expert in SQL?
No.
Do I think it's helpful to learn?
I think everybody should understand the basics.
I do.
So if I had to give an answer, that's where I'm at now.
It's data.
I would agree with you.
My data background has been incredibly helpful.
I usually don't give my opinion.
But I figure I'll agree with you on one here.
All right.
Take it.
What is the most important soft skill?
Well, I have to agree with you on this one.
I think you hit this off in a storytelling
where you have to create a narrative out of the numbers.
You can't start out by reading every line of a report.
You have to make it say something and have a point
and call out, what is this data telling me to do?
What action is this telling us to take?
Storytelling is always an important one.
It's definitely at the near the top of my list.
All right.
This one I thought I'd ask you since we have an EPM
specialist here, what's the number one thing
an FPNA professional should do in order
to have a successful implementation?
I think they should gather a wide variety of opinions.
And that could be AI.
That could be interviewing number of vendors.
Could be interviewing customers.
Could be attending a conference.
For example, like our EPM summit.
But the more you know, the more equipped a buyer,
you can be a lot of people have agendas.
That should not be a surprise.
And vendors want to lock you in.
They want to convince you.
Their tool is the end all be all
and the more breadth of opinions that you have,
more your aperture opens up.
And that's only going to serve you better.
And where I want to finish is you have a big conference
coming up in November.
We're recording this in September.
It'll be released in October.
But tell people what the conference is,
how they can learn more about it.
If they want to attend, you have an Invagus and EPM conference.
So go ahead and take a moment and tell us about that.
Sure, it's the EPM summit.
You can read about it at epmsummit.com.
And it's the largest gathering of EPM tools
with the most in-depth agenda.
We have hands-on.
We have panels with multiple vendors on the stage
at the same time.
We have over 120 sessions.
So if you want that combination of breadth and depth
for this technology, which is obviously a hot topic,
and to see how it's evolving with AI,
whether you're moving away from an older tool,
like BPC or Hyperion, or you just want to know
what's available out there.
It's the best place to come to get educated
and inspired in this area.
Yeah, and anyone who's listened to this episode
have been listening to prior ones.
You probably heard some of my ads about that.
So go ahead and check out EPM summit.
I think it'll be a great event.
You'll learn a lot there.
And David, thank you for joining me.
I've enjoyed our chat and getting to spend some time with you.
Thank you so much, Paul.
Thanks for having me.
That's it for today's episode of FPNA Unlocked.
If you enjoy FPNA Unlocked,
please take a moment to leave a five-star rating and review.
It's the best way to support the FPNA guy
and help more FPNA professionals discover the show.
Remember, you can earn CPE credit for this episode
by visiting earmarkcpe.com downloading the app
and completing the quiz.
If you need continuing education credits
for the FPAC certification, complete the quiz,
and reach out to me directly.
Thanks for listening.
I'm Paul Barnhurst, the FPNA guy.
And I'll see you next time.
[BLANK_AUDIO]
Podcast Summary
Key Points:
Excel remains a vital, portable tool due to its universal acceptance and deep integration into financial workflows.
AI is reducing the cost and complexity of building custom solutions, making it more attractive than buying off-the-shelf EPM software.
Traditional EPM tools are under pressure due to lack of operational context, poor accountability, and limited agility in planning.
AI can enhance forecasting and uncover human bias or underperformance, but full automation risks losing ownership and accountability.
Reproducibility and transparency in AI models require deterministic logic, strong data governance, and clear audit trails.
The future of FP&A lies in a hybrid model
Organizations must move faster in adopting AI to avoid being left behind, especially in large enterprises with high switching costs.
Data literacy and storytelling remain essential skills for FP&A professionals, regardless of tool evolution.
Summary:
The debate over the future of enterprise performance management (EPM) software centers on whether AI is rendering traditional tools obsolete or merely enhancing them. While Excel remains a foundational tool due to its universal format and ease of use, AI is dramatically lowering the cost of building custom solutions, enabling companies to create tailored, industry-specific models. Traditional EPM tools face challenges in operational context, accountability, and agility, especially when compared to modern BI platforms like Power BI or Fabric, which offer stronger governance, data integration, and planning capabilities.
AI can improve forecasting accuracy and detect human biases, but full automation risks eroding ownership and transparency—making a "human-in-the-loop" model essential. Reproducibility and auditability are critical, requiring deterministic logic and robust data schemas. The future lies not in abandoning EPM tools, but in evolving them through AI integration to support innovation and operational agility.
Both sides agree that data literacy and storytelling are foundational FP&A skills. Ultimately, organizations must adopt AI at a strategic pace, balancing innovation with governance, while recognizing that technical adoption is slower than marketing claims—driven by human readiness, organizational culture, and the need for trusted, transparent systems.
FAQs
Excel remains highly relevant due to its universal acceptance, portability, and familiarity. It serves as a common language for analysts and teams, allowing seamless collaboration and transparent data tracing. While AI tools may enhance its capabilities, Excel's flexibility and widespread use ensure it will continue to be a core part of FP&A workflows.
Traditional EPM tools are not dead but are facing significant pressure. They are being challenged by AI-driven tools and platforms that offer better agility, automation, and customization. However, EPM tools still hold strengths in governance, auditability, and multi-user consistency, especially for large enterprises with complex financial processes.
AI can automate and accelerate forecasting but cannot fully replace human oversight. Humans are essential for accountability, ownership, and detecting errors such as sandbagging or data manipulation. A human-in-the-loop approach, where AI generates forecasts and humans review and validate them, is more reliable and responsible.
Understanding data—such as data origins, manipulation, and normalization—is one of the most critical technical skills in FP&A. While deep SQL expertise isn't required, a foundational knowledge of data structures and operations enables professionals to build accurate, transparent, and reliable financial models.
FP&A professionals should adopt AI strategically, not universally. They should evaluate whether AI can enhance existing tools or solve specific pain points like forecasting, reporting, or model development. A phased, hybrid approach that combines AI with current tools ensures agility, transparency, and control while minimizing risk.
Storytelling is crucial. FP&A professionals must translate complex data into clear, actionable narratives that guide decision-making. This involves identifying key insights, explaining trends, and recommending actions—ensuring stakeholders understand the 'why' behind the numbers.
Chat with AI
Loading...
Pro features
Go deeper with this episode
Unlock creator-grade tools that turn any transcript into show notes and subtitle files.