---
name: financial-report-generator
description: "Generates standardized financial reports with company-specific formatting, KPI calculations, and automated validation. Use this skill when: (1) Creating monthly/quarterly financial reports, (2) Generating P&L statements with variance analysis, (3) Building budget vs actual comparisons, (4) Producing executive summary dashboards"
---

# Financial Report Generator

Generate professional financial reports following company standards.

## Report Types Supported

1. **Monthly P&L Report** — Income statement with variance analysis
2. **Budget vs Actual** — Comparison with variance percentages
3. **Cash Flow Statement** — Operating, investing, financing activities
4. **Executive Dashboard** — KPIs summary for management review

## Workflow

1. **Analyze request** — Identify report type and required data
2. **Load data** — Read from uploaded files or user input
3. **Apply calculations** — Use formulas from references/kpi-definitions.md
4. **Generate report** — Create Excel file with proper formatting
5. **Validate** — Run scripts/validate_report.py to check for errors
6. **Deliver** — Output final report with summary

![Workflow Diagram](/images/posts/claude-skill-financial-report/workflow_diagram.png)

## Formatting Standards

See `references/formatting-standards.md` for detailed color codes and number formats.

### Quick Reference

- **Blue text** (RGB: 0,0,255) — Hardcoded inputs
- **Black text** (RGB: 0,0,0) — Formulas and calculations
- **Green text** (RGB: 0,128,0) — Cross-sheet references
- **Yellow highlight** — Cells requiring attention

![Formatting Standards](/images/posts/claude-skill-financial-report/formatting_standards.png)

### Number Formats

| Type       | Format      | Example       |
| ---------- | ----------- | ------------- |
| Currency   | $#,##0      | $1,234,567    |
| Percentage | 0.0%        | 15.5%         |
| Variance   | +0.0%;-0.0% | +5.2% / -3.1% |
| Multiples  | 0.0x        | 2.5x          |

## Critical Rules

1. **NEVER hardcode calculations** — Always use Excel formulas
2. **Document all assumptions** — Add comments for key inputs
3. **Zero formula errors** — No #REF!, #DIV/0!, #VALUE!, #N/A
4. **Recalculate before delivery** — Run recalc.py after generation

# Financial Report Formatting Standards

## Color Coding (Industry Standard)

### Text Colors

| Purpose           | RGB Code  | Hex     | Usage                        |
| ----------------- | --------- | ------- | ---------------------------- |
| Hardcoded inputs  | (0,0,255) | #0000FF | Values that users can modify |
| Formulas          | (0,0,0)   | #000000 | All calculated cells         |
| Cross-sheet links | (0,128,0) | #008000 | References to other sheets   |
| External links    | (255,0,0) | #FF0000 | Links to other workbooks     |

### Background Colors

| Purpose         | RGB Code      | Hex     | Usage                   |
| --------------- | ------------- | ------- | ----------------------- |
| Key assumptions | (255,255,0)   | #FFFF00 | Cells needing attention |
| Header rows     | (68,114,196)  | #4472C4 | Table headers           |
| Subtotals       | (217,225,242) | #D9E1F2 | Summary rows            |

## Number Formatting

### Currency Formats

---
name: financial-report-generator
description: "Generates standardized financial reports with company-specific formatting, KPI calculations, and automated validation. Use this skill when: (1) Creating monthly/quarterly financial reports, (2) Generating P&L statements with variance analysis, (3) Building budget vs actual comparisons, (4) Producing executive summary dashboards, (5) User mentions 'financial report', 'P&L', 'budget analysis', or 'quarterly report'"
---

# Financial Report Generator

Generate professional financial reports following company standards.

## Quick Start

When user requests a financial report:

1. Identify report type (P&L, Budget vs Actual, Cash Flow, Dashboard)
2. Collect required data from user
3. Generate Excel with proper formatting
4. Validate with `scripts/validate_report.py`
5. Deliver with executive summary

## Report Types

### 1. Monthly P&L Report

Structure:

- Sheet 1: Executive Summary
- Sheet 2: Detailed P&L (by month)
- Sheet 3: YoY Comparison
- Sheet 4: Assumptions

Required data:

- Revenue by category
- COGS breakdown
- Operating expenses
- Prior year comparables

### 2. Budget vs Actual

Structure:

- Sheet 1: Summary Dashboard
- Sheet 2: Revenue Analysis
- Sheet 3: Expense Analysis
- Sheet 4: Variance Details

Required data:

- Actual figures (current period)
- Budget figures
- Prior year actuals (optional)

### 3. Cash Flow Statement

Structure:

- Sheet 1: Cash Flow Summary
- Sheet 2: Operating Activities
- Sheet 3: Investing Activities
- Sheet 4: Financing Activities

### 4. Executive Dashboard

Structure:

- Sheet 1: KPI Summary (single page)
- Sheet 2: Trend Charts
- Sheet 3: Supporting Data

## Formatting Rules

### Colors (ALWAYS APPLY)

```python
from openpyxl.styles import Font, PatternFill

# Define standard colors
BLUE_INPUT = Font(color="0000FF")      # Hardcoded inputs
BLACK_FORMULA = Font(color="000000")   # Formulas
GREEN_LINK = Font(color="008000")      # Cross-sheet refs
YELLOW_HIGHLIGHT = PatternFill("solid", fgColor="FFFF00")
HEADER_FILL = PatternFill("solid", fgColor="4472C4")
```