Budget vs. Actual Report: Template and Commentary Tips
By Newtown Analytics · · 5 min read
For finance, fp&a & accounting managers
A budget vs actual report is the monthly page that sets plan next to results, flags what moved and records what the manager is doing about it. This page shows the layout, the formulas, the flagging rules and a commentary format that you can build in Excel or Google Sheets. It does not provide a download; if you want a working version fitted to your accounts, contact us. The report is the output of budget variance analysis and is part of budgeting and forecasting.
Report structure
| Section | Content |
|---|---|
| Header | Company or department, period, version, convention (favorable positive), date |
| Headlines | Three to five bullet points on the biggest messages |
| Summary table | Revenue, gross profit, operating expenses, operating profit: month, YTD, full-year budget and forecast |
| Line detail | Each line with budget, actual and variance for month and year to date |
| Flags | Automatic highlights for lines above thresholds |
| Commentary | Cause, type and action for each flagged line |
| Outlook | Latest full-year forecast vs budget, with key risks |
| Actions | Decisions, owners and dates |
Column layout
| Column | Month section | YTD section | Full-year section |
|---|---|---|---|
| Budget | B | E | H |
| Actual or forecast | C | F | I (latest forecast) |
| Variance ($) | D | G | J |
| Variance (%) | K | ||
| Flag | L | ||
| Comment | M |
Formulas (Excel style)
Revenue variance = Actual - Budget
Cost variance = Budget - Actual (favorable positive)
Variance % = IF(Budget=0,"n/a", Variance / ABS(Budget))
YTD actual = SUMIFS(Actuals, Account, A5, Period, "<="&CurrentMonth)
Full-year forecast = YTD actual + SUM(Remaining months forecast)
Forecast vs budget = Forecast - Budget (revenue) or Budget - Forecast (cost)
Flag = IF(AND(ABS(Variance$)>=5000, ABS(Variance%)>=0.1), "Review", "")Example summary table
A hypothetical company, in thousands of dollars.
| Month budget | Month actual | Variance | YTD budget | YTD actual | Variance | Full-year budget | Forecast | Variance | |
|---|---|---|---|---|---|---|---|---|---|
| Revenue | 200 | 188 | -12 (U) | 600 | 584 | -16 (U) | 2,400 | 2,330 | -70 (U) |
| Gross profit | 76 | 70 | -6 (U) | 228 | 222 | -6 (U) | 912 | 888 | -24 (U) |
| Operating expenses | 68 | 69 | -1 (U) | 204 | 205 | -1 (U) | 816 | 810 | +6 (F) |
| Operating profit | 8 | 1 | -7 (U) | 24 | 17 | -7 (U) | 96 | 78 | -18 (U) |
Check: gross profit minus operating expenses gives month budget 76 - 68 = 8, actual 70 - 69 = 1, YTD budget 228 - 204 = 24, actual 222 - 205 = 17, full-year budget 912 - 816 = 96, forecast 888 - 810 = 78.
Headlines section
Write headlines as sentences with a number and a reason.
- "Revenue is $12,000 below budget for March (-6%), mainly because a distributor order slipped to April."
- "Full-year operating profit is forecast at $78,000, $18,000 below budget, after assuming the delayed order arrives and holding hiring flat."
- "No change recommended to the cash plan; minimum cash is still met in all months."
Commentary tips
- State the cause, not the number. "Higher than expected" tells the reader nothing. "Freight rates rose 8% from the carrier's January contract change" does.
- Say if it is timing or permanent.
- Quantify the full-year effect.
- Name the action and owner.
- Keep it short: two or three sentences per flagged line.
- Avoid blame. Write about causes, not people.
- Link related lines. If freight rose and gross margin fell, say so once.
- Say what you do not know yet, and when you will.
Template for a comment
Line: ____ Variance: ____ (F/U)
Cause: ____
Type: Timing / Permanent / One-off / Error
Full-year effect: ____
Action and owner: ____ By: ____Good and weak comments
| Weak | Better |
|---|---|
| "Over budget on marketing." | "Marketing is $4,500 over budget (U) due to extra paid search spend on the spring promotion; cost per lead is 15% below target. Full-year effect is +$4,500 unless we reduce spend in June. Owner: Marketing lead." |
| "Revenue lower." | "Revenue is $12,000 below budget; $10,000 is volume (one distributor order delayed to April) and $2,000 is price (two promotional deals). Order confirmed for April 12." |
| "Payroll under." | "Payroll is $8,000 favorable because two roles were filled 6 weeks late; this reverses over the next two months and the full year is unchanged." |
Design tips
- Use one page for the summary and a second for detail.
- Align numbers to the right, use thousands for readability.
- Use consistent order of accounts across months.
- Add a small chart of monthly revenue, budget vs actual vs forecast, for trend.
- Keep a version stamp and a notes cell for corrections.
- Protect formula cells and lock the layout.
Monthly process
- Close the books and load actuals.
- Refresh the report; check totals against the ledger.
- Managers add comments by the deadline.
- Finance reviews and writes the headlines.
- Circulate to the leadership team before the review meeting.
- Record decisions and update the forecast.
Want a working version?
This page shows a layout only. To discuss a version that connects to your accounting system and chart of accounts, contact us. For product companies, connect the report to the product margins that drive it. See unit economics.
Related guides
For the principles of flexing a budget to actual activity before comparing, see flexible budgets: how they work and when to use them. For the full variance method, see budget variance analysis: a step-by-step method.
Keep reading
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.