Free Budget Variance Report Template — Excel Download

01 — What's Included

What's in the Template

The Budget Variance Report is a single-sheet Excel file with a branded header, project metadata block, 12 pre-labelled work package rows and a violet auto-summing totals row. The Variance ($) and Variance (%) columns are live formulas — enter your budget and actual figures and everything else calculates instantly.

Column	Field	Notes
WP ID	Work Package ID	Pre-filled WP-01 through WP-12. Customise to match your WBS numbering.
Work Package	Category Name	Pre-labelled: Labour (PM, Dev, Design, Test), Hardware, Software, Cloud, Travel, Training, Contingency, Management Reserve, Other.
Budget ($)	Planned Cost	Enter the approved budget for this work package. Formatted as currency.
Actual ($)	Actual Spend	Enter the actual cost incurred to date or for the period. Formatted as currency.
Variance ($)	Formula	Auto-calculated: Budget minus Actual. Positive = under budget. Negative = over budget. Shown in red brackets if negative.
Variance %	Formula	Auto-calculated: Variance ÷ Budget. Shows percentage over or under. Positive = under, negative = over.
Status	RAG Indicator	Enter 🟢 Green / 🟡 Amber / 🔴 Red manually based on your threshold rules.
Notes	Explanation	Free text. Explain the cause of any significant variance — essential for sponsor reports.

The Totals Row

The violet totals row at the bottom auto-sums the Budget, Actual and Variance ($) columns across all 12 work packages. The total Variance % is also calculated automatically as (Total Budget − Total Actual) ÷ Total Budget. This gives you the overall project cost position at a glance without any manual addition.

💡

Adding more work packages: To add rows beyond the 12 pre-set categories, insert a row above the totals row (right-click → Insert Rows Above). Copy the formatting from an existing row. The totals formulas use SUM ranges that automatically expand to include inserted rows — no formula editing needed.

02 — How the Formulas Work

Budget Variance Formulas — Explained

The template uses two core formulas. Both are live — update the Budget or Actual figures and variance columns recalculate immediately.

Variance ($)

= Budget − Actual

Positive result = under budget (good). Negative result = over budget (concern). The template formats negative values in brackets to make overruns visually obvious: (5,000) means $5,000 over budget.

Variance (%)

= (Budget − Actual) ÷ Budget

Shown as a percentage. A result of +10% means you've spent 10% less than budgeted. A result of −8% means you're 8% over budget. The formula is protected against division-by-zero when Budget is blank.

Reading a Variance — Worked Example

🔴 Over Budget — Labour

Budget$45,000

Actual$52,400

Variance($7,400) — −16.4%

16.4% over on labour — note in the Notes column: "3 additional developer days due to scope change CR-004. Change budget to be adjusted."

🟢 Under Budget — Software

Budget$12,000

Actual$9,800

Variance$2,200 — +18.3%

18.3% under on software licences — note: "Negotiated volume discount. Saving to be reallocated to contingency."

📌

Budget variance vs EVM Cost Variance: This template calculates simple budget variance — planned spend vs actual spend. For a more sophisticated analysis that accounts for how much work has been completed relative to cost, use our EVM Tracker template alongside this report. EVM's Cost Variance (EV − AC) is the industry standard for performance-based cost analysis and is tested heavily on the PMP exam.

03 — How to Use

How to Use the Budget Variance Report

Fill in the metadata block

Enter the project name, PM name, reporting period (e.g. "March 2026" or "Week 12") and currency at the top. This makes every version of the report self-identifying — essential when sharing multiple period reports with sponsors.

Customise the work package names

The 12 pre-set categories (Labour — PM, Labour — Development, Hardware, Software etc.) are a starting point. Replace them with your actual WBS work packages or cost categories. If you have fewer than 12, delete unused rows. If you need more, insert rows above the totals row.

Enter Budget figures from your approved project budget

Enter the approved budget for each work package in the Budget ($) column. These should match your signed-off project budget document or change control baseline. Do not change these figures mid-period — create a new version of the report for each reporting period instead.

Enter Actual figures from your finance system

Enter the actual costs from your finance or accounting system — not estimates. For labour, this is hours worked multiplied by the agreed rate. For goods and services, this is purchase orders raised or invoices paid. Variance and percentage columns calculate automatically the moment you enter the actual.

Set RAG status and add explanatory notes

Set the RAG status for each work package using your organisation's thresholds (e.g. 🟢 within 5%, 🟡 5–10%, 🔴 over 10%). In the Notes column, explain the cause of any significant variance. A good note names the root cause and what action is being taken — not just the number. Sponsors want to know "why" and "what next", not just "we're over".

Share with sponsor and finance team

Send the completed report as part of your monthly project status pack. Save each period's report separately — e.g. "Budget-Variance-Report-March-2026.xlsx" — never overwrite previous periods. This creates an audit trail showing how the project's cost position evolved over time.

04 — RAG Thresholds

Setting RAG Thresholds for Budget Variance

The RAG (Red, Amber, Green) status column requires you to define thresholds — the percentage variance that triggers each colour. Common industry standards are:

RAG Status	Typical Threshold	What it Signals	Action Required
🟢 Green	Within ±5% of budget	On track — normal variation	Monitor. No action needed unless trend is worsening.
🟡 Amber	5–15% over budget	At risk — approaching concern	Investigate cause. Identify corrective action. Inform PM and sponsor.
🔴 Red	>15% over budget	Off track — action required	Escalate to sponsor. Raise change request if scope is driving cost. Formal recovery plan required.

These thresholds vary by organisation. Some use tighter bands (±3% / 3–8% / over 8%) for high-scrutiny projects. Agree your specific thresholds with the sponsor and finance team before the project starts and document them in your project status report.

Under Budget Isn't Always Good

A large positive variance (significantly under budget) can signal that planned work has not been done — not that the project is being delivered efficiently. If you're 20% under budget at the midpoint, check whether the project is also ahead of schedule. If it is, great. If it isn't, the under-spend may reflect delayed or missed work packages that will create a cost spike later.

📌

PMP exam tip: The PMBOK distinguishes between Budget Variance (BV = BAC − AC, a simple spend comparison) and Cost Variance (CV = EV − AC, an earned value metric). Exam questions frequently test whether you can identify which metric is being described. Simple budget variance does not account for how much work has been completed — that is why EVM was developed. See our EVM guide for a full walkthrough.

05 — FAQ

Budget Variance — 4 Common Questions

A budget variance report compares planned (budgeted) costs against actual costs incurred on a project, work package by work package. It shows the absolute variance (planned minus actual in dollars) and the percentage variance, making it easy to see where the project is over or under budget and by how much. Budget variance reports are typically produced monthly and shared with the project sponsor and finance team as part of the regular project reporting cycle.

Budget variance (BV) is the difference between the budgeted amount for a work package and the actual cost incurred. A positive variance means the project spent less than planned (under budget). A negative variance means the project spent more than planned (over budget). Budget variance is related to but different from Cost Variance (CV) in Earned Value Management, which compares the value of work completed against what was actually spent — a more precise metric that accounts for schedule performance too.

Budget Variance is a simple comparison: Budget minus Actual Spend. It tells you whether you are spending more or less than planned in absolute terms. Cost Variance (CV) in Earned Value Management is: Earned Value (EV) minus Actual Cost (AC). CV is more powerful because it accounts for how much work has actually been completed — you could be under budget but also behind schedule, which EVM's SPI reveals. For full EVM analysis, use our EVM Tracker template alongside this budget variance report.

Monthly is the standard cadence for most projects. For high-risk or fast-moving projects with weekly reporting cycles, a fortnightly report is common. The key is consistency — producing the report on the same schedule each period makes trends visible and gives stakeholders a reliable rhythm of financial updates. Each report should be discussed in the monthly project review meeting with the sponsor and finance representative, ideally alongside the status report.

Free Budget Variance Report Template Excel Download