Skip to content

How do I calculate loss (variance)?

Variance is the difference between what you used (usage) and what you sold (volume sold).

Usage = beginning inventory + purchases - ending inventory
Variance = volume sold - usage
Example: 50 shots sold - 60 shots used = 10 shots worth of loss

You can identify and calculate loss in your web portal in two different ways.

Option 1) We recommend taking a top down approach. Start by looking at your usage for overall beer, liquor, and wine.  Then look at usage by spirit type, such as vodka, whiskey, rum, etc.

You can view this usage in your Analytics page.

Use the filters to select the date range and products you want to view.

TIP: Change 'Units' in your filter to shots or ounces to compare more easily to your total drinks sold! Partender 'Shots' are 1.5 ounces.

Simply run a P-Mix report from your POS system for the same time period, and compare how much you sold against how much you actually poured out.

EXAMPLE:  You have a 1.25 pour size. Partender reports that you used 42.5 ounces of Ketel One. That's 34 drinks. Your P-Mix report shows that 29 drinks were sold. You've just identified a loss of 5 drinks!

Option 2) 
Export a Usage Report of every product you carry in your venue. We will show you your Actual Usage, give you a column to type in what you sold, and then calculate your actual variance.

You can export a Usage Report from your Reports page.

TIP: Change Units to shots or ounces to analyze your liquor and draft beer, and change Units to bottles to analyze your bottled beer.

Contact our Support Team for questions or assistance.
888-787-4228 ext. 2
Schedule a quick training session

Feedback and Knowledge Base