Loyalty points report
ZTZenoti Docs Team Updated September 4, 2026 2 min readReference
The Loyalty Points report is the primary loyalty report, providing a comprehensive view of all loyalty point activity. Use it for reviewing point balances, tracking accruals, finding expiring points, auditing referral points, or grouping data by center, guest, program, tier, or status.
On this page
Before you begin
Permission: Loyalty Points Report under Marketing in the Reports(V2) section -- Required to access this report.
Filters
| Filter | Description |
|---|---|
| Centers | Multi-select list of centers (only centers you have access to) |
| Date Type | Controls what the date range filters against: Earned On Date (default), Balance as on date, or Expiry Date |
| Start Date / End Date | The date range applied to the selected date type |
| No Expiry | When checked, includes point records with no expiry date (perpetual points) |
| Program | Filter by one or more specific loyalty programs |
| Action | Filter by one or more earning actions (for example, "Purchase a service", "Referring a new guest") |
| Current Tier | Filter to guests currently in a specific tier |
| LP Status | Filter by point status (Active, Expired, Fully Redeemed, etc.) |
| Is Referrer | Filter to referral-earned points only, non-referral points only, or both |
| Guest | Filter to a specific guest by name or code |
| Group By | Optional grouping: Center Name, Loyalty Point Program, Guest Name, Is Referrer, Current Tier, Earned On Date, Expiry Date, LP Status |
Summary totals
The report header displays grand totals across the entire filtered result:
| Column | Definition |
|---|---|
| Accrued Points | Total loyalty points earned |
| Value | Monetary value of accrued points (points x exchange rate) |
| Redeemed Value | Total value of points redeemed as payment |
| Refunded Value | Total value of points reversed due to refunds |
| Expired Value | Total value of points that expired unredeemed |
| Balance Value | Total remaining active point value |
| Balance Points | Total remaining active point count |
Detail columns
Each row represents a single points-earning event:
| Column | Definition |
|---|---|
| Accrued Center | Center where points were earned |
| Invoice No | Invoice that triggered the accrual (blank for non-invoice points) |
| Receipt No | Final receipt number |
| Program Name | Loyalty program, tier, or action label |
| Guest Name | Guest who earned the points |
| Guest Code | Unique guest identifier |
| Is Referrer | Whether points were earned through a referral |
| Current Tier | Tier the guest was in when points were accrued |
| Earned On Date | Date points were credited (center's timezone) |
| Start Date | Date points become eligible for redemption |
| Expiry Date | Date points expire |
| Accrued Points | Points earned (positive) or reversed (negative) |
| Value | Monetary value of accrued points |
| Redeemed Value | Value already redeemed from this entry |
| Refunded Value | Value reversed from this entry due to refunds |
| Expired Value | Value that expired from this entry |
| Balance Value | Remaining usable value |
| Balance Points | Remaining points available for redemption |
| LP Status Name | Status: Active, Expired, Fully Redeemed, Partially Redeemed, Refunded, or Voided |
| Action Name | The earning action that generated these points |
Grouping behavior
When a Group By dimension is selected, rows are aggregated by that dimension. Numeric columns show summed values for the group. Non-grouped columns show NULL.
Was this article helpful?
Your feedback helps us improve our documentation.