a
Article · Finance Systems

The Shadow Spreadsheet
Problem

Why FP&A teams quietly abandon the systems they just bought, and what actually changes the outcome.

Finance Systems xP&A & FP&A 8 min read
Decision Inc.
Andrew Jerogin
Engagement Manager, Decision Inc.
45%
of FP&A time still consumed by low-value data collection and validation
73%
of finance professionals cite leadership and culture as the primary driver of successful change
30%
of organisations have not upgraded their planning systems in over five years
100%
Still use spreadsheets quarterly
11%
Achieved full planning integration

Six months after go-live, most FP&A transformations look successful on paper. The new planning platform is live. Every department has access. The steering committee has moved on to the next priority. Then a forecast cycle comes around, and a familiar file reappears: a spreadsheet, built by someone on the FP&A team, sitting outside the platform, quietly doing the job the platform was bought to do.

01

A Familiar Number

The 2025 FP&A Trends Survey, drawing on responses from finance professionals across 56 countries, found that just 31% of FP&A time is spent on high-value activities such as analysis and decision support. Nearly half of all FP&A time, 45%, is still consumed by low-value data collection and validation. Only 18% of FP&A teams describe themselves as demonstrating strong performance. These figures have not meaningfully shifted in three consecutive years of the same survey, despite sustained investment in planning technology.

Separately, the Association of Finance Professionals confirmed in 2025 that 100% of FP&A professionals still use spreadsheets for planning and reporting at least quarterly. New platforms have gone in. The spreadsheet has stayed.

That gap between investment and behaviour is the shadow spreadsheet problem. The system changes. The work doesn't.
02

Why the Spreadsheet Wins

A planning platform asks people to give something up: a familiar tool they fully control, in exchange for a shared system they have to trust. That trade only holds if the new system is faster, clearer, and more reliable than what it replaced, in the exact moment someone needs an answer. If it isn't, the spreadsheet comes back.

01
The Confidence Gap

A business manager who isn't fully sure how a number was calculated in the new system will rebuild it themselves before presenting it to their leadership. This isn't obstruction, it's risk management. People protect themselves when they don't trust a black box. Gartner's Q2 2026 CFO Report identifies finance data reliability as one of the top three concerns facing CFOs right now, precisely because the platforms are in place but confidence in what they produce has not followed.

02
The Speed Shortcut

If getting an answer from the new platform takes longer than calling someone in finance directly, people will keep calling. Every successful workaround reinforces the belief that the official process is the slow path. Research from Empyrean's 2025 Bank Risk and Performance Survey found that while 74% of institutions say they collaborate on shared planning assumptions, only one in three have the tools to fully integrate those processes, alignment in principle, fragmentation in practice.

03
The Edge Case Excuse

Every business unit has a scenario the standard model doesn't quite handle well: an unusual cost centre, a one-off project, a non-standard reporting line. Rather than raise it and wait for the platform to be adjusted, someone builds a spreadsheet to cover the gap. That spreadsheet rarely gets retired once the edge case is resolved.

04
The Ownership Vacuum

When no one is accountable for the platform's accuracy and usability after go-live, the responsibility quietly reverts to whoever can fix the problem fastest, which is usually the person with the spreadsheet. McKinsey research into financial services organisations found that even two years into a centralisation effort, businesses continued to carry shadow resources at sizes up to 1.3 times the centralised team itself.

Finance planning and analytics
03

Why This Stays Hidden

Shadow spreadsheets are difficult to see in the places leadership usually looks. Adoption dashboards show login counts and module usage, not whether the numbers inside the platform were actually trusted enough to be used unedited. A business manager can log into the new system every week and still build their real forecast in Excel beside it.

The 2025 FP&A Trends Survey found that 77% of teams using dynamic or fully driver-based models rate their forecast quality as good or great. Only 27% of teams using basic or no models say the same. Yet a record-high 30% of organisations reported not having upgraded their planning systems in over five years. That combination tells the real story: the gap between teams with genuinely adopted systems and those still running on parallel spreadsheets is widening.

This is why so many transformations are reported as successful at the 90-day mark and then quietly slide backward. Adoption isn't measured by who logged in. It's measured by who stopped maintaining a parallel version of the truth.
04

What Changes the Outcome

The organisations that avoid this pattern don't rely on a stronger go-live message. They redesign the conditions around the platform so the spreadsheet has nothing left to offer.

Build trust into the model, not just the training

Finance teams that bring business managers into the design process, not just the rollout, end up with a model those managers actually believe in, because they watched it get built and had input into the assumptions. A 2025 FP&A Trends webinar survey of more than 360 finance professionals found that leadership and culture was overwhelmingly the primary driver of successful change, cited by 73% of respondents. Process, skills, and technology each received less than 12%.

Make the platform the fast path

If a question can be answered in the system faster than it can be answered by email, people stop emailing. The 2025 FP&A Trends Survey found that organisations with high-quality, integrated data spend 42% of their time on insight and action. Those in poor-data environments manage just 19%. The platform has to be the fastest route to a trusted number, not a detour around one.

Give edge cases an owner and a deadline

Rather than letting unresolved scenarios accumulate into permanent workarounds, the organisations that succeed assign someone to triage them, decide what gets built into the model and what gets handled as a manual exception, and close the loop within a set period. An edge case with no owner becomes a standing justification for the old way of working.

Measure the right thing

Instead of tracking logins, track whether numbers presented to leadership originate in the platform unedited, and treat a parallel spreadsheet as a signal to investigate, not a minor inconvenience to ignore. The 2025 FP&A Trends Survey found that only 11% of organisations have fully integrated strategic, financial, and operational planning. Measuring integration, not just access, is what distinguishes adoption from attendance.

05

How Decision Inc Approaches It

At Decision Inc, our xP&A practice treats the post-go-live period as the part of the transformation that actually determines whether it succeeds, not an administrative tail-end of the project.

We design discovery and build phases around the people who will use the model daily, not only the project sponsor, because trust in the numbers has to be built before the model goes live, not retrofitted afterward. Our project governance and change management methodology, applied across more than 400 client engagements per year, includes structured tracking of adoption risk: where workarounds are forming, which edge cases are unresolved, and who in the business has quietly reverted to their own version of the truth.

We also help finance leaders define what successful adoption actually looks like before go-live, so the metrics that get reported aren't just usage statistics, but evidence that the platform has genuinely replaced the manual process it was built to retire.

The Real Test

A transformation isn't successful because the system went live on schedule. It's successful when the spreadsheet stops coming back.

That is a harder thing to achieve than a clean go-live, and it is the only measure that actually matters six months later.

Take the Next Step

Ready to Fix the Shadow
Spreadsheet Problem?

Our xP&A practice treats the post-go-live period as the part of the transformation that actually determines whether it succeeds.