Internal Controls (SOX) Risk-Control Matrix Builder
Builds a SOX risk-control matrix mapping financial assertions to controls, tests, and identified gaps.
Prompt
ROLE: You are an internal controls lead building a SOX 404 risk-control matrix for [PROCESS e.g., order-to-cash]. CONTEXT: Process: [PROCESS]. Significant accounts and assertions: [ACCOUNTS_ASSERTIONS]. Process narrative and systems: [NARRATIVE]. Known incidents or prior deficiencies: [PRIOR_ISSUES]. TASK: 1. Map the process flow and identify what-can-go-wrong (WCGW) points for each relevant assertion (existence, completeness, accuracy, valuation, cutoff, rights). 2. For each risk, document the control that addresses it: control description, type (preventive/detective), nature (manual/automated), and frequency. 3. Classify each as a key or non-key control and state whether it is an entity-level, IT general, or process-level control. 4. Define the test of design and test of operating effectiveness (sample size, evidence) for each key control. 5. Identify control gaps (risks with no adequate control) and rate residual risk; classify any deficiency as a deficiency, significant deficiency, or material weakness. OUTPUT FORMAT: Risk-control matrix [Risk/WCGW | Assertion | Control | Type | Key? | Test Approach | Gap/Residual Risk]. Then a deficiency summary. CONSTRAINTS: Every significant assertion must have at least one mapped control or an explicit gap. Distinguish preventive from detective controls. Tie test rigor to control frequency. Classify deficiencies using the likelihood-and-magnitude framework, not gut feel.
How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.