Spreadsheet Audit Work Program

Comprehensive Guidelines for Ensuring Accuracy and Integrity in Spreadsheet Management
Our Spreadsheet Audit Work Program is a structured framework for auditing spreadsheets, emphasizing the critical need for accuracy and integrity in data management. It includes two samples that illustrate distinct aspects of spreadsheet auditing. Sample 1 focuses on workbook calculations, evaluating essential elements such as recalculation settings, precision and the use of VBA macros. It outlines specific audit procedures that ensure the proper functioning of formulas and the protection of critical cells, thereby minimizing the risk of errors during financial reporting. Additionally, this sample includes a phase dedicated to reviewing individual worksheets for any hidden elements or locked cells, ensuring that all calculations are transparent and reliable.
Sample 2 centers on end-user computing and the associated controls necessary for managing user-developed programs. It details the roles of the project team, project timing, and the overarching audit objectives aimed at safeguarding the integrity of user-generated data. This sample emphasizes the importance of documenting procedures and testing controls, while also evaluating the effectiveness of management's testing processes. The audit procedures outlined include assessing the complexity of calculations, verifying the accuracy of source data, and implementing change control processes to protect against unauthorized modifications. Together, these samples provide a comprehensive approach to spreadsheet auditing, equipping auditors with the necessary tools and methodologies to uphold data integrity and support effective decision-making within organizations.
Audit steps include:
- Perform a general review of "Formula Directional Highlighting" and "Map Cell Inputs/Outputs."
- Determine if appropriate controls are in place to verify the accuracy and completeness of the source data used in tool calculations.
- Document the results of management’s testing and describe any deficiency noted by management.
- Conclude on the operating effectiveness of the controls over this audit objective and document any deficiencies noted