The detailed variance take report focuses on the movement of each product in the period. Please use the descriptions below and the sample report above to understand this report.

The columns in this report are as follows:

• Product – this column is broken down into separate categories, then lists the product names in each category alphabetically.
• UoM/(Sub Unit) – UoM stands for Unit of Measurement. This column identifies how each product is counted, including any sub units such as tenths.
• Variance – the next 3 columns describe the result of the stock take in comparison to the expected stock holding – essentially how much you are up or down on a product. It’s shown in these 3 ways;
  • Qty – quantity, or the simple count variance. A positive figure means you have more in stock than the system expected, a negative figure means there’s stock missing.
  • @ Retail £ – this is a financial representation of the amount of stock missing or in surplus, based on the average price the product sold for in this stock period.
  • @ Cost £ – this figure shows the amount of money the missing stock cost, or surplus stock saved, at the average purchase price for the product in the period.
• Computed Sales – this section of the report represents the overall movement of each product in the period, taking into account opening stock, adding any deliveries, subtracting returns and wastage and then the closing stock figure to provide the net result. It does not necessarily match the till sales, rather it represents the actual movement in the period. Any variance reported is in effect the difference between Computed Sales and Till Sales. As with variance, there are 3 columns;
  • Qty – this is the quantity of movement in each product in the period, again expressed in terms of the UoM and any sub units.
  • @ Retail £ – this is the theoretical revenue that would have been earned had the quantity moved in the period been sold at the standard sale price.
  • @ Cost £ – again, this is a theoretical figure showing what the cost would have been of the volume moved in the period at the current default cost price.
• Stock Prices – this section shows the calculated values in the period for cost and retail price for the default sale item for each product. For example, draught beers will show the figures for a Pint, spirits a Single etc.
  • Cost Price £ – this figure is the cost of each unit of the default sale item derived from purchases used in the period. If no sales were recorded, or if no deliveries have been recorded, the default theoretical sale price is used.
  • Av. Retail Price £ – this is the average retail price of the default sale item sales in the stock period. Again, if no sales were recorded in the period then the standard price will be shown.
• Stock Inputs – this section of the report details all non-sales related movement of stock in the period. Its columns, all of which are expressed in terms of the UOM, are as follows;
  • Opening Stock – this is the quantity of each product that was recorded as being in stock at the start of the period, in other words the closing stock from the previous stock take.
  • Delivery In – this is the volume of the product recorded as having been received in deliveries during the stock period.
  • Wastage – this is the quantity of the product that’s been recorded as having been wasted in the period, either on the till or in the back office program.
  • Returns – this is the volume of stock returned to suppliers unused in the period.
  • Closing Stock – this column shows the quantity of each product recorded as being in stock at the time of the closing stock take.