Prepaid Card Report: Details

The Prepaid Card Details report tracks essential details of all prepaid cards issued at your location. The report displays details for both active and expired prepaid cards.

Use this report to:

  • Track the price and value of prepaid cards issued from your center
  • View the purchase invoice, date, and expiry details
  • View outstanding balances on the prepaid cards
  • Check if any refund was processed on the purchase of the prepaid card

This article covers the following:

Navigation

Follow these steps to run the report:

  1. Make sure you have selected the center for which you want to run the report.
  2. On the main menu, click the Reports tab.
    The Reports Dashboard opens.
  3. Click Marketing > Prepaid Cards (from the filter).
  4. Select the Details report from the list.
    The report opens in a new tab.
  5. From the date drop-down list, select either 1, 2, 3, 6 months or custom.
    If you choose Custom from the list, then specify the custom dates in the From and To fields.
    Note: For custom dates, you can view data for a maximum date range of 6 months at a time.
    Example:
    To view data from January to August, first view data from January to June and then view data from July to August.
  6. Click Refresh.
  7. To export the report, click the Excel () or .CSV icons ().

Column Descriptions

Column Description
Code The prepaid card number.
The card number is typically a code associated with the prepaid card. The front desk or guest can use this code to redeem a prepaid card, check the balance, or view other details such as the prepaid card expiry date, price and value of the card, and balance.
Invoice No The prepaid card purchase invoice number.
Click the invoice number to view the prepaid card purchase invoice.
Receipt No The receipt number of the purchased prepaid card.
Name The full name of the guest.
Click the guest's name to open the guest's profile.
Center The center where the prepaid card was purchased.
Purchase Date The date when the prepaid card was purchased.
Expiration Date The date when the prepaid card expires.
Purchase Price The price at which the prepaid card was purchased.
Value Value of the prepaid card purchased.
Value is the total worth of a prepaid card, which includes the extra amount that the organization adds to the card in addition to the Price.

Example:
If a guest purchases a prepaid card for $200 (price) and the card value is $250, the guest can later redeem the card for $250 worth of purchases or services.
Balance The remaining amount available on the prepaid card after redemption.
Note: If value is different from the purchase price, this column reflects the amount remaining on the value of the prepaid card.

Example:
If the prepaid card price is $100 and the value is $150, and if the guest has redeemed the card for $70, then the remaining balance on the card is $80 ($150-$70).
One-time Use
  • If the prepaid card sold is for one-time use only, then the column displays Yes.
    Note: One-time use cards are usable only once and any balance amount on the card automatically lapses after the first use.
  • If the prepaid card sold can be used anytime within its expiration date, then the column displays No.
Refund amount The amount refunded for the purchase of the prepaid card (if any). The field displays the amount as a negative value.

Example:
If the prepaid card was purchased for price and value $100, and later a refund of $50 was processed on its purchase, then the Refund Amount column displays -$50.
Refund Date The date on which the amount was refunded on the purchase of the prepaid card.
Have more questions? Submit a request

Comments