For all the talk about digital transformation, AI and real-time decision-making, many finance functions are still running on an operating model built for a simpler business. From annual budgets and static forecasts, to month-end reporting and manual reconciliations, many companies still operate using multiple spreadsheets, and therefore multiple versions of the truth.
Finance has spent years trying to make spreadsheets smarter. They have added more formulas, tabs, controls, and macros, but this hasn’t translated into better performance. The more fundamental question is whether spreadsheets remain fit for purpose as businesses become more complex, interconnected and dynamic.
Spreadsheets are useful analytical tools, but when they become the glue connecting planning, forecasting, workforce modelling, scenario analysis, capital expenditure and performance reporting, problems start to emerge. Data becomes harder to keep consistent, processes become disconnected, and governance and decision-making become more difficult. What looks like flexibility can actually become infrastructure debt, adding complexity and making it harder for the organisation to plan effectively, adapt to change and make timely decisions.
Plan for possibilities
The traditional finance cycle was built around relatively predictable questions like what happened, why it happened, and what will happen next. Those questions still matter, but today’s leadership teams increasingly need answers to much more dynamic, and specific, questions. If answering those questions requires the finance team to disappear into Excel for three weeks, something is fundamentally wrong, because by the time the answer arrives, the question may have changed.
This is where Enterprise Performance Management (EPM) changes everything. EPM is often sold as a better way to budget, consolidate and report, and while that’s true, it’s not the most important reason to invest in it. The real value lies in the fact that EPM can change the role finance plays in the business.
EPM shifts finance from gathering and reconciling numbers to connecting financial and operational planning. It moves forecasting beyond a single expected outcome to modelling multiple scenarios. Rather than simply reporting what happened last month, finance can help management anticipate what lies ahead. Most importantly, the budget becomes a living model that evolves with the business. Rather than being viewed as a fixed commitment.
A connected EPM environment can bring together the drivers that actually make the business move. When those drivers are connected, a change in one assumption can expose its consequences elsewhere. The model starts behaving more like the business, and suddenly, planning becomes less about producing a number and more about understanding the consequences of a decision. In other words, EPM can turn uncertainty into something the business can work with to make it better prepared for different futures.
Stop explaining performance. Start shaping it.
AI is now central to the conversation about finance transformation. Organisations want to know how it can make their finance functions more efficient, effective and forward-looking, but AI is only as effective as the foundations it builds on. It can’t compensate for fragmented processes, disconnected data or a finance function that lacks the structure to support it. In fact, AI often just makes a broken process faster.
When EPM creates a more connected performance architecture, AI has something useful to work with. It can identify anomalies, explain variances, recognise patterns, generate forecasts, test scenarios, and highlight risks.
With EPM and AI becoming more mainstream, finance now has a choice. It can either remain the organisation’s historian, explaining variances, producing reports, and defending the budget, or finance can become the organisation’s performance engine. It can model decisions, challenge assumptions, connect strategy to financial outcomes, and help the business decide what to do next.
However, technology alone won’t allow for this kind of transformation. The organisation’s finance architecture should also reflect the complexity of the business. When a business evolves but its planning processes remain unchanged, strategic decisions take longer than they should. Changing a single assumption can mean rebuilding multiple models, and in many companies, finance spends more time reconciling numbers than interpreting them.
Modern businesses need to move beyond finance models built for a slower, more predictable era to a finance function designed for the complexity, pace and demands of business today. A modern finance function needs a connected environment where data becomes insight, insights become scenarios, scenarios become decisions, and decisions become measurable performance.
