Packages report
The Packages report is the primary package report in Zenoti, providing a comprehensive, filterable view of all package activity. This report covers sales, pricing, status, benefit values, and refund details across your package programs.
Use this report for package performance analysis: reviewing sales trends, tracking benefit redemption and remaining values, monitoring package statuses, auditing refunds, or grouping data by center, guest, category, or package type.
On this page
- Before you begin
- Filter criteria
- Column descriptions
- Understanding the "Balance As On Date" filter
- Liability type toggling
- Drilldown links
- Footer aggregations
- Related articles
Before you begin
Permission: Packages Report under Marketing in the Reports(V2) section of the security role — required to open this report.
- Select the centers for which you want to run the report.
Filter criteria
| Filter | Description |
|---|---|
| Date range | The start and end dates for the report period. |
| Date type | Determines what the date range filters against: sale date, balance-as-on date, or expiry date. |
| Centers | One or more centers to include in the report. |
| Package categories | Filter by one or more package categories. |
| Liability type | Controls how monetary amounts are calculated. Sale-based: Amounts reflect the sale price. Payment-based: Amounts reflect the payment or revenue value. |
| No expiry | Include packages that have no expiry date set. |
Column descriptions
Each row represents a single guest package record with its current state and financial details.
| Column | Description |
|---|---|
| PackageName | The name of the package program. |
| PackageCode | The unique code assigned to the package. |
| GuestName | The full name of the guest who owns the package. |
| GuestCode | The unique guest identifier code. |
| CenterName | The center where the package was sold. |
| SaleDate | The date the package was sold to the guest. |
| StartDate | The date the package validity began. |
| ExpiryDate | The date the package validity ends. |
| PackagePrice | The price paid for the package. |
| TaxAmount | The tax amount charged on the package. |
| Status | Current package status (Active, Frozen, Expired, Inactive, Active(Refunded), Refunded, Closed). |
| RedeemedValue | The total monetary value of benefits redeemed. Clickable — drills down to individual redemption details. |
| RefundedValue | The amount refunded on the package. Clickable — drills down to refund details. |
| RemainingValue | The remaining monetary value of unused benefits. |
| CategoryName | The package category the package belongs to. |
| PackageType | Whether the package is Day, Series, or Custom. |
| SoldBy | The employee who completed the sale. |
| PaymentMode | The payment method used for purchase. |
Understanding the "Balance As On Date" filter
When you select Balance as on date as the date type, the report behaves differently from the sale date or expiry date filters:
- Status column — Always shows the real-time (current) status of each package, regardless of the selected date. For example, if a package is currently Expired, it shows as Expired even if you select a past date when it was Active.
- Balance columns (RedeemedValue, RemainingValue) — Show the point-in-time values as of the selected date. For example, selecting a date two months ago shows the remaining value as it was on that date, not the current remaining value.
This distinction is important for liability reconciliation: the balance columns give you an accurate snapshot of what the financial position was at the selected date, while the status column tells you where each package stands today.
Liability type toggling
Toggle between sale-based and payment-based liability modes to view different financial perspectives:
- Sale-based — Values reflect the original sale price of the package and its benefits.
- Payment-based — Values reflect actual payments collected and revenue recognized.
Drilldown links
The RedeemedValue and RefundedValue columns are clickable drilldown links. Clicking a value opens a detailed view showing individual redemption or refund transactions.
Footer aggregations
Numeric columns (PackagePrice, TaxAmount, RedeemedValue, RefundedValue, RemainingValue) display sum totals in the footer row, giving you a quick summary across all displayed records.