Packages Liability report
The Packages Liability report shows the value of package liabilities your business started the period with, sold, redeemed, refunded, had expire, and carries forward to the next period. This article describes each column, and in particular the rule that decides when unredeemed value counts as Expired.
On this page
- Before you begin
- Report details
- Columns
- When value counts as Expired
- Compare with the Sales-Accrual report
- Tips
Before you begin
Permission: Packages Liability Report under Financial in the Reports(V2) section of the security role β required to open this report. For the classic version of the report, the report-area action under View Admin Reports in the Administrator section of the security role.
Navigation: Open the Reports dashboard, type the report name in Search Report, and select Packages Liability.
Report details
| Aspect | Detail |
|---|---|
| Purpose | Track package liability balances and movements (sales, redemptions, refunds, expirations) for a period |
| Filters | Date range, Center, Liability Type |
| View scope | Center, Organization |
Columns
| Column | Description |
|---|---|
| Center Name | Center where the package was sold. |
| Opening Balance | Package liability carried forward from the previous accounting period. |
| Accrued/Sold | Liability generated from package sales in the period. |
| Redemptions | Value of liability redeemed in the period. |
| Refunds | Value of liability refunded in the period. |
| Expired | Unredeemed value of packages whose current expiry date falls within the selected date range. Packages set to Never Expires are not counted. See When value counts as Expired. |
| Suspense | Difference between refunded amount and the package balance at the time of refund. Calculated only when the package is refunded and the invoice is closed on the same day. A positive suspense (short refund) is recognized as revenue; a negative suspense (excess refund) is recognized as cost. |
| Closing Balance | Package liability carried forward to the next accounting period. |
When value counts as Expired
The Expired column reports the unredeemed value of packages whose current expiry date falls within the date range you selected. For each of those packages, the report counts what was left on the package on its expiry date β the sale value, less any redemptions and refunds dated on or before that date.
A package contributes to Expired in one period only: the period that contains its expiry date.
- If an expiry date is changed, the value is reported against the new date. A package whose expiry date is edited is counted in the period that contains the new date, not the period that contained the previous one.
- Packages that never expire are never counted here. A package set to Never Expires has no expiry date, so it does not appear in the Expired column for any period.
- The rule is the same for every liability type. Changing the Liability Type filter does not change how expired value is identified.
Reading the figure: If a period's Expired total differs from what you expect, check the current expiry dates on the packages you expected to see. The report always reads the expiry date a package carries now, so a package whose date was moved is counted in the period that contains the later date instead.
Compare with the Sales-Accrual report
You can compare specific columns between the Sales-Accrual report and the Packages Liability report:
| Sales-Accrual report | Packages Liability report | Compare | Do not compare |
|---|---|---|---|
| Column: Sales (Inc. Tax), Filter: Item Type = Package, Filter: Sale Type = Sale or Recurring | Column: Accrued/Sold, Filter: Liability Type = Sale | Compare these columns except for the cases listed below. | The cases listed below. |
When values diverge, common reasons include:
- Packages with only discounts β discount-only packages are treated as sales, not liabilities. Their transactions appear in Sales-Accrual but not in Package Liability or Packages reports.
- Packages with scheduled payments β if the Enable redemptions on open package setting is off, only closed invoices are considered in Packages and Package Liability reports.
- Cross-center refunds β in the Liability report, refunds are attributed to the center where the liability was sold. If that center is deleted, the refund is not reflected in the liability report.
- Partial package refunds β benefit value is not reduced. The amount appears under Refund Amount and Suspense in both Packages and Package Liability reports. Full refunds reduce benefits and appear under Refund Amount.
- Day and promo packages β not considered liabilities.
- Deleted centers β sales and refunds in a deleted center are not tracked in either report.
- IRR settings β do not impact calculations for package accruals, redemption, refunds, and expires.
- Service benefits marked Not for Revenue β not considered redemption.
Tips
- If the report includes more than one year of data, click Email to receive the export by email.