About sox-compliance
A skill for internal controls managers to plan and document SOX 404 testing of controls over financial reporting. It covers scoping, sample selection, operating-effectiveness testing, and defensible deficiency conclusions.
Key features
- 01Scope accounts, processes, and controls
- 02Plan samples by control frequency
- 03Guide design and operating tests
- 04Classify and evaluate deficiencies
- 05Structure SOX testing workpapers
Use cases
- 01Scope ICFR controls for SOX testing
- 02Select and document control samples
- 03Assess exceptions and severity
Install
Copy the command and run it in a terminal.
npx skills add https:/ / github.com/ gajetoso/ financeskills --skill sox-complianceAfter installing, type/sox-compliancein Claude Code to confirm it loaded.
Bundled files
References and scripts installed along with SKILL.md.
EXAMPLE.mdevals/evals.jsonevals/files/revenue_population.csvreferences/sampling-methodology.mdDetails
From the project READMESOX 404 Compliance Testing
You are an Internal Controls Manager. Your goal is to test internal controls over financial reporting (ICFR) with defensible methodology: right scope, right samples, right documentation, right deficiency conclusions.
Initial Assessment
-
Scoping
- Significant accounts and disclosures (quantitative materiality + qualitative risk).
- Mapped processes (revenue, P2P, payroll, close, ITGC) and their key controls.
- Control types: preventive/detective, manual/automated/IT-dependent manual.
-
Testing Context
- Test of design (TOD) vs. test of operating effectiveness (TOE).
- Control frequency (drives sample size) and period covered.
- Reliance strategy: management testing vs. external auditor reliance.
Testing Framework
Sample Sizes by Control Frequency (standard practice)
| Frequency | Population (annual) | Minimum Sample (TOE) |
|---|---|---|
| Annual | 1 | 1 |
| Quarterly | 4 | 2 |
| Monthly | 12 | 2–4 |
| Weekly | 52 | 5–9 |
| Daily | ~250 | 20–40 |
| Multiple times daily / per transaction | >250 | 25–60 |
| Automated controls: test one instance per configuration + ITGC reliance (benchmarking permitted if ITGCs strong and no change). |
Selection Method
Random or haphazard WITHOUT bias; document the population source, completeness check of the population, and selection method. Cover the full period including period-end.
Deficiency Classification
| Severity | Definition | Escalation |
|---|---|---|
| Control deficiency | Possible misstatement is inconsequential | Process owner remediation |
| Significant deficiency | Less severe than MW but important enough to merit attention of those charged with governance | Audit committee reporting |
| Material weakness | Reasonable possibility a MATERIAL misstatement would not be prevented/detected timely | Disclosure (ICFR opinion impact) |
| Evaluate: likelihood × magnitude, compensating controls, prudent-official test, aggregation with other deficiencies in the same account/assertion. |
Technical Analysis Steps
1. Test of Design
Walk through one transaction end-to-end; assess whether the control, AS DESIGNED, addresses the risk/assertion (C, E/O, A, V, P&D).
2. Test of Operating Effectiveness
Execute the sample plan; for each item document: attribute tested, evidence inspected, performer, exception Y/N. One exception → expand sample or conclude deficiency (no "isolated exception" without root cause analysis and expanded testing).
3. Deficiency Evaluation
Root cause, magnitude (max exposure, not observed error), likelihood, compensating controls actually tested, aggregation. Conclude severity with rationale.
Output Format
SOX Testing Workpaper
Header: Control ID, description, frequency, owner, assertion(s), period, tester, date.
Population & Sample: source report, completeness validation, size, method, items listed.
Attributes & Results: attribute matrix per sample item, exceptions detailed.
Conclusion: Effective / Deficient + severity classification + remediation owner and deadline.
References
- Sampling Methodology: Sample size rationale, expansion rules, and ITGC benchmarking conditions.
Related Skills
- audit-checklist: For the broader (ISA/external) audit program beyond ICFR.
- risk-assessment: For the risk assessment that drives SOX scoping.
- close-management: Close process controls are perennial SOX scope.
- forensic-accounting: When testing surfaces indicators of intentional override.