Gift card by time period report
Understand how to use the Gift card by time period report to track your gift card activities handled by your business.
In this article
Gift card by time period report explained
The Gift Card by Time Period report gives you an overview of your gift card activities (Issues, Expirations, Redemptions, and Refunds) for a selected date range. This report helps you monitor and adjust your gift card usage in your business:
- Loss Prevention -A significant gap between issued and sold gift card values may lead to losses upon redemption. Monitoring this helps inform future gift card pricing decisions.
- Policy Review - If you have a high amount of expired gift card value, it may indicate an overly strict policy. Consider customer feedback and adjust the expiration policy if needed.
Using the Gift card by time period report
The Gift card by time period report data results can be grouped by periods and filter by location for easy viewing.
Grouping options
Use the "Group by" drop-down menu to identify trends based on when the gift card activity took place. You can group by:
- Day
- Week
- Month
- Quarter
- Year
Date range
Select a date range using the calendar drop-down menu to view data within a specific time frame. The date range filter is based on the day the activity took place, and includes the start and end date of the selected date range.
Filter options
Use the filter drop-down menu to narrow down the data by:
- Location - The business location where the gift card activity took place.
Understanding the Gift card by time period data fields
Depending on your filters and groupings, you’ll see the following data fields:
- Opening balance - Gift cards remaining balance at the start of the selected date range.
- Issued value - Total value of gift cards issued within the selected date range, linked to the location where the gift card was sold.
- Sold value - Total value of gift cards sold within the selected date range.
- Expired value - Total value of gift cards that expired within the selected date range.
- Redeemed value - Total value of gift cards redemption and redemption refund value linked to the location where the gift card is being used as a payment method.
- Refunded value - Total value of gift card sale refunded linked to the location where the gift card is issued / sold.
- Closing balance - Gift cards remaining balance at the end of the selected date range.
NOTE:
- The Redemption value for gift cards includes redemption refunds. This value could be negative if there are only redemption refunds during the selected period.
- The Gift card expiration value refers to the remaining balance on a gift card at the time it expires.
- Redeeming Gift Cards at a different location than the original sale can affect the data when filtering by location.
Top Tip
- For a summary view of each gift card, use the Gift Card List Report.
- For a detailed view of each gift card activity, use the Liability Activity Report.