Value in Moving Beyond Legacy Financial Spreadsheets

Released in 1983, it was ground-breaking for its time multi-dimensional with in-memory computation in a spreadsheet-like user interface., these tools ended up being understood as the. This leaves the First generation out of reach for all but the biggest, most static companies.

Available through the cloud, the assured to improve access to sophisticated preparation tools massively. With lower expenses and faster implementation cycles, they did Anaplan reached just under 2,000 consumers before its $10.4 bn take-private. 7,8 Adaptive Insights had over 3,700 customers in 2018, before becoming a part of Workday for $1.6 bn.

Anaplan used a brand-new syntax unfamiliar to Excel users, and some tools required calling out an engineer for every single major model modification. Pricing likewise increased over time, now out of reach for all but deep-pocketed enterprise clients. To put it more bluntly, the dominating FP&A tools have actually been described to us by users as Lastly, the 1st and second generations deeply concentrate on their planning and modeling utilize cases.

That's why 64% of forecasting and budgeting still takes place in Excel. 12 Finance groups are stuck in siloes, and spend a lot of time cleaning data- which prevents them from being more included in operations.

You require a native modeling solution. Excel-based solutions will always break as companies scale."Julio Martinez, Co-founder and CEO, Abacum 3rd generation FP&A tools selected apart all the locations where prior generations stopped working and redesigned the option from the ground up. These business have built products that FP&A truly needs, not simply a big, pricey modeling tool.

Mastering Organisational Budgeting Success in 2026

We look at the 5 most important requirements for FP&A staff and how 3rd generation tools are innovating to deliver. By leveraging contemporary, instinctive UIs, and comprehensive training and paperwork, Gen 3 users see quick time to value. Stripping out complexity saves users from running up enormous professional services costs, which were foregone conclusion in previous generations.

Tracking crucial metrics is increased by functions like Abacum's no-code data change and Mosaic's 150+ pre-configured metrics. By integrating with the ERP at the source transaction list, click-down analysis from a control panel all the way to the transaction level is possible. Designs can be prepared in minutes, enabled by design templates, and improved by specialized modules, like Jirav's solution for labor force planning.

The best part? Integrated real-time information can roll forward into actuals without the threat of turning a model into one big #REF mistake. Leveraging the insights from data to drive design presumptions becomes simpler from within one platform, and gamers like Datarails are leveraging that benefit with predictive budgeting. Most importantly, lots of tools like Abacum provide endless dimensions, so modeling has extraordinary flexibility.

Critically, AI tools let financing personnel ask questions of their information using natural language.

The next generation of FP&A tools should provide on this expectation with instinctive interfaces, seamless combinations, and unrivaled flexibility."Joel Abdinoor, CFO, NewStoreWith these improvements, a real-time view of organization-wide data with deep analytics capabilities is within reach. No system extractions, no information preparation, no SQL. Simply like that, the manual jobs that FP&A staff waste much of their time on are eliminated.

Freed from combating for accurate information, financing groups can ask the ideal tactical concerns to level up their companies. With these tools in their hands, the FP&A department ends up being a competitive benefit. How does the 3rd generation break into the market? The mid-market is the most natural point of entry for the next generation - companies simply large enough that their preparation department is growing out of Excel, too little to pay for the price (and speaking with fees for every change!) of incumbent tools, and moving too rapidly to freeze their operations for multi-month implementations.

Unlocking Agile Budget Visibility Without Manual Data

The opportunity doesn't stop at the mid-market. Expert-level users of 1st and Second generation tools might argue that these tools are only fit for simpler/smaller planning departments, but that's timeless disturbance theory.

Examples like Pigment and Causal have already done so, with traction at PVH, Klarna, Deliveroo, and Kitopi. With a concentrate on the mid-market and business traction, we see an addressable market for these tools of $9.6 bn in the US and Europe, with a benefit to $20bn. That advantage can be attained through brand-new modules that capture usage cases like AR and AP automation.

We derive our TAM based upon the number of registered companies by size classification, adjusting for the proportion of those companies most likely to use a 3rd generation FP&A tool, and increasing out by observed pricing ($ACV).14,15,16 We see three key vectors for success in the 3rd generation FP&A market: 1) Scalability and Flexibility, 2) Alleviate of Usage, and 3) Excel-friendliness.

The ROI of Moving Beyond Legacy Financial Spreadsheets

Keep in mind, the users of these tools are Excel pros, so they'll default back to Excel at the very minute they reach the limitations of another tool. That's one factor why churn can be high in this market. Product requirements are not fixed as high-growth mid-market consumers can grow out of a tool quickly.

Business like Causal follow this playbook with an item upgrade page that shows weekly updates. Typically scalability and flexibility can come at the expenditure of ease of usage, however what's unique about this trade-off, is that it does not require to be one-for-one. Balancing the flexibility-ease of usage tightrope is an ability, and we're all acquainted with tools that do both well, like Idea.

Runway is leveraging the popular Notion-style UI, utilizing versatile, point-and-click workflows to build a monetary design. This offers incredible ease of use enhancements, helping to take the power of a sophisticated preparation tool outside the financing department. The very best FP&A tools make Excel their good friend with tight combinations to Excel and Google Sheets.

Web-native approaches can maintain attractiveness to Excel power users with Excel-like syntax and features.'s sheet view adds familiar Excel experience to the core item.