Why Next-Gen Financial Platforms Outperform Legacy Spreadsheets thumbnail

Why Next-Gen Financial Platforms Outperform Legacy Spreadsheets

Published en
4 min read

Released in 1983, it was ground-breaking for its time multi-dimensional with in-memory calculation in a spreadsheet-like interface., these tools became known as the. This leaves the 1st generation out of reach for all however the biggest, most fixed companies.

Accessible via the cloud, the promised to enhance access to sophisticated preparation tools massively. With lower expenses and faster application cycles, they did Anaplan reached just under 2,000 customers before its $10.4 bn take-private. 7,8 Adaptive Insights had more than 3,700 consumers in 2018, before ending up being a part of Workday for $1.6 bn.

Anaplan utilized a new syntax unknown to Excel users, and some tools needed calling out an engineer for every single significant model modification. Rates likewise increased gradually, now out of reach for all but deep-pocketed enterprise customers. To put it more candidly, the dominating FP&A tools have actually been explained to us by users as Finally, the 1st and second generations deeply focus on their planning and modeling utilize cases.

That's why 64% of forecasting and budgeting still takes location in Excel. 12 Financing teams are stuck in siloes, and spend a lot of time cleaning information- which prevents them from being more involved in operations.

"Julio Martinez, Co-founder and CEO, Abacum 3rd generation FP&A tools picked apart all the areas where prior generations failed and revamped the solution from the ground up. These business have actually built items that FP&A really needs, not just a big, costly modeling tool.

Finding the Leading Financial Tool Scaling

We look at the five most important needs for FP&A personnel and how 3rd generation tools are innovating to deliver. By leveraging contemporary, user-friendly UIs, and extensive training and documentation, Gen 3 users see fast time to worth. Stripping out intricacy conserves users from running up huge professional services expenses, which were par for the course in prior generations.

's 150+ pre-configured metrics. By incorporating with the ERP at the source deal list, click-down analysis from a dashboard all the way to the transaction level is possible.'s solution for labor force preparation.

The finest part? Integrated real-time information can roll forward into actuals without the risk of turning a model into one big #REF mistake. Leveraging the insights from information to drive model presumptions becomes simpler from within one platform, and players like Datarails are leveraging that advantage with predictive budgeting. Most significantly, numerous tools like Abacum offer endless measurements, so modeling has amazing versatility.

Critically, AI tools let financing personnel ask concerns of their data using natural language.

The next generation of FP&A tools should deliver on this expectation with intuitive interfaces, seamless combinations, and unparalleled flexibility."Joel Abdinoor, CFO, NewStoreWith these developments, a real-time view of organization-wide data with deep analytics abilities is within reach. No system extractions, no information prep, no SQL. Simply like that, the manual tasks that FP&A staff waste much of their time on are removed.

Freed from fighting for accurate data, financing teams can ask the ideal tactical concerns to level up their business. With these tools in their hands, the FP&A department ends up being a competitive advantage.

Optimizing Multi-User FP&A Workflows Across Teams

The opportunity doesn't stop at the mid-market. Expert-level users of First and 2nd generation tools might argue that these tools are only fit for simpler/smaller planning departments, however that's classic disturbance theory.

Examples like Pigment and Causal have currently done so, with traction at PVH, Klarna, Deliveroo, and Kitopi. With a focus 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 an advantage to $20bn. That advantage can be attained through brand-new modules that catch use cases like AR and AP automation.

Modern Budgeting Tools to Replace Manual Workflows

We obtain our TAM based on the variety of signed up business by size classification, adjusting for the percentage of those business most likely to utilize a 3rd generation FP&A tool, and multiplying out by observed rates ($ACV).14,15,16 We see three essential vectors for success in the 3rd generation FP&A market: 1) Scalability and Versatility, 2) Ease of Use, and 3) Excel-friendliness.

How to Modernize Your Annual Planning Process

Remember, the users of these tools are Excel pros, so they'll default back to Excel at the very moment 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 customers can outgrow a tool quickly.

Typically scalability and versatility can come at the expense of ease of usage, however what's special about this trade-off, is that it doesn't need to be one-for-one. This provides unbelievable ease of use improvements, assisting to take the power of an advanced planning tool outside the finance department. The best FP&A tools make Excel their pal with tight integrations to Excel and Google Sheets.

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