Business Need: This report is helpful for users who want a report to show their top selling items for a period of time.
How it Works: A Sales>Top By Item report shows a summary of top selling items over a period of time. The number of top items can be customized. There is also a customizable ‘By Sales Column’ which a user can set to further define how ‘top items’ are displayed for example quantity sold, or retail price, etc.
Generating the Report:
Go to the Standard Reports section in Yellow Dog:
- Select Standard Reports
- Open the folder titled ‘Sales’
- Select ‘Top By Item’
- Select the date range that you would like to run the report for and choose any filters that you would like to add
- Select the number of ‘top’ selling items that you would like to view in your report
- Select the ‘By Sales Column’ for your report. This column must be selected for the report to generate.
- Generate report
Reading the Report:
- Shows the filters used to produce the report’s data, including the date selected for the report.
- Change columns, sorting, and grouping: This allows users to add or remove data columns to this report as well as organize and group the data.
- Store Name: Shows the store that the sales were captured from.
- Level: Shows the level that this item is assigned to in Yellow Dog.
- Vendor: Shows the vendor that this item is assigned to in Yellow Dog.
- SKU: Shows this items Yellow Dog SKU number.
- Item: Shows the description for the item.
- Quantity Sold: Shows the total quantity sold for this item in the selected date range.
- Total Cost: Shows the total cost for the quantity sold in this period (Quantity Sold x Calculated Cost at the time of sale).
- Total Retail: Show the total retail for the items sold, prior to any discounts that may have been applied. (Quantity Sold x Item Retail)
- Total Discount: Shows the total amount discounted for the item sold in this period (Quantity Sold x Item Discount as recorded on the sales ticket).
- Net Retail: Shows the total retail price after any discounts applied to the sales for this item during this period (Total Retail – Total Discount).
- This row allows you to save, export, print, or close the current report.