Navigate to Products > Stocktakes, on the relevant stocktake, click the ellipsis and select Variance Report.

Note: Update the filters above if you want to run the report against historical stocktakes.

There are two report options

Option 1: Tick include uncounted products to see what stock will look like when you post the Stocktake with include uncounted ticked on Confirm 

Option 2: Leave unticked and this is what your stock will be when you Post Stocktake with include uncounted unticked on Confirm 

The report shows:

• Quantity before: Number of products in stock before the start of the stocktake.
• Valuation: Valuation of products in stock before the count.
• Allocated quantity: Number of products allocated in pending invoices or credits.
• Counted quantity: Number of products counted and entered into the batch count.
• Quantity after: Number of products after the stocktake.
• Valuation after: Valuation of all products after the stocktake.
• Variance quantity: The value of the missing or extra products.
• Variance latest cost: The value of the variance based on the Latest Cost of these items.

When the stocktake is updated with the batch counts, the product valuation is increased or decreased by the total latest cost variance amount. The product valuation report should be run immediately before the stocktake is updated to confirm what the financial result of updating the stocktake will be. That is, the product valuation before the stocktake plus the stocktake variance should equal the current product valuation.

Getting Gains and Losses / Variance data over a data range

To get this data, you will need to run the product transaction report by going to Products > More Options > Product Transactions. When entering in your required parameters, set the Transaction Type to Product Stocktake. The report will show all the variances in stock quantity.