Reporting Explained: Sales Top By Item
Generate the report
-
Go to Reports > Standard Reports.
-
Select Retail > Sales.
-
Configure the required filters.
-
Apply optional filters if needed.
-
Run the report.
Required filters
-
Date/Time – Select the reporting period.
-
Top – Number of top-selling items to include. The default value is 25, but you can enter any number.
Optional filters
Sales Column – Sort results by a selected metric such as:
-
First Sold
-
Last Sold
-
Quantity Sold
-
Current On Hand
-
Other available sales metrics
Every dimension in your system
Stores
Levels
Vendors
Evergreen status
-
By default, these filters include all values.
|
Column |
Description |
|
Total Retail |
Quantity sold × retail price recorded in the transaction. |
|
Total Discount |
Quantity sold × item discount recorded in the transaction. |
|
Total Net Retail |
Total Retail − Total Discount. |
|
Total Cost |
Quantity sold × calculated item cost at the time of the transaction. |
|
Net Profit |
Total Net Retail − Total Cost. |
|
Net Margin |
(Total Net Retail − Total Cost) ÷ Total Net Retail. |
|
Sell-Through Rate |
Quantity Sold ÷ (Quantity Sold + Ending On Hand). |
Related Articles
Reporting Explained: Summary By Period
The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...Reporting Explained: Sales By Day
Business Need: This report is helpful for users who want a summary of sales by location over a period. How it Works: A Sales>By Item report shows a summary of sales for your stores in Yellow Dog. Generating the Report: Go to the Standard Reports ...Reporting Explained: ReOrder
Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...Reporting Explained Sale By Hour of Day
Business Need: This report is helpful for users who want a report to show sales organized by hour of day that the sale occurred. How it Works: A Sales>By Hour of Day report shows a summary of sales organized by the hour that the sale occurred. This ...Reporting Explained: All Sales Captured Report
The All Sales Captured report shows sales exactly as they are sent from the point-of-sale (POS) system. Use this report to identify: Items sold in the POS that are not linked to a Yellow Dog item or recipe. Items created directly in the POS. POS menu ...
Popular Articles
How To: Find Your Yellow Dog Inventory Version
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...Feature Overview: Par & Re-Order Points
Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...Tips & Tricks: How do I download and install drivers for my Zebra Printer?
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...How To: Swap the On-Hand/Parent Size (Edit Base Unit)
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...FAQs: What are Bins?
Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...