The stocktake variances report

After you have submitted a stocktake, you can use the Variances tab of the stock report to view the products that have the highest variances, focussing on either negative, positive or absolute variances.

Note: The Variances tab will only display products that have a variance.

To view your variances, locate the required Stock Report from Stock > Stocktakes from the left hand navigation.

From the Stock report, locate the stocktake you would like to view variances for & click on the teal Stock report icon at the end of the stocktake row.

From the top of the Stock report screen, select the Variances tab.

You will see a list of all of the products from the stocktake that have a variance, in order from the largest absolute variance @ cost to the smallest.

For each product you can see:

• Product name - Including the measurement & order units, as well as the reporting category
• Variance - The difference between the number of order units expected by the system and the actual number declared on the stocktake
• Variance @ cost - The cost of any variance
• Variance @ retail (net) - Shows the cost of variances at retail price. Where a product can be sold at difference prices (e.g. a wine that is sold more per ml for a small glass than a bottle) the highest sale price will be used for calculating the variance@retail
• GP% variance - The difference between the potential GP and the actual GP achieved (Shown on the summary section of the stock report)

Sort By:

You can also change the order in which the products are sorted by:

• Absolute variance @ cost (descending) - largest absolute variance @ cost to smallest absolute variance @ cost. Enables you to focus on the largest variances regardless of whether they are positive or negative.
• Absolute variance @ cost (ascending) - smallest absolute variance @ cost to largest absolute variance @ cost
• Absolute variance @ retail (descending) - largest absolute variance @ retail to smallest absolute variance @ retail. Enables you to focus on the largest variances regardless of whether they are positive or negative.
• Absolute variance @ retail (ascending) - smallest absolute variance @ retail to largest absolute variance @ retail
  
• Absolute variance (descending) - largest absolute variance (units) to smallest absolute variance. Enables you to focus on the largest variances regardless of whether they are positive or negative.
• Absolute variance (ascending) - smallest absolute variance (units) to largest absolute variance
• Variance (descending) - Positive variance to negative variance
• Variance (ascending) - Negative variance to positive variance
• Variance @ cost (descending) - Positive value to negative value
• Variance @ cost (ascending) - Negative value - positive value
• Variance @ retail (descending) - Positive value to negative value
• Variance @ retail (ascending) - Negative value to positive value
• GP Variance (descending) - Positive % to negative %
• GP Variance (ascending) - Negative % to Positive %

Totals

The Totals boxes at the top of the report show the total variances for the stock report.

• Total variance @ cost - The total cost of all variances for the chosen stock report
• Total variance @ retail (net) - The total retail value in net of all variances for the chosen stock report