Gross Profit Report

The GP Report contains comprehensive information on your products and should be checked thoroughly at the end of every period. Please note that to view the report, the respective period needs to be closed.

• Use the drop-down menus to select the Section & the period start and end dates.
• If you wish to compare reports, tick the check box and select the comparable period’s start and end dates.
• A table displaying the following information will be displayed against the categories & groups in your chosen section:
  • Op Stock – opening stock of that group.
  • Purchase– the amount of stock that has been delivered.
  • Adj – the amount of stock that has been adjusted.
  • Clo Stock – closing stock of that product.
  • Cost of Sales – the amount of stock that was sold.
  • EPOS Sales – money value of sales taken from EPoS.
  • Actual GP – money value of gross profit from those sales.
  • Actual GP % - gross profit as a percentage of the cost.
  • Theo Sales – money value of sales based on recipes.
  • Theo GP – theoretical gross profit taken from theoretical sales.
  • Theo GP % - theoretical gross profit as a percentage of the cost.
  • Var% – the variance between Actual GP % and Theo GP %.
• Some of the data is clickable(underlined numbers) and will bring up further information.
• Op Stock values will bring up a table detailing:
  • Product – the name of the product.
  • Pack-Size – size that the product comes packaged in.
  • Cost/Unit – the cost per unit of that product.
  • Actual Qty – quantity of that product.
  • Actual Unit – the unit counted for that product.
  • Amount (£/$/€/¥) – currency value of that stock.
• Purchase will give you a table with the following information:
  • Product – the name of the product.
  • Pack-Size – size that the product comes packaged in.
  • Current Price – the price at which the product was delivered.
  • Purchase Qty – amount delivered.
  • Purchase Unit – package size the product was purchased in.
  • Amount (£/$/€/¥) – currency value of that delivery.Clicking on the Amount will bring up a new table showing delivery information:
  • Supplier – the name of the supplier who delivered the product.
  • Date – date at which the delivery was received.
  • Reference – the delivery note/invoice number associated with that delivery.
  • Qty – the amount of product that was delivered.
  • Price – the cost of the product in that delivery.
  • Amount – the value of the product delivered.
  • Approved by – the user who approved that delivery.

            Click the back link to return to the previous screen.

• Adj will deliver a table with:
  • Adjust Type – reason for the adjustment.
  • Product – the name of the product.
  • Pack-Size – the size that the product comes packaged in.
  • Count Qty – quantity of the product adjusted.
  • Count Unit – the package size the adjustment was counted in.
  • Amount (£/$/€/¥) – currency value of that adjustment.

• Clo Stock will display a table of the following information:
  • Product – the name of the product.
  • Pack-Size – the size that the product comes packaged in.
  • Cost/Unit – the cost per unit of that product.
  • Actual Qty – quantity of that product.
  • Actual Unit – the unit counted for that product.
  • Amount (£/$/€/¥) – currency value of that stock.
• For Cost of Sales the table will show:
  • Product – the name of the product.
  • Op Stock – opening stock of the product.
  • Inwards – the amount of stock delivered.
  • Adj – the amount of stock adjusted.
  • Clo Stock – closing stock of the product.
  • Cost of Sales – the amount of stock assumed to be sold as it has not been accounted for.
• EPOS Sales has a table displaying:
  • Product – the name of the product.
  • Pack-Size – the size that the product comes packaged in.
  • Theo Quantity – theoretical quantity of the product sold.
  • Theo Unit - the unit of measurement for the theoretical quantity.
  • Theo Cost of Sales – cost to you of the products theoretically sold.
  • Prop Sales Amount (£/$/€/¥) – currency value of sales.
• Actual GP will display a table showing:
  • Product – the name of the product.
  • Op Stock – opening stock of the product.
  • Inwards – the amount of stock delivered.
  • Adj – the amount of stock adjusted.
  • Clo Stock – closing stock of the product.
  • Cost of Sales – the cost of products sold.
  • Actual Sales – sales amount reported from EPoS.
  • Actual GP – gross profit of sales (Actual Sales – Cost)
  • Actual GP % - gross profit of sales as a percentage of the cost. Clicking on the amount under Actual GP will bring up further information. Sales dates and amounts for that product are on the top; opening stock, delivery details, and a list of adjustments are on the bottom. Click on Back to return to the previous screen.
• At any time click on Report Options to change section, period, or comparable report.
• If you would like to view the information in a .CSV format, click on Export Report.
• Clicking Printable View will show you an easy-to-read page for printing.

Please speak to the STO Support Team for any doubts.