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
All Stores, Unlimited Days
One Store, Unlimited Days
HOW DO I INTERPRET THIS REPORT?
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 |
The first column of the report indicates what type of expiration has occurred. Next is the state/province of expiration. This is followed by the number of accounts that have expired over the date range given. The next several columns give a summary on the total activity on the stored value wallet: the total amount added over the life of the cards that expired, 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. |
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. |
# of Accounts | The total number of accounts that expired over the given date range. |
Stored Value - Total $ Added | The total amount of stored value added over the life of the cards on the cards that expired. |
Stored Value - Total $ Redeemed | The total amount of stored value redeemed over the life of the cards on the cards that expired. |
Stored Value - Dormancy $ Redeemed | The total amount of dormancy fees assessed over the life of the cards on the cards that expired. |
Stored Value - SV Write-Off | The total amount of stored value written off the cards as part of the expiration. |
Discount - Total Disc Added | The total amount of discount added over the life of the cards on the cards that expired. |
Discount - Total Disc Redeemed | The total amount of discount redeemed over the life of the cards on the cards that expired. |
Discount - Dormancy Disc Redeemed | The total amount of dormancy fees assessed on the discount wallet over the life of the cards on the cards that expired. |
Discount - Disc Write-Off | The total amount of discount written off the cards 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 cards as part of the expiration. |
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.
Click Submit!