Financial Report Generator

Overview

This skill enables the creation of professional financial and business analysis reports from raw data files. It transforms Excel/CSV data into executive-ready Word documents with intelligent analysis, appropriate charts, and structured insights.

When to use this skill:
- User uploads Excel/CSV files with financial or business data
- User requests data analysis and visualization
- User needs professional reports for management/executives
- User wants monthly/quarterly business analysis reports
- User mentions "financial report", "business analysis", "management report"

Core Workflow

Follow this sequential workflow when generating reports:

1. Data Intake & Analysis

• Read and parse Excel/CSV files
• Perform statistical analysis (trends, comparisons, ratios)
• Identify key metrics and patterns
• See scripts/analyze_data.py for analysis utilities

2. Chart Generation

• Select appropriate chart types based on data characteristics
• Generate charts using Python (matplotlib/seaborn)
• Save charts as images for embedding in Word
• See scripts/generate_charts.py for chart generation
• See references/chart_guide.md for chart selection criteria

3. Report Structure & Content

• Follow the standard report structure from references/report_structure.md
• Include: Executive Summary, Key Metrics, Trend Analysis, Insights & Recommendations
• Use professional formatting and clear data visualization

4. Word Document Generation

• Use the docx-js library to create formatted Word documents
• Apply consistent styling and branding
• Embed charts and tables appropriately
• See scripts/create_report.py for document generation
• Reference the report template at assets/report_template.docx

Quick Reference

Report Structure Guidelines

All reports should follow this professional structure:

1. Executive Summary (执行摘要)

• Key findings and insights
• Critical metrics and trends
• Strategic recommendations

2. Business Overview (经营概况)

• Revenue and growth metrics
• Market position and competitive landscape
• Industry context and benchmarks

3. Financial Analysis (财务分析)

• Revenue analysis by segment/product
• Cost structure and profitability
• Key financial ratios and indicators
• Month-over-month and year-over-year comparisons

4. Key Performance Indicators (关键指标)

• Market share and growth rates
• Customer acquisition and retention
• Operational efficiency metrics

5. Insights & Recommendations (专业建议)

• Strategic opportunities
• Risk factors and mitigation
• Actionable recommendations for management

For detailed structure and examples, see references/report_structure.md.

Chart Selection Guide

Choose chart types based on data characteristics:

For detailed guidance, see references/chart_guide.md.

Technical Implementation

Data Analysis

Use Python with pandas for data processing:

import pandas as pd

# Read Excel file
df = pd.read_excel('data.xlsx', sheet_name='Sheet1')

# Basic statistics
summary = df.describe()

# Time series analysis
monthly_trend = df.groupby('Month')[['Revenue', 'Profit']].sum()

# Calculate ratios
df['Profit_Margin'] = df['Profit'] / df['Revenue'] * 100

For advanced analysis functions, see scripts/analyze_data.py.

Chart Generation

Generate charts using matplotlib and save as PNG for Word embedding:

import matplotlib.pyplot as plt
import seaborn as sns

# Line chart for trends
plt.figure(figsize=(10, 6))
plt.plot(df['Month'], df['Revenue'])
plt.title('Monthly Revenue Trend')
plt.savefig('revenue_trend.png', dpi=300, bbox_inches='tight')

For chart generation utilities, see scripts/generate_charts.py.

Word Document Creation

Use docx-js (Node.js) to create formatted Word documents:

const { Document, Packer, Paragraph, TextRun, Table, ImageRun } = require('docx');

// Create document with professional formatting
const doc = new Document({
  sections: [{
    children: [
      new Paragraph({
        text: 'Monthly Business Analysis Report',
        heading: HeadingLevel.HEADING_1
      }),
      // Add content, tables, and images
    ]
  }]
});

// Save document
Packer.toBuffer(doc).then(buffer => {
  fs.writeFileSync('report.docx', buffer);
});

For document generation utilities, see scripts/create_report.py.

Examples

Example 1: Monthly Business Analysis Report

User request: "我上传了公司2024年5月的经营数据（Excel文件），帮我生成一份给老板看的月度经营分析报告。"

Skill workflow:
1. Read Excel file with revenue, cost, profit data by department
2. Calculate key metrics: total revenue, profit margin, YoY growth
3. Generate charts: revenue trend (line), cost breakdown (pie), profit by department (bar)
4. Structure report: Executive Summary → Business Overview → Financial Analysis → KPIs → Recommendations
5. Generate Word document with professional formatting and embedded charts

Example 2: Financial Performance Report

User request: "基于这份财务年报，生成一份专业的财务分析报告，包括盈利能力、偿债能力和运营效率分析。"

Skill workflow:
1. Parse financial statements from the annual report
2. Calculate financial ratios: ROE, ROA, current ratio, asset turnover
3. Generate charts: ratio trends, comparative analysis
4. Structure report with financial analysis focus
5. Output Word document with detailed financial insights

Resources

This skill includes the following resources:

scripts/

• analyze_data.py - Data analysis and statistical utilities
• generate_charts.py - Chart generation with matplotlib
• create_report.py - Word document creation utilities

references/

• report_structure.md - Detailed report structure and formatting guidelines
• chart_guide.md - Chart selection criteria and best practices
• financial_metrics.md - Common financial metrics and calculations

assets/

• report_template.docx - Word document template with professional formatting