Product Sales Financial report (v1)
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
Audience: Center manager, accountant
The Product Sales Financial report shows every product sale at the center over a date range with full financial detail per line: list price, discount, redemptions, net price, tax, shipping, price paid, sale value, and payment method. Use it for revenue analysis, retail cohort analysis, and reconciling product revenue against POS totals.
This is a legacy report available under the classic reporting framework. The V2 successor is Sales - Product.
Custom date range capped at 6 months. For longer periods, run consecutive 6-month windows.
Open invoices. Open invoices are NOT counted in employee payroll. Use
Closedfor payroll-input runs; useAllfor revenue analysis that should include uncollected receivables.
Before you begin
Permission: This classic report is controlled by View Admin Reports in the Administrator section of the security role (Configuration > Security > Security roles > the role > Permissions). Select the report-area action that applies to this report (for example Sales, Collections, Revenue, or Accounting). Classic report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.
Run the report
- Select the center.
- Open the Reports dashboard, type the report name in Search Report, and select Sales - Product. Classic reports appear on the Reports Dashboard only when they are enabled under Configuration > Reports > List of reports (Reports V1).
- Set filters and click Refresh.
Filter reference
| Filter | Description |
|---|---|
| Business Unit | Limits to a business unit, or All. |
| Sale Date | Preset or Custom (max 6 months). |
| Invoice Status | All / Closed / Open. Closed for payroll. |
| Sold By | Specific employee or All. |
| Product Name, Tag | Free-text filter by product or tag. |
Column reference
| Column | Description |
|---|---|
| Invoice No. | Invoice number; click to view details. |
| Product Name | Click to view product details. |
| Product Code | Unique product identifier. |
| Receipt No | Generated on invoice close (0 for open). |
| Category / Sub Category | Category hierarchy the product belongs to. |
| Vendor | Vendor associated with the product. Contact your CSM if this filter is not visible. |
| Sale Date / Guest / Guest Center | Sale date, purchaser, and their home center. |
| Employee Code / Sold By | Employee code and name of the seller. |
| Quantity | Units sold on the invoice. |
| Promotion | Manual / Price Adjusted / Campaign name / Liability Type: Name / Cancellation Fee / No Show Fee. |
| Price | Product Price (from Resource > Products > Price) or Adjusted Price. |
| Discount | Discount on the sale (excludes redemptions). |
| Membership Redemption | Amount paid via membership credits (when liability sale is taxed). |
| Prepaid Card Redemption | Amount paid via prepaid card. |
| Cashback Redemption | Amount paid via cashback coupon. |
| Net Price | Sale Price β (Discount + Redemption). |
| Tax | Tax on Net Price or Sale Price per tax definition. |
| Shipping Charge | Shipping for online retail purchases. |
| Package Redemption | Value of package benefits used. |
| Price Paid | Total amount paid for the product. |
| Sale Value | Amount due or collected via Cash / Card / Check / Custom-Financial. 0 for redemption-only sales unless Include Redemption in Sales is enabled. |
| Payment Type | Cash / CC Online / CC Offline / Check / Custom β or Membership Name / Gift Card Number / Prepaid Card Number / Loyalty Points for liabilities. |
| Created By / Closed By / Closed On | Audit fields for the invoice. |
| Status | Open or Closed. |
| Guest Code / First Visit / Member | Guest identity and visit attributes. |
| Business Unit | Business unit the product belongs to. |