Excel Variance Analyzer

excel-variance-analyzer

Analyze budget vs actual variances in Excel with drill-down and root cause analysis. Use when performing variance analysis or explaining budget differences. Trigger with phrases like 'excel variance', 'analyze budget variance', 'actual vs budget'.

majiayu000/claude-skill-registry·0installs663starsFinance & Trading

SKILL.md

Full skill instructions

Excel Variance Analyzer

Overview

Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting.

Prerequisites

Excel or compatible spreadsheet software
Budget data by period and category
Actual results for comparison
Cost center or department structure

Instructions

Import budget and actual data into comparison template
Calculate absolute and percentage variances
Apply materiality thresholds for flagging
Create drill-down by category, period, or cost center
Generate variance waterfall chart for executive reporting

Output

Variance summary with favorable/unfavorable indicators
Materiality-filtered exception report
Waterfall chart showing budget-to-actual bridge
Drill-down by category or cost center

Error Handling

Error	Cause	Solution
Missing periods	Data gaps	Fill with zeros or interpolate
Percentage calc error	Zero budget	Use IF to handle div/0
Misaligned categories	Changed chart of accounts	Create mapping table

Examples

Example: Monthly P&L Variance Request: "Analyze why we missed budget by $500K this month" Result: Variance waterfall showing revenue shortfall offset by OPEX savings

Example: Department Budget Review Request: "Which departments are over budget YTD?" Result: Ranked list by variance magnitude with drill-down to line items

Resources

FP&A Best Practices
{baseDir}/references/variance-formulas.md for calculation templates

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/majiayu000/claude-skill-registry --skill excel-variance-analyzer

View on GitHub

skills/data/excel-variance-analyzer/SKILL.md

More Finance & Trading skills

View all

Finance & Trading

stripe-projects

stripe projects

1.9K 66.8K

View

Finance & Trading

ponytail-debt

Harvest every `ponytail:` comment in the codebase into a debt ledger, so the deliberate shortcuts and deferrals ponytail leaves behind get tracked instead of rotting into "later means never". One-shot report, changes nothing.

155.5K 27.9K

View

Finance & Trading

okx-dex-market

okx dex market

341 18.5K

View

Finance & Trading

okx-agentic-wallet

okx agentic wallet

341 16.7K

View

Finance & Trading

gmgn-portfolio

gmgn portfolio

596 15.7K

View

Finance & Trading

okx-dapp-discovery

okx dapp discovery

341 13.8K

View

Finance & Trading

okx-agent-payments-protocol

okx agent payments protocol

341 13K

View

Finance & Trading

stripe-integration

Stripe payment processing with checkout sessions, subscriptions, webhooks, and customer management.

40.2K 12.9K

View

Finance & Trading

startup-financial-modeling

Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-r...

40.2K 12K

View

Finance & Trading

stock-analysis

Stock and cryptocurrency analysis with portfolio management and multi-dimensional scoring.

46 11.9K

View

Finance & Trading

coinglass

Real-time crypto derivatives positioning, whale tracking, liquidations, and institutional ETF flows across 37 specialized tools.

27 11.5K

View

Finance & Trading

dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

40.2K 10.5K

View