--- title: "Understanding Your Loyalty Points Liability Report" slug: "understanding-your-loyalty-points-liability-report" tags: ["Loyalty and Referrals"] updated: 2025-01-15T14:33:59Z published: 2025-01-15T14:33:59Z canonical: "support.yotpo.com/understanding-your-loyalty-points-liability-report" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.yotpo.com/llms.txt > Use this file to discover all available pages before exploring further. # Understanding Your Loyalty Points Liability Report Products Loyalty & Referrals ###### Supported plans Free, Pro, Premium, Enterprise ###### eCommerce Platform Shopify, Shopify Plus, BigCommerce, Salesforce Commerce Cloud, Adobe Commerce (Magento), Custom The Loyalty Points Liability Report allows you to view the loyalty points balance of all your customers for any given date, and track how many points were earned or spent in a given date range. It also allows you to see how many of their points expired in that date range. Use the report to: - View customer loyalty point balances - Track loyalty point accumulation and redemption in a given date range - Track the expiration of loyalty points in a given date range In this article, you’ll learn how to export and analyze the report. ## How it works The report is a summary of outstanding points, grouped by date or by customer. This helps you manage your financial point liability by showing a breakdown of data regarding daily changes to outstanding points. This is the source of truth regarding customer loyalty point balance and activity. Please note: - The report only includes data from September 11, 2022, and onwards - The report will not include data on customers that have been [excluded from reports](https://support.yotpo.com/v1/docs/customer-management-actions#excludeinclude-in-reports) ### ### Grouping by date A report for a specific date range in the UTC zone will show a row per day within the chosen range. The row details all the changes that happened on that date and the status of points for the beginning and end of the day. Below is a breakdown of the report: | Column name | Description | | --- | --- | | Date | The date on which the point earning activity took place | | Total Points Earned | The sum of all the points earned by customers on this date | | Points Earning Reversed | All point earnings that have been canceled across all customers on a specific date. Common reasons for reverting points earning: - A refund - Manual adjustment - Imported points These points were removed from both the customer’s available point balance and total points earned. | | Total Points Redeemed | All the points that were redeemed by customers on this date. These points were removed from the customers’ available point balances. | | Redeemed Points Reimbursed | All points that have been added back to customers’ point balances on this date. Points are usually returned to a customer due to: - A refund on redemption - Manual adjustment These points were added back to the customer’s available point balances. | | Total Points Expired | All points expired across all customers on a specific date. This includes opt-out points loss - customers lose all their points when opting out of the loyalty program | | Total Outstanding Points (Start of Day) | The total outstanding points at the beginning of the day (00:00 UTC) | | Total Outstanding Points (End of Day) | The total outstanding points at the end of the day (23:59 UTC) This field is equal to the value of the Positive Outstanding Points (End of Day) + Negative Outstanding Points (End of Day) for that date | | Difference in Outstanding Points | The total change in points that happened on a specific date | | Positive Outstanding Points (End of Day) | The total of all **positive points balances** at the end of the day | | Negative Outstanding Points (End of Day) | The total of all **negative points balances** at the end of the day. This can happen if a customer uses points that have been reversed after they were already redeemed. For example, a customer makes a purchase and earns 50 points. Later on, the same customer makes a second purchase and redeems those 50 points for a discount applied to the second purchase. The customer then returns the first purchase and the points earned for that purchase are taken away (reversed). Now the customer has a -50 points balance because they already used their points before they were reversed. This can be used to monitor the health of your loyalty program. | ### Grouping by customer Please note:Customers with a 0-point balance and no activity during the selected date range will not appear in the report. A report for a specific date range in the UTC zone will show a row per customer within the chosen date range. The row details all the changes that happened with that customer’s points and the status of points for the beginning and end of the selected date range. Below is a breakdown of the report: | Column name | Description | | --- | --- | | Email | The customer’s email address | | Total Points Earned | The sum of all the points earned by a customer | | Points Earning Reversed | All point earnings that have been canceled for a customer in the selected date range. Points are usually canceled due to: - A refund - Manual adjustment - Imported points These points were removed from both the customer’s available point balance and total points earned. | | Total Points Redeemed | All the points that were redeemed by a customer in the selected date range These points were removed from the customer’s available point balance. | | Redeemed Points Reimbursed | All points that have been added back to the customer’s point balance in the selected date range. - Points are usually returned to a customer due to: - A refund on redemption - Manual adjustment These points were added back to the customer’s available point balance. | | Total Points Expired | All points expired for a customer in the selected date range. This includes: - Opt-out points - Imported points spent | | Points Balance (Start Period) | The customer’s points balance at the beginning of the selected date range(00:00 UTC of the first day) | | Points Balance (End of Period) | The customer’s points balance at the end of the selected date range (23:59 UTC of the last day) | | Difference in Points Balance | The total change to the customer’s points that happened in the selected date range | ## Exporting the liability report To export a report: 1. In your Yotpo Loyalty & Referrals main menu, go to **Analytics >** [**Reports**](https://loyalty-app.yotpo.com/reports). 2. Click the **Points liability** card. 3. Choose the desired date range. 4. Choose grouping type - by date or by customer. 5. Make sure the relevant email address is filled in and click **Send to email**. ## Comparison to other data sources Points transactions appear in different places when you compare different data sources. Below is a breakdown of the different data sources and how information is portrayed in each source: ### Earning history Note: - In cases where a campaign has a reward delay set to XX days, there may be a significant difference between the number of points reflected in the Liability and Earning History reports for a specific date. The Liability report will typically show a greater value in such instances. - For example, a customer makes a purchase on January 1st, earning 100 points with a 30-day reward delay. The Earning History report shows the points on January 1st (purchase date), while the Liability report will show them on January 31st (when they become available). | **Data type** | **Data source** | **How data is displayed in the source** | | --- | --- | --- | | Refund on earned points | Earning history report and Earning history section of the customer page | The “Date Completed” of an earning rule will automatically change to the date of the refund | | Liability report | The refund will be reflected under the “Points earning reversed” column on the date the refund was made | | Refund on redeemed points | Earning history report and Earning history section of the customer page | The refund will appear as a row in the customer's earning history | | Liability report | The refund will appear under the “Redeemed Points Reimbursed” column on the date the refund was made | ### Redemption history | **Data type** | **Data source** | **How data is displayed in the source** | | --- | --- | --- | | Redemption at checkout (delayed points deduction) | Redemption history report and Redemption history section of the customer page | The date of the redemption is the date when the customer initially made the redemption, even if the order was submitted on a later date | | Liability report | The redeemed points will appear on the date on which they were deducted from the balance | | Manual adjustment (Redeem points) | Redemption history report and Redemption history section of the customer page | The refund will appear as a row in the customer's earning history | | Liability report | Appears under the “Points Redeemed” column | ### Points overview | **Data type** | **Data source** | **How data is displayed in the source** | | --- | --- | --- | | Overview of points liability | Points overview dashboard | Dates may not reflect when changes actually happened in case of a refund | | Liability report | Each change to points appears on the date when it happened (earning/redemption and refund appear on different dates) | | Negative points import | Points overview dashboard | Appear under “Void points” | | Liability report | Appears under “Points earning reversed” | ## Related - [Loyalty & Referrals Reports](/loyalty-referrals-reports.md)