
Businesses: It’s time to break up with your Excel spreadsheets
Despite high profile stories of errors causing significant financial losses, companies still use Excel spreadsheets…
Large organizations are quickly realizing that to remain competitive in today’s turbulent markets they must drive a serious digital transformation effort. In the field of business planning and analysis, achieving this requires the reliance on disparate spreadsheets, standalone systems, and disconnected point-to-point solutions to be replaced once and for all with a much more coherent, standardized, integrated approach. This step change represents what is termed in a recent Gartner research note as Extended Planning & Analysis (xP&A) and here we explore exactly what that entails.
Gartner defines xP&A as the extension of Financial Planning & Analysis (FP&A) principles beyond the finance department. This extension could be into any area of the organization which produces business plans, including sales, marketing, and HR. Gartner predicts that by 2024, 70% of all new financial planning and analysis projects will have an extended scope beyond the finance department.
The FP&A process provides finance teams with a structured approach to financial budgeting, planning, forecasting, and reporting, enabling them to inform the strategic decisions made by senior management and assess their financial impact. The challenge is that FP&A only offers a financial perspective, ignoring the activities and plans of other areas of the business which all contribute to the bottom line.
The sales team will have planned forecasts and targets, marketing will have a series of planned campaigns, HR will have plans for remuneration and headcount, and production will have schedules, planned material, resources, and capacity. Each of these operational plans has typically been conceived in isolation of the others, without real insight into the impact it may have on the business overall – e.g. a rise in sales actually requires increased production capacity which needs additional headcount and machinery.
Trying to manually collate data from different spreadsheets and systems to pull together an overall business plan is a time-consuming and near-impossible task, especially given the ever-evolving nature of planned activities. As a result, it rarely happens, leaving management teams without clarity over the relationship between the output of each team or the overall business picture.
With xP&A this problem is overcome. When the standardized principles of FP&A are applied to other departments, financial and operational data is brought together to generate collaborative sales, demand, procurement, HR and IT planning with a common goal. This is often referred to as Integrated Business Planning.
The standardization, automation, and integration of planning activities business-wide brings far-reaching benefits for both management teams and employees:
The overall result of xP&A is one of unification, giving the organization the tools and access to data it needs to become more efficient and effective across all departments.
A standalone FP&A solution will not meet the needs of those wanting to implement xP&A. The planning requirements of each department vary greatly and the rigid approach of prebuilt software designed for finance simply doesn’t fit.
To realize xP&A effectively, organizations need a unified platform which offers the flexibility to adapt to different needs while preserving data accuracy and process control. As Gartner identifies, this requirement is pushing organizations to use fewer vendors in favor of solutions offering multiple capabilities. The unified Board Decision-Making Platform is one such offering, offering a standard foundation of data from all departments on which to base all reporting, planning, and forecasting activities.
Learn more about how to extend the principles of FP&A across the business in this on-demand webinar covering Integrated Business Analysis, Planning, and Forecasting across the Enterprise.
Watch this on-demand webinar to learn how Integrated Business Planning enables the achievement of an xP&A approach.