Finance AI Skill

External Audit

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 aud...

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