variance-analysis

Decompose financial variances into drivers with narrative explanations and waterfall charts.

1|Updated Mar 30, 2026
One-click install
npx skills add https://github.com/ilove323/comlan-skills --skill variance-analysis-ilove323
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: variance-analysis
Source: https://github.com/ilove323/comlan-skills/tree/main/finance/skills/variance-analysis
Command: npx skills add https://github.com/ilove323/comlan-skills --skill variance-analysis-ilove323

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

将财务差异分解为驱动因素,提供叙述性说明和瀑布图分析,以支持差异分析工作流。重要提醒:本技能生成的分析用于辅助报告,最终结论应由具备资质的财务专业人员审核。

Core Features & Use Cases

  • 差异分解技术:按量/价/结构等维度分解实际与预算/上期/预测之间的差异,提供定量驱动因素。
  • 叙述性说明生成:为每个驱动因素给出简明的业务原因和贡献度。
  • 瀑布图分析:以文字或图表形式展示差异如何聚合成最终结果,便于管理层审阅。
  • 使用场景:月度/季度财务报告、预算对比、预测偏差诊断、单项成本与定价对比分析。

Quick Start

请将预算、实际与预测数据输入,立即得到驱动因素分解、叙述性说明和瀑布图分析。

Frequently Asked Questions about variance-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I decompose budget vs actual variances into volume, price, and mix drivers?

You generate narrative explanations by breaking down actual versus budget or forecast gaps into specific drivers. The output provides concise business reasons and contribution metrics for each driver, supporting clear management review documentation.

Can I use waterfall chart analysis for monthly revenue and cost variance reporting?

Waterfall analysis visualizes how individual variance drivers aggregate into final financial results for monthly or quarterly reporting. It applies to revenue, costs, and profitability data, illustrating the cumulative impact of each driver on the overall outcome.

What is the best way to automate narrative explanations for financial forecast deviations?

Automating financial forecast deviation narratives involves applying variance decomposition techniques to actual versus forecast data. This generates concise business reasons and contribution metrics for each driver, streamlining the creation of management review narratives.

Does this variance analysis approach support both profitability and single cost item diagnostics?

Yes, variance analysis supports both profitability reporting and single item cost or pricing diagnostics. It applies decomposition techniques to isolate drivers, providing narrative insights and waterfall visualization for either broad profitability or specific cost comparisons.

What data do I need to prepare for variance decomposition and narrative generation?

You need to prepare budget, actual, and forecast data as input. Providing these financial datasets enables the decomposition process to immediately output quantitative drivers, narrative explanations, and waterfall chart analysis for your reporting workflow.

Are there limitations to using automated variance analysis for management reviews?

Automated variance analysis is designed to assist reporting, not replace professional judgment. Final conclusions must be reviewed by qualified financial professionals, as the generated narratives and driver decompositions serve as supportive analytical inputs.