This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit
Part 1: An Introduction to managing spreadsheet riskPart 2: How companies can manage their spreadsheet riskPart 3: Excel’s auditing functionsPart 4: Using external software packages to manage your spreadsheet risk
The potential impact of spreadsheet error hit the UK business news recently after a mistake in a spreadsheet resulted in outsourcing specialist Mouchel issuing a major profits warning and sparked the resignation of its chief executive.
See the full news article here: http://www.express.co.uk/posts/view/276053/Mouchel-profits-blow
Over the next few weeks we will look at the risk spreadsheets can introduce to an organisation and the steps that can be taken to minimise this risk.
Because we all love Excel, right? True certainly, but the main reason is that it is intuitive, flexible, cost effective and provides quick solutions to high priority day to day problems.
And what is the alternative? The IT department. The simple fact is that end user developed spreadsheets often fill the gap between the current business requirements and formally managed IT systems.
Unfortunately this reliance on spreadsheets, rather than robust, well governed IT solutions can add significant risk to an organisation if it is not properly managed.
Spreadsheet risk is the risk that a business could lose revenue and profit, fail to comply with regulators or find its reputation damaged as a result of spreadsheet error (be it fraudulent or unintentional).
Poorly structured spreadsheets can also lead to a loss of productivity and increased audit costs, further damaging the bottom line.
A recent study of typical enterprise spreadsheets by the Tuck School of Business at Dartmouth found that 94% of spreadsheets and 5% of all formulae within spreadsheets contain errors.
The European Spreadsheet Risk Interest Group (EuSPrIG) are the voice of best practice spreadsheet development and the management of spreadsheet risk.
Below are a couple of examples of what can go wrong from the EuSPrIG website:
C&C Group admit to mistake in revenue results
Shares in C&C fell 15 per cent after it said total revenue in the four months to end-June had not risen 3 per cent as reported, but had dropped 5 per cent. C&C said cider revenues in the UK had fallen 12 per cent, not 1 per cent, while cider revenues in Ireland were flat instead of up 7 per cent as reported last week.
C&C’s group finance director and COO said the error in last week’s announcement occurred after data were incorrectly transferred from an accounting system used for internal guidance to a spreadsheet used to produce the trading statement. “It was basically human error… there’s nothing wrong with our accounting systems,”
FSA fines Credit Suisse £5.6m
The FSA decided to impose a financial penalty of £5.6 million on the UK operations of Credit Suisse in respect of a breach of Principles 2 and 3 of the FSA’s Principles for Business:
Principle 2 states that “A firm must conduct its business with due skill, care and diligence.”Whilst Principle 3 requires that “A firm must take reasonable care to organise and control its affairs responsibly and effectively, with adequate risk management systems.”More specifically, section “2.33.3. The booking structure relied upon by the UK operations of Credit Suisse for the CDO trading business was complex and overly reliant on large spreadsheets with multiple entries. This resulted in a lack of transparency and inhibited the effective supervision, risk management and control of the SCG {Structured Credit Group}”
Excel is, and is likely to remain, the first choice for businesses when developing financial models and analysing data. The risk that this introduces to businesses if unmanaged is real and potentially material.
In the next article we will look at ways that companies can manage their spreadsheet risk.
In my brief usage of Excel, I have experienced several risky situations. Sometimes it just a mild data loss, other times, there was a potential of revenue loss or customer annoyance. Due to the economic slowdown many large and small corporations are employing spreadsheet based solutions. And if you do not understand the risk & manage it, then your risk being featured on EuSPrIG’s horror stories page.
Do you know (or experienced) a spreadsheet horror story? Please share your ideas and best practices with us using comments.
Many thanks to Myles for writing this series. Your experience in this area is invaluable. I am really keen to learn about the best practices and adopt them in my business. If you enjoy this series, drop a note of thanks to Myles thru comments. You can also reach him at Excel Audit or his linkedin profile.
RSS feed for comments on this post. TrackBack URI
Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Office PowerPoint 2010. The following topics are covered: Creating a New Presentation, Adding a New Slide, Changing the Slide s Layout, Changing the Slide Orientation, Changing the Slide Size, Entering Text into a Click to add... Bulleted List Placeholder, Starting a New Line Without a Bullet, Moving from Title to Body with the Keyboard, Adding Other Text on the Slide, Changing Level of Indentation, Using the Outline Tab, Rearranging Bullet Points or Paragraphs, Changing the Text Format, Changing the Text Size, Enhancing Text: Bold, Italic, etc., Turning On/Off Bullets, Formatting Text with the Mini Toolbar, Viewing Many Slides at Once, Rearranging Slides, Applying a Design Theme, Changing the Background of a Slide, Adding a Header or Footer, Creating Speaker Notes, Changing the Slide Master to Change All Slides At Once, Suppressing Slide Master Elements on Certain Slides, Adding Clip Art, Inserting a Picture from a File, Resizing Graphics, Creating a Chart, Creating an Org Chart, Adding a New Box to the Org Chart, Deleting a Box in the Org Chart, Drawing Shapes, Resizing a Shape, Rotating an Object, Moving a Shape, Adding Text to a Shape, Selecting Shapes; Changing the Color, Fill Pattern, or Line Style of a Shape or Line; Duplicating a Shape, Hiding Slides, Running a Slide Show, Assigning Transition Effects and Timings for a Slide Show, Animating an Object, Changing Slide Show Settings, Printing. Also includes: Lists of Selection, Movement, and Slide Show Shortcuts.
Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010. The following topics are covered: Creating Workbooks, Entering and Editing Data, Undo and Redo, Resizing Column Width and Row Height, Inserting and Deleting Rows Columns and Cells, Clearing Cells, Clearing Formatting, Formatting Numbers and Cells, Aligning and Merging Cell Contents, Borders and Grids, Viewing the Worksheet as it will Print, Entering Dates, Entering Sequences. Entering Formulas & Functions, Entering a SUM Function Quickly, Absolute vs. Relative Cell References. Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop. Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets. Editing Multiple Worksheets Simultaneously, Copying Data and Formatting to Multiple Worksheets. Previewing, Printing and Page Setup, Printing a Specific Area, Using Page Break Preview to Adjust Page Breaks, Repeating Rows/Columns on Every Page. Working with Previous Versions (Compatibility Mode). Also includes: Lists of Selection and Movement Shortcuts.