Financial Reporting Automation: 75% Time Reduction

Analyze financial data and create executive report:

COMPANY: [Name]
PERIOD: [Month/Quarter/Year]
COMPARISON: [vs Prior Period, vs Budget, vs Forecast]

FINANCIAL DATA:
Revenue: [Current, Prior, Budget]
Gross Margin: [%, $, trends]
Operating Expenses: [Breakdown by category]
EBITDA: [Current, margin %, YoY change]
Cash Flow: [Operating, Investing, Financing]
Balance Sheet: [Key metrics]
KPIs: [Industry-specific metrics]

Generate comprehensive analysis:

1. EXECUTIVE SUMMARY
   Financial Health Score: [Strong/Stable/Concern]
   - Top achievement: [Best metric with context]
   - Primary concern: [Biggest issue]
   - Key decision needed: [Action required]
   - Cash runway: [Months]

2. REVENUE ANALYSIS
   Performance Overview:
   - Total Revenue: $[Amount] ([%] vs target)
   - Growth Rate: [%] MoM, [%] YoY
   - Revenue Quality: [Recurring vs One-time]
   
   By Segment:
   Product/Service | Revenue | Growth | % of Total | Trend
   ---------------|---------|--------|------------|-------
   [Detailed breakdown]
   
   Geographic Performance:
   - Strongest region: [Region] (+X%)
   - Weakest region: [Region] (-X%)
   - Expansion opportunities: [Analysis]

3. PROFITABILITY DEEP DIVE
   Margin Analysis:
   - Gross Margin: [%] (△ [points] vs PY)
   - Operating Margin: [%] (△ [points])
   - Net Margin: [%] (△ [points])
   
   Cost Structure:
   Category | Amount | % Revenue | vs Budget | Action
   ---------|--------|-----------|-----------|--------
   COGS | $X | X% | +/- X% | [Optimize/Monitor]
   Sales | $X | X% | +/- X% | [Action]
   Marketing | $X | X% | +/- X% | [Action]
   R&D | $X | X% | +/- X% | [Action]
   G&A | $X | X% | +/- X% | [Action]

4. CASH FLOW INTELLIGENCE
   Operating Cash Flow:
   - Generated: $[Amount]
   - Conversion Rate: [% of revenue]
   - DSO: [Days] (△ [days] vs target)
   - DPO: [Days] (△ [days])
   - Cash Cycle: [Days]
   
   Liquidity Position:
   - Current Cash: $[Amount]
   - Burn Rate: $[Monthly]
   - Runway: [Months]
   - Working Capital: $[Amount]
   - Quick Ratio: [X]

5. VARIANCE ANALYSIS
   Budget vs Actual:
   Line Item | Budget | Actual | Variance | % | Explanation
   ----------|--------|--------|----------|---|-------------
   [Major variances >5%]
   
   Root Cause Analysis:
   - Positive variances: [Drivers]
   - Negative variances: [Causes]
   - Corrective actions: [Plans]

6. KEY METRICS & RATIOS
   Efficiency Metrics:
   - CAC: $[Amount] (△ [%])
   - LTV/CAC: [Ratio]
   - Magic Number: [Sales efficiency]
   - Rule of 40: [Growth + Margin]
   
   Financial Health:
   - Debt/Equity: [Ratio]
   - Interest Coverage: [X times]
   - Current Ratio: [X]
   - ROE: [%]
   - ROIC: [%]

7. FORECAST ACCURACY
   Previous Forecasts vs Actual:
   - Revenue: [% accuracy]
   - Expenses: [% accuracy]
   - Cash Flow: [% accuracy]
   
   Updated Forecast:
   - Q[X] Revenue: $[Amount]
   - Full Year: $[Amount]
   - Confidence Level: [High/Medium/Low]
   - Key Assumptions: [List]

8. RISK ASSESSMENT
   Financial Risks:
   Risk | Probability | Impact | Mitigation
   -----|-------------|--------|------------
   [Top 5 risks identified]

9. STRATEGIC RECOMMENDATIONS
   Immediate Actions (This Month):
   1. [Specific action with impact]
   2. [Cost optimization opportunity]
   3. [Revenue acceleration tactic]
   
   Strategic Initiatives (Quarter):
   1. [Growth opportunity]
   2. [Efficiency improvement]
   3. [Risk mitigation]

10. BOARD TALKING POINTS
    - Headline metric: [The one number to highlight]
    - Success story: [Win to celebrate]
    - Challenge: [Issue needing board input]
    - Ask: [Specific board action needed]

Format for clarity, highlight anomalies, make it actionable.

Perform detailed budget variance analysis:

PERIOD: [Month/Quarter]
BUDGET DATA: [Planned amounts by category]
ACTUAL DATA: [Actual amounts by category]
THRESHOLD: [% for material variance]
PRIOR PERIODS: [Historical data for trending]

Generate variance report:

1. EXECUTIVE VARIANCE SUMMARY
   Overall Performance:
   - Total Budget: $[Amount]
   - Total Actual: $[Amount]
   - Variance: $[Amount] ([%])
   - Status: [On Track/Caution/Alert]

2. MATERIAL VARIANCES (>X%)
   Ranked by Impact:
   
   Variance #1: [Category]
   - Budget: $[Amount]
   - Actual: $[Amount]
   - Variance: $[Amount] ([%])
   - Driver: [Root cause]
   - Trend: [Improving/Worsening]
   - Action: [Corrective measure]
   - Owner: [Responsible party]
   - Timeline: [Resolution date]

   [Continue for all material variances]

3. VARIANCE CATEGORIZATION
   Controllable Variances:
   - [Items within management control]
   - Total Impact: $[Amount]
   - Recovery Plan: [Actions]
   
   Uncontrollable Variances:
   - [External factors]
   - Total Impact: $[Amount]
   - Mitigation: [Strategies]
   
   Timing Variances:
   - [Temporary timing differences]
   - Expected Resolution: [When]

4. TREND ANALYSIS
   Recurring Variances:
   Item | Frequency | Avg Variance | Pattern
   -----|-----------|--------------|----------
   [Items with 3+ month variances]
   
   Improving Areas:
   - [Categories with reducing variance]
   
   Deteriorating Areas:
   - [Categories with increasing variance]

5. DEPARTMENTAL BREAKDOWN
   By Department:
   Dept | Budget | Actual | Var $ | Var % | Status
   -----|--------|--------|-------|-------|--------
   [All departments ranked by variance]

6. ROOT CAUSE ANALYSIS
   Top 5 Variance Drivers:
   1. [Cause]: Impact $[Amount]
      - Evidence: [Data points]
      - Correction: [Action plan]
   
   2-5. [Continue analysis]

7. FORECAST IMPLICATIONS
   Impact on Full Year:
   - Original Forecast: $[Amount]
   - Revised Forecast: $[Amount]
   - Confidence: [High/Medium/Low]
   - Key Assumptions Changed: [List]

8. CORRECTIVE ACTION PLAN
   Immediate (This Week):
   - Action: [Specific step]
   - Owner: [Person]
   - Expected Savings: $[Amount]
   
   Short-term (This Month):
   - [Actions with owners and impact]
   
   Strategic (This Quarter):
   - [Longer-term adjustments]

9. EARLY WARNING INDICATORS
   Watch List for Next Period:
   - [Metrics trending toward variance]
   - [Leading indicators to monitor]
   - [Thresholds for action]

10. RECOMMENDATIONS
    For CFO/Board:
    - Budget Adjustment: [Yes/No, amount]
    - Policy Change: [If needed]
    - Investment/Cuts: [Specific areas]
    - Risk Provisions: [Contingency needs]

Make it visual-ready with clear actions and owners.

Create 13-week cash flow forecast:

STARTING CASH: $[Amount]
REVENUE PIPELINE: [Contracted, probable, possible]
PAYABLES: [Scheduled payments by week]
RECEIVABLES: [Expected collections with probability]
HISTORICAL DATA: [Past 6 months patterns]

Generate detailed forecast:

1. WEEKLY CASH POSITION
Week | Starting | Inflows | Outflows | Net | Ending | Status
-----|----------|---------|----------|-----|--------|--------
W1 | $X | $X | $X | $X | $X | [Safe/Tight/Critical]
W2-13 [Continue for all weeks]

2. CASH INFLOW ANALYSIS
   Confirmed Revenue (90%+ probability):
   - Week 1-4: $[Amount] from [sources]
   - Week 5-8: $[Amount] from [sources]
   - Week 9-13: $[Amount] from [sources]
   
   Probable Revenue (60-89%):
   - Pipeline value: $[Amount]
   - Expected conversion: $[Amount]
   - Timing: [Week distribution]
   
   Collection Patterns:
   - DSO trend: [Days]
   - Collection rate: [%]
   - At-risk receivables: $[Amount]

3. CASH OUTFLOW PROJECTIONS
   Fixed Obligations:
   - Payroll: $[Amount] on [dates]
   - Rent/Lease: $[Amount] on [dates]
   - Debt Service: $[Amount] on [dates]
   - Total Fixed: $[Amount/week]
   
   Variable Expenses:
   - Suppliers: $[Amount] with terms
   - Operating: $[Amount] by category
   - Discretionary: $[Amount] deferrable
   
   One-time Payments:
   - [List with amounts and weeks]

4. SCENARIO ANALYSIS
   Best Case (+20% revenue):
   - Minimum Cash: $[Amount] in Week [X]
   - End Position: $[Amount]
   
   Base Case:
   - Minimum Cash: $[Amount] in Week [X]
   - End Position: $[Amount]
   
   Worst Case (-20% revenue, delayed collections):
   - Minimum Cash: $[Amount] in Week [X]
   - End Position: $[Amount]
   - ALERT: [If negative]

5. CASH OPTIMIZATION OPPORTUNITIES
   Acceleration Options:
   - Early payment discounts: Save $[Amount]
   - Invoice factoring: Access $[Amount]
   - Collection improvements: $[Amount]
   
   Deferral Options:
   - Vendor payment terms: Defer $[Amount]
   - Discretionary spending: Save $[Amount]
   - Capex postponement: Preserve $[Amount]

6. WORKING CAPITAL METRICS
   Current State:
   - Working Capital: $[Amount]
   - Current Ratio: [X]
   - Quick Ratio: [X]
   - Cash Conversion Cycle: [Days]
   
   Projected Changes:
   - Week 4: [Metrics]
   - Week 8: [Metrics]
   - Week 13: [Metrics]

7. RISK ALERTS
   Critical Weeks:
   - Week [X]: Cash below $[threshold]
   - Action Required: [Specific steps]
   
   Key Dependencies:
   - Customer [X] payment of $[Amount]
   - Credit line availability
   - Seasonal factors

8. CREDIT FACILITY STATUS
   Available Credit:
   - Line of Credit: $[Available] of $[Total]
   - Draw Recommendation: [When and amount]
   - Covenant Status: [Compliance check]

9. ACTION PLAN
   This Week:
   - Accelerate collections from [specific customers]
   - Defer [specific payments] if possible
   - Draw [amount] from credit line if needed
   
   Ongoing:
   - Daily cash position monitoring
   - Weekly forecast updates
   - Monthly trend analysis

10. DASHBOARD METRICS
    - Days Cash on Hand: [X]
    - Burn Rate: $[Daily/Weekly]
    - Runway: [Weeks/Months]
    - Liquidity Score: [Rating]

Flag any week with cash below minimum threshold.

Create comprehensive investor update:

COMPANY: [Name]
QUARTER: [Q# YYYY]
INVESTORS: [VC/PE/Public/Board]

PERFORMANCE DATA:
- Revenue: [Actual vs Plan]
- Burn/Profitability: [Metrics]
- Cash Position: [Current and runway]
- Key Metrics: [MRR, CAC, LTV, etc.]
- Highlights: [Major wins]
- Challenges: [Issues faced]

Generate investor-grade report:

1. EXECUTIVE SUMMARY
   Quarter at a Glance:
   - Headline: [One impressive metric/achievement]
   - Revenue: $[X]M ([%] vs plan, [%] YoY)
   - Burn/EBITDA: $[X]M ([trajectory])
   - Cash: $[X]M ([months] runway)
   - Team: [Headcount] ([change])
   
   Investment Thesis Status: [Strengthening/On Track/Evolving]

2. FINANCIAL PERFORMANCE
   Revenue Performance:
   - Q[X] Actual: $[Amount]
   - Q[X] Plan: $[Amount]
   - Variance: [%] ([explanation])
   - YoY Growth: [%]
   - QoQ Growth: [%]
   
   Revenue Quality:
   - Recurring: [%] of total
   - Gross Margin: [%]
   - Net Revenue Retention: [%]
   - Logo Retention: [%]

3. KEY METRICS DASHBOARD
   Growth Metrics:
   Metric | Q[X-1] | Q[X] | Target | Trend
   -------|--------|------|--------|-------
   MRR/ARR | $X | $X | $X | [↑→↓]
   Customers | X | X | X | [↑→↓]
   ARPU | $X | $X | $X | [↑→↓]
   
   Unit Economics:
   - CAC: $[Amount] (△[%] QoQ)
   - LTV: $[Amount] (△[%] QoQ)
   - LTV/CAC: [Ratio]
   - Payback: [Months]
   - Gross Margin: [%]

4. STRATEGIC PROGRESS
   Milestones Achieved:
   ✓ [Major milestone 1]
   ✓ [Major milestone 2]
   ✓ [Major milestone 3]
   
   Product Developments:
   - Launched: [Features/products]
   - In Development: [Coming next quarter]
   - Customer Impact: [Metrics improved]

5. MARKET & COMPETITION
   Market Position:
   - Market Size: $[TAM update]
   - Our Share: [%]
   - Growth vs Market: [Multiple]
   
   Competitive Dynamics:
   - Wins: [Customers won from competitors]
   - Threats: [New entrants/movements]
   - Differentiation: [Strengthening/stable]

6. CUSTOMER INSIGHTS
   Customer Success:
   - NPS: [Score] (△[points])
   - Case Study: [Marquee customer success]
   - Expansion: [Upsell/cross-sell wins]
   
   Pipeline Health:
   - Pipeline Value: $[Amount]
   - Pipeline Coverage: [X]x quota
   - Sales Cycle: [Days]
   - Win Rate: [%]

7. TEAM & CULTURE
   Organization:
   - Headcount: [Total] (+/- [X] QoQ)
   - Key Hires: [Senior positions filled]
   - Open Roles: [Critical positions]
   - Retention: [%] (voluntary turnover)

8. CHALLENGES & SOLUTIONS
   Challenge 1: [Issue]
   - Impact: [Quantified effect]
   - Root Cause: [Analysis]
   - Solution: [Action plan]
   - Timeline: [Resolution expected]

9. CASH & FINANCING
   Cash Management:
   - Starting Cash: $[Amount]
   - Operating CF: $[Amount]
   - Ending Cash: $[Amount]
   - Burn Rate: $[Monthly]
   - Runway: [Months]
   
   Capital Strategy:
   - Next Raise: [Timing if applicable]
   - Use of Funds: [If raising]
   - Path to Profitability: [Timeline]

10. OUTLOOK & ASKS
    Next Quarter Focus:
    1. [Top priority with metric]
    2. [Second priority]
    3. [Third priority]
    
    FY Guidance:
    - Revenue: $[Range]
    - Profitability: [Timeline]
    - Key Milestones: [List]
    
    Board/Investor Asks:
    - Introductions: [Specific requests]
    - Expertise: [Areas needing help]
    - Strategic: [Decisions needing input]

Tone: Confident but honest, data-driven, forward-looking