Membership Liability report (v2)

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 center managers can use this report to track whether the membership liability at your centers increased or decreased over a specific duration.

At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Memberships Liability 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 generate the report for over a year, click the Email button.

You can view the report based on the liability sale amount or value. The membership liability report data will vary depending on whether it is filtered by sale or by value.

The following table describes columns in the membership liability v2 report.

Column Name	Description
Center Name	Center in which the membership was sold
Opening Balance	Balance amount of memberships liability that is carried forward from the previous accounting period This value is the liability balance at the start of the selected date range.
Accrued/Sold	Amount of liability that was generated from the sale of memberships For example, if you sell a package for $400 with five benefits of $100 each, the liability value is $400.
Accrued Value	Liability value generated from the sale of memberships This column is only visible only for hybrid model types of memberships, for memberships that have the the Value Model flag enabled, and for memberships with credit amount.
Redemptions	Amount of liability that is redeemed during the date range
Manual Adjustments	Value of manual adjustments on the credit amount; this column is visible only when the Liability Type is By Value and for organizations that have the non-hybrid model of memberships.
Refund Value	Liability value that is refunded during the selected date range
Refund Amount	Total amount of liability that is refunded during the date range
Cancellations	Amount of liability that is canceled during the date range
Expired	Amount of liability that expired during the date range
Closing Balance	Balance liability amount of memberships that is carried forward to the next accounting period For non-hybrid model: For sale liability type Closing Balance = Opening balance (before duration) + Accrued value - +Redemptions value - Refund amount - Expired value - Suspended value - Cancelled value For value liability type Closing balance= Opening balance (before duration) + Accrued value - Redemptions value + Manual adjustments - Cancelled value - Expired value - Refund value For hybrid model For value liability type: Closing balance= Opening balance (before duration) + Accrued value - Redemptions value - Refund value - Cancelled value - Expired value - Unused credit amount. For Sale Liability Type: Balance = Sale - Redemption - Refunded - Expired - Suspense For Value Liability Type: Balance = Value - Redemption - Refunded - Expired - Suspense This value is the liability balance at the end of the selected date range.
Suspense	Liability value generated due to incomplete refunds when the membership is refunded and closed; the balance amount is zero but the complete amount is not refunded
Unused Credit Amount	Unused credit amount after redemption This column is only visible for organizations that have the hybrid model of memberships.
Conversions	Total worth of service benefits that were converted This column is only visible for organizations that have the hybrid model of memberships.

Sales-Accrual report vs Membership Liability and Memberships reports

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.

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