Skip to content

Top Products Report

Generate Report – Top Products Report

The Top Products Report provides insights into the best-selling and most profitable products in your inventory. This report helps you identify which items drive the most revenue and profit, enabling better inventory and sales strategies.

1. Access the Report Section

  • Navigate to the Reports section of your dashboard.
  • Select Generate Report from the list of available reports.

2. Define the Report Parameters:

  • Category: Ensure that Products is selected as the category.
  • Report: Choose Top Products Report from the report options.
  • Report Description: This report highlights the top-selling and most profitable products. It presents essential product details, including total quantity sold, total revenue generated, total cost incurred, and provides insights into profits, margins, and markups.

3. Set Date and Time Range

  • In the Start Date and End Date fields, specify the date range for the report.
  • Optionally, set specific times using the Start Time and End Time fields.
  • You may also use present options such as Today, Yesterday, This Week, Last Week, This Month, Last Month, This Year, or Last Year for convenience.
  • For a complete dataset, click All.

4. Generate the Report

  • After completing all selections, click the Submit button.

Report Content

Once the report is generated, you will see the following data columns:

Barcode: Unique identifier for each product. Description: Name or details of the product. Category: Product category. Total Quantity Sold: The number of units sold. Average Price: Average selling price per unit. Total Revenue: Total income generated from sales. Total Cost: Combined cost of sold items. Profit: Total revenue minus total cost. Margin: Profit percentage relative to revenue. Markup: Percentage increase from cost to selling price.

Export and Print Options:

  • Use the Export button to download the report in Excel format.
  • Click the Print button for a hard copy of the report.
  • Adjust visible columns to tailor the report display using the Columns button.