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****Varianc****e****@ 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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Feedback sent

We appreciate your effort and will try to fix the article