Liability – Memberships report (v1)
Marketing managers can use this report to track membership liability balance across centers.
At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Liability - 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 generate the report for over a year, click the Email button.
Column | Membership liability by value | Membership liability by price | Membership liability by service credit |
Center | Center at which the membership was sold | Center at which the membership was sold | Center at which the membership was sold |
Opening Balance | Liability carried over from previous period NoteTo view more details, click the opening balance. | Liability carried over from previous period NoteTo view more details, click the opening balance. | Liability carried over from previous period NoteTo view more details, click the opening balance. |
Sales | Liability generated from membership sales based on sale price or value Example If a membership is sold for $400 with five benefits of $100 each, liability is 5x$100= $500. | Liability generated from membership sales based on sale price or value Example If a membership is sold for $400 with five benefits of $100 each, liability is $400. | Liability generated from membership sales based on sale price or value Example If a membership is sold for $400 with five benefits of $100 each, liability is calculated as follows,
|
Credit Redemptions | - | Total value of the service credits redeemed in open and closed invoices NoteYou will see this column only if membership was bought at this center. | Total value of the service credits redeemed in open and closed invoices NoteYou will see this column only if membership was bought at this center. |
Service Redemptions | - | Liability value redeemed in open and closed invoices NoteYou will see this column only if membership was bought at this center. | Liability value redeemed in open and closed invoices NoteYou will see this column only if membership was bought at this center. |
Service Credit Conversions | - | - | Liability value of credits converted to dollar amount |
Revenue from Lost Credit Amount | - | - | Value of credits not redeemed, and they are no longer available to the guest |
Cancellations | - | - | Amount of liability that is canceled The center is not liable for the canceled benefits after the grace period. |
Expired Amount | Revenue generated from unused benefits of expired recurring and non-recurring memberships | Revenue generated from unused benefits of expired recurring and non-recurring memberships | Revenue generated from unused benefits of expired recurring and non-recurring memberships |
Closing Balance | Balance liability amount of memberships that is carried forward to the next accounting period Closing Balance = Opening Balance + Sales – (Redemptions + Expired amount + Revenue from Lost Credit Amount) | yes | yes |
Cost Adjustment | - | - | Cost Adjustment is the difference between Service Credit Equivalent Amount (Sales column) and membership price. For example, if membership price is 100 and Service Credit Equivalent Amount is 125, then Cost Adjustment will be 25 Note: This column is only visible for organizations that have Hybrid model of memberships. |