--- name: external-audit description: Manage external audit coordination including audit planning, audit evidence preparation, audit finding management, management letter responses, audit fee negotiation, and audit committee reporting. Use when coordinating with external auditors, preparing audit evidence, managing audit findings, responding to management letters, or reporting to the audit committee. Triggers on phrases like "external audit", "audit coordination", "audit planning", "audit evidence", "audit findings", "management letter", "audit committee", "PCAOB", "SOX audit", "audit fee", "auditor relationship", "going concern", "material weakness". --- # External Audit Management Coordinate and manage the external audit process for accurate, timely, and compliant financial reporting. ## Audit Planning & Coordination ### Annual Audit Plan ``` EXTERNAL AUDIT OVERVIEW: ════════════════════════ AUDITOR: [Big 4 / Mid-Tier Firm] Engagement partner: [Name] (10+ years) Audit manager: [Name] (5+ years) Team size: 8-12 (fieldwork) Tenure: 5 years (current partner) Quality reviews: 0 deficiencies (past 3 years) PCAOB inspection: Satisfactory (latest) Annual audit fee: $450,000 Other services (tax, advisory): $120,000 Total fees: $570,000 Fee negotiation: Annual (scope-based) Fee trend: +3% YoY (within CPI, acceptable) AUDIT SCOPE: Financial statements: Consolidated (5 entities) Internal controls over financial reporting (ICFR): Yes (SOX 404) Tax provision review: Yes (ASC 740 — uncertain tax positions) Transfer pricing: No (separate engagement) Cyber risk assessment: No (separate advisory) Reporting framework: US GAAP Compliance: SEC reporting (10-K, 10-Q) Standards: PCAOB auditing standards AUDIT TIMELINE (Annual): ┌───────────────────────────────────────┬────────────────────────────────────┐ │ Phase │ Timeline │ ├───────────────────────────────────────┼────────────────────────────────────┤ │ Audit planning │ October — November │ │ (risk assessment, materiality, scope)│ │ │ Interim testing │ November — December │ │ (controls testing, substantive test) │ │ │ Year-end procedures │ January │ │ (cutoff, confirmation, physical obs.)│ │ │ Final fieldwork │ January — February │ │ (completion, analytics, review) │ │ │ Draft financial statements │ February │ │ (audited FS + notes) │ │ │ Audit committee review │ February (before filing) │ │ (pre-approval, discussion) │ │ │ 10-K filing │ March (within 60 days of year-end) │ │ ────────────────────────────────── │ ────────────────────────────────── │ │ Quarter-end (Q1-Q3): │ │ │ Procedures: 10-15 days per quarter │ │ │ Deliverable: Audited quarterly FS │ │ │ Filing: 10-Q (within 40 days) │ │ └───────────────────────────────────────┴────────────────────────────────────┘ AUDIT PLANNING MEETING (November 2024): Key decisions: 1. Materiality: Overall materiality: $4,200,000 (2.5% of revenue) Performance materiality: $3,150,000 (75% of overall) Clearly trivial: $42,000 (1% of overall) 2. Areas of focus: - Revenue recognition (ASC 606) — HIGH risk - Intercompany transactions — HIGH risk - Goodwill impairment (ASC 350) — MEDIUM risk - Tax provision (ASC 740) — MEDIUM risk - IT general controls — MEDIUM risk - Cash and investments — LOW risk 3. Scope allocation: US parent: 60% of audit effort (revenue concentration) UK subsidiary: 15% (material entity) Canada subsidiary: 10% (compliant, lower risk) Singapore subsidiary: 10% (compliant, lower risk) IP holding: 5% (minimal activity) 4. Resource planning: On-site: 8 team members (Jan 6-24) Remote: 4 team members (ongoing) Management support: 3 dedicated FTEs Estimated hours: 1,800 total ``` ## Audit Evidence & Procedures ### Management Support ``` AUDIT EVIDENCE REQUIREMENTS: ════════════════════════════ MANAGEMENT REPRESENTATIONS: 1. Management representation letter (annual): - Financial statements: Complete and accurate - All transactions recorded - All related-party transactions disclosed - All commitments and contingencies disclosed - Accounting policies: Consistently applied - No fraud involving management - Subsequent events: None identified - Laws and regulations: Compliant - IT systems: Reliable and complete - Signed by: CEO + CFO 2. Specific representations (as requested): - Revenue recognition: Policies and judgments - Inventory (if applicable): Physical count, valuation - Litigation: Status, reserves - Tax: Positions, reserves, filings - IT controls: Environment, change management AUDIT PROCEDURES SUPPORT (by area): ┌────────────────────────────┬──────────────────────────────────────┐ │ Audit Area │ Management Support Required │ ├────────────────────────────┼──────────────────────────────────────┤ │ Revenue recognition │ Contract samples, billing records, │ │ │ revenue schedules, cut-off analysis │ ├────────────────────────────┼──────────────────────────────────────┤ │ Cash and investments │ Bank confirmations, investment │ │ │ statements, custody confirmations │ ├────────────────────────────┼──────────────────────────────────────┤ │ AR / receivables │ Aged AR trial balance, customer │ │ │ confirmations, allowance calc. │ ├────────────────────────────┼──────────────────────────────────────┤ │ Fixed assets │ FA register, purchase invoices, │ │ │ depreciation schedule, disposal docs │ ├────────────────────────────┼──────────────────────────────────────┤ │ AP / liabilities │ AP aged trial balance, vendor │ │ │ confirmations, subsequent payments │ ├────────────────────────────┼──────────────────────────────────────┤ │ Intercompany │ IC reconciliations, transfer pricing │ │ │ documentation, elimination entries │ ├────────────────────────────┼──────────────────────────────────────┤ │ Income taxes │ Tax provision calc., tax returns, │ │ │ uncertain tax position analysis │ ├────────────────────────────┼──────────────────────────────────────┤ │ Goodwill │ Impairment test model, assumptions, │ │ │ sensitivity analysis │ ├────────────────────────────┼──────────────────────────────────────┤ │ IT general controls │ Access reviews, change management, │ │ │ backup/restore tests, monitoring │ ├────────────────────────────┼──────────────────────────────────────┤ │ Fair value │ Valuation reports, model docs, │ │ │ market data, expert engagement │ └────────────────────────────┴──────────────────────────────────────┘ REQUEST TRACKING: Audit request list (standard): Total items requested: 45 Documents: 28 (policies, schedules, reconciliations) Interviews: 8 (key personnel) Confirmations: 6 (bank, customer, vendor, legal) Data extracts: 3 (GL, AR, AP, FA) Response timeline: Target: 3 business days per request Actual (Q4 audit): Avg. 2.1 days ✓ On-time response rate: 96% (target: >90%) Request management: Tool: AuditBoard (audit management platform) Workflow: Request → Assignment → Preparation → Review → Submission Tracking: Dashboard (status, aging, responsibility) AUDIT WORKPAPER ACCESS: Management access: View-only (audit workpapers via secure portal) Purpose: Transparency, coordination, early issue identification Security: NDA, restricted access, audit committee oversight Usage: Monthly review (Q4), weekly (Jan-Feb) ``` ## Audit Findings & Remediation ### Findings Management ``` AUDIT FINDINGS HISTORY: ═══════════════════════ FY2024 AUDIT OPINION: UNQUALIFIED (CLEAN) - No material misstatements identified - No material weaknesses - No significant deficiencies - No going concern doubts - Emphasis of matter: None - Other matter: None Management letter (non-critical observations): 3 items MANAGEMENT LETTER ITEMS (FY2024): ┌────┬──────────────────────────┬──────────┬────────────┬──────────┐ │ # │ Finding │ Severity │ Root Cause │ Action │ │ │ │ │ │ Taken │ ├────┼──────────────────────────┼──────────┼────────────┼──────────┤ │ ML1│ Reconciliation narrative │ Minor │ Insufficient│ Enhanced │ │ │ documentation (3 accts) │ │ detail │ template │ ├────┼──────────────────────────┼──────────┼────────────┼──────────┤ │ ML2│ Access review delay (2 │ Moderate │ Resource │ Dedicated │ │ │ months behind schedule) │ │ constraint │ reviewer │ ├────┼──────────────────────────┼──────────┼────────────┼──────────┤ │ ML3│ JE approval documentation│ Minor │ Process gap │ Enhanced │ │ │ (5 JEs missing 2nd sign) │ │ │ workflow │ └────┴──────────────────────────┴──────────┴────────────┴──────────┘ Resolution status: ML1: ✓ RESOLVED — Enhanced reconciliation templates implemented ML2: ✓ RESOLVED — Dedicated access review owner assigned ML3: ✓ RESOLVED — JE workflow updated (mandatory dual approval) All FY2023 findings: ✓ RESOLVED (0 open carry-forward) DEFICIENCY CLASSIFICATION: Material weakness (MW): Definition: Reasonable possibility of material misstatement Impact: Public disclosure, investor concern, remediation urgency Our status: 0 MWs (past 5 years) ✓ Significant deficiency (SD): Definition: Less severe than MW, important enough to report Impact: Internal reporting, audit committee notification Our status: 0 SDs (FY2024) ✓ Observation / recommendation: Definition: Process improvement suggestion Impact: Internal review, management letter Our status: 3 items (FY2024) — all minor to moderate INTERNAL CONTROLS OVER FINANCIAL REPORTING (ICFR): Controls tested: 42 (SOX 404 scope) By category: IT general controls: 15 Financial reporting controls: 18 Revenue recognition controls: 5 Intercompany controls: 4 Testing results: Operating effectively: 40 (95.2%) Design exception: 1 (enhanced — now effective) Operating exception: 1 (isolated — remediated) Overall assessment: ✓ EFFECTIVE (no MW, no SD) Remediation: Control enhancement: Implemented (Q4 2024) Validation testing: Completed (Q1 2025) Status: ✓ RESOLVED AUDIT COMMITTEE REPORTING: Quarterly reporting (to Audit Committee): - Audit status update (timeline, scope) - Findings (any identified) - Financial reporting highlights - Management letter items - Auditor independence confirmation Annual reporting (to Audit Committee): - Audit results and opinion - ICFR assessment - Auditor performance evaluation - Auditor fee discussion - Next year planning - Auditor independence + non-audit services review Audit Committee satisfaction: 4.5/5.0 (annual survey) ``` ## Output ### Audit Coordination Dashboard ``` EXTERNAL AUDIT DASHBOARD — Jan 2025 ══════════════════════════════════ Audit Engagement: Auditor: [Firm Name] (5-year tenure) Engagement partner: [Name] Team: 8-12 members Fee: $450K (audit) + $120K (other) = $570K total Scope: Consolidated FS + ICFR (5 entities) Timeline (FY2024 Audit): Planning: ✓ Complete (Nov 2024) Interim testing: ✓ Complete (Dec 2024) Year-end: ✓ Complete (Jan 2025) Final fieldwork: In progress (Jan-Feb 2025) Draft FS: Target Feb 15, 2025 Audit committee review: Target Feb 28, 2025 10-K filing: Target March 15, 2025 Evidence: Requests: 45 items Response rate: 96% on-time (target: >90%) Avg. response: 2.1 days (target: 3 days) Outstanding: 3 items (in preparation) Findings: Opinion: Unqualified (CLEAN) — expected Material weaknesses: 0 (past 5 years) Significant deficiencies: 0 (FY2024) Management letter items: 3 (all minor/moderate) Remediation: 100% resolved (0 carry-forward) ICFR: Controls tested: 42 Effective: 40/42 (95.2%) Remediated: 2/42 (5.8%) Overall assessment: EFFECTIVE Audit Committee: Next meeting: February 28, 2025 Board pack: Prepared (pending final audit data) Satisfaction: 4.5/5.0 (annual survey) Actions: 1. Complete outstanding evidence (3 items — Jan 30) 2. Final fieldwork coordination (ongoing) 3. Draft FS review (Feb 15) 4. Audit committee presentation (Feb 28) 5. 10-K filing coordination (Mar 15) ``` ## Integration Points - ERP/GL: Financial data, trial balance, journal entries, sub-ledgers - Audit management platforms (AuditBoard, TeamMate): Request tracking, workflow - Document management: Evidence storage, retrieval, version control - BI platforms: Audit analytics, data extraction - Audit committee portals: Board reporting, presentation materials - Internal audit platforms: Coordination, findings sharing - SEC filing platforms: EDGAR filing, XBRL tagging - GRC platforms: ICFR documentation, testing evidence - Communication platforms: Secure messaging, meeting coordination - Accounting platforms: Revenue schedules, tax provision models, impairment tests ## Edge Cases - **Material weakness identified**: Immediate disclosure; remediation plan; investor communication; board escalation - **Going concern doubt**: Liquidity assessment; remediation evidence; disclosure; investor briefing - **Audit firm change**: RFP process; transition planning; overlap period; audit committee approval - **PCAOB inspection**: Response coordination; documentation; remediation; audit committee notification - **Regulatory inquiry**: SEC/FPC inquiry response; audit committee involvement; legal counsel - **Scope expansion**: Additional testing; timeline impact; fee increase; management resources - **Disagreement with auditor**: Technical discussion; audit committee involvement; resolution; possible second opinion - **Data breach during audit**: Security response; auditor notification; evidence preservation; communication - **Key personnel change**: New team onboarding; knowledge transfer; relationship continuity - **Extended fieldwork**: Resource planning; management availability; timeline adjustment; cost impact