Spreadsheet horror stories

Spreadsheet horror stories

Spreadsheet horror stories 3

Finance | John Tate | 31 Oct 2011

Our old friend – the spreadsheet – must be handled with care, warns John Tate. 

Last month it was reported that the UK support-services group Mouchel had discovered an accounting error that led to a £8.6m downgrade of its profits. An independent firm of actuaries found that they had made a spreadsheet error, which meant the Mouchel pension-fund deficit had been wrongly valued. Around half of the profit write-down was due to this mistake.

This resulted in Mouchel’s share price dropping by a third, and its chief executive resigning. In case you have not come across Mouchel before, it manages highways and local authority backoffices, including processing over one million payslips for schools, universities and other public bodies.

Risk of error

What a wake-up call. After email, spreadsheets are probably the most common software tool used by accountants. If a well-respected firm of actuaries can make this mistake we are all at risk of spreadsheet errors.

In case you think you are safe from these problems, I’d refer you to a survey at a recent ICAEW faculty event. This showed that nearly a quarter of accountants have experienced financial or reputational damage due to spreadsheet errors and poor controls. More information at here

The accepted practice suggests you should use your core accounting software to produce key management information – relying on the rigours of an off-the-shelf application to generate the correct results. However, charities can find this a real challenge, or sometimes an impossibility, as the ‘functionality’ in the products they are using may not be able to do the job required.

For smaller organisations using, say, a Sage or QuickBooks product, common challenges are tracking budget and actual costs by department/project/funding source. Depending on the precise requirements, these products may not report at the right level of detail. Hence spreadsheet analysis becomes a necessity.

Suddenly it becomes all too easy to, for example, miss out some costs on a project and under-report expenses to a funder. FDs can of course consider implementing a more powerful system than, say, Sage or QuickBooks. However, this can be prohibitively expensive to buy and then operate. In any case, a more powerful system may still not meet all the charity’s needs.

Common problems include fund accounting across financial years – including commitments, tracking investments and pension obligations. There are third-party specialist products to address these needs, but this can mean organisations using half-a-dozen or more different applications. For example, on top of the accounting software: payroll, time-recording, commitment accounting/procurement, investment-management, fundraising and membership systems, and a more advanced reporting tool.

Challenges then arise to ensure period-end cuts-offs are properly managed and reconciliations between control accounts are managed with great care. Finally there is the problem of making sure information from third-parties, based on spreadsheets, is accurate – something Mouchel failed to do.

Practical tips

So with the likelihood that you are making extensive use of spreadsheets, how do you manage the risk of serious error?

The internet can come to your aid. There are a host of sites with practical tips and tricks. Some examples include:

At the end of the day, there is no substitute for checking and re-checking the information. If your systems are complex you need the resource to manage them. CEOs and boards of trustees are often reluctant to invest the necessary money in this. But, hopefully, this article will help you put your case for such expenditure.

John Tate is MD of Changebase, IT adviser to the CFDG and a visiting lecturer at Cass Business School 

Richard Blaustein
Analytic Solutions, Inc.
10 Nov 2011

Another important tool for the fight against spreadsheet error and risk is automated spreadsheet audit software. One example can be found at but there are several other good ones out there. Combine automated audit with manual audit and implementation of best practices in spreadsheet development, and spreadsheet error risk will be significantly reduced.

Richard Blaustein
Analytic Solutions, Inc.
10 Nov 2011

Great article John. Always amazes me the lack of effort and resources applied to spreadsheet risk control. Some useful tips for your readers on signficantly reducing spreadsheet risk...

Patrick O'Beirne
2 Nov 2011

Thanks for the mention of Eusprig, John.

People with success stories to tell about spreadsheet control could consider a submission to the European Spreadsheet Risk Interest Group (EuSpRIG) conference next July 2012 in Manchester, England. See


[Cancel] | Reply to:

Close »

Community Standards

The community and comments board is intended as a platform for informed and civilised debate.

We hope to encourage a broad range of views, however, there are standards that we expect commentators to uphold. We reserve the right to delete or amend any comments that do not adhere to these standards.

We welcome:

  • Robust but respectful debate
  • Strongly held opinions
  • Intelligent relevant discussion
  • The sharing of relevant experiences
  • New participants

We will not publish:

  • Rude, threatening, offensive, obscene or abusive language, or links to such material
  • Links to commercial organisations or spam postings. The comments board is not an advertising platform
  • The posting of contact details for yourself or others
  • Comments intended for malicious purpose or mindless abuse
  • Comments purporting to be from another person or organisation under false pretences
  • Gratuitous criticism, commentary or self-promotion
  • Any material which breaches copyright or privacy laws, or could be considered libellous
  • The use of the comments board for the pursuit or extension of personal disputes

Be aware:

  • Views expressed on the comments board are left at users’ discretion and are in no way views held or supported by Civil Society Media
  • Comments left by others may not be accurate, do not rely on them as fact
  • You may be misunderstood - sarcasm and humour can easily be taken out of context, try to be clear


  • Enjoy the opportunity to express your opinion and respect the right of others to express theirs
  • Confine your remarks to issues rather than personalities

Together we can keep our community a polite, respectful and intelligent platform for discussion.


John Tate

John Tate is a qualified accountant and entrepreneur. He is a columnist for Charity Finance, a visiting lecturer at Cass Business School's Centre for Charity Effectiveness and trustee of Eduserv.

Team talk and a CRM upgrade

19 Jul 2016

A CRM upgrade is not just about tech – you need to consider the effect on people, says Ivan Wainewright....

The ‘fake’ charity app scam could damage trust in charities

21 Jun 2016

Kirsty Weakley argues that if charities don’t understand what their technology partners are doing, they...

Environmentally-friendly printing - is it possible?

25 May 2016

SaxoPrint highlights how environmentally-friendly printing products and affordability for charities need...

Society Diary: Is a woman really shacked up with this dead philanthropist?

23 Sep 2016

Our weekly round-up of interesting and outlandish information, collected from the corners of the charity...

Dear Andrew: How do I deal with my board's poor attendance?

22 Sep 2016

In this regular column, Andrew Hind answers readers’ queries about governance issues. This week a trustee...

The regulator: Charities should get on the front foot

22 Sep 2016

Many charities have responded proactively to the recent media storm, and are stronger as a result, says...