ZenotiHelp

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.