financial-report-generation

# Financial Report Generation

Generate formatted financial statements — income statements, balance sheets, cash flow statements — from raw transaction data or trial balance inputs. This skill applies standard accounting presentation, calculates key financial ratios, and produces executive summaries that translate numbers into actionable insights for stakeholders.

## Workflow

1. **Collect and Validate Financial Data**
   Ingest the source data: trial balance, general ledger exports, or categorized transaction records. Verify that debits equal credits and that the chart of accounts is complete. Identify the reporting period and comparative period (prior quarter or prior year). Flag any suspense account balances or unreconciled items that need resolution before reporting.

2. **Apply Accounting Standards and Classify**
   Map accounts to their proper financial statement classification: current vs. non-current assets, current vs. long-term liabilities, revenue vs. other income, operating vs. non-operating expenses. Apply accrual adjustments for prepaid expenses, deferred revenue, depreciation, and accrued liabilities. Ensure revenue recognition follows the applicable standard (ASC 606 for US GAAP or IFRS 15).

3. **Generate Financial Statements**
   Produce the three core statements in standard format. The income statement shows revenue through net income with gross profit and operating income subtotals. The balance sheet presents assets, liabilities, and equity with current/non-current breakdowns. The cash flow statement reconciles net income to operating cash flow, then shows investing and financing activities.

4. **Calculate Financial Ratios**
   Compute key ratios from the generated statements: gross margin, operating margin, net margin, current ratio, quick ratio, debt-to-equity, return on equity, days sales outstanding, inventory turnover, and free cash flow yield. Compare each ratio to the prior period and flag significant changes (>10% shift).

5. **Write Executive Summary**
   Synthesize the numbers into a narrative summary for non-financial stakeholders. Lead with the headline (revenue growth, profitability trend, cash position), then explain the 2-3 most significant drivers of performance. Highlight risks and call out items requiring management attention. Keep it to one page.

## Usage

Provide a trial balance, chart of accounts, or transaction-level data for the reporting period. Specify the reporting standard (GAAP or IFRS), period, and which statements you need.

**Example prompt:**
> Generate a Q3 2024 income statement from this trial balance data. Compare to Q3 2023. Include gross margin, operating margin, and an executive summary. We use US GAAP.

## Examples

### Example 1: Quarterly Income Statement

**Input:** Trial balance for Q3 2024 with comparative Q3 2023 data for a mid-size e-commerce company.

**Output:**

**Consolidated Income Statement — Q3 2024**

| Line Item                        | Q3 2024      | Q3 2023      | Change $     | Change % |
|----------------------------------|--------------|--------------|--------------|----------|
| **Revenue**                      |              |              |              |          |
| Product Revenue                  | $2,840,000   | $2,310,000   | +$530,000    | +22.9%   |
| Service Revenue                  | $460,000     | $380,000     | +$80,000     | +21.1%   |
| **Total Revenue**                | **$3,300,000** | **$2,690,000** | **+$610,000** | **+22.7%** |
| Cost of Goods Sold               | ($1,254,000) | ($1,049,100) | -$204,900    | +19.5%   |
| **Gross Profit**                 | **$2,046,000** | **$1,640,900** | **+$405,100** | **+24.7%** |
| Gross Margin                     | 62.0%        | 61.0%        |              | +1.0pp   |
|                                  |              |              |              |          |
| **Operating Expenses**           |              |              |              |          |
| Sales & Marketing                | ($594,000)   | ($510,800)   | -$83,200     | +16.3%   |
| Research & Development           | ($462,000)   | ($376,600)   | -$85,400     | +22.7%   |
| General & Administrative         | ($264,000)   | ($229,900)   | -$34,100     | +14.8%   |
| **Total Operating Expenses**     | **($1,320,000)** | **($1,117,300)** | **-$202,700** | **+18.1%** |
| **Operating Income**             | **$726,000** | **$523,600** | **+$202,400** | **+38.7%** |
| Operating Margin                 | 22.0%        | 19.5%        |              | +2.5pp   |
|                                  |              |              |              |          |
| Interest Expense                 | ($18,000)    | ($24,000)    | +$6,000      | -25.0%   |
| Other Income                     | $12,000      | $8,000       | +$4,000      | +50.0%   |
| **Income Before Tax**            | **$720,000** | **$507,600** | **+$212,400** | **+41.8%** |
| Income Tax Expense (25%)         | ($180,000)   | ($126,900)   | -$53,100     | +41.8%   |
| **Net Income**                   | **$540,000** | **$380,700** | **+$159,300** | **+41.8%** |
| Net Margin                       | 16.4%        | 14.2%        |              | +2.2pp   |

**Executive Summary:**
Revenue grew 22.7% year-over-year to $3.3M, driven by strong product demand and a 21% lift in service revenue from expanded support tiers. Gross margin improved 100 basis points to 62.0% as procurement renegotiations lowered COGS growth to 19.5%, below revenue growth. Operating leverage is emerging — opex grew only 18.1% against 22.7% revenue growth, expanding operating margin by 250 basis points to 22.0%. S&M efficiency improved with CAC payback declining from 14 months to 11 months. Net income of $540K is 42% above prior year. Key risk: R&D spend tracking at 14% of revenue requires monitoring to ensure product velocity justifies the investment.

### Example 2: Cash Flow Statement

**Input:** Q3 2024 income statement (above) plus balance sheet changes.

**Output:**

*