Prepaid Card Report: Balance as on Date

The Balance as on Date report provides the prepaid card balance at your center on the selected date. You can view the following details for active prepaid cards:

  • Remaining balance on prepaid cards purchased at the center
  • Purchase price and value
  • Purchase date and expiration date

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 Balance as on date report from the list.
    The report opens in a new tab.
    By default, the report opens to the current date. To view the report for a different date, click the calendar icon, and select the required date.
  5. Click Refresh.
  6. 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 Invoice number of the prepaid card purchased.
Click the invoice number to open the invoice details.
Guest The full name of the guest.
Click the guest's name to open the guest's profile.
Receipt No The receipt number of the prepaid card purchased.
Purchase Price The amount for which the guest purchased the prepaid card.
Prepaid Card 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.
Purchase Date The date when the prepaid card was purchased.
Expiration Date The date when the prepaid card expires.
Balance Value The remaining amount available on the prepaid card after redemption.
Note: If the value is different from the purchase price, then 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 balance value on the card is $80 [Value ($150) - Amount redeemed ($70)].
Balance Price The remaining amount available on the prepaid card price after redemption.
Note: If the value is different from the price, then this column reflects the apportioned amount remaining on the price 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 balance price on the card is $30 ($100-$70).
Have more questions? Submit a request

Comments