Skip to main content

Product Sales Quantity and Profit Report

Shows, for a date range, how many of each product were sold, for how much, at what cost and with how much profit.

Menu: Reports › Product Reports › Product Sales Quantity and Profit Report

Required permission
Reports › Product Sales Quantity and Profit Report › View

What it's for​

Use it to find your best and least profitable products, to check margins after a price change, and to compare back-office sales with POS sales (choose them in Show List By).

Example

The owner runs it for last month, all branches, sorted by Total Profit descending. Softdrink 1.5 L is first in quantity (2,400 sold) but its Total Profit Percentage is only 6%, while Ice Cream 1 L sold 300 at 28%. He decides to move the ice cream freezer to the entrance.

Options on the screen​

  • From / To and Branch: the period and branches.
  • Show List By: all sales, or only Sales Outbound, Sales Return Inbound or POS Sales.
  • Product: all products, or only those with sales in the period.

Filters​

Click Filters to narrow the report. You can filter by:

Stock No., Unit Barcode, Name, Chinese Name, Status, Default Supplier, Supplier, Category Tag, Category, Brand, Branch Area, Date Created, Last Modified, Group Type, Deleted, Last PI Date, Last SO Date.

Columns​

ColumnWhat it shows
NameThe product name.
Parent CategoryThe category one level above the product's category.
SupplierThe product's default supplier.
StatusThe product's status: Active, Inactive or Discontinued.
QtyQuantity sold in the date range (returns are deducted).
Current Product CostThe product's purchase price today (not at the time of sale).
Current Wholesale PriceThe product's wholesale price today.
Current Retail PriceThe product's retail price today.
Total CostCost of the quantity sold.
Total AmountSales amount in the date range.
Total ProfitTotal amount minus total cost.
Total Profit PercentageTotal profit as a percentage of the total amount.
Avg CostTotal cost ÷ quantity.
Avg PriceTotal amount ÷ quantity.
Avg ProfitTotal profit ÷ quantity.
InventoryCurrent stock, in the product's default unit.
Last PI DateDate of the last purchase inbound of the product.
Last PI QtyQuantity of the last purchase inbound.
Last SO DateDate of the last sales outbound of the product.
Last SO QtyQuantity of the last sales outbound.

Also shows: Barcode, Stock No., Chinese Name, Description, Brand, Category, Date Created.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.

Settings that affect this module​

Your administrator can change these in Settings (see About settings). Click a section to see the choices.

Generic Settings › Income Statement