About
The Stock Profit report is a theoretical report listing the best and
worst performers. It details the quantity sold, value of sales,
cost of sales and profits but it does not take into account any stock
losses the venue may have had as a result of discrepancies or wastage.
It will also only show items which have a sales value for the period
under review.
Getting the Report
The Stock Profit report can be found in two ways:
- Sysnet Toolbar
> Reports menu > Stock > Stock Profit
- Sysnet Toolbar
> Stock menu > Reports > Stock > Stock Profit
Filtering the Report
The report can be filtered by Location and Stock Group and data is available
by outers or inners with consolidated locations. Additional filtering
can be applied to the report for top/worst performers, quantity sold,
average sales, value sold and GP $ and %.
Hints on Reading the Report
- INV CODE
= the inventory code for the item
- DESCRIPTION
= the name for the stock item
- INNERS
= the stocktake unit description for the item
- TOTAL SOLD
= the total quantity of items sold (based on Inners or Outers as per
the report selection) for the period under review
- SALES $ EX TAX
= total retail value of items sold excluding tax
- EXPECTED COS
$ = Total Sold * Average Cost (based on Inners or Outers as
per the report selection)
- GM $ EX TAX
= Sales $ Ex Tax - Expected COS $ Ex Tax
- GM % EX TAX
= GM $ Ex Tax / Sales $ Ex Tax *100
What is the Stock Profit Report Useful For?
- Analysing stock group sales and cost of sales to
determine expected profits for the week or month
- Best and worst performing products, highlighting
items which may need to be promoted
- Illustrating sales and quantity values on one report
for all sales factors. It only shows information on items sold
- Monitoring GP% to highlight areas where pricing
needs to be addresses
- The report is presented by Stock item rather than
just PLU so it provides a higher level for analysis
