The FP&A Trends Webinar: Mastering Analytical Transformation with FP&A Trends Maturity Model
Click here to view details and register
The FP&A Trends Webinar: Mastering Analytical Transformation with FP&A Trends Maturity Model
Click here to view details and register
By John Sanchez, Keynote Speaker, Corporate Trainer and Author
There is no shortage of technology tools available for Financial Planning and Analysis (FP&A) professionals. Whether you need to do some data mining, create data visualisations, create reports, perform statistical analysis, or generate budgets or forecasts, there’s an app for that.
There are purpose-built software tools for nearly any need you may have, but there are a few questions you’ll want to ask yourself before you start using any of these tools.
I once had a client who insisted that they needed to improve their reporting and analysis capabilities in the sales department.
The Vice President of sales was adamant that his team must be missing sales opportunities because they were operating in the dark. They knew at a high level what products were selling well and which were the dogs, but it was such a large organisation they had no idea why certain products sold well in some locations or through certain channels but not in others. Having seen this same problem before, I knew a solution didn’t need to be complex, so I started asking questions.
As it turned out, the company had an analysis and reporting tool with all the functionality they needed. Still, almost nobody in the company knew about it except the Director of IT. The company had bought the software years before and trained everyone in the planning department to use it. Over time the planning department experienced high turnover, and nobody who had been trained to use the tool was left. They didn’t need a new tool. They needed to train the right people to use the tool they already had.
A few good questions, followed by more good follow-up questions, will get to the heart of this issue pretty quickly, so don’t skip this step.
Once you have asked all the appropriate questions and understand the need, that’s the time to decide on what tool you need for the job.
Many FP&A professionals' first choice for any planning and analysis job is Excel. This shouldn’t be surprising since it’s been the mainstay of the profession since it took over the spreadsheet market in the 1990s and has dominated ever since. But Excel has limitations, and there are some famous stories about huge blunders made because of errors made in Excel.
One of the biggest problems with using Excel for everything is that it is sometimes just not the right tool for the job. An analogy of a Swiss Army knife is appropriate to help think about this in context. Like a Swiss Army knife, Excel has a wide variety of functionality. But, while a Swiss Army knife has a saw blade, I would not want to cut down a large tree with it. I also wouldn’t want to put together a room full of IKEA furniture using only the screwdriver in a Swiss Army knife. In both cases, I could get the job done, but it would be far from the best way to do it.
Here are a few clues that you might want to look for another tool instead of Excel.
As a finance professional implementing an FP&A / CPM / EPM platform, you might face several...
The pressure of globalization and agile decision-making requires companies to improve their business modeling. They must...
This article will focus on is the modeling of a company as a whole, its consolidated...
Excel is still a popular tool when it comes to preparing financials or analysis. However, we...
“Go to the cloud” has been a key building block in every global CIO’s digital strategy...
Spreadsheets are a great tool to build and maintain ad-hoc calculations, quickly draft a business plan...
We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.