If you’re an experienced FP&A pro, you’ve probably seen enough to know that many of us want the Goldilocks of FP&A tools. At one extreme is Excel. At the other, hulking enterprise solutions that often take months to implement and learn.
There are pros and cons to each end of the spectrum. Depending on your past experiences, you may laugh or shudder at either or both. The holy grail is the tool that elegantly splits the difference between the do-what-you-want freedom of Excel and the “fit your process to our software and say hi to your new ($400-per-hour) friends the application vendor consultants” vibe of legacy FP&A software. But first, here’s an appreciation of what we already have.
Most organizations still rely on Excel for all things FP&A even at large enterprise scale and despite having invested in expensive FP&A software or modules that “came along” with their ERP. That’s a tribute to Excel’s flexibility and the young Bill Gates’s genius.
You’d likely agree that Excel-based FP&A and modeling are great for
The main drawback to an Excel-based FP&A operation is that Excel is not built to be a data storage tool. After a certain size, files get clunky and hard to maintain, and you begin to hold your breath hoping that nothing crashes when you open large files or make changes.
As for making changes, it’s infamously hard to make top-down changes in Excel. Working in collaboration makes it even more challenging: ensuring integrity and error fixing become the death knell to many FP&A professionals highly deserved relaxed evenings and dinner dates.
If you’ve worked in enterprise-level FP&A, “enterprise FP&A software” probably brings to mind a handful of software tools. They can be from vendors or custom-built and can be a fit for
Of course, there are drawbacks. It can feel like you have to adapt your organization’s processes to fit the tools, not vice versa.
Depending on your organization and the enterprise tool, you may have to plan years ahead to adopt new or updated solutions. One Fortune 100 FP&A lead said that after scrapping their outdated custom FP&A software, they’ve been using one vendor solution and are slated to transition to another suite of tools from a different vendor “in three to four years.” Hopefully the organization’s needs and the tool’s features will line up when it’s time to implement the tool. But the timelines involved in traditional enterprise FP&A software make it harder to match tools and features to business needs multiple years in the future.
For organizations that have moved beyond the Wild West of Excel but don’t need or dread the resource commitment and inflexibility of traditional enterprise software, better options are springing up.
We’ve seen the good, bad and the ugly of FP&A software over the years. Acterys was designed as a reasonable middle ground for
As with everything, Acterys has its drawbacks. You won’t have a readily available team of consultants on site over months to build your solution. We offer ease of use and integration into familiar environments. You are the solution champions. You can manage, extend, and use the solution as you see fit.
One last thing: Acterys isn’t free, but it costs a small fraction of what less-nimble FP&A software does. We’re proud of that.
If you’re reading this, chances are you’re invested in the quality of FP&A at your organization. FP&A touches much more than budgets and forecasts in a spreadsheet, and you understand it deeply.
If you think it might be helpful to explore flexible, light, but powerful options for your FP&A team, get in touch. From our trademark Fast Start to a no-obligation trial period, we will try our best to answer any of your questions and help with improvements to your current processes.