23 September 2017

44975

Retired Member

3,111Posts 11,074,751Views 3,387Comments

CFOs: It’s Time to Say Goodbye to the Spreadsheet

27 August 2015  |  3357 views  |  2

While there have been significant changes in business models and financial governance requirements and the velocity and volume of data over the years, many organisations’ business systems haven’t changed.  Recent research reveals an incredible 60% of CFOs and finance directors still rely on Excel spreadsheets to gain access to data – even those in businesses with over $1 billion in annual revenues.

What’s wrong with Excel you ask? Plenty.

First off, they are ill-equipped to serve today’s “think fast” finance world where analytics use is becoming more prevalent. In a June 31 Twitter session, industry analyst Mark Smith of Ventana Research points out the ineffectiveness of spreadsheets and their analytics incompatibility, “Spreadsheets continue to complicate and cost businesses money,” he tweeted. They are “great for individual productivity but not for analytics across the business,” and offer “no governance of data.” Smith’s commentary stems from the results of another new research study where 58% of organisations admit spreadsheets are unreliable for analytics.

This doesn’t bode well for business, as use of analytics -- using data to enhance business performance by making more effective decisions and actively incorporating insights gained from data into business processes – is becoming vital for planning, budgeting and forecasting, to support better business strategy and execution.

Analytics offer organisations a way to derive insights and decision making from data – in a very compressed timeframe, and to understand the impact of change. This is key, as the  recent  survey results indicate CFOs are running ragged by the increasing pace of business due to digital disruption; 1/3 of CFOs polled admitted business planning and forecasting was major challenge for their organisations in 2015. Static tools and systems such as Excel less and less effective in helping increase financial productivity, as they do not take into account external data and future events.

The other big problem with Excel is that it was never designed to support collaboration – a big deficiency in today’s new era of collaboration in the office of finance, as 52% of CFOs report decisions are often made collectively, involving people outside the finance department.

Excel has been the finance person’s companion for many years, but much like a security blanket or pacifier, at some point we outgrow the need for these things, or rather our needs outgrow the thing. Such is the case with the Spreadsheet. To support smart financial strategies for innovation and growth, organisations must be able to access information and analyse it quickly to aid smart, agile decision making. The solution is to have a modern financial IT infrastructure in place that delivers the right data to the right people at the right time in the right way – providing a solid data decision framework. 

 

TagsInnovation

Comments: (2)

Paul Zaman
Paul Zaman - DomaCom - Singapore | 28 August, 2015, 05:32

As in all changing events, we need to get more distinctions.

CFO's need to be handson to be able to validate big data and big data mining extracts and do simple "sanity checks". So the CFO needs to keep their hands dirty and be able to do some simple cross checking of numbers and trends.

Conversely, as the authior rightly says, there is increasing collaboration and increasing multiply sources making up the big data. It is ridiculus to try to condense, simplify, summarise the content in big data to a flat two dimensional spreadsheet.

So both are needed.

I have come across CFO's of listed companies whom no longer have the skills to do basic summation and trend anomaly spotting. Ihave come across Annual reports, that on exmaination have been publsihed with mistakes and needed the internal audit and external audit to wonder how basic accounting errors accurred.

Lets keep spreadsheets as a simple skillset and tool, to keep big data honest, true and fair

1 thumb up! 1 thumb up! (Log in to thumb up)
Stephen Hart
Stephen Hart - Cardswitcher.co.uk - Manchester | 28 August, 2015, 08:36

good point Paul.  I agree, both are needed. 

Be the first to give this comment the thumbs up 0 thumb ups! (Log in to thumb up)
Comment on this story (membership required)

Retired's profile

job title
location
member since 2014
Summary profile See full profile »

Retired's expertise

Member since 2009
3071 posts3,387 comments
What Retired reads

Who's commenting on Retired's posts

Ketharaman Swaminathan
Charmaine Oak
Francis Chlarie
Raymond Lee
Deepthi Rajan
Melvin Haskins
João Bohner
Bob Lyddon
Urs Meier
Steven Hatton
Ahmed Saleh