Skip to content

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

MetricUnitBetterTargetActual September 2026August 2026vs targetvs lastStatusOwnerCommentary (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.

1Executive summary

Harbor & Pine Foods · September 2026

Executive summary

A steady September 2026: every metric on or close to target.

  • 2 of 7 metrics on or above target and 5 close.
  • Strongest result: Net sales at $8.92M, 3.7% ahead of target.
  • Needs attention: Marketing at $342K against a $310K target.
  • 4 of 7 metrics improved on August 2026.

Written from your numbers. Edit to write your own.

2On target
5Close
0Off track
Budget vs Actual — September 20261 / 5
2Target vs actual table

Harbor & Pine Foods · September 2026

Budget vs actual by line

MetricTargetActualvs targetvs August 2026StatusCommentary
Net sales$8.6M$8.92M▲3.7%▲7.3%On targetNet sales came in at $8.92M, 3.7% better than the $8.6M target, and up 7.3% on August 2026.
Cost of goods sold$5.68M$6.01M▲5.8%▲8.7%CloseCost of goods sold came in at $6.01M, 5.8% short of the $5.68M target, and up 8.7% on August 2026.
Gross profit$2.92M$2.91M▼0.3%▲4.7%CloseGross profit came in at $2.91M, 0.3% short of the $2.92M target, though up 4.7% on August 2026.
Salaries$980K$955K▼2.6%▼1.5%On targetSalaries came in at $955K, 2.6% better than the $980K target, and down 1.5% on August 2026.
Marketing$310K$342K▲10.3%▲15.9%CloseMarketing came in at $342K, 10.3% short of the $310K target, and up 15.9% on August 2026.
Other overheads$580K$603K▲4%▲4.9%CloseOther overheads came in at $603K, 4% short of the $580K target, and up 4.9% on August 2026.
EBITDA$1.05M$1.01M▼3.8%▲7.4%CloseEBITDA came in at $1.01M, 3.8% short of the $1.05M target, though up 7.4% on August 2026.
Budget vs Actual — September 20262 / 5
3Attainment chart

Harbor & Pine Foods · September 2026

Each line as a % of budget

Net salesTarget104%
Cost of goods sold95%
Gross profit100%
Salaries103%
Marketing91%
Other overheads96%
EBITDA96%

Each metric as a % of its target. Lower-is-better metrics are flipped, so 100% always means on target.

Budget vs Actual — September 20263 / 5
4Wins, challenges or asks

Harbor & Pine Foods · September 2026

Main variances explained

  • Cost of goods sold — $330K adverse

    Dairy price increase from August; contract renegotiated from November.

  • Marketing — $32K adverse

    Autumn campaign brought forward from October.

  • Salaries — $25K favorable

    Two vacancies unfilled.

Budget vs Actual — September 20264 / 5
5Next steps

Harbor & Pine Foods · September 2026

Next steps

ActionOwnerDue
01Reforecast Q4 with new dairy priceFP&A15 Oct
02Phase October marketing downMarketingNow
Budget vs Actual — September 20265 / 5

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. 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. 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. 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. 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.