Budget vs Actual Report Builder
Enter budget and actual for each line. The variance, favorable or adverse status and commentary are worked out for you; costs are scored the right way round.
Your numbers
| Metric | Unit | Better | Target | Actual September 2026 | August 2026 | vs target | vs last | Status | Owner | Commentary (blank = written for you) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| +3.7% | +7.3% | On target | |||||||||
| +5.8% | +8.7% | Close | |||||||||
| −0.3% | +4.7% | Close | |||||||||
| −2.6% | −1.5% | On target | |||||||||
| +10.3% | +15.9% | Close | |||||||||
| +4% | +4.9% | Close | |||||||||
| −3.8% | +7.4% | Close |
Paste rows straight from Excel or Google Sheets into any cell · Sample CSV · Leave Commentary blank and it is written from the numbers.
Slides
Click a slide to edit it. Hidden slides stay here but are left out of the download.
About the Budget vs Actual Report Builder
It opens on the P&L budget vs actual template (5 slides): monthly P&L against budget with variance commentary. Pick a Review switches to one more template: Department budget vs actual (a cost center’s spending against budget).
The example numbers track Net sales, Cost of goods sold, Gross profit, Salaries and Marketing. Each metric has a target, an actual and last period's figure. The builder works out the variance, scores it red, amber or green (costs and other lower-is-better metrics the right way round) and writes a sentence of commentary from the numbers, which you can overwrite. Paste rows from Excel, upload a CSV, edit any slide's words, and hide or add slides.
Download an editable PowerPoint deck built from native tables and charts, with talking points in the speaker notes, and an Excel workbook whose variance and status are live formulas. Save the review as a small file and, next period, open it and press Next period. It is free, with no sign-up, and nothing is stored.
For a chart dashboard of spending against budget, see the budget versus actual dashboard.
2 Budget vs Actual templates
Each opens with example numbers. Switching keeps nothing from your edits, and Undo brings them back.
How to use the Budget vs Actual Report Builder
- 1
Pick a review
Click Pick a Review. This page has 2 ready-made templates, such as P&L budget vs actual and Department budget vs actual. Each opens as a finished deck with example numbers.
- 2
Put your numbers in
Type each metric's target, actual and last period in Your numbers, paste rows from Excel, or use Upload CSV or Excel. Status, variance and commentary update as you type.
- 3
Edit the slides
Click any slide to change its words. Hide what you don't need, or use Add slide for wins, risks, next steps and more. Undo (Ctrl+Z) reverses any change.
- 4
Download
Download lists every format: a free PDF of the slides, an editable PowerPoint deck with native tables and charts, and Excel with variance and status as formulas. The Review file is a small file: next period open it and press Next period.
Start from a spreadsheet: download the sample CSV, fill it in and upload it.
Terms used in this review
- Favourable variance
- A difference from budget that improves profit.
- Adverse variance
- A difference from budget that reduces profit.
Common questions
How is variance calculated?
(Actual − Budget) ÷ Budget. For costs, spending less than budget is favorable, so cost lines are set to “lower is better” and scored that way.
What counts as favorable or adverse?
Favourable means better for profit: revenue above budget or costs below. Adverse is the opposite. The status pill shows how far off budget each line is.
Does the Excel file keep formulas?
Yes. Variance and status are live formulas, and the amber band is one editable cell.
Is it free?
Yes.
Can I download the budget vs actual as PowerPoint or Excel?
Yes. The PowerPoint deck is built from native text, tables and charts you can edit, with commentary in the speaker notes, and the Excel workbook keeps variance and status as live formulas. Both are free, with no sign-up.
Goes well with this — from our other free tools
Example figures and names are illustrative. Replace them with yours before sharing anything.

SlideTeam