Skip to main content
skill CX Codex

excel-variance-analyzer — Claude Code skill: setup and overview

excel-variance-analyzer is a Claude Code skill that compares budget and actual figures in Excel, flags variances, builds waterfall charts, and identifies root causes.

MIT 3 installs ★ 2,935 updated 2026-11-01

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-code
Open on GitHub

What excel-variance-analyzer does

This skill automates budget vs actual comparisons inside spreadsheet workflows. It calculates dollar and percentage gaps, flags favorable and unfavorable movements, and applies materiality thresholds so noise is filtered out. Breakdowns can be grouped by reporting period or cost center.

For management presentations, the skill produces waterfall charts illustrating the bridge from target budget to actual figures. If a budget line contains zero, percentage math breaks without explicit IF formulas for division by zero. When the chart of accounts shifts, you must supply a category mapping table to keep comparisons aligned.

Analysis depends on having structured budget and actual data by department or cost center. The skill references calculation logic from references/variance-formulas.md to assemble exception reports for finance leads.

What it helps with

  • calculate absolute and percentage variances between budget and actual spend
  • generate variance waterfall charts for executive reviews
  • filter out immaterial discrepancies using threshold rules
  • identify specific departments and line items driving cost overruns

Example prompts for the agent

  • Analyze why we missed budget by $500K this month
  • Which departments are over budget YTD?
  • Run an actual vs budget variance check and flag major differences

How to install excel-variance-analyzer

1Skills CLI (Vercel)

npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-code

2Manually: put the files in place

~/.claude/skills/excel-variance-analyzer/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/excel-variance-analyzer/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about excel-variance-analyzer

How to install excel-variance-analyzer in Claude Code?

Run npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-code. The tool installs into your Claude Code skills directory.

What does excel-variance-analyzer do?

It compares planned budgets against actual spreadsheet numbers, flags material deviations, and generates variance waterfall charts showing root causes.

What inputs does the skill require to run?

You need budget and actual data broken down by period and category, along with an established department or cost center structure.

Source text

SKILL.md · MIT
---
name: excel-variance-analyzer
description: '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''.

  '
allowed-tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*)
version: 1.22.0
author: Jeremy Longshore <[email protected]>
license: MIT
tags:
- business
- excel-variance
compatibility: Designed for Claude Code
---
# 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

1. Import budget and actual data into comparison template
2. Calculate absolute and percentage variances
3. Apply materiality thresholds for flagging
4. Create drill-down by category, period, or cost center
5. 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](https://www.fpanda.org/)
- [`references/variance-formulas.md`](references/variance-formulas.md) for calculation templates

© Jeremy Longshore · MIT · jeremylongshore/tons-of-skills-marketplace

Similar skills

All skills for Finance and business →
variance-analysis official anthropics variance-analysis decomposes budget versus actual variances into underlying business drivers and writes narrative commentary for leadership. It helps analyze period-over-period revenue or expense shifts. CX Codex +1 3,500installs excel-automation daymade excel-automation generates styled Excel reports using openpyxl, extracts data from large xlsm models with stdlib zipfile, and drives Excel on macOS. Handy for financial modeling and rebuilding paper forms. CX Codex +1 1,500installs Skywork Excel SkyworkAI Skywork Excel generates spreadsheets, formulas, and charts using the Skywork backend with live web search. Useful for financial modeling and converting tables from PDF. CX Codex +1 370installs budget-variance-analyzer datadrivenconstruction budget-variance-analyzer is a skill for Claude Code that compares budget figures with actual costs, flags overruns, and forecasts a project's final cost. It tracks spending variances by project line item. CX Codex +1 139installs Softwiro Excel templates and calculators softwiro The Softwiro Excel templates and calculators Claude Code MCP server works with Arabic Excel templates and runs calculators. Ask the agent to use it for tasks such as VAT or gold zakat calculations. CX Codex +1 excel-analysis davila7 excel-analysis is a Claude Code skill with workflows for processing Excel spreadsheets and generating Python scripts for pivot tables, data cleanup, and formatted reports. CX Codex +1 3,031installs

From the same set139

The whole set →
langchain-webhooks-events langchain-webhooks-events dispatches LangChain 1.0 and LangGraph events to HTTP webhooks or Kafka without stalling chain execution. Useful for real-time tool telemetry and monitoring. CX Codex +1 4installs excel-macro-creator The excel-macro-creator skill assists with Excel macro tasks by producing code, configurations, and step-by-step guidance. It activates when related phrases appear in a request. CX Codex +1 4installs pdf-parser pdf-parser is a Claude Code skill that activates on PDF-related requests and guides the agent through a plan, draft config and code, and a result check. CX Codex +1 4installs pdf-generator pdf-generator handles PDF generation tasks in business automation workflows. Generates production-ready code and configuration templates. CX Codex +1 4installs helm-chart-generator The helm-chart-generator skill guides Helm chart generation, creates configuration drafts and checks the result. It fits requests about Helm generators and related DevOps work. CX Codex +1 3installs brand-strategy Build or review a seven-part brand strategy with an AI coding assistant. Use it for a brand brief, positioning work, or messaging revisions. CX Codex +1 2installs seo-meta-generator An auto-activating skill for frontend work. It kicks in when a prompt mentions seo, seo generator, or seo meta generator, and walks through SEO metadata generation. CX Codex +1 2installs openrouter-pricing-basics openrouter-pricing-basics calculates OpenRouter token costs, tracks credit balances, and compares model rates. Helpful when estimating LLM spend or picking cheaper providers. CX Codex +1 2installs

Project sponsors

Companies that keep this analytics open