THE BRIEF
Our September P&L came in $38k worse than budget and my board meeting is next week. Here's the budget and actuals export. Tell me what happened and what to say.
Scenario: Founder-CEO of a 30-person marketing agency
Package: Monthly budget vs actual variance memo · $50 · 4 hrs
Assumptions first, so we can argue about the right things. Then the numbers.
ASSUMPTIONS I USED
- Budget is the version the board approved in January, not the June reforecast.
- Revenue is recognized when invoiced, as your books do it.
- Anything under $2,000 or 5% is noise; I don't comment on it.
THE HEADLINE
Net income was $38,400 below budget. About $31,000 of that is timing, and about $7,400 is real. That's the sentence for the board.
THE VARIANCES THAT MATTER
| Line | Budget | Actual | Variance | What happened | Timing or real? |
|---|---|---|---|---|---|
| Project revenue | $412,000 | $388,500 | -$23,500 | Hollis Foods launch slipped to October | Timing |
| Freelancer costs | $61,000 | $68,200 | -$7,200 | Two freelancers covered the open designer role | Real, until you hire |
| Software | $14,500 | $22,300 | -$7,800 | Annual Adobe renewal paid in September, budgeted monthly | Timing |
| Travel | $9,000 | $9,600 | -$600 | Noise | |
| Rent | $28,000 | $28,000 | $0 |
- Line
- Project revenue
- Budget
- $412,000
- Actual
- $388,500
- Variance
- -$23,500
- What happened
- Hollis Foods launch slipped to October
- Timing or real?
- Timing
- Line
- Freelancer costs
- Budget
- $61,000
- Actual
- $68,200
- Variance
- -$7,200
- What happened
- Two freelancers covered the open designer role
- Timing or real?
- Real, until you hire
- Line
- Software
- Budget
- $14,500
- Actual
- $22,300
- Variance
- -$7,800
- What happened
- Annual Adobe renewal paid in September, budgeted monthly
- Timing or real?
- Timing
- Line
- Travel
- Budget
- $9,000
- Actual
- $9,600
- Variance
- -$600
- What happened
- Noise
- Timing or real?
- Line
- Rent
- Budget
- $28,000
- Actual
- $28,000
- Variance
- $0
- What happened
- Timing or real?
WHY I CALL THE HOLLIS SLIP TIMING
The signed statement of work dates the launch October 14 and the client confirmed in writing. If October also slips, it stops being timing and becomes a pipeline question. I'd say so to the board before they ask.
WHAT TO TELL THE BOARD
- September missed by $38k; $31k reverses in October and over the rest of the year.
- The $7k real miss is the open designer seat. The hire starts November 4, which ends it.
- Year-to-date we're $12k ahead of budget, even after September.
CHECK CELL
Variances sum to -$38,400, which ties to the P&L. Year-to-date ties to the trial balance.
Checks tie out. Downside's covered. Sleep easy. — Andrew
