Finance AI Skill

Financial Reporting

Generate financial statements, management reports, regulatory filings, and board packages including income statements, balance sheets, cash flow statements, segment reporting, and XBRL-tagged filings. Use when producing monthly financial reports, board deck...

Financial Reporting

Produce accurate, timely financial statements and management reports for internal and external stakeholders.

Financial Statement Generation

Automated Statement Production

Trigger at month-end close completion (or on-demand for management reporting):

FINANCIAL STATEMENT GENERATION PROCESS:
════════════════════════════════════════

Step 1: Trial Balance Extraction
  - Final trial balance (post-close, all adjustments posted)
  - All entities included
  - All currencies translated to reporting currency
  - Prior period comparatives loaded

Step 2: Account-to-Line-Item Mapping
  - Chart of accounts mapped to financial statement lines
  - GAAP/IFRS presentation format applied
  - Materiality thresholds applied (immaterial items aggregated)
  - Reclassification entries (if needed for presentation)

Step 3: Statement Assembly
  - Income Statement: Revenue through net income
  - Balance Sheet: Assets, liabilities, equity
  - Cash Flow Statement: Operating, investing, financing
  - Statement of Changes in Equity
  - Notes to financial statements (standard disclosures)

Step 4: Variance Analysis
  - Prior period comparison (absolute and percentage)
  - Budget/forecast comparison
  - Year-to-date variance
  - Key ratio calculations

Step 5: Review & Approval
  - Controller review (accuracy, completeness)
  - CFO sign-off (reasonableness, commentary)
  - CEO sign-off (SOX certification, if public)
  - Audit Committee review (quarterly/annual)

Financial Statement Templates

INCOME STATEMENT — Standard Presentation (GAAP)
════════════════════════════════════════════════

Revenue:
  Product revenue:                    $________
  Subscription revenue:               $________
  Professional services:              $________
  Other revenue:                      $________
  Total Revenue:                      $________

Cost of Revenue:
  Cost of goods sold:                 $________
  Hosting/infrastructure:             $________
  Personnel (delivery):               $________
  Total Cost of Revenue:              $________
  
  GROSS PROFIT:                       $________   (____% margin)

Operating Expenses:
  Research & Development:
    Personnel:                        $________
    Contract services:                $________
    Software/tools:                   $________
    R&D Total:                        $________
  
  Sales & Marketing:
    Sales personnel:                  $________
    Marketing spend:                  $________
    Commissions:                      $________
    S&M Total:                        $________
  
  General & Administrative:
    Executive/management:             $________
    Finance/accounting:               $________
    HR:                               $________
    Legal:                            $________
    Facilities:                       $________
    Other G&A:                        $________
    G&A Total:                        $________
  
  Total Operating Expenses:           $________

OPERATING INCOME:                     $________   (____% margin)

Other Income/Expense:
  Interest income:                    $________
  Interest expense:                   $________
  Foreign exchange gain/(loss):       $________
  Other (non-operating):              $________
  Total Other:                        $________

INCOME BEFORE TAXES:                  $________
Income tax provision:                 $________

NET INCOME:                           $________   (____% margin)

Earnings Per Share (Basic):           $________
Earnings Per Share (Diluted):         $________
Weighted Avg Shares (Basic):          ________
Weighted Avg Shares (Diluted):        ________

Management Reporting

Department-Level P&L

MANAGEMENT P&L REPORT — Department View
════════════════════════════════════════

DEPARTMENT: Engineering
PERIOD: January 2025
MANAGER: [VP of Engineering]

Revenue (Allocated):
  Direct revenue: $0 (cost center)
  Internal chargebacks: $0
  Allocated revenue: $48,000,000 (headcount-based allocation)

Expenses:
  Personnel:
    Salaries:                     $3,200,000
    Bonuses:                        $180,000
    Benefits:                       $540,000
    Stock compensation:             $320,000
    Personnel Total:              $4,240,000
  
  Operating:
    Cloud infrastructure:           $420,000
    Software licenses:              $185,000
    Contractor fees:                $125,000
    Training/certifications:         $45,000
    Other:                           $30,000
    Operating Total:              $805,000
  
  TOTAL DEPARTMENT EXPENSE:       $5,045,000

Budget vs Actual:
  Budget:                         $4,850,000
  Actual:                         $5,045,000
  Variance:                       $195,000 (+4.0%)
  YTD Budget:                    $14,550,000
  YTD Actual:                    $15,235,000
  YTD Variance:                   $685,000 (+4.7%)

Headcount:
  Budgeted: 145                   Actual: 148 (+3)
  New hires (month): 4             Attrition: 1
  Open requisitions: 7

Variance Explanation:
  Cloud infrastructure +$80K above budget:
    Auto-scaling costs during product launch traffic spike
    One-time; expected to normalize in February
  
  Personnel +$110K above budget:
    3 engineers hired 1 month earlier than planned
    2 contractor extensions ($35K) for launch support

Key Metrics:
  Revenue per engineer: $324,324 (allocated)
  Expense per engineer: $34,088
  Cloud cost per deploy: $2,100

Executive Dashboard Reports

EXECUTIVE FINANCIAL SUMMARY — January 2025
════════════════════════════════════════════

KEY HIGHLIGHTS:
  ✓ Revenue $42.1M (+4.5% vs budget, +42% YoY)
  ✓ Gross margin 78.1% (+0.4pp vs budget)
  ⚠ Operating expenses $28.4M (+3.3% vs budget)
  ✓ Operating income $3.7M (8.8% margin)
  ✓ Cash position $42.1M (13.2 months runway)
  ✓ Net revenue retention 112%

QUARTER-TO-DATE (Q1 2025):
  Revenue: $124.2M (31% of annual budget of $400M)
  Gross profit: $97.1M (78.2% margin)
  Operating income: $10.8M (8.7% margin)
  Net income: $8.2M (6.6% margin)
  Free cash flow: $6.4M

TREND ANALYSIS (Last 6 Months):
  Revenue growth: ↑↑↑ Strong (avg 8% MoM)
  Gross margin: ↑ Improving (76.8% → 78.1%)
  CAC: → Stable ($4,200)
  Churn: ↑ Concern (2.2% → 2.8%, monitor)
  Operating leverage: ↑ Improving (OpEx/Rev declining)

ACTION ITEMS:
  1. Address Q1 churn uptick — root cause analysis by Feb 10
  2. Cloud cost optimization — FinOps initiative by Mar 1
  3. Update Q2 forecast — reflect January actuals
  4. Board meeting prep — draft Q1 review deck by Feb 15

Board & Investor Reporting

Board Package Assembly

BOARD MEETING PACKAGE — Q1 2025 Review
════════════════════════════════════════

PACKAGE CONTENTS:
  1. Executive Summary (2 pages)
  2. Financial Results — Q1 2025 (4 pages)
  3. Revenue Analysis by Segment (3 pages)
  4. Operating Expense Review (2 pages)
  5. Cash Flow & Balance Sheet (2 pages)
  6. Key Metrics Dashboard (2 pages)
  7. Strategic Initiatives Update (3 pages)
  8. Risk Review (2 pages)
  9. Outlook & Guidance (2 pages)
  10. Appendix: Detailed Financials (10 pages)
  
  Total: ~32 pages

ASSEMBLY TIMELINE:
  Day -10: Data collection begins
  Day -7: Draft financials complete
  Day -5: CFO review of all sections
  Day -4: CEO review of narrative sections
  Day -3: Final edits and formatting
  Day -2: Distribution to board members
  Day 0: Board meeting

AUTO-GENERATED SECTIONS:
  - Financial tables (from ERP data)
  - Charts and graphs (from BI platform)
  - KPI dashboards (real-time pull)
  - Variance analysis (auto-calculated)
  
  MANUAL SECTIONS (AI-assisted drafting):
  - Executive summary narrative
  - Strategic updates
  - Risk commentary
  - Outlook discussion
  
DISTRIBUTION:
  Secure portal upload (board portal)
  Email notification with access link
  Printed copies for in-person meeting
  NDA acknowledgment confirmation

Investor Update Template

MONTHLY INVESTOR UPDATE — January 2025
════════════════════════════════════════

COMPANY: [Company Name]
PERIOD: January 2025
DISTRIBUTION: All investors via secure portal

══════════════════════════════════════════
SECTION 1: KEY METRICS SNAPSHOT
══════════════════════════════════════════

  MRR: $12.4M (+8% MoM, +42% YoY)
  ARR: $148.8M
  Net Revenue Retention: 112%
  Gross Margin: 78.1%
  Customers: 1,247 (+37 new this month)
  Cash Position: $42.1M
  Runway: 13.2 months

══════════════════════════════════════════
SECTION 2: FINANCIAL HIGHLIGHTS
══════════════════════════════════════════

  Revenue: $42.1M
  Gross Profit: $32.9M
  Operating Expenses: $28.4M
  Operating Income: $4.5M
  Net Income: $3.2M
  Free Cash Flow: $2.8M

  vs. Budget: Revenue +4.5%, OpEx +3.3%, OI +2.1%
  vs. Prior Year: Revenue +42%, Gross margin +1.2pp

══════════════════════════════════════════
SECTION 3: PRODUCT & CUSTOMER UPDATES
══════════════════════════════════════════

  Product Launches:
    - v3.2 release (Jan 15): AI-powered analytics module
    - API v2.0 (Jan 20): Enhanced developer experience
  
  Customer Wins:
    - Enterprise: GlobalTech Corp ($480K ACV)
    - Enterprise: DataFlow Inc ($320K ACV)
    - Mid-market: 12 new customers ($84K total ARR)
  
  Net Promoter Score: 62 (+5 vs Q4)

══════════════════════════════════════════
SECTION 4: STRATEGIC MILESTONES
══════════════════════════════════════════

  ✓ Completed Series A follow-on ($15M)
  ✓ Opened European office (Dublin)
  ✓ Launched partner channel program
  → Q2 target: SOC 2 Type II certification
  → Q2 target: Product line extension launch
  → Q2 target: Series B initiation

══════════════════════════════════════════
SECTION 5: RISK & MITIGATION
══════════════════════════════════════════

  Revenue concentration: Top 5 customers = 28% → Diversification in progress
  Churn uptick: 2.8% vs. 2.2% Q4 → CS program enhancement planned
  Competitive: 2 new entrants → R&D investment maintaining differentiation
  
══════════════════════════════════════════
SECTION 6: USE OF FUNDS
══════════════════════════════════════════

  Series A capital deployed: 62% of total raised
    Product/R&D: 35%
    Sales/Marketing: 30%
    Operations: 20%
    Reserve: 15%

Regulatory & SEC Filings

Public Company Reporting

SEC FILING CALENDAR (if public):
══════════════════════════════════

ANNUAL FILINGS:
  Form 10-K: Due 60-90 days after fiscal year-end
    - Comprehensive annual report
    - Audited financial statements
    - MD&A, risk factors, corporate governance
    - XBRL-tagged financial data
    - Certifications (CEO/CFO)
  
  Proxy Statement (DEF 14A): Before annual shareholder meeting
    - Director nominations, executive compensation
    - Say-on-pay, say-on-frequency
    - Related party transactions
    - Audit committee report

QUARTERLY FILINGS:
  Form 10-Q: Due 30-40 days after quarter-end
    - Unaudited financial statements
    - MD&A (condensed)
    - Controls and procedures
    - XBRL-tagged data

CURRENT FILINGS:
  Form 8-K: Within 4 business days of material event
    - Material agreements
    - Executive changes
    - Financial results (voluntary)
    - M&A transactions
    - Debt transactions

XBRL TAGGING PROCESS:
  1. Extract financial data from final trial balance
  2. Map to SEC taxonomies (US GAAP)
  3. Apply fact-level tags
  4. Validate against SEC validation rules
  5. Review tagged filing for accuracy
  6. Submit to EDGAR system

FILING QUALITY METRICS:
  Deficiency letters received: 0 (clean filing history)
  XBRL validation errors: 0
  Late filings: 0
  Restatements: 0

Segment & Product Reporting

Multi-Segment Reporting

SEGMENT REPORTING — January 2025
════════════════════════════════

BUSINESS SEGMENTS:
  ┌─────────────────┬──────────┬──────────┬──────────┬──────────┐
  │ Segment         │ Revenue  │ % Total  │ Gross M. │ OpEx     │
  ├─────────────────┼──────────┼──────────┼──────────┼──────────┤
  │ Enterprise      │ $24.1M   │ 57.2%    │ 81.2%    │ $8.2M    │
  │ Mid-Market      │ $11.8M   │ 28.0%    │ 76.5%    │ $6.4M    │
  │ SMB             │ $4.2M    │ 10.0%    │ 72.1%    │ $3.1M    │
  │ Professional Svc│ $2.0M    │ 4.8%     │ 58.0%    │ $1.8M    │
  │ ─────────────── │ ──────── │ ──────── │ ──────── │ ──────── │
  │ Total           │ $42.1M   │ 100%     │ 78.1%    │ $19.5M   │
  └─────────────────┴──────────┴──────────┴──────────┴──────────┘

GEOGRAPHIC SEGMENTS:
  North America:  $32.4M (77.0%)  ↑ 5.2% vs budget
  Europe:         $6.8M (16.1%)   ↑ 12.1% vs budget
  Asia-Pacific:   $2.1M (5.0%)    ↑ 3.8% vs budget
  Rest of World:  $0.8M (1.9%)    ↓ 2.1% vs budget

PRODUCT LINE REPORTING:
  Core Platform:  $28.4M (67.5%)  Gross margin: 82%
  Add-on Modules: $8.7M (20.7%)   Gross margin: 74%
  Professional Svc: $2.0M (4.8%)  Gross margin: 58%
  Other/Other:    $3.0M (7.0%)    Gross margin: 65%

KEY INSIGHTS:
  - Enterprise segment outperforming (strong deal pipeline)
  - Europe growth above budget (accelerated expansion)
  - SMB churn slightly elevated — monitor retention
  - Professional services margin below target — pricing review

Output

Reporting Dashboard View

FINANCIAL REPORTING DASHBOARD — Jan 27, 2025
══════════════════════════════════════════════

Statement Status:
  January financials:  ✓ Complete (Day 7 close)
  Q1 package:          In progress (60%)
  Board deck:          Drafting (30%)
  Investor update:     Drafting (25%)

Reporting Schedule:
  Internal management:  Due Feb 5 (8 days)
  Board package:        Due Feb 15 (19 days)
  Investor update:      Due Feb 7 (11 days)
  SEC 10-Q (if public): Due May 15

Compliance:
  Prior filings:        All on time (0 late)
  XBRL validation:      Clean (0 errors)
  Deficiency letters:   0
  Restatements:         0

Data Quality:
  Trial balance:        ✓ Locked (Jan 2025)
  Recs complete:        100%
  JE documentation:     100%
  Variance analysis:    85% complete

Distribution:
  Board portal:         Active (8 members)
  Investor portal:      Active (23 investors)
  Internal dashboard:   Live (Tableau/Power BI)
  Mobile access:        Enabled

Integration Points

Edge Cases