Article Content
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 |
* This is used by merchants that have automated expiration/escheatment/exemption configured. |
Restrictions |
* None |
SAMPLE OUTPUTS
Example Report
THIS LOOKS GOOD, NOW WHAT DOES IT MEAN?
To explain this report, a little background on how Paytronix Expiration is set up can be helpful. Merchants may request that they have gift cards configured such that they will automatically “expire” after a specified period of time. This is controlled at the card template level in Paytronix, where merchants can indicate which specific gift cards are expirable, and which are not. Once it is determined that expiration is wanted for some/all gift card templates, the next step is assigning a “state of escheatment” for every store location. Some merchant default all their stores to the state in which their company was incorporated, while others use the geographical location of the store to determine this value. The merchant makes the determination as to what is the correct/appropriate setting for them. The escheatment state on the store of activation will govern how and when a card is expired with one exception. If gift cards are registered (a guest goes online and provides their mailing address), the state the guest provided at the time of registration will then govern how and when the card will be expired. In addition, the merchant needs to provide the terms by which they want the cards to expire. In Paytronix there are several settings for each state. For every state included in the “state of escheatment”, the following information is needed:
What kind of expiration
Expire = value expires off the card and the value is retained by the merchant
Escheat = value expires off the card and the value is transferred (by the merchant) to the state
Exempt = a specialized type of expiration
How many months before the expiration review occurs?
What month should the expiration review occur?
For most states, filing escheatment occurs on an annual basis. This parameter can be used to have the escheatment event happen in enough time to file the paperwork as required by law.
Keep alive activity. For all cards that will expire, Paytronix needs to know when to “start the clock”. The options for this setting are:
Sale
Sale and reload
Guest activity
No Expiration if Issued Before – if cards were issued PRIOR to a specific date, they should all be ignored for any expiration processing.
When merchants used automated expiration, the cards in the database are processed per the specs configured in the expiration set-up. As a card is taken through the expiration process, all value is removed from the it (both stored value and any discount value), and the card’s status is changed to “Expired” or “Escheated” (based on the state’s label). These cards are no longer usable in the Paytronix system (or through the merchant‘s POS) as the value has been removed, and cards are no longer active.
Note: Merchants are responsible for ensuring that the expiration configuration is consistent with any legislation for the appropriate jurisdictions. Paytronix will offer support in ensuring the settings match what is requested, but the merchant is responsible for determining what the settings should be.
Interpretation Summary |
This report provides the detail information for each card that has expired over the date range given. The first column tells what kind of expiration was used. Next is the state/province whose rules were followed in expiring the cards. The next series of columns reference the enrollment (activation) store for the card: the store code, store name, and the date the card was activated. Next are the last activity date on the card, the card template and the card number. The next several columns give a summary on the total activity for that card on the stored value wallet: the total amount added over the life of the card, the total redeemed, the total that went to dormancy fees (if applicable), and then the total amount expired off the stored value wallet is in the column “SV Write-Off”. The next set of columns covers the same information, but on the stored value Discount Wallet. The last set of columns nets out the stored value and discount amounts. Finally, if the card has been registered, the contact information for the guest is included in the last several columns. If the card is not registered, these fields are blank. |
Column Name | Definition |
Expiration Type | What kind of expiration has been configured for the state, this is set my the merchant. |
Expiration State/Province | The “geographic” state whose cards are being expired. |
Store Code | The code of the store in which the card was enrolled (activated). |
Store Name | The name of the store in which the card was enrolled (activated). |
Enrollment Date | The date the card was enrolled (activated). |
Last Activity Date | The last time the card was used. |
Card Template | The name of the templates. |
Card Number | The card (or account) number - this is a unique identifier. |
Stored Value - Total $ Added | The total amount of stored value added over the life of the card. |
Stored Value - Total $ Redeemed | The total amount of stored value redeemed over the life of the card. |
Stored Value - Dormancy $ Redeemed | The total amount of dormancy fees assessed over the life of the card. |
Stored Value - SV Write-Off | The total amount of stored value written off the card as part of the expiration. |
Discount - Total Disc Added | The total amount of discounts added over the life of the card. |
Discount - Total Disc Redeemed | The total amount of discounts redeemed over the life of the card. |
Discount - Dormancy Disc Redeemed | The total amount of dormancy fees assessed on the discount wallet over the life of the card. |
Discount - Disc Write-Off | The total amount of discounts written off the card as part of the expiration. |
Net - Added | The difference in the stored value and discount wallet added. |
Net - Redeemed | The difference in the stored value and discount wallet redeemed. |
Net - Dormancy Redeemed | The difference in the stored value and discount wallet dormancy fees. |
Net - Write-Off | The net amount of stored value less discount written off the card as part of the expiration. |
Name | The first and last name of the guest provided at the time of registration |
Address | The mailing address for the registered guest. |
City | The city of the guest. |
State/Province | The state/province of the guest. |
Zip/Postal Code | The zip/postal code of the guest. |
I LIKE IT, SO HOW DO I RUN THIS REPORT?
First enter the date range for which you’d like to run the report.
Quick Date: Here you can choose Yesterday, Today, the current month, or last month. If you have set up by your custom fiscal periods, you may also choose to run the report by fiscal period.
Manual Date Entry: Here you can type in your desired date range or find the day by clicking on the calendar icon to the right.
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 desired state from the drop down menu or leave “All” selected.
Click Submit!