Prepaid card reports
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
This article covers the legacy prepaid card reports available from the Marketing reports menu. For the consolidated grid-view report, see the Prepaid cards report.
The legacy menu provides six prepaid-card views, each with its own date filter and column set. Use them when you need a graphical breakdown or a balance snapshot that is not in the consolidated report.
Before you begin
Permission: This legacy report uses a module-level permission. Grant View Marketing Reports in the Marketing Manager section of Configuration > Security > Security roles > [role] > PERMISSIONS. Legacy report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.
- Select the centers for which you want to run the report.
Navigation: Reports > Marketing > Prepaid Cards
Balance as on Date report
Provides the prepaid card balance at your center on the selected date for active prepaid cards: remaining balance, purchase price and value, and purchase and expiration dates.
| Column | Description |
|---|---|
| Code | Prepaid card number used to redeem, check the balance, or view card details |
| Invoice No | Invoice number of the prepaid card purchase. Click to open the invoice |
| Guest | Guest who purchased the prepaid card. Click to open the guest profile |
| Receipt No | Receipt number of the prepaid card purchase |
| Purchase Price | Amount the guest paid for the prepaid card |
| Prepaid Card Value | Total worth of the prepaid card, including any extra amount added on top of the price |
| Purchase Date | Date when the prepaid card was purchased |
| Expiration Date | Date when the prepaid card expires |
| Balance Value | Remaining amount on the prepaid card (against value) |
| Balance Price | Remaining amount on the prepaid card (apportioned against price) |
Balances (Graphical) report
Graphical and tabular representation of total unused balance on prepaid cards purchased at your center for a selected duration (1, 2, 3, or 6 months, or a custom range up to 6 months).
The graph shows monthly unused balances; click Data to view the tabular equivalent.
Details report
Tracks essential details of all prepaid cards (active and expired) issued at your location.
| Column | Description |
|---|---|
| Code | Prepaid card number |
| Invoice No | Purchase invoice number |
| Receipt No | Purchase receipt number |
| Name | Guest who purchased the prepaid card |
| Center | Center where the prepaid card was purchased |
| Purchase Date | Date of purchase |
| Expiration Date | Date the prepaid card expires |
| Purchase Price | Price paid for the prepaid card |
| Value | Total worth of the prepaid card |
| Balance | Remaining amount on the prepaid card |
| One-time Use | Yes if the card is single-use; any balance lapses after first use. No otherwise |
| Refund Amount | Amount refunded for the prepaid card purchase. Displayed as a negative value |
| Refund Date | Date the refund was processed |
Sales (Graphical) report
Graphical and tabular representation of prepaid card sales in the selected duration. Considers only closed invoices and payments made using cash, checks, credit cards, gift cards, prepaid cards, or custom payments.
The tabular view shows:
- Month -- Month based on the filter
- Prepaid card sales -- Sales revenue for prepaid cards in that month
- #Prepaid cards -- Number of prepaid cards sold in that month
Revenue (Graphical) report
Graphical and tabular representation of the revenue realized when prepaid cards are redeemed against items. Considers only closed invoices.
Redemptions report
View the prepaid cards redeemed or purchased at your center in a selected duration.
| Filter | Options | Description |
|---|---|---|
| Center | Redeemed at this center / Purchased at this center | Either prepaid cards redeemed at your center (regardless of where purchased), or purchased at your center (regardless of where redeemed) |
| Date | 1, 2, 3, or 6 Months / Custom | Custom dates allow a maximum range of 6 months |
| Column | Description |
|---|---|
| Code | Prepaid card number |
| Invoice No | Invoice number of the redemption. Click to open the redemption invoice |
| Receipt No | Receipt number of the redemption invoice |
| Guest | Guest who redeemed the prepaid card |
| Sale Date | Date the prepaid card was used to redeem an item |
| Redemption Amount | Amount for which the prepaid card was used, including tax |
| Adjusted Amount | When price and value differ, the redemption amount apportioned against the card price. For a card priced at 50 with value 100, a 20 redemption shows an adjusted amount of 10 |
| Tip Amount | Tip amount paid at the time of redemption |
| Center | Center where the redemption occurred |
Expiration report
Details of prepaid cards that have expired or that are about to expire in the selected duration: amount used, balance available, expiration date, and any refund processed.
Note: Once a partial or complete refund is processed on a prepaid card, the card cannot be used to pay for any further purchases.