See how a plan compares with what actually sold: month by month, for this year so far or against last year, with the differences that matter shaded.
Anyone who can open a plan can compare it. Setting the month the books are closed through is the Owner's job.
Before you start
- Actuals for the year you want to compare must be imported (see Import your sales lines).
- To compare this year so far, the Owner sets Books closed through in Settings (for example, October 2026), once the month's figures are final. Without it, every month is compared, including months not yet closed, and those show large shortfalls that aren't real.
- To measure the year against a fixed plan, the Owner approves it first (see Approve a plan). Without an approval, the comparison uses the plan as it stands, and it moves whenever someone edits it.
Steps
Open Plans and open the plan.
In the toolbar, choose Compare with:
- FYxxxx actuals (this plan's year): how the year is going against the plan.
- FYxxxx actuals (last year): what the plan asks for compared with last year, read as growth (see Against last year: growth below).
You should see a line under the toolbar saying what is compared, for example Year to date, through Jun 2026, and the heading of the last column change to YTD when comparing this plan's own year.
Comparing with last year while that year is still in progress (for example a FY2027 plan against FY2026 actuals that run to October) counts only the months that year has actuals for: the line reads Compared month by month with FY2026, January–October, the last column becomes Jan–Oct, and November and December show — until their actuals are imported. Months that haven't happened yet are never read as nothing sold.
Check Plan side. For an approved plan it shows the baseline, for example Approved 13 Nov 2026 (baseline): the year is measured against the plan as approved. Choose Working plan, as edited now to see how the year compares with today's version instead.
Choose what the cells show: Plan, Actual, Variance (actual minus plan) or Var % (variance as a percentage of plan).
You should see cells shaded green where actuals are above plan and red where they're below, by more than 5%. Darker shading means 20% or more. For Cost per unit the colours turn: cost above plan is red, cost below plan green.
Use Show to switch between Quantity, Revenue and Price per unit, and Group by to look by vendor, brand or category, as usual. Expand a row to find the items behind a difference.
To see what drove a difference, click Explain in the panel on the right (see Explain why actuals differ from the plan).
To see only the surprises, set Rows to New and dropped items only.
You should see items tagged New (sold in the compared months, but not planned for them) and Dropped (planned, but nothing sold). Items added after the plan was made appear as New, so every sale counts in the totals.
Against last year: growth
Comparing with last year answers a different question: what the plan asks for, not how the year is going. So it reads the way a finance team expects growth to read:
- The buttons become Plan, FY2026 (last year's actuals), Change and Change %.
- Change is plan minus last year: +2,500 means the plan asks for 2,500 more than last year sold. Change % is that as a percentage of last year.
- Growth is shaded green and a decline red, beyond 5%. For Cost per unit, a higher planned cost is red.
- Explain reads the same way, for example Planned revenue is 466,702 above FY2026: more units are planned, with FY2026, Plan and Change in its table.
Reading the numbers
- Variance is actual minus plan: a negative number means less sold than planned.
- Price per unit for actuals is the average selling price: revenue divided by quantity sold.
- Gross margin for actuals is revenue minus the cost of goods sold on the imported lines, and Cost per unit is that cost divided by quantity sold. The plan's margin uses its own cost rates (the items' standard cost unless changed).
- YTD adds up only the closed months, for both plan and actual, so the two are always like for like.
- — means there's no meaningful figure: quantities in different units can't be added together, a month isn't closed yet, or (for revenue) the import had no amount column.
Common mistakes
- Comparing this year without setting the closed month. Months that haven't happened yet show actual zero against the plan, so the year looks far behind. Ask the Owner to set Books closed through.
- Margin and cost per unit show —. The actuals were imported without a cost column. Import the sales lines again with Cost amount mapped (see Import your sales lines); each month is replaced, so nothing is counted twice.
- Comparing against a plan someone is still editing. Without an approval, every edit moves the comparison. Ask the Owner to approve the plan, then compare against the baseline.
- Trying to change a New item. Items that aren't in the plan can't be changed from the comparison: they are shown so their sales count. Changes apply to the plan's own items only.