Product Daily Sales Ranking
Ranks products by what they sold in a chosen date range, with POS sales, back-office sales and both combined, in quantity, amount and profit.
Menu: Reports › Ranking Reports › Product Daily Sales Ranking
What it's for
Use it to see which products bring the most sales and profit, and which bring little. Sort by the column you want to rank by (for example Total Amount or Total Profit, descending). Click Click to Show Summary at the bottom for the totals of all lines.
On the first day of a price promotion, the manager ranks the promoted products for today and sees Coffee 3-in-1 already sold 600 packs, with 120 left in Inventory, so she requests more from the warehouse.
Filters
Click Filters to narrow the report. You can filter by:
Branch, Trans. Date, Stock No., Unit Barcode, Name, Chinese Name, Description, Status, Supplier, Category Tag, Category, Brand, Date Created, Last Modified, Group Type, Inventory Status.
Columns
| Column | What it shows |
|---|---|
| Product Name | The product name. |
| Supplier | The product's default supplier. |
| Inventory | Current stock, in the product's default unit. |
| Average Price | Average selling price. |
| POS Qty | Quantity sold at the POS. |
| POS Amount | Amount sold at the POS. |
| POS Profit | Profit on POS sales (amount − cost). |
| Backend Qty | Quantity sold through back-office sales outbounds. |
| Backend Amount | Amount of back-office sales outbounds. |
| Backend Profit | Profit on back-office sales outbounds. |
| Total Qty | POS Qty + Backend Qty. |
| Total Amount | POS Amount + Backend Amount. |
| Total Profit | POS Profit + Backend Profit. |
| Total Profit Percentage | Total Profit as a percentage of Total Amount. |
Also shows: Stock No., Barcode, Chinese Name, Description, Brand, Category.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.