Auditing spreadsheets: With or without a tool?
Description: Auditing spreadsheets: With or without a tool? Simone Schalkwijk BSc Dr Felienne Hermans Dr Michiel van der Ven Dr Hans Duits RA A joint student project between the HU University of Applied Sciences Utrecht and the TU Delft University of
Related Topics
Download Presentation
"Auditing spreadsheets: With or without a tool?" is the property of its rightful owner. Permission is granted to download and print the materials on this website for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Presentation Transcript
slide1. Auditing spreadsheets: With or without a tool? Simone Schalkwijk BSc
Dr Felienne Hermans
Dr Michiel van der Ven
Dr Hans Duits RA
A joint student project between the HU University of Applied Sciences Utrecht and the TU Delft University of Technology<br>
slide2. Why this research? Excel horror stories
Errors in spreadsheets post a major threat for the auditor in terms of financial damage and image damage
Previous research showed mixed results on the usefulness of spreadsheet tools for auditing in general<br>
slide3. What did we want to know? R1 Are common errors recognized by auditors?
R2 To what extent does PerfectXL contribute to a more efficient and effective audit?
R3 Which functionalities should PerfectXL possess in order to contribute towards a more efficient and effective audit?<br>
slide4. How did we perform this research? Semi-structured interviews with 8 auditors of a big 4 audit firm with a working experience of over four years
PerfectXL demo<br>
slide5. What are the results of this research? Some common errors are agreed upon
Most auditors have a positive attitude towards the visualization functionality
Mixed opinions on the risk analysis functionality whereas most auditors where doubtful on the impact on efficiency and effectiveness of the audit<br>
slide6. Visualization: The most valued functionality of PerfectXL<br>
slide7. Visualization: Some side effects<br>
slide8. Risk analysis: Some auditors doubted the usefulness of this functionality<br>
slide9. What did we learn from this research? Some common errors are recognized by auditors
Visualization is useful in order to perform a more efficient and effective audit
Results might apply to other spreadsheet auditing tools<br>
slide10. Suggestions for future research Quantitative effects could be measured during an experiment
Aim should not be to look at correctly flagging errors by PerfectXL but should rather focus on differences in effectiveness and efficiency within the audit<br>
Dr Felienne Hermans
Dr Michiel van der Ven
Dr Hans Duits RA
A joint student project between the HU University of Applied Sciences Utrecht and the TU Delft University of Technology<br>
slide2. Why this research? Excel horror stories
Errors in spreadsheets post a major threat for the auditor in terms of financial damage and image damage
Previous research showed mixed results on the usefulness of spreadsheet tools for auditing in general<br>
slide3. What did we want to know? R1 Are common errors recognized by auditors?
R2 To what extent does PerfectXL contribute to a more efficient and effective audit?
R3 Which functionalities should PerfectXL possess in order to contribute towards a more efficient and effective audit?<br>
slide4. How did we perform this research? Semi-structured interviews with 8 auditors of a big 4 audit firm with a working experience of over four years
PerfectXL demo<br>
slide5. What are the results of this research? Some common errors are agreed upon
Most auditors have a positive attitude towards the visualization functionality
Mixed opinions on the risk analysis functionality whereas most auditors where doubtful on the impact on efficiency and effectiveness of the audit<br>
slide6. Visualization: The most valued functionality of PerfectXL<br>
slide7. Visualization: Some side effects<br>
slide8. Risk analysis: Some auditors doubted the usefulness of this functionality<br>
slide9. What did we learn from this research? Some common errors are recognized by auditors
Visualization is useful in order to perform a more efficient and effective audit
Results might apply to other spreadsheet auditing tools<br>
slide10. Suggestions for future research Quantitative effects could be measured during an experiment
Aim should not be to look at correctly flagging errors by PerfectXL but should rather focus on differences in effectiveness and efficiency within the audit<br>