Budget vs. Actual Variance Analysis Skill

Perform rigorous period-end budget vs. actual analysis. This skill guides Sam Ledger through pulling actuals, comparing against budget, calculating variances, identifying root causes, drafting management commentary, and producing a reforecast update.

---

When to Use This Skill

Trigger phrases:

• - "Run budget vs. actual for [month/quarter]"
• "Explain our variances this month"
• "Why did we miss/beat revenue?"
• "Prepare the management report for [period]"
• "Update the rolling forecast based on actuals"
• "Board needs BvA commentary"
• "What drove the EBITDA miss?"
• "Reforecast the rest of the year"

NOT for:

• - Building the original budget — use INLINECODE0
• Tax filings or tax provision work — use compliance workflows
• Real-time bookkeeping or transaction categorization — use qbo-automation or INLINECODE2
• Multi-entity consolidations with intercompany eliminations (requires dedicated consolidation tooling)
• Strategic planning or multi-year long-range planning (LRP)

---

Core Concepts

Variance Types

Type	Formula	Meaning
Absolute Variance	Actual − Budget	Dollar difference
Percentage Variance

(Actual − Budget) / Budget × 100 | Magnitude relative to budget | | Favorable (F) | Revenue: Actual > Budget / Expense: Actual < Budget | Better than plan | | Unfavorable (U) | Revenue: Actual < Budget / Expense: Actual > Budget | Worse than plan |

Materiality Thresholds (Default — customize per engagement)

CODEBLOCK0

Variance Root Causes — Taxonomy

Revenue Variances:

• - Volume variance: More/fewer units/customers than planned
• Price/rate variance: ASP or pricing differed from assumption
• Mix variance: Different product/segment mix than modeled
• Timing variance: Deal closed in wrong period (pulled forward or pushed out)
• New vs. existing: Over/under-performance in specific cohort

Expense Variances:

• - Headcount timing: Hire later/earlier than budgeted
• Contractor/vendor: Over/under-spend vs. plan
• One-time items: Non-recurring expenses not in budget
• Volume-linked: COGS, sales commission scaled with revenue
• Pricing/inflation: Vendor price changes not modeled

---

Step-by-Step Workflow

Step 1: Collect Inputs

CODEBLOCK1

Step 2: Normalize Data

Map actuals to budget line items. Standard P&L mapping:

CODEBLOCK2

Step 3: Calculate Variances

For each line item:

CODEBLOCK3

Step 4: Build the Variance Table

Standard Output Format:

CODEBLOCK4

Step 5: Root Cause Analysis

For each flagged variance, drill down:

Revenue miss example (Product Revenue -$11,500 / -9.6%):
CODEBLOCK5

S&M overrun example ($2,400 / +9.6% unfavorable):
CODEBLOCK6

Step 6: Management Commentary

Draft in this structure for each material variance:

CODEBLOCK7

Example commentary:

EBITDA — Unfavorable $7,500 (-16.7%)
WHAT: March EBITDA of $37,500 missed the $45,000 budget by $7,500, driven by a revenue shortfall partially offset by lower R&D spend.
WHY: Product revenue missed by $11,500 due to 2 enterprise deals slipping to April (pipeline confirmed, not lost). S&M ran $2,400 over budget on a one-time conference registration. R&D came in $1,500 favorable as one contractor engagement started late.
ACTION: The 2 slipped deals are expected to close in April (both in final contract stage). Conference registration expensed — not recurring. R&D contractor now onboarded; expect full burn starting April.
OUTLOOK: Revising Q2 forecast to front-load the 2 slipped deals. Full-year EBITDA forecast unchanged at $540,000.

Step 7: Update Rolling Forecast

After analyzing actuals, update the remainder of the year:

CODEBLOCK8

Reforecast summary table:

CODEBLOCK9

---

Output Formats

1. Management Report (Narrative + Table)

Full commentary with variance table, root causes, and reforecast. For CFO/CEO/Board use.

2. Quick BvA Flash (1 Page)

Three sections only:

• - Headline KPIs: Revenue, Gross Margin, EBITDA, Cash (actual vs budget, one line each)
• Top 3 variances with one-sentence explanations
• Reforecast change vs. prior

3. Structured JSON (for downstream processing)

{
  "period": "2026-03",
  "period_type": "month",
  "generated_at": "2026-04-02",
  "summary": {
    "total_revenue_budget": 150000,
    "total_revenue_actual": 142700,
    "total_revenue_variance_abs": -7300,
    "total_revenue_variance_pct": -4.87,
    "ebitda_budget": 45000,
    "ebitda_actual": 37500,
    "ebitda_variance_abs": -7500,
    "ebitda_variance_pct": -16.67
  },
  "line_items": [
    {
      "name": "Product Revenue",
      "budget": 120000,
      "actual": 108500,
      "variance_abs": -11500,
      "variance_pct": -9.58,
      "favorable": false,
      "material": true,
      "root_cause": "2 enterprise deals slipped to April (pipeline confirmed)",
      "action": "Deals expected April close; no change to full-year forecast"
    }
  ],
  "reforecast": {
    "full_year_revenue_original": 1800000,
    "full_year_revenue_current": 1762000,
    "full_year_ebitda_original": 540000,
    "full_year_ebitda_current": 512500
  }
}

---

QBO Integration Workflow

When actuals come from QuickBooks Online (via qbo-automation):

CODEBLOCK11

Common QBO mapping pitfalls:

• - QBO may break out subcategories that are lumped in budget → aggregate up
• Owner draws in QBO are not an expense → exclude from P&L analysis
• Payroll taxes may be in separate QBO accounts → roll up to loaded headcount cost

---

Handling Common Edge Cases

Budget is $0 for a line item that has actuals

CODEBLOCK12

Prior period restatements

CODEBLOCK13

Multiple departments / cost centers

CODEBLOCK14

Seasonal businesses

Include YoY comparison alongside BvA:
  March 2026 Actual vs. March 2026 Budget (primary)
  March 2026 Actual vs. March 2025 Actual (context)
  Flag: is variance seasonal (expected) or structural (new issue)?

---

Metrics Glossary

Term	Definition
BvA	Budget vs. Actual
F

Favorable (better than plan) | | U | Unfavorable (worse than plan) | | pp | Percentage points (for margin comparisons) | | YTD | Year-to-date (cumulative from Jan 1) | | QTD | Quarter-to-date | | MTD | Month-to-date | | Reforecast | Updated projection for remainder of year, based on actuals to date | | Flash | Quick preliminary BvA before full close (estimates OK) | | Hard close | Final, locked actuals (no further adjustments) | | Soft close | Preliminary actuals, subject to accruals and adjustments |

---

Integration Points

• - qbo-automation — Pull actuals directly from QuickBooks Online
• startup-financial-model — Original budget/forecast data source
• kpi-alert-system — Trigger alerts when variance thresholds are breached
• report-generator — Format BvA output into board-ready PDF or deck
• financial-analysis-agent — Deep-dive trend analysis when root cause isn't obvious

---

Example Intake Prompt

"March is closed. Budget had us at $150k revenue and $45k EBITDA. Actuals came in at $142k revenue and $37.5k EBITDA. Product was $11.5k short — two enterprise deals slipped. Service came in $4.2k over. S&M ran $2.4k over on a conference. R&D was $1.5k under — contractor started late. Draft the BvA table, root cause summary, and board commentary. Flag reforecast impact."

Sam will:

1. 1. Build the variance table with F/U flags and materiality indicators
2. Write root-cause summaries for all flagged lines
3. Draft management commentary in WHAT/WHY/ACTION/OUTLOOK format
4. Produce the reforecast delta (timing vs. structural adjustments)
5. Output structured JSON if downstream processing is needed