AGENT SKILL

sox-compliance

When the user wants to plan or execute SOX 404 control testing, select audit samples, build testing workpapers, or classify control deficiencies. Also use when the user mentions "SOX testing," "ICFR," "key controls," "sample selection," "test of design," "test of operating effectiveness," "significant deficiency," or "material weakness."

License 许可
MIT
最近更新
2026-11-01
Stars
★ 47
Forks
14

01 前言 Front Matter

name
sox-compliance
metadata
{ "version": "1.0.0" }
description
When the user wants to plan or execute SOX 404 control testing, select audit samples, build testing workpapers, or classify control deficiencies. Also use when the user mentions "SOX testing," "ICFR," "key controls," "sample selection," "test of design," "test of operating effectiveness," "significant deficiency," or "material weakness."

02 资源文件 4

03 SKILL.md 正文

SOX 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

  1. 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.
  2. 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


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.

04 同仓库更多 Skills

GAJETOso
GAJETOso/financeskills

working-capital-analysis

When the user wants to analyze or optimize working capital — receivables, payables, inventory, and the cash conversion cycle. Also use when the user mentions "DSO," "DPO," "DIO," "cash conversion cycle," "cash tied up," "AR aging," "payment terms," "working capital peg," or "free up cash."

★ 47
GAJETOso
GAJETOso/financeskills

wacc-computation

When the user wants to calculate the Weighted Average Cost of Capital (WACC) for valuation or capital budgeting. Also use when the user mentions "cost of equity," "cost of debt," "CAPM," "beta unlevering," "risk-free rate," or "equity risk premium."

★ 47
GAJETOso
GAJETOso/financeskills

venture-debt

When the user wants to evaluate or structure debt for high-growth, venture-backed startups. Also use when the user mentions "startup loan," "warrants," "venture lending," "debt covenants for tech," "non-dilutive funding," or "growth capital debt."

★ 47
GAJETOso
GAJETOso/financeskills

variance-analysis

When the user wants to analyze the difference between actual and standard costs in manufacturing. Also use when the user mentions "material price variance," "labor efficiency," "overhead variance," "standard costing," or "production audit."

★ 47
GAJETOso
GAJETOso/financeskills

treasury-management

When the user wants to manage corporate liquidity, investments, or financial risks like FX and interest rates. Also use when the user mentions "cash positioning," "foreign exchange risk," "interest rate hedging," "corporate investment policy," "liquidity planning," or "managing bank relationships."

★ 47
GAJETOso
GAJETOso/financeskills

three-statement-modeling

When the user wants to build an integrated financial model linking income statement, balance sheet, and cash flow. Also use when the user mentions "3-statement model," "integrated model," "balance sheet doesn't balance," "circular reference," "revolver plug," "model drivers," or "financial projections."

★ 47