In today’s fiercely competitive economy, business leaders are turning to the finance group to do a lot more than accounting. Yet despite the world of finance (and the role of the CFO) being turned on its head, spreadsheet functionality has remained basically the same for years. Today’s version of Excel would be instantly familiar to someone who hadn’t used it for a decade.
Whilst CFOs are being increasingly relied upon to turn companies around, how many are still only relying on a static, relatively unchanged formula – the good old electronic spreadsheet? Microsoft gauges the number of Excel users worldwide at more than 400 million, and Forrester Research estimates 50 to 80 percent of enterprises still rely on stand-alone spreadsheets for critical applications like financial reporting or budget forecasting.
Yet increasingly, a common lament for CFO users is that piecing together cash flow, profitability and operations data with Excel spreadsheets and static reports is inefficient and inadequate. Even within companies who have BI tools in-house and have spent significant money on this, when it comes to ad-hoc reports or shared forecast processes, the “last mile” will still be done from many CFOs with an Excel spreadsheet.
This tug-of-war between data consistency and flexibility will plague users of stand-alone spreadsheets for the foreseeable future. CFOs need to take aim squarely – or at least obliquely – at Excel. The answer lies in CPM and BI tools, like Palo, that are absolutely essential to optimize spreadsheets: online modules that are low or no cost, and truly Web-based allowing for file sharing on a global basis. Because, more than ever, companies compete based on the decisions they make.

Dear Kristian,
No doubt that a lot has still to be done on the ‘last mile’ from IT systems to ad-hoc reports & shared forcast. I was an auditor by KPMG in the 90′s and also a computer processing specialist. After years as a CFO and COO in Midcap companies I have seen the summit of it all within headquarters of Large Caps. What it the cost of this last mile ?
Time : CFO’s spend nights & week ends consolidating data, burning energy & brain.
Lack of brain : Maybe a IT Rule could be set up : the more you spend joining/merging the less you take distance with the numbers …. the highest the risks !
I am convinced that a new perspective is now open : from Excel to Cube, that is the question.
Happy to take part to it !
Mit freundlichen Grüssen,
Pierre-Louis Malphettes * France
Non Exec Board Member GCSA group
Management consulting & recruting, Eurosearch & Associes