Budget vs actual compares what a team planned to earn and spend with what it did. Subtract the budget from the actual for each line, mark the gap favorable or unfavorable, and explain every gap above a threshold set in advance. At year-end, also tie bookings to revenue and score the forecast.
Year-end is when the budget gets graded. The plan was set a year ago, the forecast has moved all year, and the actuals are in. This guide covers the reconciliation: what to compare, how to compute the gap, the steps to follow in order and what to carry into next year's budget.
We read Investopedia's pages on budget variance and on budgeting vs forecasting, bill.com's budget variance guide and FloQast's budget variance analysis on November 11, 2026. They explain the subtraction well. Most of them treat revenue as one line. FloQast splits it into volume and price, which is the right instinct. A revenue team's year has three revenue lines, and each one misses for a different reason. This guide splits them and adds the steps that tie the CRM's bookings to the finance team's revenue.
What is budget vs actual?
Budget vs actual compares the plan approved for a period with the results recorded when it closed. The gap between the two is the budget variance. Investopedia calls it the gap between budgeted amounts and actual outcomes, a way to judge how good the plan was.It is one of three comparisons a revenue team runs. Budget vs actual grades the plan. Forecast vs actual grades the forecast. Forecast vs budget shows the gap while the period is still open.
How do you calculate budget vs actual variance?
Variance equals actual minus budget, shown in dollars and as a percent of the budget. A revenue line above budget is favorable. An expense line above budget is unfavorable. The sign alone does not say which one you have, so label every line.| Measure | Formula | Example: $250,000 sales budget, $200,000 actual |
|---|---|---|
| Variance in dollars | Actual - Budget | -$50,000 |
| Variance in percent | (Actual - Budget) / Budget | -20% |
| Favorable or unfavorable | Revenue above budget, or expense below budget, is favorable | Unfavorable |
| Line type | Actual above budget | Actual below budget |
|---|---|---|
| Revenue or bookings | Favorable | Unfavorable |
| Expense | Unfavorable | Favorable |
Worked example: one SaaS year
A total that looks mild can hide a miss in the line that matters. The table below is illustrative, not a customer's.| Line | Budget | Actual | Variance | Variance % | Label |
|---|---|---|---|---|---|
| New logo bookings | $4,000,000 | $3,400,000 | -$600,000 | -15.0% | Unfavorable |
| Expansion bookings | $1,500,000 | $1,725,000 | +$225,000 | +15.0% | Favorable |
| Renewal bookings | $6,000,000 | $5,940,000 | -$60,000 | -1.0% | Unfavorable |
| Total bookings | $11,500,000 | $11,065,000 | -$435,000 | -3.8% | Unfavorable |
| Sales and marketing expense | $5,200,000 | $5,330,000 | +$130,000 | +2.5% | Unfavorable |
- New logo bookings missed by 15%. The cause sits upstream: pipeline created, win rate or deal size. Check each one before you blame the team.
- Expansion beat by 15%. It covered most of the new logo miss. Do not let it hide the miss.
- Renewals landed within 1%. There is little to explain.
- Total bookings are down 3.8%. That number alone suggests a small problem. The mix says otherwise.
- Spend ran 2.5% over while new logo bookings fell short. Cost rose as results fell. That pairing is worth a line in the board summary.
What goes in a budget vs actual report?
Use one row per line, with the budget, the actual, the variance and a written reason. FloQast recommends a spreadsheet with a column for budgeted values, one for actual values, one for the variance and one for a written explanation of the cause. Revenue teams need three more.| Column | What it holds | Why it matters |
|---|---|---|
| Budget | The approved figure, frozen | The reference does not move mid-year |
| Actual | The closed figure from one named source | Two sources give two answers |
| Variance, dollars and percent | Actual minus budget | Size and scale |
| Label | Favorable or unfavorable | The sign alone is ambiguous |
| Owner | The person who explains it | Someone has to answer for each line |
| Driver | Pipeline, win rate, deal size, timing or error | Turns the number into an action |
| Explanation | One written sentence | Variances without a reason get ignored |
| Template | Use it for |
|---|---|
| Annual operating plan template | The budget side of the report |
| Financial forecast template | The forecast column next to it |
Year-end reconciliation, step by step
Run the steps in order. Each one assumes the one before it is done.- Freeze the baseline and the definitions. Pick the budget you compare against and leave it alone. Agree which CRM field is the booking amount and what counts as new logo, expansion and renewal.
- Name one source of truth per line. Bookings come from the CRM. Revenue comes from finance. Say which one each row uses.
- Tie bookings to revenue. The two will not match, and the difference has an explanation. ORM's guides on reconciling ARR to GAAP revenue and on ARR vs GAAP revenue show where the gap comes from.
- Lay the budget, the last forecast and the actual side by side. Three columns give you two variances in one view.
- Compute the variance and label it. Use one sign convention for the whole report.
- Set the materiality threshold before you look. Use a dollar floor and a percent floor. The method is in how to set a materiality threshold.
- Explain every material variance in one sentence. Name the cause. Split revenue into deal count and deal size. ORM's read is that pressure on deal size and win rate points to competition, while a low deal count points to pipeline generation.
- Score the forecast too. A team can hit budget and still have a blind forecast. Forecast vs actual analysis shows how to grade it.
- Decide what changes. Each material variance ends in one of three outcomes: fix the process, change the assumption or accept the miss.
- Save the pack. Keep the report, the explanations and the definitions so next year's review starts from the same baseline.
Why do actuals miss the budget?
Budgets miss because they rest on estimates. Three causes come up most often.| Cause, as Investopedia names it | What it looks like |
|---|---|
| Errors | Faulty math, a wrong assumption or stale data in the budget |
| Changing conditions | A new competitor, a weaker economy or a regulatory change |
| Unmet expectations | The team beat or missed the estimates the budget rests on |
ORM sees three assumptions that cause most of the miss in revenue budgets:
- Pipeline timing. About 20% of the pipeline dated to close in a quarter on day one usually closes in that quarter, and the share varies by customer. The rest usually does not. A budget that counts the close-date column at face value starts the quarter overstated. See how much day-one pipeline actually closes.
- Rep ramp. Most plans assume reps are 25% productive in quarter one, 50% in quarter two and 75% in quarter three, then fully productive. That is almost never true across a whole company.
- Attainment. In ORM's experience, the average quota attainment to plan for is 75% to 80%, with a tail below and a tail above. A plan that assumes everyone hits 100% is missing by design. See what a good quota attainment rate is.
How do expiring budgets change Q4?
Year-end changes what your buyers do with their own budgets. Jeffrey Liebman and Neale Mahoney studied 14.6 million federal contracts from 2004 to 2009 (NBER Working Paper 19481). Federal agencies spent 4.9 times more in the last week of the fiscal year than in a typical week. That week held 8.7% of annual spending, against a normal 1.9%. IT projects bought in the last week were between two and six times more likely to receive a lower quality rating.The study covers federal agencies, where unspent funds expire. It shows how expiring budgets behave. It does not give a rate for your buyers. Three habits help a revenue team in a year-end rush:
- Record the buyer's budget expiry date on the deal, when there is one.
- Hold those deals to the same stage rules as every other deal. A deal that misses the expiry date can wait for the next budget.
- Report pulled-forward revenue on its own line in the budget vs actual review. Next year's budget should not treat a one-time surge as a trend.
For the other side of the same pattern, see forecast vs budget, which covers the cost of pulling next quarter's deals into this one.
Budget vs actual, forecast vs actual and flux: which review answers what
Each review answers a different question, so keep them in separate columns. The year-end pack should carry all three.| Review | Question it answers | Read more |
|---|---|---|
| Budget vs actual | Did the plan hold? | This guide |
| Forecast vs actual | Did we call our own result? | Forecast vs actual analysis |
| Variance analysis | How does the gap split into price, volume and mix? | Variance analysis |
| Flux analysis | What changed since last month? | Flux analysis |
| Plan vs actual reporting | What does the recurring revenue-team version look like? | Plan vs actual reporting |
What should carry into next year's budget?
The year-end review is worth the effort only if it changes next year's inputs. Carry these forward:- Attainment. Use the attainment you measured for each segment. Do not assume 100%.
- Ramp. Replace the blended 25, 50, 75 assumption with measured ramp by tenure.
- Seasonality. Phase the budget by month. In ORM's data, Q2 and Q4 run stronger than Q1 and Q3, and the third month of a quarter closes more than the first two. See how to add seasonality to a sales forecast.
- Mix. Budget expansion on its own line. Benchmarkit reports that existing customers supplied 40% of total new ARR in its sample, up from a 25% median in 2022.
- Timing. Use the day-one close rate, not the close-date column.
- Process. Start earlier. Investopedia's SaaS example builds the budget in Q4, and ORM's annual planning timeline shows the order of work. For a spending plan that updates monthly, see the rolling budget guide and the sales budget guide.
ORM's take
A budget is a commitment, and the year-end review is how a team finds out what it was worth. The arithmetic is easy. The value is in the explanation, the tie-out and the inputs for next year.
ORM forecasts bookings deal by deal from stage, close date and amount history. It targets 95% accuracy on new and expansion business. That gives a revenue team a forecast to put next to the budget and the actual. The year-end pack then answers two questions. Did the plan hold? Was the forecast any good? For the full-year view, see full-year reforecast.
Sources
All checked on November 11, 2026.
- Investopedia, Budget Variance: Definition, Primary Causes, and Types (updated April 29, 2026): the definition, favorable and unfavorable variances, the three primary causes, materiality as subjective, and the $250,000 budget with $200,000 actual example
- Investopedia, Budgeting vs. Forecasting: Key Differences Explained (updated March 25, 2026): the budget compared with actual results, and a SaaS company that builds its budget in Q4
- bill.com, What Is Budget Variance?: the formula actual minus budgeted, with favorable and unfavorable examples
- FloQast, Budget Variance Analysis: Basics to Expert Insights (November 6, 2023): the four-column spreadsheet, the subtraction step, volume and price variances, and continuous monitoring
- Jeffrey Liebman and Neale Mahoney, Do Expiring Budgets Lead to Wasteful Year-End Spending? Evidence from Federal Procurement (NBER Working Paper 19481), as summarized in the NBER Digest: 14.6 million contracts from 2004 to 2009, 4.9 times the typical weekly spending in the last week, 8.7% against 1.9% of annual spending, and IT project quality
- Maxio, What are the Latest SaaS Metrics Benchmarks Telling Us? (July 3, 2025), summarizing the Benchmarkit 2025 SaaS Performance Metrics Benchmarks Report: median planned growth of 35% against a median actual of 26% for 2024, and 40% of total new ARR from existing customers against a 25% median in 2022
- ORM Technologies, observations across its customer base: the share of day-one pipeline that closes in the quarter, the blended ramp assumption, planned attainment of 75% to 80%, quarter and month seasonality, and the deal size and deal count read on a revenue miss
Frequently Asked Questions
What is budget vs actual?
Budget vs actual compares the plan approved for a period with the results recorded when the period closed. You subtract the budget from the actual for each line, show the gap in dollars and as a percent, and label it favorable or unfavorable. The report exists to show where the plan held, where it did not and why.
How do you calculate budget variance percentage?
Subtract the budget from the actual, then divide by the budget. A $250,000 sales budget with $200,000 in actual sales gives a variance of minus $50,000, or minus 20%. That is Investopedia's own example. Use one sign convention on the whole report and write it at the top.
What is a good budget variance percentage?
There is no standard figure. Investopedia notes that what counts as material is subjective and depends on the company and the size of the variance. Set a dollar floor and a percent floor before the year ends. If a material variance repeats over a long stretch, the budget process needs work.
What is the difference between budget vs actual and budget vs forecast?
Budget vs actual grades the plan after the period closes. Budget vs forecast compares the plan with the current expectation while the period is still running. A team can hit the budget and still have forecast variance, because the two answer different questions. Report both so you can tell a planning problem from a forecasting problem.
What goes in a budget vs actual report?
Use one row per line. Show the budget, the actual, the variance in dollars and percent, a favorable or unfavorable label and a written reason. FloQast recommends that layout. Revenue teams should add an owner and split revenue into new logo, expansion and renewal rows.
When should you reconcile budget vs actual?
Review it monthly or quarterly and run the full reconciliation at year-end. FloQast advises against treating variance analysis as a once-a-year task, since steady monitoring catches problems early. The year-end pass ties bookings to revenue and sets the inputs for next year.
See how ORM turns these insights into action
ORM builds custom revenue forecast models for B2B SaaS companies. Not dashboards. Prescriptive analytics that tell you what to do next.
Schedule a Demo
