Spreadsheet controls 222



  • Hey, does anyone have another link to Richards PWC spreadsheet documment…I can not find it.
    I am looking at the controls around spreadsheets and databases and need a starting point, can anyone suggest any other articles of interest.
    I work for a bank and we have hundreds of spreadsheets.



  • Here is the link to the PWC whitepaper if that is what you are looking for -
    cfodirect.com/cfopublic.nsf?opendatabase-and-content=http://www.cfodirect.com/cfopublic.nsf/vContent/THUG-63CNN5?Open



  • I think my situation is relevant to this thread and I wanted to see if I could get some feedback?%0AMy company uses Excel spreadsheets for calculating non-standard pricing requests from our customers. If a customer of ours needs a lower price in order to complete a deal, Excel is used to calculate what the impact to our profit margin of that deal is in terms of %, total USD, etc… Currently Excel is used only as a calculation, communication, and decision-making device between sales department and the business decision makers.%0AIf the lower pricing is approved, the Excel file is then sent to another group who uses the data from it to make changes in the actual price-quote (which is in an enterprise level database). All aggregate financial reporting of what was sold to whom for how much comes from the database.%0AAre there any compliance issues that stand out to anyone here? Any feedback at all is much appreciated.



  • There are no SOX compliance issues with this. Your risk is purely operational in that you could miscalculate your profit in the pricing and quote too high to get the sale or too low to make money on it.
    Any financial reporting risk comes after the sale when you record the sale and recognize the income from it. Now, if the spreadsheet is used somehow to calculate your cost of the item sold for financial reporting purposes. then you may have some risk if the spreadsheet is not properly reviewed and monitored for accurate formulas, input, etc.



  • Thanks Kymike. That is what I thought. I do believe the spreadsheet is used in some cases to calculate our costs. But this is limited to situations where we must purchase an item from a supply company that we do not normally warehouse ourselves. In which case, if there is an improper calculation, the supplier is quick to point it out and reject our purchase order. We then make the appropriate correction and resubmit.
    I am guessing this kind of natural ‘control’ is also compliant, am I right about that?



  • I am guessing this kind of natural ‘control’ is also compliant, am I right about that?
    Hi - Issues like this are subject to interpretation. Even things that are indirectly related to SOX compliancy might still be seen as needed sometimes.
    I’d suggest working directly with audit for the answer on this potential exposure related to financial risks. If it’s not too difficult, it’d be beneficial to err on the side of caution.
    As an IT person I may be wrong on this, as I’d recommend adding at least some controls for the following reasons:

    1. The supplier will most likely catch most billing discrepancies. However, what if they don’t have good systems or controls?
    2. For example, as long as they’re getting paid they may think it’s a partial or overpayment check and not always assume you’re paying the bill in full each time?
    3. What if you’re overpaying? Not all folks are ethical and they could at a minimum enjoy some ‘cash float’ for a few weeks or months. This is the exception rather than the rule, but it’s worth noting.
    4. I’ve seen enough billing errors in my 34 years of business experience to suggest it’s a good point to place better controls, reconciliation, and testing on this.
    5. At a minimum, I’d suggest capturing any occurrences from documentation standpoint. This way you’d know how much of a risk it truly is and whether it’s something that you need to go the next step on.
      The key point is you don’t want audit comments to go to the executives or board on failures to comply.


  • HarryWaldron brings up good points. There are very good reasons to have good controls over pricing and billing from a business operations perspective. In my responses, I am trying to ensure that we are identifying the controls that need to be documented and tested for minimum SOX compliance.



  • Thanks Waldron, definitely good points, and I am sure the ‘what if’s’ you bring up most likely have occurred at some point in my company. Law of averages makes it almost a certainty.
    We do have internal controls on the spreadsheet (in the form of macros and password protection, etc… many of the things mentioned in the PWC white paper) and the group that actually makes the adjustments in the database have check procedures, etc…
    I am stuck in the middle of a debate at my company and trying to come up with a balanced solution. One group of folks at my company think that the use of Excel for anything at all constitutes SOX violation. The other group thinks it is actually quite difficult for spreadsheets to trigger violation unless they are specifically for financial reporting.
    I am sure the answer is somewhere in the middle. The thing is that this current spreadsheet is a vast improvement over previous versions designed for the same purpose. We used to have several different spreadsheets floating around the company, different spreadsheets for different product lines, created by different people. They each had vastly different look, formulas, processes, etc… Not to mention no protection or version control. Now we have just the one which accomodates all product lines in a uniform fashion and has protection, version control, centralized management, etc…
    I’ve got to believe that auditors consider this when doing evaluations. If a company cannot afford to put certain functions into an enterprise level data base right away, but is making a conscious effort to make their spreadsheet methods more compliant, would this be enough to avoid violation? Or do you think the only way to be sure is to follow every single guideline in the PWC paper?
    Our company does eventually want to move as many functions as possible to our database, but to do all of it at once would be financially impossible. Spreadsheets seem to be a nice way to bridge that gap and get some level of compliance without having to invest huge dollar amounts, time, resources, etc… It seems to me they at least allow business decision makers the option of delaying costly IT investments while still addressing compliance.
    We are contemplating the creation of a business unit primarily dedicated to spreadsheet creation and management for this reason. I wonder how many others are contemplating making this move and what was can be gained from those who already have this in practice?
    Thanks a ton for the great feedback. I think I will get with our auditors to discuss this now that I feel more well equipped.



  • All
    We are based in South Africa and provide spreadsheet services.
    South African companies are not required to comply with SoX but as we have spreadsheet experience we have tried to put together some ideas on how to address spreadsheet risks using Excel’s inbuilt features, the tool we distribute and some common sense.
    The problem is we are not sure how ‘common’ this common sense is as there is no easy way to test it with limited companies to test against.
    We would appreciate some feedback from a group like yourselves on whether the free advice is practical and useful. If not please make suggestions. The page is auditexcel.co.za/sox_S404.html .



  • Hi,
    You might check out the Spreadsheet Documentation Guide for additional information.
    auditnet.org/Guides/Spreadsheet_Documentation_Guide.pdf
    Hope this further helps,
    Milan



  • I am stuck in the middle of a debate at my company and trying to come up with a balanced solution. One group of folks at my company think that the use of Excel for anything at all constitutes SOX violation. The other group thinks it is actually quite difficult for spreadsheets to trigger violation unless they are specifically for financial reporting.
    I think you’re right on track, as some education and negotiations are required. Certainly SOX standards don’t require you to rewrite everything into database applications and they specifically support the use of spreadsheets with best practices (as noted in prior posts). Going too far with SOX standards can drive up costs and create resistance when you truly need to address real issues
    With your recent work in version control, security controls, autonomy levels, and standardizing the process , place your company in a good position to meet SOX spreadsheet requirements. Any financial risk management aspects of this still might need to discussed and possibly resolved if it’s needed. Otherwise your current position looks good to me 🙂


Log in to reply