Analyzes actual-vs-plan and period-over-period financial variances against predefined dimensions (entity, account, product, region) using standard volume/rate/mix decomposition, with business interpretation. Use when finance teams need variance narratives and action-focused insights explained against known categories. Use `predictive-model-development` instead when the explanatory grouping itself is unknown and must be discovered (e.g., clustering or segmentation to find which vendors, invoice types, or processors are driving a pattern).
Decomposition logic is traceable and non-overlapping.
Materiality thresholds are applied.
Recommendations map to controllable levers.
1---2name: financial-variance-analysis3description: Analyzes actual-vs-plan and period-over-period financial variances against predefined dimensions (entity, account, product, region) using standard volume/rate/mix decomposition, with business interpretation. Use when finance teams need variance narratives and action-focused insights explained against known categories. Use `predictive-model-development` instead when the explanatory grouping itself is unknown and must be discovered (e.g., clustering or segmentation to find which vendors, invoice types, or processors are driving a pattern).4---56# Financial Variance Analysis78## When to Use9- Month-end and quarter-end performance reviews.10- Budget vs actual explanation requests.11- Executive review preparation for financial drivers.1213## Workflow141. Define baseline comparison (plan, forecast, prior period).152. Quantify variance by key dimensions (entity, account, product, region).163. Decompose variance into volume, rate, mix, and one-off effects.174. Flag material drivers and recurring patterns.185. Convert findings into decisions and corrective actions.1920## Output Template21```markdown22# Variance Analysis Brief2324## Comparison basis25- Actual period:26- Baseline:2728## Headline variance29- Amount:30- Percent:3132## Driver decomposition33- Volume:34- Rate:35- Mix:36- One-off:3738## Actions391. ...40```4142## Quality Checklist43- Baseline is clearly stated and consistent.44- Decomposition logic is traceable and non-overlapping.45- Materiality thresholds are applied.46- Recommendations map to controllable levers.
Run npx skillmds@latest add bkjohn2018/financial-variance-analysis in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Analyzes actual-vs-plan and period-over-period financial variances against predefined dimensions (entity, account, product, region) using standard volume/rate/mix decomposition, with business interpretation. Use when finance teams need variance narratives and action-focused insights explained against known categories. Use `predictive-model-development` instead when the explanatory grouping itself is unknown and must be discovered (e.g., clustering or segmentation to find which vendors, invoice types, or processors are driving a pattern). It is listed under AI & ML on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
bkjohn2018 (@bkjohn2018) published this skill. Their other Agent Skills are listed on their SkillMD profile.