This report helps you evaluate the performance of each product individually, identify best-selling and most profitable items, and make informed decisions on supplier purchases, promotional planning, and inventory management to maximize profit.
ℹ️ Notes:
This report does not include shipping or cash-on-delivery fees from e-commerce integrations.
The Data for deleted products from the inventory are not shown nor accounted for.
Accessing the Report
Go to Reports > Inventory > Product Performance Report.
Click on the report to view the details.
Searching in the Report
Enter the product name or SKU in the search field.
Filtering Results
Click Filter.
You can filter results by:
Date (From–To)
Supplier name
Brand
Category
Location
Click Apply.
Set Time
1- Click on the Time field.
2- Select the time range you want:
24 hours (default).
Adjust Timeframe (Temporary or Saved period).
To set a temporary time:
Click “Adjust Timeframe”.
Select the start time and end time.
Click “Apply”.
To add a Custom Timeframe:
Click “Set Saved Period”.
Enter a name for the period.
Define the period hours.
Click “Save”.
Sorting Data
Click the Sort By field and choose the preferred option to display report data.
Report Sections
Summary: Shows the total sales and profit for all products.
Details: Displays detailed data for each product.
ℹ️ Numbers are calculated according to your filtration criteria
Report Data
Product Name / SKU | Based on the data entered in the Products section. |
Today’s Available Quantity | Current available quantity in the Products section on Rewaa. |
Today’s Available Quantity | The total available product quantity in the inventory (This number is not affected by date filter or any other filters). |
Today’s Product’s Cost | Product Average weighted cost in inventory. |
Today’s Inventory Value | Product Average weighted cost multiplied by product quantity (packed, composite products inventory value is not accounted for) |
Supplier / Brand / Category | Based on the product details you assigned in the Products section. |
Location | The branch where the sale occurred. |
Sales | Total completed sales (excluding Tax), minus returns and discounts. |
Cost of Goods Sold (COGS) | Total cost of sold products, minus the cost of returned items. |
Gross Margin | Net sales (excluding Tax) minus COGS. |
Total Tax | Total Tax collected for taxable products across all rates. |
Sales (Tax Inclusive) | Total completed sales including Tax, minus returns and discounts. |
Markup | (Sales – COGS) ÷ COGS. |
Margin % | (Sales – COGS) ÷ Sales. |
Sold Quantity | Quantity sold before deducting returns. |
Purchased Quantity | Total quantity purchased through purchase invoices (manual stock adjustments not included). |
Returned Quantity | Total quantity of returned items. |
ℹ️ The table contains multiple columns. Use the scrollbar at the bottom to view all fields.
Export the Report
Click Export:
To export a summary of the report, select Summary (.xlsx).
To export the detailed report, select Excel File or PDF File.
The file will be downloaded to your device.
FAQs
1. Can I check the sales of a specific product in one branch?
Yes. Click Filter > Select the branch > Apply.
2. How can I view sales for all products across all branches since the first recorded transaction?
Do not select a time period or filters. The report will display the total sales.
3. Can I track the sales of a specific category?
Yes. Click Filter > Enter the category name > Apply.
4. How do I identify the Highest products?
Use the Sort By field and choose Highest First.
5. How can I check the number of products sold during a specific time period?
Click Filter > Select the time period > Apply.
6. Why are some data points missing from the report?
Use the scrollbar at the bottom of the table to view all fields, or click Export to see all data in Excel.
7. How can I identify slow-moving products that were never sold or not sold within a certain period?
Use the Obsolete Inventory Report to find these products.