I offer an enterprise 7-tab IT General Controls (ITGC) Audit & Testing Workpaper Suite made
WHO IS THIS MASTER WORKBOOK FOR?:
Internal Auditors, IT Compliance Leads, vCISOs, and SOX 404 Consultants.
WHAT IS INCLUDED IN THE MASTER WORKBOOK:
TAB 1: ISSUE REMEDIATION LOG
Central audit findings ledger tracking control deficiencies, SOX 404/ISO 27001 mapping, root causes, assigned remediation owners, and resolution deadlines.
TAB 2: AUDIT REFERENCE & CITATION TABLE
Master lookup mapping internal condition annotations to SOX 404 (PCAOB AS 2201), ISO/IEC 27001:2022 controls, and NIST SP 800-53 Rev. 5 framework standards.
TAB 3: ACCESS PROVISIONING TEST SUITE
Detailed user access testing ledger covering onboarding approvals, role mapping accuracy, segregation of duties (SoD) checks, and manager sign-offs.
TAB 4: TERMINATED USER STATUS REVIEW
Deprovisioning audit sheet verifying HR termination logs against Active Directory/SSO account revocation timestamps to identify stale active access.
TAB 5: PRIVILEGED ACCESS MANAGEMENT (PAM) TEST
High-risk privilege testing matrix evaluating root/admin account usage, emergency break-glass access logs, and MFA enforcement.
TAB 6: ACCESS RECERTIFICATION REVIEW
Quarterly/Annual entitlement review sheet checking manager recertification approvals, orphan accounts, and privilege revocation verification.
TAB 7: CHANGE MANAGEMENT TESTING SUITE
Production change control audit testing board tracking change tickets, peer code reviews, UAT testing sign-offs, deployment approvals, and segregation of duties.
WHY THIS SUITE?
• Fully editable Excel (.xlsx) file with dynamic formulas and zero macros.
• Comprehensive 7-tab workpaper covering the complete ITGC audit lifecycle (Logical
Access, PAM, Deprovisioning, Recertification, and Change Management).
Pre-mapped to SOX 404, ISO 27001:2022, and NIST SP 800-53 standards.
IS THIS MASTER WORKBOOK READY TO USE?:
Yes, it is immediately ready to use upon purchase and is fully editable right at the moment.
EXCLUSIONS:
• Standardized operational compliance templates for internal team execution.
• Hands-on custom auditing is offered exclusively for ITGC and TPRM domains.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Information Technology, Audit Management Excel: Enterprise ITGC Audit Workpaper Excel (XLSX) Spreadsheet, gx76455