Prepaid cards report
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.
Audience: Center manager, marketing manager, accountant
The Prepaid Cards report shows every prepaid card in the org with full lifecycle state — value loaded, redeemed, remaining balance, expiry, status, and issue type (Sale / Auto-generated / Membership unfreeze). Use it for prepaid-program audits, identifying expiring cards needing redemption reminders, and reviewing cards auto-generated through membership / package purchases.
This is a legacy report available under the classic reporting framework.
Code masking. Prepaid card codes may be masked (only last 2 characters visible) when the user role lacks the Show gift card numbers permission under GiftCards in the Loyalty Manager section. Grant that permission only to roles that need it — full card codes are sensitive.
Three issuance paths. Prepaid cards enter the system through (a) direct Sale, (b) Auto-generated as a benefit of a membership or package purchase, and (c) Membership unfreeze when a frozen membership is unfrozen and the org has
Generate prepaid card on membership unfreezeenabled. All three issue types appear in the report; filter by Issue Type for an audit of any one source.
Data refresh: Real-time on Refresh.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Understanding issue types
- Tips
- Related articles
Before you begin
- Centers must be selected for the report to populate; the user must have access to the centers.
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.
Run the report
- Navigate to the Reports Dashboard.
- Select Prepaid Cards.
- Configure filters.
- Results render in an interactive grid; export to flat file when needed.
Filter reference
| Filter | Description |
|---|---|
| Centers | One or more centers. |
| Liability Type | By Payment (price paid), By Value (face value), By Sale (default — sale-transaction basis). |
| Date Type | Anchors the date range on Sale Date (issuance), Balance as on date (point-in-time snapshot), or Expiry Date. |
| Start Date / End Date | Applied to the selected Date Type. |
| Include No Expiry | Includes cards without expiry dates. |
| Statuses | Active / Expired / Refunded. Leave blank for all. |
| Issue Types | Sale / Auto-generated / Membership unfreeze. Leave blank for all. |
| Guests | One or more guests by name or code. |
| Card Type | Filter by prepaid card type. |
| Group Column | Optional aggregation dimension. |
| Page / Records per page | Pagination. |
Column reference
| Column | Description |
|---|---|
| Prepaid Card Code | Unique card code; may be masked. |
| Guest Name | Card owner. |
| Center Name | Center where issued. |
| Sale Date | Issuance date. |
| Expiry Date | Card expiry; blank for no-expiry cards. |
| Card Value | Original face value loaded. |
| Card Price | Price paid for the card (may differ from face value for promo-priced cards). |
| Redeemed Value | Total redeemed. |
| Remaining Balance | Available balance. |
| Status | Active / Expired / Refunded. |
| Issue Type | Sale / Auto-generated / Membership unfreeze. |
| Sold By | Selling employee. Blank for Auto-generated cards. |
Understanding issue types
| Issue Type | When this happens |
|---|---|
| Sale | Front-desk sells the card directly to the guest. |
| Auto-generated | Zenoti automatically creates the card as a benefit of a membership or package purchase. |
| Membership unfreeze | When a frozen membership is unfrozen and the Generate prepaid card on membership unfreeze org setting is enabled, Zenoti generates a new card capturing the frozen value. |
Tips
- Audit auto-generated cards quarterly. Filter
Issue Type = Auto-generatedto confirm membership / package benefits are correctly producing prepaid cards. - Identify expiring cards. Filter
Date Type = Expiry Date, set Start/End to the next 30-60 days, excludeInclude No Expiry. The result is the expiring-soon redemption-reminder list. - Reconcile against Prepaid card liability report. Sum of
Remaining Balancehere should match the aggregate liability there.