Package Liability v1 report
Overview
The Package Liability report helps you keep track of the liability balance after the sale, redemption, and expiry of packages across your centers. You can use this report to view the following:
Opening and closing liability balance as on date
Total value of packages that have been sold, redeemed, refunded, or have expired
Ensure that you are at the Center level when you want to run this report.
On the Main menu, click the Reports tab. The Reports Dashboard opens.
Click Finance> Accounting (from the filter).
Select the Liability - Packages report from the list. The report opens in a new tab.
Select the appropriate option from the Filter Criteria and click
Refresh.
Tip
To view all columns of a report, export the report by clicking the Excel
or .CSV
icons.
Note
If you have the appropriate permissions, you can generate this report from the organization level to view liability data for packages for all your centers.
What is liability and how is it calculated?
On any given date, Zenoti checks whether guests have redeemed services of a package in accordance with payments they have made. If guests have paid for a package (in part or in whole), but have not redeemed services in accordance, the value of services yet to be redeemed (as part of the package) is the liability on the business. In other words, the center is liable to provide services worth the value of the Closing Balance (see Column Descriptions) as on a given date.
Calculation of Liability for Payment Date Consider a package that costs $100 and guest makes partial payments as follows:
On Day 1: Guest pays $20
On Day 2: Guest pays $30
On Day 3: Guest pays $50
Note
The guest does not redeem any of the services of the package during this time. In this case, Zenoti calculates liability as follows:
On Day 1: Liability is $20 (Guest has paid but not redeemed any services)
On Day 2: Liability is $50 ($20+$30, that is sum of payments made till date and assuming that the guest has not yet redeemed any services)
On Day 3: Liability is $100 ($20+$30+$50, as full payment has been recognized and assuming the guest has still not redeemed any services).
Note
See the Filter Criteria section for more on Payment Date.
Calculation of Liability for Sale Date
Scenario 1: Consider a package that costs $100 and guest makes the full payment on day 1. The invoice is closed.
In this case, Zenoti calculates liability as follows:
On Day 1, 2, and 3: Liability is $100 (Guest has paid in full but has not redeemed any services) The liability on your business reduces as and when guests redeem services from the package.
Scenario 2: Consider a package costs $100 and a guest makes a partial payment on the same day ($30). Since the full payment is not yet recognized, the invoice is open and the Sale Date filter does not consider this invoice.
If the guest pays the balance amount ($70) on day 5, and then the invoice is closed (as full payment has been recognized and assuming that the guest has still not redeemed any services), then the liability report for Sale date will show $100 as the liability from day 6 onwards. The liability on your business reduces as and when guests redeem services from the package.
Note
See the Filter Criteria section for more on Sale Date.
Filters
The filter criteria you view depends on whether the checkbox Enable redemptions on Open packages at the Organizational level is selected or not. Refer to the following table for details to understand why the filter criteria differs.
Is the checkbox selected? | This means... | ...liability data is based on ... | Filter criteria is... | ...and Invoice status is... |
No | Guests need to make full payment for a series package to be able to start redeeming the services of the package. | Sale Date (since the full payment is collected on the date of sale of the package) | Sale Date | Closed |
Yes | Guests can start redeeming the services of the package once they make a partial payment. Guests can redeem services up to the limit for which they have paid - see Note below. | Either the date on which guests make a partial payment (Payment Date) or the date on which guests make the full payment (Sale Date). | Payment Date Sale Date | Open or Closed |
Note
Consider this scenario where a package costs $1000, a guest pays $200, and the option Enable redemptions on Open packages is selected. In such a case, Zenoti allows the guest to redeem services worth $200 only. As and when the guest pays the balance amount, the guest can avail the remaining services of the package.
Scenario 1: If this checkbox Enable redemptions on Open packages is not selected, you can view the following filter criteria.
Note
Since this scenario covers only Sale Date, there is no separate filter for the same.
Criteria | Options | Description |
Time period | 1 Month 2 Months 3 Months 6 Months Custom | Based on your requirement, from the drop-down list, select either 1, 2, 3, or 6 months. You can alternatively choose Custom from the list and specify custom dates. NoteFor custom dates, you can view data for a maximum date range of 6 months at a time. Example: If you wish to see data from January to August, first view data from January to June and then view data from July to August. |
Scenario 2: If the checkbox Enable redemptions on Open packages (Organization level) is selected, you can view the following filter criteria.
Criteria | Options | Description |
Packages filtered by | By Payment Date By Sale Date |
|
Time period | 1 Month 2 Months 3 Months 6 Months Custom | Based on your requirement, from the drop-down list, select either 1, 2, 3, or 6 months. You can also choose Custom from the list and specify custom dates. NoteFor custom dates, you can view data for a maximum date range of 6 months at a time. Example: If you wish to see data from January to August, first view data from January to June and then view data from July to August. |
Column descriptions
Column | Description |
Center | Displays the name of the Center. |
Opening Balance | Displays the opening liability balance for packages of the center on the start date you specify. That is, the balance on the previous date at 11:59:59 P.M. Click the Opening Balance to drill down to view the Packages - Credit Balance report that shows Opening (liability) Balance details for the start date of the date range you specify. If Payment Date is your filter: Opening Balance = Amount paid for packages - (minus) Redemptions as on the starting date of your date range. Example: Cost of a package: $100 Amount paid: $30 Initial Recognition: $5 Redemptions on start date: $15 Opening Balance: 30-20 (15+5) =10 NoteZenoti considers both, closed and open invoices for calculations. If Sale Date is your filter: Opening Balance = Price of the package - (minus) Value of Initial Recognition as on the starting date of your date range. NoteZenoti considers only closed invoices for calculations. Example: Cost of a package: $100 Amount paid: $100 Initial Recognition: $5 Redemptions on start date: $15 Opening Balance: 100-20 (15+5) = 80 |
Sales | Displays the total credit amount (balance) generated by the center for package sales in the date range you specify. Click the Sales amount to drill down to view the Package Details report. If Payment Date is your filter: Sales = Sum of payments made for packages during the duration you specify minus amount of total recognition in that period. Considers both, open and closed invoices (in the date range you specify). If Sale Date is your filter: Sales = Value of packages sold minus value of initial recognition. Considers only closed invoices (in the date range you specify). |
Redemptions | Displays the total value of package redemptions (redemption value) that a center has made in the date range you specify. In other words, this is the total value of services that guests have redeemed (paid for and availed services) during the date range you specify. NoteRedemptions are shown in the center where customers bought the packages. |
Expirations | Displays the total value of packages that have expired and have not been redeemed at a center in the date range you specify. Expirations become part of revenue reports. Zenoti considers both, open and closed invoices to get the total value of package expirations. Click the Expirations value to drill down to view the Package Expirations report. |
Refunded | Displays the amount that has been refunded from packages during the date range you specify. This column is available only if you choose the Payment Date as your filter. |
Closing Balance | Displays the closing balance or liability of packages that the center has on the last date in the date range you specify. If Payment Date is your filter: Closing Balance = [Opening Balance + Payments made during the duration (Sales)] - (minus) [Redemptions + Expirations + Refunds] as on the last date of your date range. If Sale Date is your filter: Closing Balance = [Opening Balance + Value of packages sold (Sales)] - (minus) [Redemptions + Expirations] as on the last date of your date range. |
Important notes
The figures in the Package Liability report will not match with the Collections by Item report in the following cases:
If the package is bought in one center and payment is done at another center, the Package Liability report considers only the balance in the center where the package was sold and not in the center where the payment was made. But the Collections by Item report shows the collection for the center where the payment was made.
If the package has initial recognition configured, the Package Liability report deducts the initial recognition from the amount paid by the guest and then show only the balance amount. But the Collections by Item report shows the total amount collected.
If the open invoice contains a product and a package, Zenoti does not apportion the paid amount to both package and product in Package Liability report. First, the payment is given to the product and the remaining amount is taken for the package. But the Collections by Item report apportions the paid amount between both, the package and the product.