Product - Profitability report (v1)
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.
Important
This is a legacy report. Businesses that have signed up with Zenoti after April 2022 do not have access to this report. Inventory managers can use this report to view the cost and profit of all the products sold at a center, including employee commissions and returns.
- At the organization or center level, click the Reports icon.
- On the Reports page, search for and select the Product - Profitability report.
- If the report has many columns, scroll horizontally to the right or left to view all columns.
- To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
- Click Refresh.If you generate the report for over a year, click the Email button. Impacts and considerations
To view the report by a business unit, select the Show Business Unit check box and click Refresh.
To view commissions in the report, select the Include Employee Commission check box and click Refresh.
If you cannot view price and commission details, then the Hide Price permission is enabled for your role. Column descriptions
Column Description Code Unique code that identifies the product Product Name Product that was sold or returned Category Category to which the product belongs Sub Category Subcategory to which the product belongs VendorNote: If you do not see this filter, reach out to Zenoti to enable it for your business. Vendor associated with the productIf the product is associated with multiple vendors, you will see Multiple in this column. Quantity (Including Returns) Quantity of the product sold, including returns Cost (A) Purchase cost of the product Commission (Including Returns) (B) Amount paid to employees for selling the productYou will see this column only if the Include employee commission check box is selected. Total Cost(A+B) Sum of the cost of the product and the commission given to the employees for its sale Total Sale Total amount made from selling the product Profit(Total Sale β Total Cost) Difference between the total sales and the total cost of the product Profit Margin (%) Percentage by which the value from sales exceeds the cost to the center Average Cost Average of the total costAverage Cost = Total Cost / Quantity (Including Returns) Average Sale Average of the total saleAverage Sale = Total Sale / Quantity (Including Returns) List Price Price of the product set at the center level or the adjusted price after manual discount
Calculate retail profitability using alternative reports
Businesses that signed up with Zenoti in or after April 2022 can still calculate retail profitability using other available reports. By using the Sales Accrual and Cost of Goods reports, you can derive the necessary profitability information for a specific time frame.
- Generate the Sales Accrual reportAccess the Sales Accrual report.At the organization or center level, click the Reports icon.On the Reports page, search for and select the Sales-Accrual report.If the report has many columns, scroll horizontally to the right or left to view all columns.To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.Click Refresh.If you generate the report for over a year, click the Email button.Apply filters to include only product sales.Exclude other types of sales to focus on products.Define the time frame for the sales.Export the filtered Sales Accrual report.
- Generate the Cost of Goods reportAccess the Cost of Goods report.At the organization or center level, click the Reports icon.On the Reports page, search for and select the Cost of Goods report.If the report has many columns, scroll horizontally to the right or left to view all columns.To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.Click Refresh.If you generate the report for over a year, click the Email button.Select the Retail filter.Ensure the filters match the time frame used in the Sales Accrual report for consistency.Export the filtered report.
- Calculate net profitTo combine data from the downloaded reports, use spreadsheet software, such as MS Excel.For each product, calculate net profit using the formula:Net Profit = Sale Price (Excluding Tax) - Cost of GoodsIf specific customizations are needed, use the filters on the reports to adjust the columns and calculations as required. In this section :