Total sale of products on closed invoices divided by number on closed invoices which have product sale
Product Invoices Count
Zenoti -> Reports NEW (v2 report) -> Financial Reports -> Sales - Accrual report -> Select all values in Item Type, Sale Type and Payment Type dropdown -> select centers as displayed in ezPulse app
Unhide Invoice Closed Date and Status column
Export the report in excel, open the file remove top 5 rows and last row
Select the table and Go to Insert Tab -> Pivot table
Add Item Type in Filters, select product
Add Item Status in Filters, select Closed
Add Invoice No in Rows and count the number of invoices shown
Product Sale
Zenoti -> Reports NEW -> Financial Reports -> Sales - Accrual report -> Select all values in Item Type, Sale Type and Payment Type dropdown -> select centers as displayed in ezPulse app
Unhide Invoice Closed Date and Status column
Export the report in excel, open the file remove top 5 rows and last row
Select the table and Go to Insert Tab -> Pivot table
Add Item Type in Filters and Sum Sales(Exc. Tax) column in values
Select Product in Item Type Filter, the value shown is the sale value
Average service spend = Product Sale / Product Invoices Count