Agent skill

Variance Analysis

by rongxinzy in rongxinzy/RongxinAI

Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary.

AGPL-3.0Auto-check passedBusiness, Finance & HR

Install Variance Analysis

skills CLI
$ npx skills add rongxinzy/RongxinAI --skill variance-analysis -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install rongxinzy/RongxinAI variance-analysis --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/rongxinzy/RongxinAI.git skills-src && mkdir -p .claude/skills && cp -r skills-src/SKILLs/zhiyuan-expert-manager/presets/finance-accounting-expert/skills/variance-analysis .claude/skills/variance-analysis && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
variance-analysis
GitHub stars
154
Token cost
~528 tokens
SKILL.md length
231 words
Files
1
Skills in repo
94
Repo updated
First seen
Licence
AGPL-3.0

At a glance

Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary.

  • Works in 5 steps: amount, percentage,… → quantified primary and offsetting drivers; → the business cause and evidence; → …
  • Price-volume-mix
  • SKILL.md covers Prepare the comparison, Decompose drivers, Narrative and Waterfall and output
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Variance Analysis is an agent skill from rongxinzy/RongxinAI. Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary. Use for price-volume-mix, rate, headcount, spend, margin, and waterfall analysis.

Its SKILL.md is about 530 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Business, Finance & HR. The repository describes itself as: An all-in-one local AI Agent workspace with a fully self-developed stack. The licence is AGPL-3.0.

When your agent uses it

  • Price-volume-mix
  • Waterfall analysis

Example prompts

  • “/variance-analysis”

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  1. amount, percentage, favorable/unfavorable status, comparison, and period;
  2. quantified primary and offsetting drivers;
  3. the business cause and evidence;
  4. whether the effect is timing, one-time, structural, or uncertain;
  5. outlook, action, owner, and forecast implication.

What it can do on your machine

Read from SKILL.md and the folder at commit aa2b27b. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Variance Analysis loads about 528 tokens when it runs. Until then it costs about 56 tokens; SKILL.md has 231 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~56
When it runs · the whole SKILL.md, loaded when a task matches
~528

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from rongxinzy/RongxinAI at commit aa2b27b, republished under its AGPL-3.0 licence (© rongxinzy). 231 words, ~528 tokens.

Download SKILL.mdSave it as .claude/skills/variance-analysis/SKILL.md (or your agent's skills folder).
name
variance-analysis
description
Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary. Use for price-volume-mix, rate, headcount, spend, margin, and waterfall analysis.

Variance Analysis

Prepare the comparison

Confirm entity, account hierarchy, period, currency, unit, actual/budget/forecast versions, sign convention, and materiality. Validate that compared datasets use consistent scope and mappings.

Calculate absolute variance = actual - comparison and percentage variance using a documented denominator. Treat zero or sign-changing denominators explicitly rather than presenting misleading percentages.

Decompose drivers

  • Price/volume: volume effect = (actual volume - baseline volume) x baseline price; price effect = (actual price - baseline price) x actual volume.
  • Mix/rate: quantify shifts among products, customers, channels, regions, grades, or contract types.
  • Headcount: separate headcount, compensation rate, mix, hiring timing, attrition, bonus, and benefit effects.
  • Spend: separate fixed, volume-driven, discretionary, contractual, one-time, foreign-exchange, and timing effects.

The starting value plus all signed drivers must equal the ending value. Show any residual as an unresolved item, not “other” without explanation.

Narrative

For each material variance state:

  1. amount, percentage, favorable/unfavorable status, comparison, and period;
  2. quantified primary and offsetting drivers;
  3. the business cause and evidence;
  4. whether the effect is timing, one-time, structural, or uncertain;
  5. outlook, action, owner, and forecast implication.

Avoid circular statements such as “revenue increased because revenue was higher.” Distinguish proven cause from plausible hypothesis.

Waterfall and output

Limit a waterfall to a decision-useful set of drivers, verify it reconciles, and accompany it with a driver table. Rank follow-up by absolute impact, unexpected direction, recurrence, trend, controllability, and materiality. State all data limitations and required review.

© rongxinzy, AGPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in SKILLs/zhiyuan-expert-manager/presets/finance-accounting-expert/skills/variance-analysis of rongxinzy/RongxinAI.

Open the folder on GitHubat commit aa2b27b

Compare with similar skills

Variance Analysis next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Variance Analysis compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Variance Analysis this skillrongxinzy/RongxinAI154—~528Automated safety check: PassAGPL-3.0
Technical Analysttradermonty/claude-trading-skills3k4 repos~4.6kAutomated safety check: PassMIT
Theme Detectortradermonty/claude-trading-skills3k2 repos~4.9kAutomated safety check: PassMIT
Creating Financial ModelsChen-zexi/open-ptc-agent7293 repos~1.3kAutomated safety check: PassMIT
Stock APIzhangxiangliang/stock-api2k—~507Automated safety check: PassMIT
Itr Walakaranb192/itr-wala871—~3.6kAutomated safety check: PassMIT

Similar skills

  • Technical Analyst

    tradermonty/claude-trading-skills

    This skill should be used when analyzing weekly price charts for stocks, stock indices, cryptocurrencies, or forex pairs.

    3k GitHub starsUsed in 4 repos~4.6k tokens
    Business, Finance & HRAuto-check passed
  • Theme Detector

    tradermonty/claude-trading-skills

    Detect and analyze trending market themes across sectors. An agent skill from tradermonty/claude-trading-skills.

    3k GitHub starsUsed in 2 repos~4.9k tokens
    Business, Finance & HRAuto-check passed
  • Creating Financial Models

    Chen-zexi/open-ptc-agent

    This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions

    729 GitHub starsUsed in 3 repos~1.3k tokens
    Business, Finance & HRAuto-check passed
  • Stock API

    zhangxiangliang/stock-api

    Fetch real-time stock quotes, K-line (candlestick) history, and search symbols for China A-shares, Hong Kong, and US markets.

    2k GitHub stars~507 tokensUpdated today
    Business, Finance & HRAuto-check passed
  • Itr Wala

    karanb192/itr-wala

    File Indian income tax returns (ITR) for FY 2025-26 / AY 2026-27.

    871 GitHub stars~3.6k tokensUpdated 5 days ago
    Business, Finance & HRAuto-check passed
  • Tushare Data

    zillionare/zillionare

    面向中文自然语言的 Tushare 数据研究技能。用于把“看看这只股票最近怎么样”“帮我查财报趋势”“最近哪个板块最强”“北向资金在买什么”“给我导出一份行情数据”这类请求,转成可执行的数据获取、清洗、对比、筛选、导出与简要分析流程。适用于 A 股、指数、ETF/基金、财务、估值、资金流、公告新闻、板块概念与宏观数据等研究场景。

    321 GitHub starsUsed in 2 repos~2.3k tokens
    Business, Finance & HRAuto-check passed

More from rongxinzy/RongxinAI

All 94 skills in this repo
  • SaaS Metrics Coach

    rongxinzy/RongxinAI

    SaaS financial health advisor. An agent skill from rongxinzy/RongxinAI.

    154 GitHub starsUsed in 2 repos~1.3k tokens
    Auto-check passed
  • Churn Prevention

    rongxinzy/RongxinAI

    Reduce voluntary and involuntary churn through cancel flow design, save offers, exit surveys, and dunning sequences.

    154 GitHub starsUsed in 3 repos~2.6k tokens
    Auto-check passed
  • Presentation Studio

    rongxinzy/RongxinAI

    The only skill for creating a new PowerPoint deck. An agent skill from rongxinzy/RongxinAI.

    154 GitHub stars~2.1k tokensUpdated today
    Auto-check passed
  • Zhiyuan Expert Manager

    rongxinzy/RongxinAI

    ZhiYuan Agent expert package lifecycle manager for the pi engine.

    154 GitHub stars~1.9k tokensUpdated today
    Auto-check passed
  • Ziwei Doushu

    rongxinzy/RongxinAI

    Professional Ziwei Doushu consultation skill with an offline calculation engine.

    154 GitHub stars~746 tokensUpdated today
    Auto-check passed
  • Lark Mail

    rongxinzy/RongxinAI

    飞书邮箱:Use when user mentions 起草邮件、写邮件、草稿、发送/回复/转发邮件、查阅邮件、看邮件、搜索邮件、邮件文件夹、邮件标签、邮件联系人、监听新邮件、邮件收信规则等;use for mail/email intent only.

    154 GitHub starsUsed in 3 repos~4.1k tokens
    Auto-check: warnings

Questions about Variance Analysis

What does Variance Analysis do?

Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary. Variance Analysis is an agent skill from rongxinzy/RongxinAI. Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary.

When should I use Variance Analysis?

Variance Analysis fits situations like: price-volume-mix; waterfall analysis.

How do I install Variance Analysis in Claude Code?

Run `npx skills add rongxinzy/RongxinAI --skill variance-analysis -a claude-code`. Or copy the skill folder (SKILLs/zhiyuan-expert-manager/presets/finance-accounting-expert/skills/variance-analysis in rongxinzy/RongxinAI) into .claude/skills/variance-analysis in your project. Claude Code loads it when a task matches its description.

How do I install Variance Analysis in Codex?

Run `npx skills add rongxinzy/RongxinAI --skill variance-analysis -a codex`. Or copy the skill folder (SKILLs/zhiyuan-expert-manager/presets/finance-accounting-expert/skills/variance-analysis in rongxinzy/RongxinAI) into .agents/skills/variance-analysis in your project. Codex loads it when a task matches its description.

Can I use Variance Analysis in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add rongxinzy/RongxinAI --skill variance-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/variance-analysis, .gemini/skills/variance-analysis, .github/skills/variance-analysis and .opencode/skills/variance-analysis in your project.

What does Variance Analysis need to run?

SKILL.md names no scripts, command-line tools or credentials: Variance Analysis is instructions for the agent only.

Does Variance Analysis access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Variance Analysis safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Variance Analysis use?

Variance Analysis is published under the AGPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Variance Analysis use?

About 528 tokens (SKILL.md is roughly 2.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Variance Analysis?

Skills that share tags, products or a category with Variance Analysis: Technical Analyst (tradermonty/claude-trading-skills, 3k stars), Theme Detector (tradermonty/claude-trading-skills, 3k stars), Creating Financial Models (Chen-zexi/open-ptc-agent, 729 stars) and Stock API (zhangxiangliang/stock-api, 2k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Variance Analysis?

rongxinzy (a GitHub organization) maintains it in rongxinzy/RongxinAI, which has 154 GitHub stars. The repository holds 94 skills in this directory. The repository was last updated on October 9, 2026.

Source: rongxinzy/RongxinAI on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.