The free lunch that spreadsheets represent will have to be paid for - at a premium.
Earlier today, I spoke with Dennis Keeling, CEO of BASDA the trade organisation for the UK (and some of Europe's) software development community. In essence, studies undertaken with PwC and others reveal that spreadsheet proliferation is one of the chief causes for audit cost hikes in the wake of the need for SarbOx compliance. Keeling said that in a typical large organisation, there can be up to 3,000 spreadsheets all of which have to be audited.
The main problem with spreadsheets and one I've commented on regularly for over 10 years, is their ad-hoc, uncontrolled nature. Development is almost always undertaken by people who don't have formal development skills and so the spreadsheet is rarely documented. There are many examples of how this impacts organisations.
I recall speaking with Heineken where the UK FD passed his home grown monthly reporting spread to a colleague who, through no fault of his own, screwed up interest payment allocation to the tune of some £1 million per month - four months elapsed before anyone noticed anything unusual. Then there was the building society that overpaid £135 million when purchasing a mortgage 'book.' The calculations to support the purchase were made using a defective spreadsheet. In the US, defective spreadsheets are blamed for incorrect electricity demand calculations that led to a massive over commitment in forward buying of power. The figure runs into billions of dollars.
The problem can be partially avoided where back end systems functionality allows for reporting from inside the system, but as Keeling notes: "People have for whatever reason chosen to use spreadsheets instead of available functionality." I suspect this is more to do with implementation of features after core rollout.
According to BASDA, a number of mid-range accounting packages may need to be re-engineered so they incorporate automated reporting and so avoid the manual input that plagues spreadsheets. The idea is that work and process flow will characterise the systems of tomorrow.
Audit teams will only have to audit the system once and then apply tests to the outputs. It means that over time, consolidation in an already consolidating market for accounting software is likely to accelerate. That translates into reduced customer choice.
Equally worrying is the lack of compliance related skills among mid-tier accounting professionals. Sarbanes-Oxely has wide impact, much wider than listed companies. Anyone that has a trade relationship with US firms will be impacted over time. But it's only the thin end of the broader compliance wedge. Keeling agrees. Already the EU is looking to enact legislation similar to SarbOx so again, over time, SarbOx style compliance will become mandatory.
If this is an area likely to impact your clients, there is an opportunity to skill up and perhaps offer services to other practices or even the Big Four.
The detailed (and excellent) report is available for purchase by contacting BASDA here
Recent Comments