The Stock Category Summary provides a high-level view of the financial aspects of a stock period and its movements. No individual product data is provided in this report, rather all the products within each category are combined to provide a single figure for the category. Please use the descriptions below and the sample report above to understand this report.

The columns in this report are as follows:

• Stock Category Summary – this column lists the category names in the stock family in question.
• Variance – the next 2 columns describe the result of the stock take in comparison to the expected stock holding. It’s shown in these 2 ways;
  • @ Retail £ – this is a financial representation of the amount of stock missing or in surplus, based on the average prices the products in each category 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 products in the category in the period.
• Stock Management – this section of the report focuses on the return generated in the period for each category. Its columns are as follows;
  • Yield % – this figure is a percentage indicating what proportion of the anticipated revenue for each category was actually received in the period. We take the average retail price for the period, then calculate the expected revenue by multiplying that by the computed sales quantity. The yield is then calculated as the till revenue ÷ expected revenue. As such, there’s a direct correlation between variance and yield – zero variance will generate 100% yield. If the computed revenue is negative (i.e. stock lost in the period without explanation such as wastage) but actual revenue is positive, yield will be a negative percentage.
  • Gross Margin £ – this is the gross profit for the category in the period. It’s calculated by taking the cost of all the products used in the period (including any variance), netting the VAT from the overall revenue for the category and then taking the former away from the latter.
  • Gross Margin % – this figure is generated by taking the gross profit total and dividing it by the overall net revenue to give a percentage.
  • SOH @ Cost £ – SOH stands for Stock On Hand. This figure represents the purchase cost of the combined closing stock figures for each product in the category.
• Till Sales – this section of the report highlights the sales activity for the category in the period. The columns here are;
  • @ Retail £ – this is the revenue received in the period for the category. Where products are sold exclusively individually, such as bottled beers, these figures will map directly to sale item sales reports but for products such as spirits and mixers, where two or more products are sold together, revenue is calculated based on the proportions generated by the cost prices. For example, if a vodka and coke is sold for £5, and the vodka costs 80p and the coke 20p, £4 of the revenue will be allocated to the vodka and £1 to the coke (80p of a total cost of £1 = 80%). The same vodka, when sold with a tonic water costing 60p (80p out of a total of £1.40 = 57%), would only be allocated £2.86 of the £5. Revenue shown here includes any stock that was on live tabs at the time of the previous stock take which has subsequently been paid for, but the quantity will not be included since it will have been shown on the previous stock take.
  • @ Cost £ – this figure represents the combined total cost of the volume of each product in the category sold through the till in the period, and is based on actual FIFO (first in, first out) cost calculation.
• Computed Sales – this section of the report represents the total overall movement of each product in the category 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;
  • @ 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 Inputs – this section of the report details the 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 Cost £ – this is the total value of each product in the category 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 Cost £ – this is the cost of all deliveries of products in the category recorded as having been received during the stock period.
  • Wastage Cost £ – this is the combined cost of all products in the category that were been recorded as having been wasted in the period, either on the till or in the back office program.
  • Returns Cost £ – this is the cost of stock in the category returned to suppliers unused in the period.
  • Closing Stock Cost £ – this column shows the value at purchase price of all products in the category recorded as being in stock at the time of the closing stock take.

Each column in the Stock Category Summary report is totalled at the foot of the report. This total row, up to and including the Computed Sales but not the Stock Inputs, is replicated in the Stock Summary report;