Employees Sales-Cash Report β Surcharge Collected column
The Surcharge Collected column in the Employees Sales-Cash report shows the surcharge amount collected on transactions attributed to each employee. This overview explains what the column measures, how its addition affects the display order of subsequent columns, and how to interpret it alongside other financial figures in the report.
Before you begin
Your organization must use Zenoti Payments with surcharge collection enabled.
You need access to the Employees Sales-Cash report. Access is controlled by your security role.
Permission: Access to the Employees Sales-Cash report is granted through the Reports(V2) section of your security role, under the Financial group. Contact your administrator if the report is not visible.
How it works
The Employees Sales-Cash report attributes each closed invoice to the employee recorded as the service provider or salesperson on that invoice. For every invoice row, the report calculates financial totals β including sales amounts, tax collected, and any surcharge collected β and aggregates them at the employee level.
The Surcharge Collected column captures the monetary amount of payment surcharge that was collected on transactions attributed to the employee during the selected date range. Surcharge is a fee added to a transaction when a guest pays by credit or debit card, where permitted by applicable regulations and your organization's Zenoti Payments configuration.
What the column measures
The Surcharge Collected column reflects the surcharge amounts on closed invoices that are attributed to the reporting employee. The value is expressed as a money amount in your organization's configured currency.
Key behaviors to understand:
- The column shows the total surcharge collected on all transactions attributed to the employee within the selected date range, not a percentage or a rate.
- If no surcharge was collected on an employee's transactions β either because the payment method did not attract a surcharge or because surcharge is not configured β the column displays zero or is empty.
- Surcharge amounts are reported in the same invoice period as the sale, consistent with how other financial columns in the report are dated.
- Because the column represents an amount collected from the guest rather than revenue earned by the employee, it does not factor into commission calculations.
Column display order
The addition of the Surcharge Collected column shifts the display order of several subsequent columns. The updated order for the affected columns is:
| Column | Display order |
|---|---|
| Surcharge Collected | 21 |
| Processing Fee | 22 |
| Serviced By | 23 |
| Sold By | 24 |
| Receivable Account | 25 |
| Sale Type | 26 |
| Invoice Adjusted after closure. | 27 |
How this column relates to other report columns
The Surcharge Collected column is supplementary financial information. It is distinct from:
- Sales columns β which show the net or gross sale price of services, products, or other items, excluding surcharge.
- Tax Collected β which shows applicable taxes on the sale, also separate from surcharge.
- Commission-related columns β which are calculated from commissionable revenue, not from surcharge amounts.
Use the Surcharge Collected column when you need to account for the full amount collected from guests across the employees who generated those transactions, for example when reconciling register totals or reviewing overall collections against a sales-cash figure.
Key features
- Money data type β The column value is a monetary amount formatted with your organization's currency symbol, aligned consistently with other money columns in the report grid.
- Employee attribution β Surcharge amounts are attributed to the same employee as the underlying transaction, following the same attribution logic applied to all other columns in the Employees Sales-Cash report.
- Date-range scoped β The column aggregates surcharge for the date range and center scope you apply when running the report, consistent with all other columns.
- Exportable β The Surcharge Collected column is included when you click Export to download the report as an XLSX or CSV file, provided the column is visible in your current column configuration.