If you do not see this report in your Report Center, you do not currently have permission to run it. If you feel that this report could be useful for you, but it doesn’t appear on your list, please contact your user administrator for assistance.
IS THIS REPORT RIGHT FOR ME?
Uses |
* Shows the age of your gift card liability, by card template. See: What are Card Templates and Tiers? |
Restrictions |
* This report can only be run for one month at a time. (The report output shows the ending liability balances for the month the report was run.) |
SAMPLE OUTPUTS
All Stores, One Month
One Store, One Month
Note: These examples are only showing balances through 22 months - the actual report will show information in individual columns for months 0 - 59. The last column on the report will show information for months 60 and more (in one column).
HOW DO I INTERPRET THIS REPORT?
Column Name | Definition |
Card Template | The name of the card. See What are Card Templates and Tiers? for more information on card templates. |
Total Liability | Total amount of liability for your merchant |
Discount Balance | The amount of stored value discount on your cards |
Net Liability | The total liability minus the stored value discount amount |
0…59 Month | The month in which the liability below resides |
60+ Month | The total liability over 60 months old |
Interpretation Summary |
This report shows the allocations of gift card liability over time, organized by card template. All liability values are net stored value (or stored value minus discount, where applicable). The aging calculations depend on the non-expiring card activity selected while running the report. If you choose “Sale” as the non-expiring card activity, even if a card is reloaded its liability will appear in the month in which it was sold. If you choose “Sale and Reload” the liability will appear in the month in which the card was last reloaded (or sold). If you choose “Guest Activity”, the liability will appear in the month in which the card last had activity, including sales, redemptions and reloads (but not including balance inquiries). It is important to note that if this report is run back in time (not for the current month), ONLY the “Sale” non-expiring card activity designation will return accurate data. “Sale and Reload” and “Guest Activity” should only be used when running this report for the current month. If a merchant has been a customer of Paytronix for less than 5 years, and did not migrate a gift card program over when engaging Paytronix, these columns will show as zero values. The report will always show columns up to 60+ months as headings, regardless of activity. |
I LIKE IT, SO HOW DO I RUN THIS REPORT?
First enter the date range for which you’d like to run the report. The report can be run for one month at a time.
Quick Period: Here you can choose Last Month or This Month.
Manual Date Entry: Here you can select your desired month and type in the year.
Check the “All” box if you would like to include all stores. You can also enter a specific store code to see one store or select a store group from the drop down box.
Select the desired Card Template from the drop down menu or leave “All” selected.
Select the desired Non-Expiring Card Activity. This selection determines which type of activity used in determining the last-use date of the card. If you want all card liability to appear in the month the card was sold, select “Sale”. If you want all card liability to appear in the month the card was last reloaded, select “Reload”. If you want all card liability to appear in the month the card was last used (this includes sale, redemptions and reloads), select “Guest Activity”. It is important to note that if this report is run back in time (not for the current month), ONLY the “Sale” non-expiring card activity designation will return accurate data. “Sale and Reload” and “Guest Activity” should only be used when running this report for the current month
.
Note: This report is not updated in real time; activity up to 45 minutes in the past may not be included.
For further assistance, please contact your solutions consultant or customer success manager, or email [email protected].