Product - Profitability report (v1)
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 |
Vendor Note: If you do not see this filter, reach out to Zenoti to enable it for your business. | Vendor associated with the product If 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 product You 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 cost Average Cost = Total Cost / Quantity (Including Returns) |
Average Sale | Average of the total sale Average 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 report
Access 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 report
Access 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 profit
To 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 Goods
If specific customizations are needed, use the filters on the reports to adjust the columns and calculations as required.