codexkit-audit-readiness-checker

name	codexkit-audit-readiness-checker
description	Assess organizational readiness for financial audits (internal or external). Map assertions to account balances, check evidence completeness, score readiness using a Red/Amber/Green framework, and generate a remediation timeline. Aligned with SOX, IFRS, and GAAP audit standards. Use before scheduled audits or when preparing for first-time compliance.
version	1.0.0
category	verification

Audit Readiness Checker

When to Use

• 60–90 days before a scheduled external audit
• When preparing for SOX compliance for the first time
• After prior audit findings need remediation verification
• When internal audit wants a pre-flight check

Procedure

Step 1 — Map Assertions to Accounts

For each material account balance, map the relevant audit assertions:

Assertion	What It Tests
Existence/Occurrence	Did the transaction/asset actually happen/exist?
Completeness	Are all transactions recorded?
Valuation/Accuracy	Are amounts recorded correctly?
Rights & Obligations	Does the entity own/owe the amounts?
Presentation & Disclosure	Is it properly classified and disclosed?
Cut-off	Are transactions in the correct period?

Step 2 — Check Evidence Completeness

For each assertion per account, verify supporting evidence:

1. Source documents (invoices, contracts, bank statements)
2. Reconciliations (bank, intercompany, sub-ledger to GL)
3. Approvals and authorization records
4. Third-party confirmations
5. Management representations and estimates documentation

Step 3 — Score Readiness

Score	Criteria
🟢 Green	All evidence available, reconciled, no open items
🟡 Amber	Evidence partially available, minor gaps, reconciliation in progress
🔴 Red	Missing evidence, unreconciled, prior audit finding unresolved

Step 4 — Generate Remediation Plan

For each 🟡 and 🔴 item:

1. Describe the gap
2. Assign an owner
3. Set a deadline (must be before audit fieldwork)
4. Define the evidence deliverable

Inputs

Input	Required	Format
Trial balance	Yes	Account list with balances
Prior audit findings	Recommended	Management letter or audit report
Audit timeline	Yes	Fieldwork start date
Supporting schedules	Recommended	Reconciliations, roll-forwards

Output

## Audit Readiness Scorecard — [Entity] — [Audit Period]

### Overall Score: 🟡 AMBER (72% ready — 12 weeks to fieldwork)

### By Account Area

| Account | Assertion | Evidence | Status | Gap | Owner | Deadline |
|---------|-----------|----------|--------|-----|-------|----------|
| Cash | Existence | Bank confirmations | 🟢 | — | — | — |
| Cash | Completeness | Bank reconciliation | 🟢 | — | — | — |
| AR | Existence | Confirmations | 🟡 | 3 confirmations pending | AR Lead | Week 8 |
| AR | Valuation | Aging + allowance | 🔴 | Allowance model not updated | Controller | Week 6 |
| Revenue | Cut-off | Shipping docs | 🟢 | — | — | — |
| PP&E | Existence | Physical count | 🔴 | Count not scheduled | Ops Mgr | Week 4 |

### Prior Findings Status

| Finding | Year | Status | Remediation |
|---------|------|--------|-------------|
| Inventory count procedures | 2024 | 🟡 In progress | New SOP drafted, testing pending |
| AR confirmation process | 2024 | 🟢 Resolved | Automated via NetSuite |

### Remediation Timeline

| Week | Action | Owner |
|------|--------|-------|
| Week 4 | Schedule PP&E physical count | Ops Manager |
| Week 6 | Update AR allowance model | Controller |
| Week 8 | Complete AR confirmations | AR Lead |
| Week 10 | Final reconciliation review | CFO |
| Week 12 | Audit fieldwork begins | — |

Definition of Done

• All material accounts mapped to audit assertions
• Evidence completeness checked per assertion
• RAG status assigned to every account/assertion combination
• Prior audit findings tracked with remediation status
• Remediation plan with owners and deadlines for all 🟡/🔴 items
• Timeline fits before audit fieldwork start

Examples

Prompt

Our external audit fieldwork starts in 12 weeks for FY2025.
Here is our trial balance: [paste]. Prior year findings: AR confirmation delays, inventory count gaps.
Assess our audit readiness and create a remediation plan.

Quality Criteria

• Every finding is tied to a specific evidence source (log, test, metric)
• Pass/fail criteria are binary and measurable — no subjective judgments
• Severity levels are assigned with clear thresholds
• Remediation steps are provided for all critical and high findings

Verification (4C)

Check	Question
Correctness	Are all pass/fail criteria applied against the correct standard or rule?
Completeness	Were all required dimensions or checklist items evaluated?
Context-fit	Does the verification scope match the actual risk level of the deliverable?
Consequence	If this passed verification but had a hidden flaw, what is the worst-case impact?

Edge Cases

• Incomplete data for full assessment — Document which checks were limited and flag for re-verification when data becomes available.
• Ambiguous pass/fail criteria — Request clarification from the standard owner before scoring. Mark as 'Needs Review'.
• Multiple overlapping standards — Identify the governing standard and note where others diverge.

Changelog

• v1.0.0 — Initial release