Service - 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.
Audience: Center manager, accountant
The Service - Profitability report shows, for each service sold at the selected center over a date range, the cost the center incurred to deliver it (consumables, the configured service-internal cost, and optionally employee commission), the final sale value collected, and the resulting profit and profit margin. Use it to identify which services are most and least profitable at a center, to test the impact of including or excluding commission, and to size the gap between sale price and total delivery cost.
This is a legacy report available only under the classic reporting framework. Center managers use it for a quick per-service profitability snapshot; finance teams reconcile a center's profit footprint against the sales reports it pairs with. Profitability values are available from June 5, 2014 onward; earlier dates return empty rows.
Data refresh: Real-time on Refresh. Sale and consumable-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
- Run the report
- Filter reference
- Column reference
- How profit and margin are calculated
- Notes and limitations
- Tips
- Troubleshooting
- Related articles
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 service code, name, category, sub-category, and quantity (including refunds) columns are visible; cost, sale, profit, and margin columns are hidden.
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
- Select the center for which you want to run the report.
- Navigate to Reports > Admin.
- Open the Service - Profitability report (display order 180 in the Admin category; report group Profitability).
- Set the date range and any additional filters from the Filter reference.
- To break results down by business unit, select the Show Business Unit check box.
- To include employee commission in cost and profit columns, select the Include Employee Commission check box.
- Click Refresh.
To export the report, click the Excel or CSV icon.
Note on date range: The date filter anchors on the appointment Start Time for service-sale rows and on the Return Date for refund rows. An appointment that started Jan 9 but was invoiced Jan 10 appears in the Jan 9 row.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date range | From / To dates | Filters by appointment Start Time for sale rows and by Return Date for refund rows. |
| Category | Configured service categories | Limits results to services in the selected category (parent category in the category hierarchy). |
| Sub-Category | Configured service sub-categories | Further narrows the category filter. |
| Show Business Unit | Check box | When selected, adds the Business Unit column and groups results so the same service 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 Service report type. Formulas for computed columns are documented inline.
| Column | Type | Description |
|---|---|---|
| Business Unit | Text | The business unit that owns the service. Visible only when Show Business Unit is selected. |
| Code | Identifier | The unique service code. |
| Service | Text | The service name. |
| Category | Text | The parent service category. |
| Sub Category | Text | The service sub-category. |
| Quantity (Including Refunds) | Number | Net number of sales of this service in the date range. Refunded units count as negative one each, so a service sold five times and refunded once shows four. |
| Cost of Consumables (A) | Currency | Sum of the average per-unit value of the products consumed in delivering this service, multiplied by the quantity used, across all appointments in the date range. |
| Cost To Center (B) | Currency | The center's internal cost of delivering the service, taken from the Service internal cost value configured on the service, multiplied by quantity. |
| Commission (Including Refunds) (C) | Currency | Total employee commission attributable to invoices for this service in the date range. Visible only when Include Employee Commission is selected. Computed from the employee-commission engine output. |
| TOTAL COST (A + B + C) | Currency | Cost of Consumables + Cost To Center + Commission (Commission included only when the check box is selected). |
| Total Sale | Currency | SalePrice β Discount for the matching invoice items. |
| PROFIT (TOTAL SALE - TOTAL COST) | Currency | Total Sale β (Cost of Consumables + Cost To Center + Commission). |
| Profit Margin (%) | Percent | Profit Γ· Total Cost Γ 100. When Total Cost is zero the column is displayed as zero rather than divided. |
How profit and margin are calculated
The report rolls four moving parts into one row per service (per business unit, when the check box is on):
- Consumables consumed. The product-consumption engine records the average per-unit value of every product used on each appointment. Summed across all appointments in the date range, this is the Cost of Consumables (A).
- Service internal cost. A flat per-delivery cost configured on the service record, multiplied by quantity sold. This is the Cost To Center (B) β the closest legacy equivalent to a labour-plus-overhead allocation.
- 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 service 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 service in some sales reports, where margin is computed against sale.
Notes and limitations
- Profitability data start date. The report returns empty rows for any date before June 5, 2014. Older history is not retained in the underlying tables.
- Refunds are netted in. A refunded service contributes
β1to Quantity and a negative sale to Total Sale in the same row as the original sale, so a service that breaks even on refunds can show zero quantity. To see refund counts separately, run the Sales - service report alongside this report. - Cross-center day packages. When a service is consumed as part of a day package whose price is allocated across multiple items, the report reads the allocated per-service price from the day-package allocation, not the full package price.
- Commission accuracy depends on payroll. The commission engine writes per-invoice-item commission rows as appointments 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.
- Business unit grouping. With Show Business Unit selected, the same service appears in multiple rows when it has been delivered against multiple business units. Sums in those rows do not equal the un-grouped row for that service unless the service is tied to a single business unit.
- Closed invoices only. Only invoice items in the closed state are included. Open invoices, parked invoices, and abandoned cart items do not contribute to the report.
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 service row is the commission carried by that service, and is the lever a center manager has when planning service-pricing or commission-tier changes.
- Pair with Sales - service for unit economics. The Sales - service report shows revenue per service without cost decomposition. Open both side by side to see what each service earned and what it cost, against the same date filter.
- Use Business Unit to spot loss-leaders by program. A service can be profitable overall and unprofitable in one business unit (for example a promotional location). Show Business Unit and sort by Profit ascending to surface the worst offenders.
- Export for quarter-end reconciliation. Set the date range to the quarter, select Include Employee Commission, and export to Excel. The export retains all calculated columns and is the cleanest starting point for finance to roll up service profitability against payroll.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| The report is not listed on the Reports Dashboard | The role lacks the classic report permission (View Admin Reports in the Administrator section of the security role). | Grant the report-area action in the security role. See Report permissions and customization. |
| Cost, sale, and profit columns are blank but service 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. |
| Profit Margin shows a very large value | Total Cost on that row is very small (a service with negligible internal cost and no consumables). Margin is computed against cost, so small denominators produce large percentages. | Cross-check the service's Service internal cost and whether product consumption is being recorded against it. |
| 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. |
| Numbers do not match the Sales - service report | Sales reports are net of discount but exclude internal cost and commission. Profit Margin in this report is against cost; sales reports use margin against sale. | Reconcile Total Sale in this report against the sales report's revenue column, then expect cost and margin columns to differ by definition. |
| Report shows no rows for a date range before June 2014 | Profitability values are only retained from June 5, 2014 onward. | Choose a date range that starts on or after June 5, 2014. |