Package benefits detail report
The Package Benefits Detail report provides a granular view of benefit allocation, redemption, and remaining quantities and values for each benefit within each guest's package. Use this report to track individual benefit usage, identify underutilized benefits, and analyze redemption patterns.
On this page
- Before you begin
- Filter criteria
- Column descriptions
- Liability type toggling
- Grouping options
- Footer aggregations
- Related articles
Before you begin
Navigation: Reports > search for and select Package Benefits Detail.
Permission: Package Benefits Detail 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. You can run the report for a single center or across multiple centers you have access to, depending on your organization's setup.
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, expiry date, etc.). |
| Centers | One or more centers to include in the report. |
| Categories | Filter by one or more package categories. |
| Liability type | Controls how monetary values are calculated (sale-based or payment-based). |
| Guest | Filter to a specific guest. |
| Packages | Filter to specific packages. |
| Package names | Filter by one or more package program names. |
| No expiry | Include packages that have no expiry date set. |
| Group column | Select a grouping dimension to aggregate results. |
Column descriptions
Each row represents a single benefit item within a guest's package.
| Column | Description |
|---|---|
| Sale Center | The center where the package was sold. |
| Invoice# | The invoice number for the package sale. |
| Package Code | The unique code identifying the package. |
| Package Name | The name of the package program. |
| Package Category | The category the package belongs to. |
| Guest Name | The full name of the guest who owns the package. |
| Sale Date | The date the package was sold. |
| Start Date | The date the package (and its benefits) became active. |
| Expiry Date | The date the package benefit expires. |
| Expiry Date (Grace Period) | The expiry date including any grace period extension. |
| Benefit Type | Whether the benefit is a Service, Product, or Class. |
| Benefit Name | The name of the service or product benefit. |
| Quantity | The total quantity of this benefit included in the package. |
| Value | The total monetary value of this benefit. |
| Redeemed Quantity | The number of units of this benefit that have been redeemed. |
| Redeemed Value | The monetary value of redeemed benefits. |
| Balance Quantity | The remaining quantity available for redemption. |
| Package Status | Current status of the package (Active, Frozen, Expired, etc.). |
Liability type toggling
Toggle between sale-based and payment-based liability modes:
- Sale-based — Values reflect the original sale allocation of each benefit.
- Payment-based — Values reflect actual payments collected for each benefit.
Grouping options
Use the Group column filter to aggregate benefit data by dimensions such as center, package name, benefit type, or guest. Grouped views show subtotals for each group.
Footer aggregations
Numeric columns (Quantity, Redeemed Quantity, Balance Quantity, Value, Redeemed Value) display sum totals in the footer row.