shield_lock
金大哥
← 返回 Skill 列表
extension
分类: 数据与分析无需 API Key

Financial Report Generator

Generate professional financial and business analysis reports from Excel/CSV data. Use when users upload financial data files (Excel, CSV) and request: (1) data analysis and statistical analysis, (2) generating charts and visualizations, (3) creating professional Word reports for management, (4) monthly/quarterly business analysis reports, (5) financial performance reports. The skill reads data, performs intelligent analysis, generates appropriate charts, and outputs formatted Word documents suitable for executives.

person作者: user_6723fe8dhubcommunity
download下载资源包

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

Quick Reference

| Task | Approach | Script/Reference | |------|----------|------------------| | Read Excel/CSV | Use pandas to parse data | scripts/analyze_data.py | | Generate charts | Match chart type to data | scripts/generate_charts.py, references/chart_guide.md | | Create report structure | Follow standard template | references/report_structure.md | | Generate Word doc | Use docx-js library | scripts/create_report.py |

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:

| Data Type | Recommended Chart | When to Use | |-----------|-------------------|-------------| | Time series/trends | Line chart | Showing trends over time | | Comparisons | Bar/Column chart | Comparing categories or periods | | Composition | Pie/Doughnut chart | Showing parts of a whole | | Relationships | Scatter plot | Correlation between variables | | Distribution | Histogram | Frequency distribution | | Multi-dimensional | Stacked bar/area chart | Multiple data series |

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