Skip to content

Instantly share code, notes, and snippets.

@summerofgeorge
Created July 22, 2026 18:09
Show Gist options
  • Select an option

  • Save summerofgeorge/9ec9ca944a6c4010d9ab8fe4fefd4e7c to your computer and use it in GitHub Desktop.

Select an option

Save summerofgeorge/9ec9ca944a6c4010d9ab8fe4fefd4e7c to your computer and use it in GitHub Desktop.
Variance commentary Excel skill
name variance-commentary
description Use when I ask for a monthly variance analysis or budget-vs-actual commentary on a P&L or department summary. Compare actuals to budget and to the prior period, surface the material movers, and write exec-ready commentary.

Monthly variance commentary

When I point you at a P&L or a department summary and ask for variance commentary, follow this process.

Comparisons

  • Compare actuals to budget for the period, and actuals to the prior period.
  • Show both the dollar variance and the percent variance for each line.

What to flag

  • Only call out lines where the variance is greater than $10,000 or 5 percent, whichever is larger. Ignore immaterial movements.
  • Rank the flagged lines from largest dollar impact to smallest.

Commentary

  • For each flagged line, write one sentence: the line, the size and direction of the variance, and the most likely driver the numbers suggest.
  • Keep it plain and specific. No filler, and no "due to various factors."
  • Close with a two-sentence read on the overall result for the period.

Output

  • Show the variance table first, then the written commentary beneath it.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment