🔴  LIVE ON AIR - Mastering Year-End Accounts & AGAR - WATCH LIVE
PRODUCTS
PRODUCTS
Accounts
Bookings
Cemetery
Allotments
Read case studies
It's just so user friendly! I don't have a favourite application, I love it all! I just think if I can use it, anyone can use it.
View Clerk Testimonal
Amazed at year-end at how easy it was, I had to do very little as Finance Officer- my job was essentially redundant!
View Councillor Testimonal
SCRIBE ACADEMY™
TESTIMONIALS
FREE RESOURCES
FREE RESOURCES FOR COUNCILS
Scribefest 2021 on-demand sessions
Scribe Bytesize - Short help videos
A-Z of UK Grant Funders
Year End Checklist
Budgeting Spreadsheet
Free Online Training Events
Council Clerks Mastermind on Facebook
What Is The Model Code Of Conduct?
Top Tips For A Successful Grant Application
The Secret To Mastering Year End
View All Blog Posts
Free eBooks, grant lists & budgeting spreadsheets and checklists.
Discover More
Scribe Academy: Free monthly online training from accounts to management. Open to all.
Discover Training Events
LinkLink 2
COMPANY
COMPANY
Contact
Pricing
Terms & Conditions
Privacy Policy
Blog & News
Partners
Scribe Blog: Exclusive Parish & Town Council Tips
Discover More
Scribe Academy
Discover More
SUPPORT
SUPPORT
Accounts Help Guides
Bookings Help Guides
Cemetery Help Guides
Scribe Family: The Facebook Support Group
Scribe Academy™
Practioners Guide
Blog
Scribe Blog: Exclusive Parish & Town Council Tips
Discover More
Scribe Academy
Discover More
LinkLink 2Link 3
SIGN IN
GET STARTED

Dangers of using spreadsheets for managing Parish, Town and Community Council finances

by 
John Fagan
· Updated
Nov 18, 2021

Did you know 88% of spreadsheets have errors? 

This was the result of a USA study carried out by MarketWatch.  The UK government has an embarrassingly long history of spreadsheet horror stories. 

  • Rolvenden Parish Council loss due to fraud- £80k loss
  • Maesteg Town Council loss due to fraud - £34k loss
  • Denbighshire County Council loses £21m 
  • Flintshire County Council school £1M cash blunder
  • COVID-19 spike with 16,000 positive results going unreported
  • Blackpool Teaching Hospitals fined £185k
  • Edinburgh hospital opening delay causing £16M loss 

We hope these facts grab your attention and provide food for thought regarding the use of spreadsheets for managing precepts, income and expenditure and budgeting at Parish, Town and Community Councils across England and Wales.

But, it’s cheap and easy 

We hear you. We understand why local councils use spreadsheets.  

You will have a PC or laptop with Microsoft Office installed. Many Clerks and Responsible Financial Officers have experience using Excel. It’s the quickest, cheapest and most convenient application to use to manage council accounts. But are you making the right cost versus convenience tradeoffs?   

#1 Human error and frustration 

Spreadsheets are extremely sensitive to human errors.  

Minor errors can result in significant problems.  Worst case, these could go undetected for many years.

Common human errors are typos, misuse of negative signs, copy and paste, misaligned rows, circular references, leaving cells out of sums, not normalising data, adding blank rows or merging cells to make it look nice, not using data validation.

Common frustrations when inheriting someone else’s spreadsheet are multiple versions of the same file, corrupt files, lost files, no documentation, no support, locked cells, hidden cells, calculated values with no formulas. 

To illustrate the impact of human error, let’s look at some real examples. 

Typos & formatting errors

  • MI5 bugged the wrong phones
  • Barclays spent millions on worthless contracts
  • AstraZeneca released confidential information
  • Kodak suffered an $11 million severance

Copy and paste errors 

  • JP Morgan lost $6 billion
  • TransAlta lost $24 million

Formula mistakes

  • Emerson lost $3.7 million 

Data manipulation errors

  • NHS missed 16,000 positive cases of Covid-19

 #2 Fraud 

Spreadsheets are very easy for opportunistic and unscrupulous Clerks or RFOs to manipulate finances for personal gain.  

Spreadsheets do not have any controls, no audit trails, no access control, no role-specific permission handling.  This makes it extremely easy to alter data and formulas, whether that’s proactively or retrospectively. 

#3 Collaboration and troubleshooting

Spreadsheets are very portable, easy to copy and share via email. This is a bad thing.

Clerks and RFOs are the key people that manage council accounts.   There are many other “users” of financial accounts:

  • Councillors 
  • Auditors
  • General Public
  • HMRC - Making Tax Digital for VAT
  • Banking systems

Within local councils, spreadsheets are copied, reformatted and transformed into other documents.  Creating many different versions, and many different “versions of the truth”.

Spreadsheets don't enable easy collaborative sharing, in which multiple users can collaborate at the same time, along with controls in place regarding audit logging and permissions users have to create, read, update and delete specific records.  

Spreadsheets do not offer any support for easy integration into external systems.  In particular, HMRC’s system for Making Tax Digital for VAT. As of April 2022 registered Parish and Town councils must submit VAT via software that integrates with HMRC systems.

#4 Regulatory Compliance 

After reading points 1,2 and 3, you will see this creates a big challenge for ensuring your accounts are compliant.   

Spreadsheets are highly susceptible to human error and fraud.  They make it hard to collaborate and share information, data is scattered everywhere in folders, PCs, laptops and inboxes.  It makes it impossible to adhere to regulations such as GDPR.

What’s more, over the last two decades, we’ve seen a surge in regulations that directly affect spreadsheet-based systems.  

Next Steps

We hope you found this blog informative, the good news is this is very easy to fix.  If you would like to have a friendly chat with our team of experts at Scribe, register here.

https://resources.scribeaccounts.com/free-consultation

We have a team of qualified and part qualified accountants, expert trainers and problem solvers.  Happy to have a chat.

Hannah Driver (MAAT), Senior Accountant
Jane Dafforn, Chief Customer Officer


‍

‍

‍

‍

‍

Want to know more about Scribe Accounts?

  • Super easy to use
  • Multiple users with different permission controls
  • Audit trails and daily backups
  • Instant AGAR reports
  • VAT Returns via HMRC portal
  • FREE training and FREE support

Register for a demo here 

https://www.scribeaccounts.com/demo-request 

 Sources 

  • https://www.teampay.co/insights/biggest-excel-mistakes-of-all-time/
  • https://blog.caspio.com/5-of-the-most-terrifying-excel-spreadsheet-horror-stories-weve-ever-heard/ 
  • https://www.denizon.com/spreadsheet-fraud/ 
  • https://www.businessinsider.com/excel-partly-to-blame-for-trading-loss-2013-2?r=US&IR=T
  • https://www.optimaconnect.co.uk/post/why-excel-isnt-to-blame-for-the-nhs-test-and-trace-blunder 
  • https://theconversation.com/excel-errors-the-uk-government-has-an-embarrassingly-long-history-of-spreadsheet-horror-stories-147606 
  • https://flatfile.com/blog/7-scary-excel-errors-your-team-is-probably-making/ 
  • https://www.denizon.com/top-10-disadvantages-of-spreadsheets/‍
  • https://www.zdnet.com/article/excel-errors-microsofts-spreadsheet-may-be-hazardous-to-your-health/

Free Resources

GET YEAR END RIGHT FIRST TIME

PARISH & TOWN COUNCIL YEAR END CHECKLIST

Get FREE CHECKLIST
ACCESS GRANTS THE EASY WAY

PARISH & TOWN COUNCIL GRANT FUNDERS LIST

Get THE FREE LIST
GET THE BUDGETING TEMPLATE FOR FREE

PARISH & TOWN COUNCIL BUDGETING SPREADSHEET

Get FREE TEMPALTE

Get helpful Council accounting tips by email

Subscribe to our newsletter to receive new posts straight to your inbox 👇

✓
Thank you!
You have been added to the list.
Oops! Something went wrong while submitting the form.

Read More

Scribe Academy
Simple Tips to Cut Your Climate Impact
May 13, 2022
Jessica Shackley
Scribe Academy
Can You Pass the Web Accesibility Test?
May 11, 2022
Jessica Shackley
Scribe Academy
Local Council Accounts - From Zero to Hero
May 6, 2022
Jessica Shackley
Scribe Academy
Scribe Academy™ (Season 2) - Free Webinars for Local Council Clerks and Councillors
Mar 28, 2022
Jane Dafforn
HomeFeaturesCase studiespricingBLOGContactscribe cemeteryscribe BOOKINGS
GET STARTED
Carefully crafted by Starboard Systems Ltd
Terms and ConditionsPrivacy Policy