See what drove the difference between plan and actual for any row: more or fewer units (volume), a shift toward cheaper or dearer items (mix), different selling prices (price), and different costs (cost). It answers questions like "revenue is down although quantity is up: why?"
Anyone who can open a plan can use it.
Before you start
- Compare the plan with actuals first (see Compare a plan with actuals). For this year so far, the Owner sets Books closed through in Settings.
- For the margin column, the actuals need their cost (see Import your sales lines, the Cost amount column).
Steps
Open the plan and choose Compare with an actuals year.
In the panel on the right, click Explain.
You should see Why it differs for the Whole plan, the months compared (for example Year to date, through Oct 2026), and whether the plan side is the approved baseline or the plan as it stands.
Read the sentence at the top. It names the biggest reason, for example Revenue is 600 below plan although quantity is 10 above: the mix shifted toward lower-priced items (−900).
Read the table. For Revenue and Margin it shows the plan, the actual and the variance, then the parts that make up the variance:
- Volume: more or fewer units in total, valued at the plan's average price (or margin) per unit for the row;
- Mix: the shares of the row's items changed, toward cheaper or dearer ones;
- Price: items sold above or below their plan price;
- Cost (margin only): items cost more or less than planned.
The parts always add up to the variance.
Click a row in the grid (a vendor, a brand, an item) to explain just that row. Click it again to go back to the whole plan.
See the parts across the grid
To see which rows and months drive a part, show it in every cell:
While comparing, set Show to Revenue or Gross margin.
Next to Plan · Actual · Variance · Var %, click Volume, Mix or Price, or Cost for margin.
You should see each cell's share of its variance from that part, for example +1,200 under Volume for a brand that sold more than planned. Cells beyond ±5% of their plan are shaded, as for the variance. A cell's Volume, Mix, Price and Cost add up to its Variance.
The parts explain money, so the buttons don't appear for quantity, price per unit or cost per unit.
Reading the parts
- Volume and mix in one line. When a row's items are counted in different units (cases and kegs) without an equivalent factor, units can't be added together, so volume and mix can't be told apart. The table shows them combined.
- Items that weren't planned are valued at the price they sold for, so their sales count as volume and mix, not as a price effect.
- A shift between months counts as mix. Each item and month is one part of the sum: selling more in a cheaper month moves the mix too.
- — in a cell: that part can't be worked out. The actuals have no amounts (revenue) or no cost (margin).
Common mistakes
- Mix shows — in the grid. The row's items are in different units without an equivalent factor, so mix can't be told apart from volume: Volume shows both.
- Expecting Explain without a comparison. The tab appears only while the grid compares with actuals.
- Reading a whole-year comparison mid-year. Without Books closed through, months not yet closed count as zero sales, and volume looks far below plan. Ask the Owner to set the closed month.
- A large price effect on a plan seeded from list prices. If the plan's prices are list prices and the sales carry discounts, the discounts show as a negative price effect. That's real: it's the gap between list price and what customers paid.