After your sales have been integrated, and your POS mapping is more than 80% complete, the next time you submit an inventory, you'll receive a PDF detailing your variances. 

The variance summary report is sent to each user that has been designated as a recipient. It can also be viewed on the Web Portal.

Learn how to manage your email notifications permissions here.

Variance Report

There are two sections of the variance report:

  1. Summary by Family and Category
  2. Individual Item Variances

Summary by Family and Category

This section provides a high-level summary for each family (Beer, Liquor, Wine, etc) and category, displaying:

  • Variance Cost 
  • Sales
  • Cost (of Goods Sold)
  • Variance Retail
  • Beverage Cost

Individual Item Variances

This page provides more detailed information for each item in your venue:

  • Beginning Inventory (Bottles)
  • Movements (Bottles) - this includes any deliveries, returns etc.
  • Ending Inventory (Bottles)
  • Consumed (Bottles)
  • Sold (Bottles)
  • Variance (Bottles and Oz)
  • Variance Cost
  • Variance Retail
  • Beverage Cost

Interpreting the Data

If you see any items where the value in the Variance (bottles) column displays in red text, this indicates a loss. 

In the example above for the Belvedere 750ml, it says 32.1 bottles were sold, but 48.2 bottles were consumed.  This indicates a loss of 16 bottles, which amounts to $679.22 at Variance Cost, and could've theoretically sold for $2665.78 (Variance Retail).

Whenever looking at a variance, it will always come down to one of two cases:

  1. Consumption is greater than sales (a loss)
  2. Sales is greater than consumption (a surplus)

As a result, you want to check that the consumption and sales are accurate.

Consumption

As a reminder, Consumption = Beginning Inventory (Bottles) + Movements (Bottles) - Ending Inventory (Bottles). 

If either inventory count is inaccurate, or you have missed or made an error on a delivery, that will impact the consumption.

Sales

When checking sales, you'll want to make sure that the item is mapped to all POS Items it is sold in, the serving size is correct, and that there isn't any missing sales data.

The long term goal is to try and get your sales and consumption as close to equal as possible.

For more information about investigating your variance, please see the Variance section of the help site.

Did this answer your question?