Go back

Will AI Replace Enterprise Performance Management? | David den Boer

from FP&A Unlocked

49m 36s

Will AI Replace Enterprise Performance Management? | David den Boer

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.

Transcription

7895 Words, 42967 Characters

English
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:

  1. Excel remains a vital, portable tool due to its universal acceptance and deep integration into financial workflows.
  2. AI is reducing the cost and complexity of building custom solutions, making it more attractive than buying off-the-shelf EPM software.
  3. Traditional EPM tools are under pressure due to lack of operational context, poor accountability, and limited agility in planning.
  4. AI can enhance forecasting and uncover human bias or underperformance, but full automation risks losing ownership and accountability.
  5. Reproducibility and transparency in AI models require deterministic logic, strong data governance, and clear audit trails.
  6. The future of FP&A lies in a hybrid model
  7. Organizations must move faster in adopting AI to avoid being left behind, especially in large enterprises with high switching costs.
  8. 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.