Month·End·Close
← Month-End Close

Tools

Budget vs actual: which variances to explain, and whether the explanation adds up

Paste budget and actual by account. You get each line's variance in dollars and as a percent of budget, whether it's favorable or unfavorable, the lines that cross your thresholds with a plain sentence for each, and a check on whether your explanation adds up to the number.

Most budget vs actual templates stop at the variance column. The work starts after it: deciding which lines need explaining, and making sure the explanation accounts for the variance rather than describing it. This does both, and hands you a workbook where every figure is a formula.

Runs entirely in your browser. Nothing you paste is uploaded or stored; it stays in your browser.

Thresholds

“And” flags a line only when it crosses both; “or” flags it when it crosses either. See how many lines each setting would flag.

Budget and actual

One row per line, tab or comma separated: account, type, budget, actual. Type is revenue, expense, other+ (other income) or other- (other expense); it decides which way is favorable, so the tool never guesses it from the account name. Amounts as they appear on a budget report, usually positive. A header row is fine.

How it's calculated

StepRule
VarianceActual minus budget, in exact cents.
% of budgetVariance divided by the budget (as a positive number), shown to one decimal. A line with a zero budget shows n/a.
Favorable or unfavorableFavorable when the variance helps net income: revenue or other income above budget, an expense or other expense below it.
FlagThe variance is more than your dollar threshold and (or, if you choose) more than your percent of budget. A zero-budget line with any variance passes the percent test.
Net incomeRevenue less expenses plus other income less other expense, for budget and actual. The net income variance equals the sum of every line's effect.

Favorable and unfavorable, line by line

A positive variance isn't automatically good. Revenue $48,200 above budget is favorable; cost of goods sold $27,500 above budget is unfavorable, even though both are “over.” That's why each line carries a type. The tool doesn't read it from the account name, because names don't settle it: a contra-revenue line, a rebate, other income booked in the 7000s. You say which way each line runs, and the tool applies it the same way every time.

Which lines to explain

Two thresholds, one in dollars and one in percent, with a rule for combining them. “And” is the default because it keeps the queue to what matters on both counts: in the worked example, software subscriptions are 24.2% over budget but only $2,300, and they don't make the list at $5,000 and 5%. Switch to “or” and they do. Neither is right in general; it's a policy choice, and the useful thing is to write it down and use it every month. Flux thresholds shows how many lines each setting would flag on your own numbers.

A line with no budget and any actual spend passes the percent test, since any amount is an infinite percentage of zero. Whether it's flagged then depends on the dollar threshold.

An explanation that adds up

Each flagged line gets a sentence built from the numbers: “5100 Freight in: $7,400 (35.2%) over budget, unfavorable.” That's the what. The why is yours, and that's where explanations usually go wrong: a cause that's true but accounts for a third of the variance. Open “Explain it” under any flagged line, enter the drivers with their amounts, and the tool shows how much of the variance they cover and what's left unexplained. It's the same test as the commentary test, applied to budget variances. For a revenue line, the price/volume/mix calculator splits the variance into the drivers for you.

Budget variance and flux are different questions

Budget vs actual asks how the month compared with the plan. Flux analysis asks how it compared with last month, and the answer usually lives in the ledger rather than in the plan. Most closes need both, and the same thresholds and coverage test work for each.

What it doesn't do

It doesn't judge the budget, assign account types, or decide whether a line under your thresholds still deserves a word. It doesn't find causes: the sentence states the variance, and the drivers are yours. It doesn't post or store anything.

The company and figures in the worked example 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: budget vs actual variance analysis, with a worked example; flux analysis vs variance analysis; the price/volume/mix calculator, for revenue lines; flux thresholds; and the commentary test.

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