Skip to main content
All CollectionsezPulseMetrics
Average Product Spend Inc. Tax
Average Product Spend Inc. Tax
Simplified Support avatar
Written by Simplified Support
Updated over 2 years ago

Total sale of products on closed invoices divided by number on closed invoices which have product sale. The sale value includes Tax amount.

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(Inc. 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

Did this answer your question?