Employee Split Tips v1 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: Payroll admin, center admin
The Employee Split Tips report shows invoice-by-invoice tip detail for each employee, broken down by the payment method the guest used to pay the tip β Cash, Check, Custom, CC, and Prepaid Card. Use this report to verify employee tip earnings against payroll, to investigate disputes over tip amounts, and to keep a per-invoice tip ledger for tax and regulatory reporting.
Tips are part of the income service providers earn, and most jurisdictions require providers to report tips when they file taxes. This report gives the center a per-invoice record of every tip β who received it, how much, from which guest, and through which payment method β so the business can compute and report tip income accurately.
This is a legacy report available under the classic reporting framework. Newer organizations should use the V2 successor.
V2 equivalent: For the current version of this report, see Split tips report.
Data refresh: Real-time on Refresh. Values reflect tips recorded against invoices at the moment of click.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Notes and limitations
- Worked example
- Tips
- Troubleshooting
- Related articles
Before you begin
- Confirm your organization signed up with Zenoti before April 2022. Organizations onboarded after that date do not have access to this V1 report.
- Enable the report for your organization under Configuration > Reports > List of reports, where the Split Tips row must be turned on.
- Turn on the org-level Split Tips setting if you want tips to be split across multiple service providers on the same invoice. The setting gates the report's split-aware behavior.
Permission: Performance (under View Employee Reports) β Required to open the Employee reports surface that hosts the Split Tips report. Grant it on the View Employee Reports row in the Employee Manager section of the security role (Configuration > Security > Security roles > the role > Permissions).
Run the report
- Select the center for which you want to run the report.
- Navigate to Reports.
- On the Reports dashboard, click Employee > Sales.
- From the list of reports, click Split Tips. The report opens in a new tab.
- Set the date range, Date Type, Invoice Type, Time Period, and Employee Name filter from the Filter reference.
- Click Refresh.
To export the report, click the Excel or CSV icon. To see every column, export rather than view in the browser β some columns are wider than the report grid.
Note on date range: The date filter anchors on the Date Type you choose β Sale Date, Collection Date, or Closed Date. The three choices map to different result sets. See the Date Type row of the Filter reference for the rules.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date Type | By Sale Date / By Collection Date / By Closed Date | Controls which date anchors the result set. By Sale Date returns invoices whose service or item sale falls in the range and includes both Open and Closed invoices. By Collection Date returns only Closed invoices where a tip was paid, anchored on the date the tip was collected. By Closed Date returns only Closed invoices anchored on the date the front desk closed the invoice. |
| Invoice Type | All / Open / Closed | Filters the report by invoice status. Open invoices are those where the guest made partial payment or full payment but the invoice has not yet been closed. Closed invoices are those the front desk closed with the Close and Email or Close and Print action. |
| Time Period | Today / Last 7 days / Last 14 days / 1 month / 2 months / 3 months / 6 months / Custom | Sets the date window. For Custom, the maximum range is 6 months at a time β to see January to August, run JanuaryβJune first, then JulyβAugust. |
| Employee Name | List of employees | Limits results to one employee. The list shows employees of the current center plus employees on loan from another center who are scheduled to work here. Deactivated employees (those with an End Date in the General tab of the employee profile) are not in the list. |
Column reference
| Column | Type | Description |
|---|---|---|
| Code | Identifier | The employee code of the person who received the tip. |
| Employee | Text | The first name and last name of the employee who received the tip. |
| Invoice Number | Identifier | The center receipt number of the invoice on which the tip was paid. |
| Guest Name | Text | The guest who paid the tip and in whose name the invoice was raised. The full last name is shown when the org-level setting permits guest last name disclosure; otherwise only the first name is shown. |
| Cash | Currency | The portion of the employee's tip the guest paid in cash. Allocated from the invoice total cash-tip pool in proportion to this employee's share of the tip. |
| Check | Currency | The portion of the employee's tip the guest paid by check, allocated by the same proportional split. |
| Custom | Currency | The portion paid using a custom payment method β for example, a coupon or a company card β allocated proportionally. |
| CC | Currency | The portion paid by credit card, allocated proportionally. |
| Prepaid Card | Currency | The portion paid using a prepaid card or gift card balance, allocated proportionally. |
| Tip | Currency | The total tip amount the employee received on this invoice β the sum of the five payment-method columns for the employee's share. |
| Status | Enum | Open or Closed. Closed means the invoice was closed by the front desk after full payment; Open means partial payment was recorded or the invoice was never closed. |
| Closed Date | Date | The date the invoice was closed. Empty for Open invoices. |
Notes and limitations
- Total tip, not split tip. The report shows the total tip amount recorded against each invoice. The amount is the full tip on the invoice β not a tip that has necessarily been split among several employees. If the org-level Split Tips setting is off, the entire tip on each invoice goes to one employee.
- How the split works when the setting is on. When the org-level Split Tips setting is on, the front desk can split an invoice's tip across two or more service providers from the invoice screen. The report then allocates each payment-method column proportionally to each employee's share of the tip pool for that invoice. The five payment-method columns always sum (row-wise) to the Tip column for that employee.
- Date anchoring affects what you see. By Sale Date includes Open and Closed invoices for the period. By Collection Date includes only Closed invoices where a tip was paid (Open invoices without a tip collection date drop out). By Closed Date includes Closed invoices regardless of whether a tip was paid.
- Open invoices, defined. Open invoices are those on which the guest has paid partially using a payment type (cash, card, check, or custom) or a redemption instrument (membership, package, gift card, or prepaid card), or has paid in full but the front desk has not yet closed the invoice. The due amount, if any, is tracked against the guest.
- Closed invoices, defined. Closed invoices are those the front desk closed using Close and Email or Close and Print after the guest paid in full using any combination of payment types and redemption instruments.
- Cross-check with Employee Tips Summary. If you use the same Date Type, Invoice Type, and Time Period filters in the Employee Tips Summary report, the per-employee tip totals in both reports should match. A mismatch usually means the filter sets are different.
- Stick to one filter set across time periods. Mixing filter sets β for example, By Sale Date with Invoice Type "All" in one period and By Collection Date with Invoice Type "Closed" in another β produces totals that are not directly comparable.
- On-loan employees. Employees on loan from another center appear in the Employee Name dropdown only while they are scheduled at the current center. Once their on-loan schedule ends, the report no longer lists them.
- Sale date is service date. For service items, the sale date is the date the service was performed β not the date the appointment was booked and not the date the invoice was closed.
Worked example
A salon wants to verify the cash and credit-card tip split for Alex Morgan for the last pay cycle (1 May to 15 May).
- Open Reports > Employee > Sales > Split Tips.
- Set Date Type: By Closed Date. Invoice Type: Closed. Time Period: Custom with 1 May to 15 May.
- Employee Name: Alex Morgan.
- Click Refresh.
Sample result:
| Invoice Number | Guest Name | Cash | Check | Custom | CC | Prepaid Card | Tip | Status | Closed Date |
|---|---|---|---|---|---|---|---|---|---|
| 4012 | Priya R. | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10.00 | Closed | 02-May |
| 4055 | Jordan K. | 0.00 | 0.00 | 0.00 | 12.00 | 0.00 | 12.00 | Closed | 06-May |
| 4101 | Sam L. | 5.00 | 0.00 | 0.00 | 7.50 | 0.00 | 12.50 | Closed | 11-May |
| 4144 | Devi N. | 0.00 | 0.00 | 0.00 | 0.00 | 8.00 | 8.00 | Closed | 14-May |
Cash total: 15.00. CC total: 19.50. Prepaid total: 8.00. Tip total: 42.50.
The payroll team compares the 42.50 against Alex's tip line in the payroll detail. If the payroll line reads 42.50, no action is needed. If it reads less, the difference usually points to an invoice closed after the cutoff that will appear in the next cycle.
Tips
- Reconcile tips against payroll. Export the report by Closed Date for the payroll period, then sum the Tip column by employee. The total should match the tip line in the payroll detail for the same employee. If it doesn't, the difference usually comes from invoices closed inside the payroll window but for services delivered earlier β those count on Closed Date but not on Sale Date.
- Investigate a tip dispute. When an employee questions a tip amount, run the report filtered to their name with Date Type By Sale Date and Invoice Type All. Each row shows the invoice, the guest, the payment-method breakdown, and the status β enough to locate the disputed transaction. If the dispute is about the split percentage, compare the row to the invoice in the appointment book and confirm the split set at close time.
- Group large filters into multiple runs. The 6-month custom-range cap means a year-end review needs two runs. Export each half to CSV and combine in Excel.
- Compare cash and card mix. Filter to a single employee for a quarter and chart Cash vs. CC totals. A sustained shift toward Cash can signal tip-reporting risk because cash tips depend on the employee self-declaring; CC tips are recorded at the point of payment.
- Spot prepaid-card tipping. The Prepaid Card column captures tips paid from gift card or prepaid card balances. If the column is unexpectedly high, confirm the org allows tipping from prepaid balances and that this is consistent with local tax rules for tipping income.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Report option is not visible on the Reports dashboard | The organization signed up after April 2022, or the Split Tips row is not enabled in Configuration > Reports > List of reports. | If your organization is post-April-2022, use the Split tips report instead. Otherwise, ask an admin to enable the Split Tips row in List of reports. |
| Permission denied opening the report | The role lacks the Performance check box on the View Employee Reports row (Employee Manager section). | Grant Performance on the View Employee Reports row in the security role. |
| Employee is missing from the Employee Name filter | The employee is deactivated (an End Date is set in the General tab of their profile), or an on-loan employee has no schedule at the current center. | Reactivate the employee, or schedule the on-loan employee at the current center for the date range you want to report on. |
| Totals do not match the Employee Tips Summary report | The two reports were run with different Date Type or Invoice Type filters. | Re-run both reports with identical Date Type, Invoice Type, and Time Period. The per-employee tip total should match. |
| Closed Date column is empty for some rows | Those rows are Open invoices β the invoice has not been closed by the front desk. | Filter Invoice Type to Closed if you only want closed invoices, or accept that the column is empty for in-progress invoices. |
| Payment-method columns sum to less than the Tip column for a row | The invoice has a tip recorded against a payment type the org has not configured under its payment options (rare, usually only after a payment-method cleanup). | Re-add the missing payment type at the org level, then re-run the report. The tip will then attribute to the matching column. |
| Two employees on the same invoice show different totals than expected | The Split Tips org setting was changed between the time the invoice was paid and the time the report was run. | The report reflects the split as recorded at the time of payment. Use the invoice screen in the appointment book to view and adjust the recorded split if needed. |