Disclaimer
This article is only for the latest version of Zenoti Reports. Do not compare the data in this version with the data in the previous version.
Business owners and accountants can use this report to identify the paid-in-full memberships and recurring memberships that are sold, redeemed, refunded, and expired.
At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Memberships report.
If the report has many columns, scroll horizontally to the right or left to view all columns.
To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
Click Refresh.
If you are generating the report for more than a year, click the Email button.
Impacts and considerations
Use the Memberships v2 report to view all the memberships that were canceled within a certain time frame. Select the date range as per your requirement and select the membership status as Cancelled.
When you choose Cancelled or Expired in the Membership Status filter, memberships that are canceled or expired but are still in their grace period cannot be filtered separately. To see these memberships, pick any status other than Cancelled or Expired from the filter and select the Include terminated/expired memberships that are in the grace period checkbox.
To get an accurate list of canceled memberships in the Memberships report, you need to apply specific filters based on the liability type associated with each membership.
If a canceled membership includes service credits, select the Liability Type as By Sale. This filter ensures that memberships, where the primary liability is linked to services already sold, are accurately captured.
Conversely, if a canceled membership includes a credit amount, select the Liability Type as By Value. This filter helps identify memberships where the primary liability is based on the monetary value or credits remaining in the account.
Column description
Column | Description |
Invoice No | Invoice on which the membership was sold |
Sale Center | Center in which the membership was sold |
Center Code | Unique identifier of the center in which the membership was sold |
Membership Name | Membership that was sold |
Membership Type | Type of the membership that was sold |
Benefit Type | Type of the membership |
Guest Name | Guest who purchased the membership |
Sale Date | Date on which the membership was sold |
Start Date | Start date of the membership |
Sales | Total amount of sales generated using the membership |
Sales(Inc. Tax) | Total amount of sales (including tax) generated using the membership |
Benefit | Benefits available as part of the membership
|
Accrued Value | Value of the sold membership calculated based on its final price, not on the payment that was collected from the guest The accrued value differs for the benefit type of membership:
The IRR, MRR, and SCR settings do not have any impact on the calculation of this column. |
Redeemed Value | Value of the redeemed membership The IRR, MRR, and SCR settings do not have any impact on the calculation of this column. |
Refund Value | Liability value that is refunded on the selected day or during the specified time period. |
Manual Adjustments | Value of manual adjustments on the credit amount; this column is visible only for organizations that have the non-hybrid model of memberships. |
Refunded Value | Value of the refunded membership |
Cancelled Value | Value of the canceled membership |
Expired Value | Value of the expired membership or the value of the expired service benefits |
Unused Credit | Unused credit amount after the membership has been redeemed This column is only visible for hybrid memberships. |
Balance Value | Remaining value of the membership after the redeemed, refunded, and expired values are deducted from the accrued value amount |
Membership Status | Status of the membership |
Recurrence Status | Current recurrence status of the membership |
Next Recurrence Date | Next scheduled payment date for the recurring membership |
Invoice Status | Status of the invoice An invoice with membership can be in open state only if your business allows redemptions on open invoices. |
Receipt No | Number of the receipt generated for the sold membership |
Sale Type | Membership is a new sale or part of recurring collection |
Membership Code | Unique identifier of the sold membership |
Guest Code | Unique identifier of the guest who purchased the membership |
Sold By | Employee who sold the membership |
Membership Category | Category to which the membership belongs |
Freeze Date | Date on which membership was frozen for the last time or it is set to freeze on a future date This field shows a value only if the Recurrence Status of the membership is Frozen. |
Unfreeze Date | Date on which membership was unfrozen for the last time or it is set to be unfrozen on a future date |
Refund Amount | Sale amount that was refunded for the membership |
Converted Amount | Worth of service benefits converted for the membership This column is only visible for those organizations that have a Hybrid membership model. |
Last Refunded Invoice # | Invoice number of the last refunded membership |
Recurrence Cycle # | Recurrence cycle number of the membership's recurring collected payment |
Membership Termination Date | Date on which the membership is set to be terminated or was terminated |
Recurrence Cancellation Date | Date on which the membership's recurrence is set to expire This field shows a value only if the Recurrence Status of the membership is Frozen and its value is always with respect to the membership's Freeze Date. |
Redemption Post Expiry | Membership is redeemable after expiry |
Membership Renewal | Membership that is set to be auto-renewed |
Add On Members# | Number of add-on members defined in the membership |
Sales-Accrual | Membership Liability | Compare | Do not compare |
Column: Sales (Inc. Tax) Filter 1: Item Type Option: Membership Filter 2: Sale Type Options: Sale, Recurring | Column: Accrued/Sold Filter: Liability Type Option: Sale | Compare these columns except for the reasons listed after this table. | Cannot compare these columns for the reasons listed after this table. |
Reasons
Memberships with only discounts
Memberships with only discounts are considered sales, not liabilities. A transaction using such membership is considered in the Sales-Accrual report, not in the Membership Liability report or Memberships report.
Memberships with only credit amount
Memberships with only credit amount are considered as sales. In the Membership Liability and in Memberships reports, such membership is considered a liability when these reports are generated with the Liability Type filter selected as Value.
Recurring memberships
If the Enable Redemptions on Open Membershipssetting is not enabled, only closed invoices are considered in the Membership and Membership Liability reports.
Cross-center refunds
Cross-center refunds are considered for the center where the refund was done. In the liability report, refunds are considered for the center where the liability was sold, and if this center is deleted, then the refund is not considered in the liability report.
Memberships with refunds
When a membership is refunded partially, the benefit value does not decrease. The amount is tracked under the Refund amount column and Suspense column in the Memberships and Membership Liability reports.
When a membership is refunded fully, the membership benefits are refunded and the amount is shown under the Refund Amount column in the Memberships or Membership Liability reports.
Memberships with setup fees and freeze fees are not treated as liabilities.
IRR, SCR, and MRR settings have no impact on calculations for membership accruals, redemption, refunds, and expires
Memberships with only credit amount are shown in both the reports generated with the Liability Type filter as Value