Skip to main content

Package collections inc. tax

This is to compute all Package sales on a sale basis. It includes payments of all types excluding tax and reckons the date of sale.

Validate in Zenoti

Zenoti > Reports NEW(v2 report) > Financial Reports > Sales - Cash report > Select all values in Item Type, Sale Type, and Payment Type ( cash, cheque, card, custom financial) dropdown > select centers as displayed in ezPulse app

  1. Unhide the Invoice Closed Date and Status column

  2. Export the report in Excel, open the file remove the top 5 rows and the last row

  3. Select the table and Go to Insert Tab > Pivot table

  4. Add Item Type in Filters and Sum Sales(Inc. Tax) column in values

  5. Select Package in Item Type Filter, the value shown is the sale value