Budget Variance Report Template: Free One‑Pager Example

Every example was made with MakeOnepagers. The names and figures are samples, and the example opens as a template you can edit for free.

What goes on a budget variance report

Pick a threshold before you write, such as 5% or $25k. Any line past it gets a reason. Any line inside it does not.

How to work out budget variance

Variance is actual minus plan. Divide by plan to get the percentage.

A positive number on a cost line means you spent more than planned, so it is shown in red. A negative number means you spent less. On a revenue line it is the other way around, so say which kind of line you are reporting.

Budget variance report example

Edit this template

A program office's quarter: three totals, six lines against plan, two reasons and one recommendation.

What to copy:

• Three numbers at the top: spent $2.41M, plan $2.30M, over +4.8%. The reader has the answer before the first chart.
• Every line as a bar against a plan marker, with the variance in green or red on the right. Contractors at +22% and travel at -20% stand out at a glance.
• Reasons only for the lines that matter: contractors ($540k planned, $660k spent, testing cover) and hardware ($300k, $330k, a price rise). Travel was under plan, so it needs no story.
• A recommendation with a number and an end date: "Release $90k from contingency for contractors. Testing cover ends in November, so the overspend stops there."
• The overspend by month: +$20k, +$50k, +$40k, adding up to the +$110k in the totals. The reader can check the math.

Open it: budget variance report template.

Edit this template

A free budget variance report template

Copy this outline, or open the example above and edit it.

1. Headline: Budget variance: [period], with the team and the end date.
2. Totals: spent, plan and the variance as a percentage.
3. By line, actual against plan: five or six lines and the full year forecast, each with its variance.
4. Why: a table of every line past your threshold, with plan, actual and the reason in a few words.
5. Recommendation: what you want approved, how much and until when.
6. By month: the variance each month and the total for the period.

For a budget that has not started yet, use a budget summary One-Pager instead.

How to make a budget variance report in 5 steps

1. Export plan and actual for the period from your accounting system, by budget line.
2. Work out each variance in dollars and as a percentage of plan.
3. Set a threshold and mark every line past it.
4. Write one reason per marked line in a few words, such as "price rise" or "testing cover".
5. End on a recommendation with the dollar amount and when the variance stops.

Have a long finance pack or a spreadsheet? Drop it into the free AI One-Pager generator and get a first budget variance report back to edit.

Budget variance report mistakes

• A reason for every line. The reader stops reading before the two that matter.
• Percentages without dollars. +22% on a small line can matter less than +5% on a big one. Show both.
• No forecast. The reader wants to know where the year will land, not only the quarter.
• Mixing cost and revenue lines without saying which is which, so red and green mean different things.
• No recommendation. A variance report that only reports leaves the decision to someone with less context than you.

Make your budget variance report

Open the free budget variance report template and put in your numbers, or drop your finance pack into the free AI One-Pager generator and get a finished page back. Browse every One-Pager template for more layouts.