Find your best sellers, most profitable items and peak hours

Five short reports under Reports & Analytics › Sales Reports answer the questions buyers and store managers ask every week. Each one uses the period in From and To; empty means the current month.

Most Sold Items

Items ranked by quantity sold. Filter by Branch ID. Columns: Item, Serial (the item code), Sales Unit, Default Unit, Unit Qty and Sold Qty. Use it to decide what to keep in stock and where to place it.

Most Profitable Items

Items ranked by profit. Filter by Branch ID. Columns:

• Sold Qty.

• Sales Value: sale price × quantity.

• Cost Value: the cost recorded on each sale line × quantity.

• Net Profit: Sales Value − Cost Value.

A best seller with a thin profit, or a slow item with a high one, stands out quickly when you compare this report with Most Sold Items.

Most Sold Items by Category

Best sellers inside one category. Choose a Main category to cover all its sub-categories, or a Sub-category to look at one of them. Choose at least the main category; without it the report returns no rows. Columns match Most Sold Items.

Avg Sale Price

The average price you actually achieved for each item and unit, after line discounts. Filter by Item ID, Branch ID, Warehouse ID, Customer ID, POS terminal, Main category or Sub-category. Columns: Main Category, Sub Category, Item, Unit, Sold Qty, Total Sales (including tax) and Avg Price (net sales before tax ÷ quantity). Compare Avg Price with your price list to see how much discounting costs you.

Peak Sales Times

The number of invoices in each hour of the day. Filter by Branch ID. Columns: Hour and Invoices. Use it to plan shifts and staffing at the till.

Export

Every report exports with Export Excel or Export PDF.

Common questions

Most Sold Items by Category is empty. Choose a main category, then select Apply.

Why does the profit look too high for some items? Net Profit uses the cost recorded when the item was sold. If an item was sold before its purchase cost was entered, its cost may be zero. Check the item's cost and the inventory valuation.