Skip to main content
All CollectionsInventory reporting
Identifying and Fixing Common Stock Variance Issues
Identifying and Fixing Common Stock Variance Issues

A guide to understanding missing sales, deliveries, miscounts, and incorrect recipes in your stock reconciliation report.

Sara Cicatiello avatar
Written by Sara Cicatiello
Updated over 3 weeks ago

Stock variances can be frustrating, but they often point to specific issues that can be identified and resolved. Whether itโ€™s missing sales, unrecorded deliveries, miscounts, or incorrect recipes, understanding the root cause is key to maintaining accurate inventory records.

In this guide, weโ€™ll walk through the most common (and simple to fix) stock variance issues:

  • Missing sales

  • Missing deliveries

  • Miscounts

  • Incorrect Recipes

Missing sales

In the screenshot below there is a variance of -3.21 cases of Diet Coke. The stock was counted correctly but there were not sale of the item connected to a recipe in Nory, this is shown in the column POS sales.

Missing deliveries

In the screenshot below Diet Coke is up 2 cases. The closing count is correct, but there are no deliveries of this product. 2 cases were delivered but the received on date was not within the stock period.

๐Ÿ’กThe same process could be followed for missing waste entries and transfers that have not been completed.

Miscounts

In the screenshot below there is a variance of -3.84 cases of Diet Coke the closing count looks low.

When the count was reviewed it looks as though the cases were counted in the line for each creating the variance.

Incorrect Recipes

In the screenshot below there is a positive variance of 16 loaves of gluten-free bread.

The deliveries are correct and the closing count has been checked. In the POS sales column, it shows that 18 loaves have been sold in the week. The team know this is not correct as they sell very few gluten-free options.

When looking at the item setup it was found that the loaves were set up as 1 each.

โ— Permission to edit inventory items is needed to access the inventory set up.

๐Ÿ“– Learn more about Permissions in Nory

The recipe for gluten-free bread was for 2 each, assuming 2 slices of bread would be deleted. Instead two loaves were being deducted per order.

To rectify this problem the item was updated to 10 each (10 slices of bread per loaf).

Did this answer your question?