Excel workbook previewSOX Control Testing Workpaper Template (Excel)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A control testing workpaper records how a key control was tested, which items were selected, what was examined for each item and what was found. Management testing supports the annual section 404 assessment, and a clear workpaper lets the external auditor consider using the work. A missing population, an unexplained sample size or an exception without follow-up are the usual reasons a test is rejected.
This workbook has a test register that looks up the sample size from frequency, nature and risk, an attribute testing sheet worked for a credit memo approval control, and a summary that counts results by process. The sample size table is a common practice convention, not a rule, and every size is an editable input. The testing approach follows the design and operating effectiveness procedures in PCAOB AS 2201 paragraphs 42 to 46.
Who it is for
The internal auditor or SOX tester who must test key controls for the year and give the external auditor workpapers they can review and rely on.
What is inside
- Test register with 10 worked control tests and 20 blank formatted rows
- Sample size looked up by formula from frequency, nature and risk of failure, capped at the population
- Sample size table marked as a common convention with editable sizes for lower and higher risk
- Attribute testing sheet for one worked control: 25 credit memos tested against four attributes, one exception
- Conclusion formulas that show Effective, Incomplete or Exception, colored by result
- Days awaiting review formula that turns red after 10 days without reviewer sign-off
- Summary sheet with tests by conclusion and by process, all COUNTIFS
- Dropdowns, frozen headers and filters on the register and attribute sheet, landscape print fit on every sheet
How to use it
Enter each key control from your RCM on the Test register, then agree the sample size table with your external auditor.
Files
- XLSXsox-control-testing-workpaper-template.xlsx20 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 sample size should I use for SOX testing?
No SEC rule or PCAOB standard sets a fixed sample size for management testing. Many companies and auditors use a convention linked to how often a control operates, for example one item for an annual control and 25 or more for a control that runs many times a day. This template keeps the table as editable inputs so you can align it with your auditor.
What is an attribute in control testing?
An attribute is one specific thing the tester examines for each sample item, such as approval by the right person before posting or agreement of the amount to the support. Each item passes or fails each attribute. Any failure is an exception, which the tester explains and then evaluates as a possible control deficiency.
What happens when a control test has an exception?
The tester records the cause, confirms whether the exception is isolated or systemic, and checks whether a compensating control covered the same risk. The exception is then evaluated as a control deficiency for severity. Some companies extend the sample to confirm that the exception rate is low, but an extended sample does not remove the need to evaluate the deficiency.




