9 pillars of a well set up FP&A System, first time

9 pillars of a well set up FP&A system

When you’re first approaching any new FP&A system implementation, it can be very overwhelming. There is a lot to get right and the decisions you make early on will have an outsized impact on how the entire system works for you over the long term. Worst case a poor initial decision can have lasting consequences which you will need to live with. As a result, we always encourage new clients to take their time during the setup process and be as thorough as possible because it helps to avoid plenty of headaches down the road.

In that spirit, we thought we’d briefly look at some of the many features worth paying attention to when setting up your FP&A ecosystem.  These are all found in Apliqo’s FPM administration module – where you can tinker and make changes all you want.  However, making the best use of this requires some thought around what some of these key initial pillars actually are.

  1. Roles.  With such a wide variety of people interacting with your system, you’ll want to think carefully about what each person can and can’t do in their particular role.  Apliqo FPM allows for highly specific access and editing permissions to be set for each user type so that you can control who can do what, and when and which data and business structures they can see and write to.

  2. Data Backups.  We cannot emphasize enough how important it is to be backing your data up on a regular basis.  By setting in place a robust strategy and process from the very beginning, you ensure that you’re never caught out when something goes wrong.  You can restore from a recent backup and wipe that sweat off your brow as you do so.

  3. Time Horizon.  Setting up your time horizons for your historical data as well as your planning helps to align the system more generally with your strategic and regulatory requirements.  This makes for more meaningful benchmarking and thus – a smoother journey.

  4. Chart of Accounts.  Your company’s chart of accounts is at the heart of all your financial planning and analysis and so it’s crucial that you think through this carefully.  Taking your time here to find a workable solution for your specific needs will pay off in leaps and bounds as your company grows and expands.

  5. KPIs.  You should always be aware of what KPIs are most important for your organization and by building them into the foundation of your financial system you can ensure that they’re always front of mind.

  6. Business Segmentation.  When you’re slicing and dicing your company data, you’ll want to leverage several different views that are more relevant for specific decision-makers.  As such, you should segment your operations appropriately to create clear delineation that can make the reporting process much easier. Use of alternate hierarchies is key here for being able to analyse or “slice & dice” both results and forecasts.

  7. Granularity. Don’t get caught in the precision versus accuracy paradox. This can be a trap. Modern systems are capable of holding vast amounts of data, but just because you can do something doesn’t mean you should. It’s perfectly OK, in fact appropriate for budgets and forecasts to have a different level of granularity to actuals. Too much detail in forecasts can create much additional work for no added value. Choosing the appropriate granularity for both actual and forecast data is one of your most important decisions when setting up a system.

  8. External Connectors.  If you’re using a tool like Apliqo, you have the option of connecting to a wide variety of external software applications that can push and pull data in and out of your system.  Getting this configured upfront helps with the implementation so that you can leverage the system you already rely on.

  9. Planning Drivers.  You can get started by setting up some key drivers of both revenue and costs which will then inform your planning and forecasting capabilities.  This can of course be tweaked over time, but it’s a good idea to get started on these early so that you can immediately begin making decisions with real backing behind them.

These barely scratch the surface of what an effective implementation looks like but hopefully it gives you a sense of some of the key considerations that should be front of mind.

As mentioned, you’ll find the levers for all of these within the FPM administration module – which makes it very easy to get the desired configuration for your organization.  The entire thing has got a facelift recently, so it’s definitely worth checking out!  We hope that by making this extra functionality more accessible for our users we can maximize results and improve efficiencies across the board.

Related Posts

More resources

Apliqo announces new partnership with OLAPLINE to expand financial planning and analytics capabilities

At Apliqo, we pride ourselves on building partnerships with companies that not only share our goal of transforming the landscape of financial planning and analytics but also offer distinct perspectives and capabilities that enable clients to make the most of their data. While technology provides the essential tools, its full potential can only be realized through a strategic and expertly managed implementation journey.

Read this article
Apliqo OLAPLINE partnership

How FP&A solutions drive value in M&A transactions

An "executive summary" article on the profound importance of FP&A solutions in the context of an M&A transaction.

Read this article
How FP&A solutions drive value in M&A transactions

The most important part of your rolling forecasts is data consistency

In this article, we’re going to explore how data consistency is key to M&A transactions – especially when a transaction takes months (and in some cases, years) to close.

Read this article
In this article, we’re going to explore how data consistency is key to M&A transactions – especially when a transaction takes months (and in some cases, years) to close.

Impact and Influence: How to determine the KPIs that truly matter

Not every KPI is created equal however and, as with so many decisions, the devil is in the details. In this article, we’ll explore how to select the right KPIs for your business so that you can align your company with the incentives that actually matter.

Read this article
Not every KPI is created equal however and, as with so many decisions, the devil is in the details. In this article, we’ll explore how to select the right KPIs for your business so that you can align your company with the incentives that actually matter.

Don’t underestimate the amount of preparation required for an M&A transaction

In this article, we’re going to delve into what this preparation looks like and hopefully, by showing the scope and scale of what is needed, we can help CFOs and their teams to better understand how much work actually needs to happen before they sit down at the negotiation table.

Read this article
In this article, we’re going to delve into what this preparation looks like and hopefully, by showing the scope and scale of what is needed, we can help CFOs and their teams to better understand how much work actually needs to happen before they sit down at the negotiation table.