Sales revenue variance is actual sales revenue minus the amount in your budget. Finish this exercise with a single-product price and quantity bridge that reconciles exactly, plus an evidence question to investigate next.
Updated: 29 October 2026.
What question does this revenue bridge answer?
A shop can sell fewer units than planned while nearly meeting its revenue budget. A higher realized price can offset part of the quantity shortfall. A useful first step is to separate those arithmetic effects without pretending to know why customers behaved differently. The result tells you which records to inspect, not which employee or campaign caused the outcome.
Keep the exercise to one product code, one unit of measure and one reporting period. Do not combine unrelated products into a single average price. A change in product mix can alter that average even when every individual price stays unchanged. Our worksheet deliberately avoids a multi-product mix analysis.
All inputs below are fictional teaching material created for this article. They are not an Anar client assignment, a shop experiment or a measured business improvement. The arithmetic and saved output were checked programmatically; no accounting platform or desktop user trial was operated. The profit margin guide addresses costs and earnings. This exercise only reconciles revenue.
Freeze four inputs and define their basis
Start with budget quantity, budget unit price, actual quantity and actual net sales revenue. Preserve the original approved budget rather than replacing it after seeing the outcome. A revised forecast can be useful, but it belongs in a separate comparison with its own version and date.
| Input | Fictional value | Definition |
|---|---|---|
| Budget quantity | 100 | Units of one product |
| Budget price | 20 | Currency units per product |
| Actual quantity | 90 | Same product and unit |
| Actual net revenue | 1,980 | Same period and revenue basis |
The example excludes tax, includes discounts already reflected in net revenue and has no returns. If your records include returns, verify how both quantity and revenue were adjusted before continuing. A refund relating to another period can make a simple current-period average misleading. Freight income should not enter the actual amount unless the budget includes it on the same basis.
The realized average price is 1,980 divided by 90, or 22. It is not necessarily the advertised list price. Keep the original revenue amount rather than reconstructing it from a rounded average. Customer receipts also do not define revenue: use the partial-payment matching worksheet for the separate job of connecting receipts to invoices.
Move from budget revenue to actual quantity first
Our declared convention changes quantity first while holding the budget price constant. Budget revenue is 100 times 20, or 2,000. Valuing the actual ninety units at the budget price produces 1,800. The difference, negative 200, is the quantity leg of this revenue bridge.
Budget revenue = 100 × 20 = 2000 Actual quantity at budget price = 90 × 20 = 1800 Quantity leg = (90 − 100) × 20 = −200
The minus sign means this leg reduces revenue relative to the chosen budget. It does not establish poor performance. An unrealistic budget, unavailable stock or a deliberate reduction in low-value orders could lead to a quantity shortfall. Each explanation requires evidence beyond these four numbers.
Label the measure precisely: quantity difference valued at budget selling price. Accounting materials also describe sales-volume profit and contribution variances, which use standard profit or contribution per unit. Those are different measures. We use selling price because our endpoint is revenue, not profit. Keeping the label clear prevents a plausible formula from answering the wrong management question.
Calculate the price leg and reconcile both routes
The second step moves from the intermediate 1,800 to actual revenue of 1,980. The price leg is therefore positive 180. Where actual quantity is positive, the equivalent calculation is realized price minus budget price, multiplied by actual quantity: (22−20)×90. ACCA explains the actual-quantity basis of a sales-price variance; the International BSF lesson sets out the revenue-based price and quantity formulas.
| Stage | Change | Running revenue |
|---|---|---|
| Original budget | 2000 | |
| Quantity leg | -200 | 1800 |
| Price leg | 180 | 1980 |
| Actual less budget | -20 | 1980 |
The final row is a check, not a third adjustment. Negative 200 plus positive 180 equals negative 20. Independently, 1,980 minus 2,000 also equals negative 20. Both routes must agree before you interpret anything. If they do not, inspect signs, units and the input cells instead of adding an unexplained balancing item.
Revenue is one percent below budget in this example. That percentage is optional context, not the basis for allocating the two legs. Nor does the positive price leg establish improved earnings. Costs are absent. Payment timing is absent too; maintain a separate cash-flow review before drawing conclusions about the bank balance.
Why can another valid convention produce different legs?
Price and quantity both changed, so their interaction needs an allocation convention. Our quantity-first route places that interaction in the price leg by using actual quantity. Another route changes price first: 100×22 gives 2,200, then 90×22 gives 1,980. That route has a positive 200 price leg and a negative 220 quantity leg. Its total remains negative 20.
Never combine a leg from each route. Taking positive 200 from the second route and negative 200 from the first would incorrectly report no revenue difference. State your convention in the worksheet header and keep it consistent when comparing reporting periods. If you change it, preserve both versions and explain the break in comparability.
Neither route uniquely proves economic causation. It is a complete arithmetic allocation of the observed difference. Determining whether a price increase reduced demand requires additional evidence about offers, customers, timing and alternatives. Likewise, the customer concentration worksheet examines dependence on buyers, not the price and quantity components of this budget comparison.
Stop rather than invent a missing or invalid input
If actual quantity and actual revenue are both zero, do not calculate realized average price. The quantity leg is (0−100)×20, or negative 2,000. The price leg can be calculated directly as actual revenue minus actual quantity at budget price: zero minus zero, or zero. The bridge reconciles, but the realized price is undefined rather than zero.
A positive actual revenue with zero actual units is outside this simple product model and needs investigation. A zero budget quantity makes budget revenue zero. A money difference can still be shown if the budget price is genuinely supplied, but percentage change against zero budget revenue is not defined. An absent budget price cannot be invented just to complete the bridge.
Missing fields, negative quantities, incompatible currencies, different product codes and changed units are stop conditions. Returns and unusual adjustments may need an extended model. Keep them visible rather than clipping negative values or quietly excluding difficult rows. Calculate using the original precision and round only for presentation. Save corrections separately from the source snapshot so another reviewer can reproduce what changed.
Save a worksheet another person can reproduce
On Windows, search Start for Notepad and create a blank document. Search Start for Calculator and open it separately. Copy the scope, four inputs, intermediate amount, two legs and independent check. The editor records the work; it does not execute the formulas. Fifteen minutes is a suggested planning window for these supplied inputs, not an observed completion-time claim.
Fictional V1; one product; one currency; quantity-first Budget:100 units ×20 =2000 Actual:90 units; net revenue1980; realized average22 Intermediate:90×20=1800 Quantity−200; price+180; total−20 Independent check:1980−2000=−20 Next evidence:confirm source of realized price and unit count
In Notepad, choose File → Save As, select Documents and save revenue-bridge-V1.txt. Choose a different version name if it already exists; do not overwrite another file. Close Notepad, open Documents in File Explorer and reopen that saved file. Locate the four inputs, the intermediate 1,800 and both negative-twenty checks. Put the zero-actual-quantity test in a separate V2 file without overwriting the base exercise.
Record one next action in the team decision log: for example, ask the reporting owner to verify the revenue adjustments and unit count. Keep the fictional label until you replace the inputs with verified business records. Completing the calculation does not authorize a price change or establish the cause of a sales movement.
Frequently asked questions
Does this bridge measure profit?
No. It reconciles budget and actual net sales revenue. Costs and earnings are outside the model.
Which price values the quantity difference?
This quantity-first convention uses budget selling price; the price leg uses actual quantity.
What is realized price when actual quantity is zero?
It is not calculated. Avoid division by zero and separately check that actual revenue is also zero.
Does the calculation prove why sales changed?
No. It is a declared arithmetic allocation. Causal explanations require additional evidence.
