Stock Variance Reporting

Variance reporting is where stocktakes pay for themselves. StockLens AI shows you, per product and per category, the difference between what your tills said you sold and what your stocktake actually counted.

What variance reporting reveals

Most bars run somewhere between 2% and 8% beverage variance. Over a year that is tens of thousands of pounds lost to over-pouring, breakage, theft or untracked transfers. Surfacing the problem is the first step to closing it.

How StockLens calculates variance

Opening stock + purchases − closing stock = actual usage. Sales × recipes = theoretical usage. The gap is your variance. StockLens calculates this automatically and shows it per product, per category and per venue.

Drilling into the numbers

You can filter variance by category, supplier, venue and date range. Persistent offenders are flagged automatically. Click into any product to see the underlying counts, sales and purchases that drove the number.

  • Variance in units, pounds and percent
  • Per-product, per-category, per-venue views
  • Persistent outlier flagging
  • Drill-through to source data

Frequently asked questions

  • Industry benchmarks suggest under 2% for spirits, under 5% for beer and under 4% for wine. StockLens flags anything above your chosen threshold.

Related

Ready to modernise your stock takes?

Start a 14-day free trial and see how StockLens AI can cut your stocktake time from hours to minutes.