Employee Utilization (Operational) report
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: Operations manager, center admin
The Employee Utilization (Operational) report gives a snapshot of how an employee's time was spent over a chosen period β service hours, paid block-out time, mandatory breaks, and total scheduled or clocked-in hours β and rolls these into a single utilization percentage per employee.
This is a legacy report in the classic Reports dashboard. For newer organizations and for richer per-day, per-month, and rollup views, use the V2 report family below.
V2 equivalent: For the current version of this report, see Employee Utilization reports.
Data refresh: Real-time on Refresh. Values reflect appointments, schedule, attendance, and break records at the moment of click.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Hourly data export
- Notes and limitations
- Tips
- Troubleshooting
- Related articles
Before you begin
- Confirm your organization signed up with Zenoti on or before April 2022. Newer organizations will not see this report in the dashboard.
- Confirm the Employee Manager module and the Employee Reports sub-license are enabled for your center.
Permission: Utilization (under View Admin Reports) β The Operational utilization screen sits under the Room Utilization page in the legacy dashboard, so it shares this permission gate. Grant it on the View Admin Reports row in the Administrator section of the security role (Configuration > Security > Security roles > the role > Permissions).
Run the report
- Confirm the Center in the header is the center for which you want utilization.
- On the main menu, click Reports.
- On the Reports Dashboard, set the filter to Operational > Utilization.
- From the list of reports, click Employee Utilization. The report opens in a new tab.
- Set the Time Period filter and any other criteria, then click Refresh.
- To get the per-hour view, click Download Hourly Data.
- To export the on-screen table, click the Excel or CSV icon.
Note on date range: The date filter anchors on the center's local time. When you choose a custom range that extends into the future, scheduled hours for future dates come from each employee's schedule and service hours come from booked appointments β actual hours and breaks contribute only for past dates.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Time Period | 1 Month, 2 Months, 3 Months, 6 Months, Custom |
Selects the rolling window for the report. Resolves to a center-local start and end date. |
| Custom dates | From / To dates | When Custom is selected, supply the date range directly. Maximum 6 months per run. |
| Job | Configured jobs | Optional. Limits results to employees mapped to the selected job. |
| Employee | Configured employees | Optional. Limits results to a single employee. |
Note: For custom dates spanning more than 6 months, split the run. For example, January to August β run JanuaryβJune first, then JulyβAugust.
Column reference
| Column | Type | Description |
|---|---|---|
| Employee Code | Identifier | The unique employee code, shown on the on-screen grid and in the Hourly Data export. |
| Name | Text | Employee display name (nickname when present, otherwise first and last name). |
| Service Hours (#) | Number (hours) | Total service hours delivered, taken from completed and booked appointments in the period. When the org setting Consider service recovery time in employee utilization is on, recovery time is added in. |
| Paid Block Out Hours (#) | Number (hours) | Block-out time that counts toward utilization (categories flagged Count in utilization). Uses the actual block-out duration recorded on the Appointment Book, not the configured default. |
| Mandatory Break Hours (#) | Number (hours) | Mandatory break hours configured on the employee profile, summed across the days in the period. |
| Total scheduled/Clocked in Hours (#) | Number (hours) | Either scheduled hours or actual clocked-in hours, depending on the center setting Calculate payroll hours based on (Schedule and actual hours combination β scheduled; Actual check-in/check-out β clocked-in). Mandatory break time is subtracted from the actual-hours variant. |
| Utilization (%) | Percent | (Service Hours + Paid Block Out Hours + Mandatory Break Hours) / Total Scheduled or Clocked-in Hours Γ 100. Returns 0 when the denominator is 0. |
Worked example: Service Hours 25 + Paid Block Out Hours 20 + Mandatory Break Hours 30 = 75 numerator. Total Scheduled or Clocked-in Hours 170.
75 / 170 Γ 100 = 44.11%.
Hourly data export
Click Download Hourly Data to get a CSV with one row per employee per hour slot.
| Column | Description |
|---|---|
| Year, Month, Day, Date | Calendar parts of the slot date. |
| Employee Code, Name | Same identifiers as the on-screen report. |
| Time Slot | One-hour slot derived from the center's operating hours. For 9:00β20:00 β 9:00β10:00, 10:00β11:00, and so on. For 9:30β20:30 β 9:30β10:30, 10:30β11:30, and so on. |
| Job Code, Job | The employee's job code and job name for the slot. |
| Mandatory Break Hours (#) | Mandatory break time falling in the slot. |
| Utilized Time | A decimal between 0 and 1 β the fraction of the one-hour slot covered by service, paid block-out, and mandatory break time. Matches the numerator of the row-level utilization formula scaled to the slot. |
| Scheduled Hours | A decimal between 0 and 1 β the fraction of the slot the employee was scheduled or clocked in. Matches the denominator scaled to the slot. |
| Service Hours | Service time delivered in the slot. |
Productivity: A common follow-up metric is
Productivity = Service Hours / Scheduled Hoursper slot or per employee. The report does not surface this column directly β derive it in the exported sheet.
Notes and limitations
- Only employees with the THERAPIST security profile appear in the on-screen results. Other roles are filtered out by the operational wrapper.
- Cancelled and no-show appointments are excluded from Service Hours.
- Voided records are excluded across appointments, segments, breaks, schedule, and attendance.
- Future dates use schedule and bookings, not actuals. When the chosen range extends past today, scheduled hours come from the employee schedule and service hours come from future appointments β there are no clocked-in or break records to consider yet.
- Multi-center context. The denominator and Service Hours are calculated within the selected center. When the org setting Do not consider other-center invoices for payroll is on, attendance from other centers is also excluded from Total Clocked-in Hours.
- Currency decimals from the organization profile drive the rounding for hours and percentage.
Tips
- Pair on-screen and hourly views. The on-screen grid gives the period-level percentage; the Hourly Data CSV explains which hours of which days drive that percentage. Open both when investigating a low utilization week.
- Switch the denominator deliberately. If you want utilization against the planned roster, run with Calculate payroll hours based on = Schedule. To measure against actual presence, run with Actual check-in/check-out. The same employees can score differently under each setting.
- Inspect Paid Block Out categories. Two block-out categories with similar names β one flagged Count in utilization and one not β produce very different numerators. Audit the Block Out Category configuration before defending a utilization number to leadership.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Report not visible in the dashboard | The organization signed up with Zenoti after April 2022; this legacy report is hidden for newer cohorts. | Use the V2 Employee Utilization reports family instead. |
| Permission denied opening the report | The user role lacks Admin Reports β Room Utilization under Reports Admin. | Ask an organization admin to grant the action on the role. |
| Utilization is unexpectedly low | Total Scheduled or Clocked-in Hours is too high relative to Service Hours β for example, the role was scheduled all day but worked fewer billable hours. | Open Hourly Data, identify slots with Scheduled Hours > 0 and Utilized Time = 0, then review the Appointment Book and break log for those slots. |
| Numbers don't match the V2 daily report | The V1 operational report uses the THERAPIST-only filter and a slightly different denominator switch; the V2 daily report covers all eligible roles. | Treat the two reports as independent. Use V2 as the system of record going forward. |