ZenotiHelp

Retail Profitability report

ZTZenoti Docs Team Updated November 10, 2026 4 min readReference

Use the Retail Profitability report to analyze retail gross profitability by product. The report shows the quantity sold and net sales for each retail product, the Cost of Goods Sold (COGS) computed three ways, and the resulting Gross Profit and Gross Margin % for each costing method — so you can compare how each costing choice affects margin.


On this page


Before you begin

  • Select the centers for which you want to run the report.

Permission: Retail Profitability Report (under Reports(V2)) — Required to access this report.

Access the report

  1. Go to the Reports Dashboard.
  2. Search for and select Retail Profitability.
  3. Set the filters (see below), then run the report to view results.

Navigation: Reports > Inventory > Retail Profitability

Filters

Open the filter panel, set the filters you need, and run the report. The report exposes the following filters:

Filter Description
Transaction Date (From, To) Limits the report to retail product transactions posted within the selected date range.
Centers One or more centers to include.
Category Product category.
Sub Category Product sub-category.
Vendor Vendor for the product.
Brand Brand of the product.
Business Unit Business unit the center belongs to.
Search Find a product by Product Name, Product Code, or Barcode.

Key terms

The report values each sale three ways, showing three Cost-of-Goods-Sold columns side-by-side, so you can compare margins:

Term Definition
Cost of Goods Sold (COGS) The cost of the products sold during the period. The report computes COGS three ways, shown as three Cost-of-Goods-Sold columns side-by-side, described below.
Perpetual Average Values COGS using the running weighted-average cost of the product on the date of sale.
Latest Procurement Price Values COGS using the cost from the most recent purchase order for the product.
Configured Purchase Price Values COGS using the purchase price configured in the product setup.
Gross Profit Net Sales minus COGS, calculated separately for each costing method.
Gross Margin % Gross Profit as a percentage of Net Sales, calculated separately for each costing method.

Columns

Each costing method (Perpetual Average, Latest Procurement Price, Configured Purchase Price) produces its own COGS, Gross Profit, and Gross Margin % column.

Column Description
Center Name Center where the retail sales occurred.
Business Unit Business unit the center belongs to.
Product Name Name of the retail product sold.
Product Code Unique product code.
Product Type Type of product (for example, retail or professional).
Brand Brand of the product.
Vendor Vendor for the product.
Category Product category.
Subcategory Product sub-category.
UOM Unit of measure configured for the product — for example, bottle, ml, or gram.
Qty Total quantity of the product sold in the date range.
Net Sales Net retail sales amount (after discounts, before tax).
COGS (Perpetual Average) Cost of goods sold, valued at the running average cost of the product on the date of sale.
COGS (Latest Procurement Price) Cost of goods sold, valued at the most recent purchase order cost for the product.
COGS (Configured Purchase Price) Cost of goods sold, valued at the purchase price configured in the product setup.
Gross Profit (Perpetual Average) Gross profit calculated using the Perpetual Average COGS.
Gross Profit (Latest Procurement Price) Gross profit calculated using the Latest Procurement Price COGS.
Gross Profit (Configured Purchase Price) Gross profit calculated using the Configured Purchase Price COGS.
Gross Margin % (Perpetual Average) Gross margin as a percentage, using the Perpetual Average COGS.
Gross Margin % (Latest Procurement Price) Gross margin as a percentage, using the Latest Procurement Price COGS.
Gross Margin % (Configured Purchase Price) Gross margin as a percentage, using the Configured Purchase Price COGS.

Note: Qty, Net Sales, all three COGS columns, and all three Gross Profit columns roll up in the report footer. Gross Margin % values are per row and do not aggregate.

Limitations

  • The report covers retail product sales only. Consumable consumption, service consumption, internal consumption, wastage, and stock adjustments are excluded.
  • The report shows gross profit, not net profit. For a full profit-and-loss view, combine it with the Sales-Accrual report.
  • Net Sales excludes tax.
  • Gross Margin % is blank when Net Sales is zero (the percentage cannot be computed).
  • Qty and the three COGS columns come from stock movements; Net Sales comes from invoice lines. Both include product sales and returns in the date range, but they are counted separately: quantity and cost by the date of the stock movement, and Net Sales by the date of the invoice. A row can therefore show zero Qty and zero COGS with a non-zero Net Sales — for example, when a sale and its return in the same period cancel out in quantity but not in amount, or when the stock movement and the invoice fall on different sides of the date range. Cross-check such a row against the Sales-Accrual report.
  • Large date ranges may take longer to load.

Sort and export the report

  • Click a column header to sort the grid by that column.
  • Click Export to download the report.
Was this article helpful?
Your feedback helps us improve our documentation.