Welcome to xFiles, Solver's investigative video series that uncovers the most perplexing mysteries plaguing finance teams everywhere. Each episode solves common financial planning nightmares that keep CFOs awake at night.
In this episode, Solver "investigator" Michael Buehner takes on a case that will feel painfully familiar to anyone who has ever inherited a 50-tab Excel workbook and been told, "this is how we do budgeting."
The organization at the center of this case had a problem that started small and grew into something unmanageable. They ran multiple systems across the business, each generating its own data in its own format. An internal data warehouse was supposed to bring it all together, but the reporting coming out of it was not delivering what finance needed.
So the team did what finance teams everywhere do when systems fail them: they turned to Excel.
Budget owners downloaded data from each source, copied it into spreadsheets, and manually combined everything into massive workbooks. We are talking 50 tabs or more per file, with multiple files in rotation. Different data types from different systems, all stitched together by hand.
The risks were exactly what you would expect. File corruption. Version control chaos. No audit trail. Numbers that nobody could fully trust. And a budgeting process that consumed enormous time without producing reliable results.
According to research from the University of Hawaii, nearly 90% of large spreadsheets contain at least one error. When your entire budget lives in a patchwork of 50-tab workbooks, the question is not whether something is wrong. It is how much.
Michael approached this case the way a good investigator should: by ignoring the surface symptoms and looking at the underlying business processes. Rather than starting with the Excel templates (which had been built years ago by someone no longer with the company), he went deeper.
The investigation focused on three core questions:
This was not a quick-fix engagement. It required a thorough review of each data source, each system, and the business logic that connected them. Michael describes it as old-fashioned business process reengineering: understanding the destination first, then mapping the route.
The key insight? The existing templates did not tell the story of what the business actually needed. They told the story of what someone had built years ago and everyone had been working around ever since.
Watch the full investigation:
After the investigation phase, the team built a solution in three stages.
The first step was connecting the organization's disparate data sources into Solver's data warehouse. Rather than forcing everything through the existing internal warehouse (which was not meeting their needs), the team set up two tenants: one fed from the internal data warehouse and one connected directly to the ERP and other source systems. This gave finance a single, consolidated view without requiring a massive infrastructure overhaul.
Instead of replicating the old 50-tab workbooks inside a new tool, Michael's team rebuilt the planning process from scratch. They aligned budget forms and reports to actual business processes and management requirements, using Solver's Template Marketplace assets as a starting point. The result was a planning structure that reflected how the business actually operates, not how it operated five years ago under a different team.
The team ran a try-and-buy proof of concept so stakeholders could see their own data working inside the platform before signing on for a full implementation. This removed the risk of a large upfront commitment and let the finance team build confidence in the new approach. Once they saw their data flowing correctly and the reports reflecting what they actually needed, the transition to a paid subscription happened quickly.
A year and a half later, the team has gone well beyond the original scope. They have built out capabilities they did not even anticipate during the initial engagement, all because the foundation was designed around their real business needs rather than a copy of their old spreadsheet habits.
If your budgeting process still depends on massive Excel workbooks stitched together by hand from half a dozen systems, you are not investigating a rare case. Take a closer look at how budgeting and forecasting built around your actual business processes, backed by a data warehouse that connects every source in one place, can turn your next planning cycle into something you can trust instead of something you're hoping holds together.