variance-analysis

Decompose financial variances into driver-based explanations and reconciled waterfall structures.

Updated Apr 8, 2026
One-click install
npx skills add https://github.com/sun2443/designer-skills --skill variance-analysis-sun2443
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: variance-analysis
Source: https://github.com/sun2443/designer-skills/tree/main/finance/skills/variance-analysis
Command: npx skills add https://github.com/sun2443/designer-skills --skill variance-analysis-sun2443

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you break down budget vs actual (or prior vs actual) financial differences into clear, accountable drivers and produces leadership-ready narrative commentary.

Core Features & Use Cases

  • Variance decomposition: Break total variance into price/volume, rate/mix, headcount/comp, and spend-category drivers with formulas you can reconcile.
  • Materiality + prioritization: Apply investigation thresholds and rank which variances need attention first based on magnitude, direction, novelty, and trends.
  • Narrative generation + waterfall methodology: Draft consistent explanations and build text-based waterfall/bridge reconciliations that verify start + drivers = end.

Quick Start

Use variance-analysis to decompose and narrate the variance for a specific line item and period comparison, then present it as a reconciled waterfall-ready summary.

Frequently Asked Questions about variance-analysis

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

FAQPage Schema
How do I break down budget vs actual variances into specific financial drivers?

Variance analysis decomposes budget vs actual differences into reconcilable drivers like price/volume, rate/mix, and headcount/comp. It applies attribution formulas to each line item so the total variance reconciles precisely with the sum of its individual components.

How do I write narrative commentary for financial reporting variances?

Variance analysis generates narrative commentary by applying templates that include directionality, quantified impacts, outlook, and actions. It transforms raw financial variances into leadership-ready explanations that provide context and accountability for reporting workflows.

How do I build a waterfall chart reconciliation for financial reporting?

Variance analysis builds text-based waterfall structures that verify start plus drivers equals end. It reconciles period comparisons by mapping decomposed financial drivers into a sequential bridge format for leadership reporting and presentation.

How do I apply materiality thresholds to prioritize which financial variances to investigate?

Variance analysis applies materiality thresholds and trigger logic to rank which financial variances need attention first. It prioritizes investigations based on magnitude, direction, novelty, and trends to focus reporting workflows on the most impactful differences.

Can I use variance analysis for expense categories and headcount compensation splits?

Yes, variance analysis applies to revenue and expense line items including headcount/comp and spend-category splits. It decomposes these financial variances using specific attribution formulas for prior, budget, forecast, and period comparisons across reporting workflows.

What is mix decomposition in financial variance analysis?

Mix decomposition in variance analysis breaks down total financial variances into rate and mix components. It isolates the specific impact of changes in product or service mix versus rate fluctuations to produce reconciled driver-based explanations for budget and actual comparisons.