We're pleased to announce the September 2026 release, introducing four new daily Loyalty Program reports that give you full daily visibility into the lifecycle of reservation rewards — from the moment they are issued through to redemption, expiry, and available usage.
What's new
This release adds four new daily reports under CRM Reports → Loyalty Program Reports, giving you a complete audit trail of reward activity for any given day.
Rewards - Daily Issued
A new Rewards - Daily Issued report is now available under CRM Reports → Loyalty Program Reports. It shows every reward that was issued on the selected Report Date, giving you a complete audit trail of reward creation activity for any given day.
How to access Rewards - Daily Issued
From the left menu, click CRM Reports.
Select Loyalty Program Reports.
Select the Rewards - Daily Issued tab.
Report Date filter: select the date you want to review. The report returns all rewards issued on that day.
Property filter: narrow results to a specific hotel, or leave as All to include all properties.
Include PII: check this box to display guest first name, last name, and email. When unchecked, these fields are blank.
Columns returned: ReportDate, RewardIssuedID, RewardName, RewardCode, RewardValue, HotelCode, HotelName, LoyaltyMemberID, firstname, lastname, email, InitialUsageCount, BeginDate, ExpireDate, IssuedTime.
Export: download the results using the Export button.
Rewards - Daily Redeemed
A new Rewards - Daily Redeemed report is now available under CRM Reports → Loyalty Program Reports. It returns one row per individual redemption (QR-code scan) that occurred on the selected Report Date. Because rewards can be multi-use, a single reward may appear more than once if it was scanned multiple times on the same day.
Rewards - Daily Redeemed report showing the active tab, Report Date and Property filters, and Include PII checkbox.
Column headers for the Rewards - Daily Redeemed report, including redemption-specific fields.
How to access Rewards - Daily Redeemed
From the left menu, click CRM Reports.
Select Loyalty Program Reports.
Select the Rewards - Daily Redeemed tab.
Report Date filter: select the date you want to review. The report returns all redemption scans that occurred on that day.
Property filter: narrow results to a specific hotel, or leave as All.
Include PII: check this box to display guest first name, last name, and email.
Columns returned: ReportDate, TransactionID, RewardIssuedID, RewardName, RewardCode, RewardValue, HotelCode, HotelName, LoyaltyMemberID, firstname, lastname, email, RedemptionDate, ReservationConfirmationNumber, RedemptionHotelCode, InitialUsageCount, RemainingUsageCount, CurrentRewardStatus.
Export: download the results using the Export button.
Rewards - Daily Expired Usage
A new Rewards - Daily Expired Usage report is now available under CRM Reports → Loyalty Program Reports. It returns one row per reward that had a valid usage slot on the selected Report Date but was not redeemed on that day. A reservation reward has one valid usage day per night within its validity window (from Begin Date up to, but not including, Expire Date) — if that day has passed with no redemption recorded, it appears in this report as an expired usage slot.
Rewards - Daily Expired Usage report showing the active tab, Report Date and Property filters, and Include PII checkbox.
Column headers for the Rewards - Daily Expired Usage report, including expiry-specific fields.
📌 Note: This report captures partial day-level expirations. A reward may still be active with remaining usage, this report identifies individual days within the validity window that were missed, not only fully expired rewards.
How to access Rewards - Daily Expired Usage
From the left menu, click CRM Reports.
Select Loyalty Program Reports.
Select the Rewards - Daily Expired Usage tab.
Report Date filter: select the date you want to review. The report returns all usage slots that were valid on that day but went unredeemed.
Property filter: narrow results to a specific hotel, or leave as All.
Include PII: check this box to display guest first name, last name, and email.
Columns returned: ReportDate, RewardIssuedID, RewardName, RewardCode, RewardValue, HotelCode, HotelName, LoyaltyMemberID, firstname, lastname, email, BeginDate, ExpireDate, CurrentRewardStatus, RemainingUsageCount, ExpiredUsageDate, TotalRedemptionCount, InitialUsageCount.
Export: download the results using the Export button.
Rewards - Daily Available Usage
A new Rewards - Daily Available Usage report is now available under CRM Reports → Loyalty Program Reports. It returns one row per reward that had a valid usage slot on the selected Report Date, regardless of whether it was redeemed or not. Cancelled rewards are excluded. This is the superset report, designed for daily reconciliation — for any given date:
Available Usage = Redeemed + Expired Usage
The WasRedeemed column (1 = redeemed, 0 = not redeemed) lets you split the report into its two subsets directly within a single export.
Rewards - Daily Available Usage report showing the active tab, Report Date and Property filters, and Include PII checkbox.
Column headers for the Rewards - Daily Available Usage report, including the WasRedeemed reconciliation field.
How to access Rewards - Daily Available Usage
From the left menu, click CRM Reports.
Select Loyalty Program Reports.
Select the Rewards - Daily Available Usage tab.
Report Date filter: select the date you want to review. The report returns all valid usage slots for that day.
Property filter: narrow results to a specific hotel, or leave as All.
Include PII: check this box to display guest first name, last name, and email.
Columns returned: ReportDate, RewardIssuedID, RewardName, RewardCode, RewardValue, HotelCode, HotelName, LoyaltyMemberID, firstname, lastname, email, BeginDate, ExpireDate, CurrentRewardStatus, RemainingUsageCount, InitialUsageCount, TotalRedemptionCount, WasRedeemed.
Export: download the results using the Export button.
Scheduling the reports
All four reports are available as scheduled report types. You can configure them to run automatically on a recurring basis and have results delivered by email — useful for daily monitoring without needing to log in manually.
To set up a schedule, navigate to the report scheduling area and select Loyalty Program Reports as the Report Category. All four new reports appear in the Report Type dropdown.
Once a report type is selected, configure the remaining schedule fields.
Schedule Name: give the schedule a descriptive name.
Begin Date / End Date: optionally set a date range for the schedule to run within.
Include PII: check to include guest personally identifiable information in the scheduled output.
Search Hotel: filter to a specific property, or leave as All.
Time Zone: select the time zone for the schedule.
Export Format: choose the output format (e.g. CSV).
Frequency: set how often the report runs (e.g. Once, Daily).
Schedule Begin Time: set the time the scheduled run should start.
Send Email To: enter one or more email addresses (separated by semicolons) to receive the report output.
Active: turn on to activate the schedule.
How to access this update
These reports are automatically available in the CRM. No action is required to receive these changes.
Access to the Loyalty Program Reports is controlled by the Loyalty Program Report permission. Users without this permission will not see the Loyalty Program Reports section under CRM Reports. Contact your administrator if you require access.