Skip to main content
Sales per guest
Simplified Support avatar
Written by Simplified Support
Updated over a year ago

Total Sales Per Guest

Total sales accrual based (closed and open invoices) divided by guests of all the employees in the center

Total number of unique guest per day added up for all the days within a date range. This includes all types of items (closed and open invoices)

  • Example - The number of invoices with the sale date in the selected time period. Multiple invoices on the same day by the same guest are considered as one visit. A visit can be for any item type. Refunds, recurring invoices, automatic payments, freeze fees, etc. are not considered as a visit.

  • Guest visits Center A multiple times on 1/10: 1 visit

  • Guest visits Center A, Center B on 1/10: 1 visit in Center A, 1visit in Center B

  • Guest visits Center A on 1/10 and 1/11: 2 visits

Validate in Zenoti

Zenoti -> Reports > Finance > Sales-Accrual report -> Select Sale Type as Sale and Charges, Select All values in Item Type and Payment Type dropdown -> select desired date range in Sale Date -> select centers as displayed in ezPulse app

  • Export the report CSV, open the file

  • Select the table and Go to Insert Tab -> Pivot table

  • Add Guest Code in Rows

  • Use formula =COUNTA(select rows in pivot table)

  • Number of cells in pivot table that contain data are the Number of Guest Visits.

Total Sales

Zenoti -> Reports -> Finance -> Sales-Accrual report -> Select Sale Type as Sale, Refund, and Charges ->Select All values in Item Type and Payment Type dropdown -> select desired date range in Sale Date -> select centers as displayed in ezPulse app

  • Export the report CSV

  • Sum the data in column Sales (Exc. Tax)

Total Sales Per Guest = Total Sales / Total Guests

Did this answer your question?