ZenotiHelp

Product - Profitability report (v1)

ZTZenoti Docs Team Updated September 4, 2026 10 min readReference

Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.

Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.

Deprecated: This is a legacy report. Businesses that have signed up with Zenoti after April 2022 do not have access to this report.

Audience: Inventory manager, center manager, accountant

The Product - Profitability report shows, for each retail product sold at the selected center over a date range, the cost the center paid for it (perpetual-average product cost and optionally employee commission), the final sale value collected, and the resulting profit and profit margin. Use it to identify your highest- and lowest-margin retail items, to test the impact of including or excluding commission on per-product profitability, and to size the gap between sale price and total acquisition cost.

This is a legacy report available only under the classic reporting framework. Inventory managers use it for a quick per-product profitability snapshot at a single center; finance teams reconcile retail margins against the sales reports it pairs with. Refunds are netted in β€” a product sold five times and refunded once shows a quantity of four.

Data refresh: Real-time on Refresh. Sale and cost values reflect transactions completed at the moment of click. The Commission column reflects whatever the employee-commission engine has computed so far β€” for a fully reconciled number, the payroll run must be completed for the pay periods that overlap the report date range.


On this page


Before you begin

  • The org-level Show profitability reports setting must be enabled. The report row is hidden in the Reports list when the setting is off.
  • For commission values to be meaningful, payroll must be run for the pay periods that overlap the selected date range.
  • If your role has the Hide Price permission, only the product code, name, category, sub-category, vendor, and quantity columns are visible; cost, sale, profit, and margin columns are hidden.
  • The Vendor filter is hidden by default. If you do not see it, ask the org admin to enable vendor display on product reports.

Permission: This classic report is controlled by View Admin Reports in the Administrator section of the security role (Configuration > Security > Security roles > the role > Permissions). Select the report-area action that applies to this report (for example Sales, Collections, Revenue, or Accounting). Classic report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.

Run the report

  1. Select the center for which you want to run the report.
  2. Navigate to Reports > Admin.
  3. Open the Product - Profitability report (report group Profitability).
  4. Set the date range and any additional filters from the Filter reference.
  5. To break results down by business unit, select the Show Business Unit check box.
  6. To include employee commission in cost and profit columns, select the Include Employee Commission check box.
  7. Click Refresh.

To export the report, click the Excel or CSV icon. If the date range spans more than a year, click Email instead β€” the report is rendered in the background and delivered as an attachment.

Note on date range: The date filter anchors on the invoice created date for product-sale rows and on the Return Date for refund rows. A product sold and invoiced Jan 9 but refunded Jan 14 contributes a sale row on Jan 9 and a refund row on Jan 14.

Filter reference

Filter Values Description
Date range From / To dates Filters by invoice created date for sale rows and by Return Date for refund rows.
Category Configured product categories Limits results to products in the selected category (parent category in the category hierarchy).
Sub-Category Configured product sub-categories Further narrows the category filter.
Vendor Configured vendors Limits results to products linked to the selected vendor. The filter is hidden unless the org-level setting for vendor display on product reports is enabled.
Show Business Unit Check box When selected, adds the Business Unit column and groups results so the same product appears once per business unit.
Include Employee Commission Check box When selected, adds the Commission column, includes commission in Total Cost, and subtracts it from Profit. When clear, Commission shows zero and is excluded from Total Cost and Profit.

Column reference

All columns below are produced by the report run with the Product report type. Formulas for computed columns are documented inline.

Column Type Description
Business Unit Text The business unit that owns the product. Visible only when Show Business Unit is selected.
Code Identifier The unique product code.
Unit Text The product's volume per item plus the volume-type abbreviation (for example, 100 ml, 200 g).
Product Text The product name.
Color Text The product color, when one is configured on the product record.
Size Text The product size, when one is configured on the product record.
Category Text The parent product category.
Sub Category Text The product sub-category.
Vendor Text The vendor associated with the product. When a product has more than one configured vendor, the column shows Multiple.
Quantity (Including Returns) Number Net units of this product sold in the date range. Returned units contribute as negative quantities, so a product sold five times and returned once shows four.
Cost (A) Currency The center's acquisition cost for the units sold β€” the perpetual-average per-unit cost multiplied by the quantity sold. Refund rows subtract the equivalent cost using the original invoice's per-unit cost.
Commission (Including Returns) (B) Currency Total employee commission attributable to invoice items for this product in the date range. Visible only when Include Employee Commission is selected.
TOTAL COST (A + B) Currency Cost + Commission (Commission included only when the check box is selected).
Total Sale Currency SalePrice βˆ’ Discount for the matching invoice items. Refund rows subtract the proportional sale.
PROFIT (TOTAL SALE - TOTAL COST) Currency Total Sale βˆ’ (Cost + Commission).
Profit Margin (%) Percent Profit Γ· Total Cost Γ— 100. When Total Cost is zero and Sale is zero, the column shows zero; when Total Cost is zero but Sale is non-zero, the column shows 100.
Average Cost Currency Total Cost Γ· Quantity (Including Returns). When quantity is zero, the column shows zero.
Average Sale Currency Total Sale Γ· Quantity (Including Returns). When quantity is zero, the column shows zero.
List Price Currency The product's sale price as configured at the center, or the price after a manual discount when applicable.

How profit and margin are calculated

The report rolls three moving parts into one row per product (per business unit, when the check box is on):

  • Acquisition cost. Each retail sale carries the perpetual-average value per unit that was on the books when the invoice item was created. Summed across all units sold in the date range, this is the Cost (A) column.
  • Commission. Optional. When Include Employee Commission is selected, the report joins to the employee-commission engine output and adds the per-invoice-item commission to total cost. When clear, this contribution is zero on every row.
  • Sale. The discounted final price collected on the invoice item.

Profit margin in this report is expressed against cost, not against sale β€” a product sold for 100 with a total cost of 80 reports a margin of 25 percent (20 Γ· 80), not 20 percent (20 Γ· 100). This differs from the percentage shown next to the same product in some sales reports, where margin is computed against sale.

Worked example

A center sold 10 units of a shampoo over the last month at a list price of 30 each. One unit was returned. Per-unit perpetual-average cost at the time of sale was 12. Commission rate is 5 percent of sale.

Field Value Source
Quantity (Including Returns) 9 10 sold βˆ’ 1 returned
Cost (A) 108 9 Γ— 12
Commission (B) 13.50 9 Γ— 30 Γ— 5%
Total Cost (A+B) 121.50 Cost + Commission
Total Sale 270 9 Γ— 30
Profit 148.50 Total Sale βˆ’ Total Cost
Profit Margin (%) 122.22 148.50 Γ· 121.50 Γ— 100
Average Cost 13.50 Total Cost Γ· Quantity
Average Sale 30 Total Sale Γ· Quantity
List Price 30 Configured at center

With Include Employee Commission cleared, the same row would report Total Cost 108, Profit 162, and Profit Margin 150 percent. The 27.78-point margin swing between the two runs is the commission carried by this product.

Notes and limitations

  • Single center per run. The report runs against one center at a time. To compare retail profitability across centers, run the report at each center and combine the exports.
  • Perpetual-average cost only. This legacy report exposes one costing method β€” perpetual-average value per unit at sale time. It does not surface FIFO, latest procurement price, or configured purchase price. For multi-method cost comparison, use Cost of goods report.
  • Returns are netted in. A returned product contributes a negative quantity and a negative sale and cost in the same row as the original sale, so a product that is returned at the same rate it sells can show zero quantity and zero profit. To see returns separately, run the Sales product report alongside this report.
  • Commission accuracy depends on payroll. The commission engine writes per-invoice-item commission rows as invoices close, but final adjustments (tiered rates, retroactive overrides, payroll-period close) only land after the payroll run for the pay period completes. Running the report mid-pay-period can understate commission and overstate profit.
  • Closed invoices only. Only invoice items in the closed state contribute to the report. Open invoices, parked invoices, and abandoned-cart items are excluded.
  • Excluded cost markers. Invoice items where the per-unit cost is βˆ’2 or βˆ’4 are excluded from the report. These markers are used by the consumption engine for non-priced transfers (samples, write-offs) and would distort retail profitability if included.
  • Business unit grouping. With Show Business Unit selected, the same product appears in multiple rows when it has been sold against multiple business units. Sums in those rows do not equal the un-grouped row for that product unless the product is tied to a single business unit.

Tips

  • Test the margin-with-commission swing. Run the report twice over the same date range β€” once with Include Employee Commission clear, once with it selected. The delta on each product row is the commission carried by that product, and is the lever a center manager has when planning retail-pricing or commission-tier changes.
  • Sort Average Sale against List Price to spot heavy discounting. When Average Sale is materially below List Price for a product, the gap is the average per-unit discount applied at the register. Recurring large gaps point to under-priced manual discounts or stacked promotions.
  • Use Vendor to compare cost performance across suppliers. Filter by Vendor and sort by Profit Margin descending to see which suppliers' products carry the best margin at sale time. Products tagged Multiple vendor are excluded from per-vendor comparison.
  • Combine Sales Accrual + Cost of Goods for organizations onboarded after April 2022. When this legacy report is unavailable, derive per-product profit by exporting the Sales accrual report (filtered to product sales) and the Cost of goods report (with the Retail filter) over the same date range, and subtract per product in a spreadsheet: Net Profit = Sale Price (excluding tax) βˆ’ Cost of Goods.

Troubleshooting

Issue Cause Resolution
Report row is hidden on the Reports dashboard The org-level Show profitability reports setting is off, or the organization was onboarded on or after April 2022 (when this legacy report stopped being provisioned). Confirm onboarding date. For pre-April-2022 organizations, ask the org admin to enable Show profitability reports. For post-April-2022 organizations, use the Sales Accrual + Cost of Goods combination described in Tips.
Cost, sale, and profit columns are blank but product rows show The role has the Hide Price permission, which masks every monetary column on this report. Run the report with a role that does not have Hide Price, or remove the permission from the role.
Vendor column shows Multiple for a product The product has more than one vendor configured at the organization. Open the product record and review configured vendors. The report cannot attribute units to a single vendor when multiple are linked.
Vendor column or filter is missing The org-level setting for vendor display on product reports is off. Ask the org admin to enable vendor display on product reports.
Profit Margin shows a very large value Total Cost on that row is very small (free samples mis-priced, mis-configured product cost). Margin is computed against cost, so small denominators produce large percentages. Cross-check the product's per-unit cost on Manage products and confirm receiving was recorded correctly.
Commission column shows zero on every row even though commissions are paid Include Employee Commission is not selected, or the commission engine has not yet written rows for the pay period. Select the check box and click Refresh. If still zero, confirm the payroll for the pay periods that overlap the date range has been run.
Quantity and Total Sale are both zero for a product I know sold All units sold in the date range were returned in the same range, netting to zero. Widen the date range, or pair with Sales product report to see gross sale and return units separately.
Was this article helpful?
Your feedback helps us improve our documentation.