--- name: financial-reporting description: 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 decks, SEC filings, segment analysis, or regulatory submissions. Triggers on phrases like "financial statements", "management report", "board deck", "SEC filing", "10-K 10-Q", "XBRL", "segment reporting", "regulatory filing", "financial reporting", "P&L report", "cash flow statement". --- # 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 - ERP/GL (NetSuite, SAP, Oracle): Financial data source, trial balance - BI platforms (Tableau, Power BI, Looker): Visualization, self-service analytics - Board portals (DataRoom, BoardBook): Secure distribution - Investor relations platforms (Q4, S&P IR): Investor communication - SEC filing systems (EDGAR, Workiva): Regulatory filing submission - XBRL tools (HFM, TM1, OneWare): Tagging and validation - Planning tools (Anaplan, Adaptive): Budget/forecast comparison - Document management: Report archive, version control - Presentation tools: Board deck assembly, chart generation ## Edge Cases - **First-time reporting**: New company establishing reporting framework; baseline metrics; historical reconstruction - **Accounting policy changes**: Retrospective vs. prospective application; dual presentation; MD&A explanation - **Restatements**: Prior period adjustment; dual-column presentation; management discussion; auditor coordination - **Multi-GAAP reporting**: US GAAP + IFRS reconciliation; dual reporting requirements - **Hypergrowth adjustments**: Scaling reporting infrastructure; automated report generation; real-time dashboards - **M&A reporting**: Pro-forma presentation; acquired entity integration; goodwill impairment testing - **Segment reorganization**: Recast prior period data; communicate changes to stakeholders - **Non-GAAP measures**: Reconciliation to GAAP; consistent definitions; regulatory compliance - **Interim vs. annual reporting**: Different detail levels; year-end adjustments; audit vs. review - **Private company reporting**: Simplified (vs. public); investor-focused; no SEC requirements