ZenotiHelp

Product returns report

ZTZenoti Docs Team Updated September 5, 2026 4 min readReference

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: Inventory manager, retail manager, center admin

The product returns report shows guest-side product return transactions — returns by date, product, category, refund method, and financial impact. Use this report to track return volumes, identify frequently returned products, and understand the revenue impact of returns.

This is a legacy report available under the classic reporting framework.

Scope: This report covers guest returns only — returns initiated through POS (Point of Sale) or Webstore by or on behalf of a guest. Vendor returns (return purchase orders, where the center sends stock back to a vendor) are NOT in this report; they appear in the Inventory orders report. The report covers BOTH in-center POS returns AND online (Webstore V2 / CMA (Customer Mobile App)) returns.

Data refresh: Real-time on Refresh.


On this page


Before you begin

  • Enable the report for your organization under Configuration > Reports > List of reports.
  • The setting Allow to restock returned products at Configuration > Inventory > Stock actions controls whether returned products can be restocked. If you see Restock Status values you didn't expect, verify this setting.

Permission: Returns under View Inventory Reports in the Inventory Manager section of the security role — Required to access the Product returns report.

Run the report

  1. Select the center for which you want to run the report.
  2. Navigate to Reports > Inventory.
  3. Select the Returns report.
  4. Set the date range, product type, and additional filters from the Filter reference.
  5. Click Refresh.

To export the report, click the Excel or CSV icon.

Filter reference

Filter Values Description
Date range From / To dates Filters by return transaction date.
Product Type Retail / Consumable / Both Three-state classification: Retail, Consumable, or Both.
Guest Search guest Filter to returns by a specific guest.
Restock Status Yes / No / Partial Filter by restock disposition (see Column reference).
Return Reason Configured reasons (per Set up stock actions) Filter by reason code.
Channel POS / Webstore V2 / CMA Origin channel of the return.

Column reference

Column Type Description
Return Date Date When the return was processed.
Invoice Reference Identifier The original sale invoice the return relates to.
Product Code / Name Text The product returned.
Product Type Enum Retail or Consumable.
Quantity Returned Number Units returned (always positive in this report).
Return Value Currency The refund amount before tax adjustments. Equals Sale Price × Quantity, unless adjusted at return.
Tax Adjustment Currency Sales tax reversed on the refund.
Refund Method Enum How the refund was issued: Original Tender, Store Credit, Gift Card, Cash, Cheque. For partial refunds split across methods, this column shows a comma-separated list.
Return Reason Text Configured reason from the Configuration > Inventory > Stock actions reasons list.
Restock Status Enum Yes (returned to stock), No (discarded), Partial (partial restock + partial discard for the same return).
Restocked Quantity Number The number of returned units actually returned to stock. May be < Quantity Returned when Restock Status is Partial.
Discarded Quantity Number The number of returned units written off (Quantity Returned − Restocked Quantity).
Guest Name / Phone / Email Text The returning guest.
Channel Enum POS, Webstore V2, or CMA.

Worked example

A center wants to identify the top return reasons for April.

  1. Set Date range: 2026-04-01 to 2026-04-30.
  2. Product Type: Retail.
  3. Click Refresh.

Sample (4 returns):

Return Date Invoice Product Qty Return Value Refund Method Return Reason Restock Status Restocked Discarded
2026-04-04 INV-2055 Shampoo A 1 $25 Original Tender Wrong product Yes 1 0
2026-04-12 INV-2098 Hair Oil C 2 $80 Store Credit Damaged on receipt No 0 2
2026-04-18 INV-2118 Conditioner B 3 $96 Original Tender, Gift Card Skin reaction Partial 1 2
2026-04-25 INV-2140 Hair Oil C 1 $40 Cash Damaged on receipt No 0 1

Insight: "Damaged on receipt" accounts for 3 of 4 returns. Discarded units (5 of 7) cost the center $200+ in lost stock. Investigate vendor packaging or receiving handling. The split-tender refund on INV-2118 (Original Tender + Gift Card) is captured in the Refund Method column.

Tips

  • High return rates by product. If you see frequent returns for the same product, review product quality, shelf life, vendor packaging, or guest expectations. Frequent returns may indicate a product listing issue or a mismatch between the product description and the actual product.
  • Restock vs. discard analysis. Sum Restocked Quantity vs. Discarded Quantity to estimate the actual stock recovered through returns. High Discarded percentages flag receiving / handling issues at the center.
  • Reconcile against Inventory sales. The same returns appear as negative-quantity rows in the Inventory sales report. For net-revenue calculations use that report; for returns-only analysis use this one.

Troubleshooting

Issue Cause Resolution
Return rows missing Date range excludes the return date OR the user lacks permission. Verify date range; verify the Returns check box under View Inventory Reports.
Restock Status shows blank or unexpected values The org-level Allow to restock returned products setting was changed mid-period; older returns reflect the prior policy. Document the policy change date; segment the report by date range.
Tax Adjustment is zero on a return The original sale was tax-exempt OR the return was processed with no tax reversal. Inspect the original invoice for tax application.
Refund Method shows multiple values The return was split-tender-refunded (e.g., partial Original Tender + partial Store Credit). Review the comma-separated values; cross-check against the return record on the invoice.
Was this article helpful?
Your feedback helps us improve our documentation.