variance-analysis
SolidUse when explaining a dated actual-versus-budget or actual-versus-forecast variance for a comparable finance period. Not for tracking close checklist completion; use close-status.
Install
Quality Score: 85/100
Skill Content
Details
- Author
- davekilleen
- Repository
- davekilleen/Dex
- Created
- 8 months ago
- Last Updated
- yesterday
- Language
- Python
- License
- NOASSERTION
Integrates with
Bundled in these plugins
Similar Skills
Semantically similar based on skill content — not just same category
finance-month-end-variance-analysis
Runs month-end variance analysis in the only order that works: reconciliation first, explanation second, so that anything failing to tie out is reported as the finding rather than explained as a variance. Decomposes explained movement into price, volume, mix, timing, FX and one-off effects and refuses to produce commentary when the ledger, sub-ledger or prior-period figures were not supplied. Use at month-end or quarter-end close, when a P&L or cost line moved unexpectedly, when preparing the close pack, or when a reviewer asks why a number changed. Trigger on 'month-end', 'variance analysis', 'why did this line move', 'close pack', 'flux analysis', 'reconciliation', 'period-over-period'. Not for forward-looking budget narrative and forecast implications (use finance-budget-vs-actual-commentary) or for assessing individual expense claims (use finance-expense-policy-triage).
variance-analysis
Explains budget-vs-actual or period-over-period variances: sets a materiality threshold first, builds the variance table in dollars and percent, decomposes drivers (price, volume, mix, timing, one-offs), draws a bridge waterfall, and writes the so-what per material line with forecast impact. Use when the user says 'why are we over budget', 'explain the miss vs plan', 'build the monthly flux commentary', or 'what drove the revenue variance'.
fortax-variance-analysis
Explain the movement between two periods, or budget vs actual vs forecast, line by line with the reason for each - price / volume / mix decomposition, headcount and salary variances, expense-category analysis, materiality thresholds, narratives that name the driver, text or Excel waterfall bridges, forecast accuracy and trends. For MIS reviews, audit analytical procedures, the Schedule III ratio note (reasons for change over 25%) and bank / investor questions. Typical asks - "variance analysis karo", "last year se kya badla aur kyun", "budget vs actual", "profit kyun gira", "sales badhi par margin kam kyun", "bridge chart bana do".