Prepaid card liability 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: Finance manager, accountant
The Prepaid Card Liability report shows outstanding prepaid-card balances per card — total value loaded, redeemed value, and remaining liability. Each unredeemed dollar is a financial obligation the business owes back to the cardholder. Use it for balance-sheet liability reporting, period-end reconciliation, and identifying high-liability cards that might benefit from a redemption-reminder campaign.
This is a legacy report available under the classic reporting framework.
Prepaid card vs. gift card. This report uses the same row structure as the Gift Card Liability report, filtered to prepaid cards. Prepaid cards enter the system through (a) direct purchase, (b) auto-generation from membership / package sales, and (c) membership-unfreeze events that refund stored value. All three issuance paths contribute to the liability.
Expired-card balance. Cards with
Status = Expiredmay still show aLiability Amount> 0 if the cardholder didn't fully redeem before expiry. Depending on local regulations, the org may need to recognize expired balances differently (write-off to revenue vs. continued liability) — consult finance / legal.
Data refresh: Real-time on Refresh.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Use case: financial reconciliation
- Tips
- Related articles
Before you begin
- Prepaid cards must exist in the org (any issuance path).
- Center selection is required for the report to populate; the user must have access to the centers selected.
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 Card Liability.
- Configure filters.
- The report displays in an interactive grid with sorting, filtering, and aggregation.
- Export to flat file when needed.
Filter reference
| Filter | Description |
|---|---|
| Centers | Select one or more centers; only centers the user has access to are visible. |
| Start Date / End Date | Liability period bounds. |
| Liability Type | Controls how the liability amount is calculated (e.g., issue-date basis vs. payment-date basis). |
| Page / Records per page | Pagination for large result sets. |
Column reference
| Column | Description |
|---|---|
| Prepaid Card Code | Unique card code. |
| Guest Name | Card-owner guest. |
| Center Name | Center where the card was issued. |
| Sale Date | Card issuance date. |
| Total Value | Value loaded onto the card at issuance. |
| Redeemed Value | Total redeemed across all transactions. |
| Liability Amount | Total Value − Redeemed Value. Available balance the guest can still redeem. |
| Expiry Date | Card expiry date; blank for cards with no expiry. |
| Status | Active / Expired / Refunded. |
Use case: financial reconciliation
Run this report at the end of each accounting period:
- Set Start / End Date to span the period.
- Set Liability Type per the org's accounting policy.
- Sum the
Liability Amountcolumn for the aggregate balance-sheet liability figure. - For center-level reporting, filter by center and report each separately.
- For expired cards, decide per local regulation whether to keep the liability or recognize as breakage revenue.
Tips
- Identify dormant high-liability cards. Sort by
Liability Amountdescending, then bySale Dateascending (oldest first). Cards with high balance and old sale dates haven't been redeemed in a while — target the cardholders with a redemption-reminder communication. - Reconcile against Liability - Pre-paid Cards. The two reports should agree on aggregate liability for the same period.