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:
Follow these steps to run the report:
- Make sure you have selected the center for which you want to run the report.
- On the main menu, click the Reports tab.
The Reports Dashboard opens.
- Click Marketing > Prepaid Cards (from the filter).
- 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.
- Click Refresh.
- To export the report, click the Excel () or .CSV icons ().
|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.
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.
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.
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).