Month·End·Close
← Month-End Close

Flux & Variance

Budget vs actual variance analysis: a worked example

Budget vs actual variance analysis compares what happened in a period with what the budget said would happen, line by line. The arithmetic is one subtraction. The work is the two decisions after it: which differences are worth explaining, and whether the explanation actually accounts for the number.

Variance: actual − budget.

Variance %: variance ÷ budget.

Favorable or unfavorable: favorable when the difference helps net income (revenue above budget, or an expense below it), unfavorable when it hurts.

How to calculate a budget variance

Take each line's actual and subtract its budget. Divide the result by the budget to get the variance as a percentage. A service revenue line budgeted at 120,000.00 that came in at 108,600.00 has a variance of −11,400.00, or −9.5% of budget.

Some reports subtract the other way, budget minus actual. Neither order is wrong, but mixing them is, and a sign on its own doesn't tell a reader whether the news is good. That's what the favorable or unfavorable label is for. Use one order for every line and every month, and label each variance.

When the budget is zero, there's no percentage to calculate: any actual is an infinite percentage of nothing. Show the dollar variance and mark the percentage n/a rather than leaving a division error in the report.

Favorable or unfavorable depends on the line, not the sign

A positive variance is good news on a revenue line and bad news on an expense line. Product revenue 48,200.00 over budget is favorable. Cost of goods sold 27,500.00 over budget is unfavorable. Both are “over.”

So each line needs a type: revenue, expense, other income or other expense. Don't infer it from the account name. Contra-revenue lines, rebates and other income sitting in an expense range all break that inference, and a single line labeled the wrong way turns its variance around. Set the type once per account and keep it.

A worked example: one month, fifteen lines

A fictional distributor's September 2026 income statement against budget:

LineTypeBudgetActualVariance%Direction
4000 Product revenueRevenue840,000.00888,200.0048,200.005.7%Favorable
4100 Service revenueRevenue120,000.00108,600.00(11,400.00)−9.5%Unfavorable
4900 Freight billed to customersRevenue18,000.0019,500.001,500.008.3%Favorable
5000 Cost of goods soldExpense504,000.00531,500.0027,500.005.5%Unfavorable
5100 Freight inExpense21,000.0028,400.007,400.0035.2%Unfavorable
6000 Salaries and wagesExpense145,000.00146,200.001,200.000.8%Unfavorable
6050 Payroll taxes and benefitsExpense33,000.0034,100.001,100.003.3%Unfavorable
6100 RentExpense24,000.0024,000.00–0.0%On budget
6200 Software subscriptionsExpense9,500.0011,800.002,300.0024.2%Unfavorable
6300 TravelExpense6,000.003,100.00(2,900.00)−48.3%Favorable
6400 MarketingExpense15,000.0017,200.002,200.0014.7%Unfavorable
6500 Professional feesExpense8,000.0014,500.006,500.0081.3%Unfavorable
6600 Repairs and maintenanceExpense0.006,850.006,850.00n/aUnfavorable
6700 InsuranceExpense5,200.005,200.00–0.0%On budget
7000 Interest expenseOther expense4,100.004,250.00150.003.7%Unfavorable
Net income203,200.00189,200.00(14,000.00)Unfavorable

Revenue came in 38,300.00 over budget, expenses 52,150.00 over and interest expense 150.00 over, so net income finished 14,000.00 below budget. The headline is unfavorable even though the largest single variance, product revenue, is favorable. That's typical: the summary line rarely tells you which lines need a word.

Which variances to explain

Explaining every line wastes the review on rounding. Explaining only the biggest dollar amounts misses small lines that have gone badly off plan. A common approach is two thresholds, one in dollars and one in percent, and a rule for combining them.

With the thresholds at $5,000 and 5% and both required, six lines in the example need an explanation: product revenue, cost of goods sold, service revenue, freight in, repairs and maintenance, and professional fees. Software subscriptions are 24.2% over budget but only 2,300.00, so they don't make the list. Switch the rule to either threshold and ten lines qualify, adding software, marketing, travel and freight billed.

Neither rule is right in general. “Both” keeps the list to what matters on both counts; “either” catches small lines that have gone far off plan. What matters is picking one, writing it down, and using it every month, so the list of variances to explain is the same whoever prepares it. The repairs line, with a zero budget, passes the percent test automatically, and whether it's on the list depends only on the dollar threshold. Flux thresholds shows how many lines a given setting flags on your own numbers.

An explanation that adds up

A useful explanation states the variance and names its causes with amounts. “Freight in: $7,400 (35.2%) over budget, unfavorable” is the variance. The causes are a fuel surcharge on inbound loads of 4,200.00 and expedited freight for a promotion of 2,650.00. Together they explain 6,850.00, which is 92.6% of the variance, and leave 550.00 unexplained.

Writing the amounts down is what makes the explanation reviewable. “Higher freight costs due to fuel and expediting” sounds complete and can't be checked. Two causes with amounts that add up to 92.6% can, and the 550.00 left over is either small enough to accept or the next question. Watch for causes that total more than the variance, or that point the other way: something is counted twice or has the wrong sign. And treat words like “timing,” “various” or “normal fluctuation” as a category, not a cause. A reviewer will ask what it was. The commentary test runs the same checks on flux explanations.

The three common ways variances get split

Textbooks group variances differently, which is why searches for the “three types of variance analysis” give different answers. In cost accounting, each cost (materials, labor, overhead) splits into a price or rate variance and a quantity or efficiency variance. For revenue, the usual split is price, volume and mix: did we charge more, sell more, or sell a different combination? The price/volume/mix calculator does that split for a revenue line like the product revenue variance above. A budget vs actual review usually starts one level up, at the line, and splits only the lines that need it.

Budget vs actual in Excel

The usual layout is one row per line and columns for budget, actual, variance, variance %, direction and a flag, with the thresholds in their own input cells so the flags recalculate when policy changes. Two details save trouble later. Wrap the percentage in a check for a zero budget instead of letting it return a division error. And compute the direction from the line's type, not from the sign of the variance. The budget vs actual tool downloads this layout as a workbook, with every variance, direction and flag as a formula, plus the line type and the two threshold tests.

Budget variance and flux are different questions

Budget vs actual asks how the month compared with the plan. Flux asks how it compared with last month, and the answer usually sits in the ledger rather than in the plan. Most closes need both, and the same thresholds and the same “does it add up” test work for each. Flux analysis vs variance analysis covers where each one's answer lives.

The company and figures on this page are synthetic.


Budget vs actual covers the plan. The free flux template covers month over month. The CloseOps Flux & Variance System ($79) starts from your trial balance instead: confirm each account's classification and it builds the income statement and balance sheet flux statements, then ranks what to investigate.

Related: the budget vs actual tool, which runs this on your own numbers; flux analysis vs variance analysis; the price/volume/mix calculator; and why most flux commentary failures are arithmetic.

Found something wrong or missing? Tell me here — anonymous, thirty seconds.