First page of the ITGC Testing Template for SOX (Excel)Excel workbook preview

SOX and ICFR

ITGC Testing Template for SOX (Excel)

ITGC testing template in Excel for SOX: 12 worked IT general controls across access, program change, development and operations, with systems scoping and results.

Excel workbook · 16 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

IT general controls (ITGCs) are the controls over access, program changes, program development and computer operations that keep financial systems and their automated controls working as designed. SEC Release 33-8810 says that management only needs to evaluate the ITGCs necessary for the proper and consistent operation of controls that address financial reporting risks. External auditors test ITGCs before they rely on any automated control or system report.

This workbook holds 12 worked ITGCs for an invented company with an ERP, a subscription billing system, a payroll provider and a consolidation tool. Each control names the IT risk it addresses, drawn mainly from PCAOB AS 2110 Appendix B, with test procedure, population, sample tested, exceptions and a formula result. A systems sheet records which ITGC areas apply to each system, and a summary sheet counts results by area.

Who it is for

The IT audit lead or SOX coordinator who must test the IT general controls behind the financial systems before the external auditor relies on automated controls.

What is inside

  • 12 worked ITGCs across the four areas named in SEC Release 33-8810: access to programs and data, program changes, program development and computer operations
  • Each control names the IT risk it addresses, drawn mainly from the list in PCAOB AS 2110 Appendix B
  • Result formula that shows Effective, Exception or Not tested, plus a live days-to-next-test count
  • Overdue test dates and exceptions highlighted in color, 20 blank formatted rows with dropdowns
  • In-scope systems sheet for 6 systems with the ITGC areas that apply to each and service auditor report status
  • Summary sheet with controls, tested, effective and exceptions per area, and systems in scope per area
  • How to use sheet, frozen headers, filters and landscape print fit

How to use it

List your financially relevant systems on the Systems in scope sheet first, then adjust the 12 sample ITGCs to those systems.

Files

  • XLSXitgc-testing-template-for-sox.xlsx16 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What are the four ITGC areas for SOX?

SEC Release 33-8810 gives program development, program changes, computer operations and access to programs and data as examples of IT general control areas that management can consider. The release also says that not every area applies to every company. This template uses those four areas and lets you mark which apply to each system.

Why do ITGCs matter for SOX?

Automated controls and system reports only stay reliable if nobody can change the program or the data without authorization. PCAOB AS 2201 says that when general controls over program changes, access and computer operations are effective, an auditor can rely on an unchanged automated control without repeating the full test each year. Weak ITGCs remove that reliance and increase manual testing.

Do I test ITGCs for a system run by a service provider?

When a service provider runs part of your financial reporting system, its controls form part of your internal control. Companies usually obtain the provider's independent service auditor report, read the exceptions and test the user controls the report expects the company to operate. The systems sheet in this template records that status for each system.