AvklarePlan Help Sign in Start a free trial

Help ›

Compare a plan with actuals

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

Steps

  1. Open Plans and open the plan.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. To see what drove a difference, click Explain in the panel on the right (see Explain why actuals differ from the plan).

  7. 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:

Reading the numbers

Common mistakes

All guides

An unhandled error has occurred. Reload 🗙