End-of-year offer Planner for the price of Reporter for two years, set up for you during a free 30-day trial. Ten places, start by 31 January.
Product · Report the month

The number explains itself.

A number moved and someone wants to know why. Compare any two versions, see which lines drove the change, and drill down until you reach the rows that caused it.

Book a demoStart free

Where's the gap? A column against last year, traffic lights on every line, then why it changed.

Net sales price, volume and mix variance: a one million favourable change bridged through units, price and mix effects
Price, volume, mix

Net sales up a million.
Here is what did it.

Pick two periods or two versions and the bridge splits the change into units, price and mix, with a written summary and the biggest movers underneath.

  • 01Effects bridge from one figure to the other
  • 02Units, price per unit and mix effects, each with its share
  • 03A plain-English summary of what drove the change
  • 04Top movers and headwinds by product, customer or branch
The price, volume and mix variance exported to Excel: the headline figures, the bridge table and a waterfall chart from last September to this September, with sheets for branch, product, customer and top contributors
Export to Excel

The bridge lands in Excel
as a waterfall.

Export a variance and the workbook opens on a real Excel waterfall chart, every bar labelled, favourable steps green and adverse ones red. The figures sit above it, with a sheet for each breakdown behind.

  • 01A native Excel chart, not a picture: restyle it or paste it into your pack
  • 02Coloured the way the variance reads: a cost going up is red
  • 03A sheet per breakdown, and the top contributors
  • 04Prints landscape, one page wide
Why this number? on net sales: gross sales minus discounts, the slice it covers and a button to show the rows used
Show rows used
Rows used for net sales: each branch, customer and product with its gross sales, discounts and result, totalling 17,167,429.78 over 49,087 rows

The formula broken down into its parts, row by row: Gross sales − Discounts = Result. Each part totals to the figure in the popover.

Why this number?

Every calculated figure
shows its working.

Right-click a number and see the formula, the values it adds up and the slice it covers. One more click lists the rows behind it, each with its parts and its result, adding up to the number you started from.

  • 01The formula and each input's value
  • 02The branches, customers and products in the slice
  • 03How many stored cells it read, and when
  • 04Every row used, with the formula broken into its parts
What you get

From "it moved" to "here's why".

01

Any two versions

Actual against Budget, Forecast or last year, at every level of every hierarchy.

02

Price, volume and mix

Split a revenue or cost change into rate, quantity and mix effects.

03

Bridges

See which lines took you from the baseline to the actual, and click any step to rank what is under it.

04

New, gone, moved

Match rows on a key to show new hires, leavers, moves and raises as their own bridge steps.

05

Materiality

Set what counts as a material change, so the report shows the lines that matter.

06

An AI summary

Abigail writes the explanation from the numbers, and you edit it before it goes out.

Ask why a number is what it is.

Where does it come from?

Build a calculated line with a lookup to a file, right in the report. Then ask why a number is what it is.

Dynamic drilling

Down a region to the branch, across to the product, and back, on a production-sized report that reshapes as you go.

See a variance explain itself.

Book a demo and we'll take a month's variance from the total down to the rows that caused it.

Book a demo Start free