---
title: "Budget vs actual: Report, variance formula, and examples"
description: "Budget vs actual compares planned and actual results. Get the budget variance formula, a full report example, and how to explain each variance."
url: https://emptyspaces.ai/resources/blog/budget-vs-actual
language: en
---

[Blog](https://emptyspaces.ai/resources/blog) Guide

# Budget vs actual: Report, variance formula, and examples

Published October 9, 2026 8 min read

Key takeaways

- Budget vs actual compares what your business planned to earn and spend in a period with what it actually earned and spent, and the difference is the budget variance.
- Budget variance equals actual minus budget, and dividing by the budget gives the variance as a percentage.
- A useful budget vs actual report explains only the variances above a set threshold, says whether each one is timing or permanent, and shows what it means for the forecast.

Budget vs actual is a comparison of what your business planned to earn and spend in a period with what it actually earned and spent. The difference between the two is the budget variance, calculated as actual minus budget in dollars and as a percentage of the budget. Reviewing budget vs actual every month helps you catch overspending early, hold budget owners accountable, and keep your forecast accurate. This guide covers the variance formula, favorable and unfavorable variances, a complete budget vs actual report with commentary, and how to run the analysis each month.

## What is budget vs actual?

Budget vs actual is the monthly check of your financial results against the plan leadership approved. It starts once the month-end close is complete, because the actuals need to be final before you compare them.

- **Budget** The approved plan for revenue and expenses, usually set once a year and split by month
- **Actuals** The recorded results for the period, taken from your closed books
- **Budget variance** The difference between actual and budget for each line, in dollars and as a percentage

You'll also see the comparison called budget to actual, budget vs actuals, or actual vs budget. They all describe the same analysis. For how it fits into the wider planning cycle, see [what FP&A is](https://emptyspaces.ai/resources/blog/fpa).

## Why compare budget vs actual?

The purpose of comparing budget vs actual is to find out early where the business is departing from its plan, and why. The main benefits are:

- **Early warning** A cost line running 15% over budget in March is easier to correct than the same overspend found in November
- **Accountability** Each budget owner explains the variances in their area, so spending decisions have a named owner
- **Better forecasts** Variances that will continue feed straight into the next reforecast, so the outlook reflects what's actually happening
- **Clear decisions** Leadership sees which variances are timing and which are permanent, so it can decide what to act on

The work takes significant time. In Ledge's 2025 survey of finance teams, variance and budget vs actual analysis ranked as the fourth-biggest time sink in the monthly close. The 2025 FP&A Trends Survey found that FP&A professionals spend 46% of their time on data-related work, such as collecting and validating numbers, rather than on analysis.

## How to calculate budget variance

The budget variance formula gives you the difference in dollars, and the percentage formula shows how large that difference is relative to the plan:

- **Budget variance ($)** Actual − Budget
- **Budget variance (%)** (Actual − Budget) / Budget × 100

Example

Your sales and marketing budget for March is $300,000, and actual spend is $345,000. The variance is $345,000 − $300,000 = $45,000, and the percentage is $45,000 / $300,000 × 100 = 15.0%. Because this is a cost line and actual is higher than budget, the variance is unfavorable.

### Do you subtract budget from actual or actual from budget?

The common convention is actual minus budget, which is what the formula above uses, with each variance then labeled favorable or unfavorable. Some teams flip the sign for expense lines so that a positive number always means favorable. Either approach works, as long as the report states which one it uses and applies it to every line.

## Favorable vs unfavorable variances

Whether a variance is favorable depends on the type of line, so the same sign can mean good news on revenue and bad news on costs:

| Line type | Actual above budget | Actual below budget |
| ------------------------------------------------------- | ------------------- | ------------------- |
| Revenue and other income | Favorable | Unfavorable |
| Cost of goods sold and operating expenses | Unfavorable | Favorable |
| Profit lines, such as gross profit and operating income | Favorable | Unfavorable |

A favorable variance isn't always good news. Spending less than budget on hiring can mean open roles that will slow the business later, so every significant variance still needs an explanation.

## Budget vs actual report example

A budget vs actual report lists each line of the income statement with its budget, actual, and variance in dollars and percent.

Example

A software company's March report looks like this:

| Line | Budget | Actual | Variance ($) | Variance (%) | F/U |
| -------------------------- | ---------- | ---------- | ------------ | ------------ | --- |
| Revenue | $1,200,000 | $1,150,000 | −$50,000 | −4.2% | U |
| Cost of goods sold | $360,000 | $333,500 | −$26,500 | −7.4% | F |
| Gross profit | $840,000 | $816,500 | −$23,500 | −2.8% | U |
| Sales and marketing | $300,000 | $345,000 | $45,000 | 15.0% | U |
| Research and development | $250,000 | $238,000 | −$12,000 | −4.8% | F |
| General and administrative | $150,000 | $152,000 | $2,000 | 1.3% | U |
| Operating income | $140,000 | $81,500 | −$58,500 | −41.8% | U |

The company's threshold is any variance above $25,000 or 10%. That flags revenue, cost of goods sold, and sales and marketing for commentary, along with operating income, which those three lines drive. Research and development and general and administrative stay below the threshold, so they need no explanation this month.

## How to do a budget vs actual analysis

A consistent monthly routine helps you finish the analysis quickly and keeps the commentary comparable from month to month:

1. **Start from closed books** Run the analysis after the month-end close, so actuals include accruals and adjustments.
2. **Map actuals to budget lines** Make sure each account rolls up to the same lines the budget uses.
3. **Calculate the variances** Work out the dollar and percentage variance for every line, and label each one favorable or unfavorable.
4. **Apply your threshold** Explain only the lines above it, such as $25,000 or 10% for a mid-sized company. There's no universal standard, so size the threshold to your company.
5. **Find the driver** Trace each flagged variance to its cause, such as volume, price, timing, a one-off item, or a coding error.
6. **Write the commentary** State the cause, the amount, and whether the variance will continue.
7. **Update the forecast** Carry permanent variances into the next reforecast.

For the full month-end sequence that produces the actuals, see [the month-end close process](https://emptyspaces.ai/resources/blog/month-end-close-process).

## How to explain budget variances

Clear commentary turns a list of numbers into something leadership can act on. Each explanation should give the cause, the amount, and whether the variance is timing or permanent.

Example

Here's weak and useful commentary for the flagged lines in the March report:

| Line | Weak commentary | Useful commentary |
| ------------------- | --------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Revenue | "Revenue $50,000 under budget." | "$60,000 from two enterprise deals budgeted for March closed on April 3. Expansion revenue added $10,000. Timing, so the full-year forecast is unchanged." |
| Cost of goods sold | "COGS below budget." | "A hosting discount that started in March saved $15,000, and lower usage saved $11,500. The discount is permanent and lowers the full-year forecast by $150,000." |
| Sales and marketing | "Marketing overspent by $45,000." | "$35,000 is the trade show moved from May to March, which is timing. $10,000 is a new agency retainer that runs through December and is permanent." |

Each useful comment adds up to the full variance: $60,000 − $10,000 = $50,000, $15,000 + $11,500 = $26,500, and $35,000 + $10,000 = $45,000. Commentary that doesn't reconcile to the variance usually means part of the cause is still missing.

Each variance fits one of five categories:

- **Timing** Revenue or spending landed in a different month than planned, and it will reverse
- **Volume** You sold, bought, or hired more or fewer units than planned
- **Price or rate** Prices, wages, or supplier costs differ from the plan
- **One-off** An event the budget didn't include, such as a legal settlement
- **Error** A cost coded to the wrong account or posted to the wrong month, which should be corrected

## Budget vs actual vs forecast

Comparing actuals with both the budget and the latest forecast gives you two different answers, and leadership usually wants both:

| Comparison | Question it answers | When it changes |
| ------------------ | ------------------------------------------------------------ | -------------------------------------------- |
| Actual vs budget | How are you performing against the plan leadership approved? | The budget stays fixed for the year |
| Actual vs forecast | How accurate is your latest expectation? | The forecast is updated monthly or quarterly |
| Forecast vs budget | Where will the full year land compared with the plan? | Each time you reforecast |

The budget gives you a stable baseline, while the forecast shows where the year is heading.

## How often should you review budget vs actual?

Review budget vs actual every month, a few days after the close, and reforecast at least quarterly. The work involves several roles:

| Role | What they do |
| ------------- | -------------------------------------------------------------- |
| Controller | Confirms the actuals are final after the close |
| FP&A analyst | Builds the report, applies the threshold, and drafts questions |
| Budget owners | Explain the variances in their departments |
| FP&A lead | Reviews the commentary and updates the forecast |
| CFO | Reviews the report with leadership and decides what to act on |

The finished report usually goes into the monthly management pack.

## How to create a budget vs actual report in your accounting system

QuickBooks Online, NetSuite, and Xero each include a standard budget vs actual report once you load the budget:

- **QuickBooks Online** The Budget vs. Actuals report compares each account with its budget by month, in the Plus and Advanced plans
- **NetSuite** The Budget vs. Actual report compares results with a budget by period and segment
- **Xero** The Budget Variance report shows budget, actual, and variance for each account

These reports calculate the variances, but they don't explain them. To group accounts into budget lines, apply a threshold, and add commentary, export the numbers to Excel or an FP&A tool. The report example above works as a budget vs actual template in Excel: six columns for line, budget, actual, variance in dollars, variance in percent, and favorable or unfavorable, plus a seventh for commentary.

Software can also take on the investigation itself, such as tracing a variance to the transactions behind it and drafting the explanation for review.

If you want to see how our agents prepare the monthly management report and its commentary for your review, [explore management reporting](https://emptyspaces.ai/solutions/management-reporting).

Share this article

- [ Share on X ](https://x.com/intent/post?url=https%3A%2F%2Femptyspaces.ai%2Fresources%2Fblog%2Fbudget-vs-actual&text=Budget%20vs%20actual%3A%20Report%2C%20variance%20formula%2C%20and%20examples)
- [ Share on LinkedIn ](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Femptyspaces.ai%2Fresources%2Fblog%2Fbudget-vs-actual)

## See our agents work through a finance process that matters to your team.

Tell us where the work gets stuck. We’ll walk through how the agents could help.

[Book a working session](https://emptyspaces.ai/contact-us)