You need to have the Reports > Packages site permission to view the report. See User and Roles.
The report is only available to users of iconnect360 Standard. Contact our sales team at email@example.com if you wish to upgrade your iconnect360 system.
The Deferred Revenue for Package Sales report provides details of realised and deferred revenue or income from sales of packages as of a specified date.
Note: Packages are available only for users of the iconnect360 Standard version.
Deferred revenue is a term used to describe advanced payment or unearned revenue until the services have been rendered. For example, the up-front payment you received for a 3-month package plan. The revenue from the package plan relates to a future benefit for the customer in that he/she will be able to access the club or attend classes over the course of the 3 months.
- At the site level, select Reports from the left navigation menu
- In the Packages section of the Reports page, select Deferred Revenue for Package Sales.
- By default, the report will be generated for deferred revenue as of yesterday's date. You may select up to 7 days in the past.
For example, today is the 8/09/2015. The defaulted date for the report is yesterday, i.e. 7/09/2015. You may also select a date between 1/09/2014 and 7/09/2015.
Note: You will not be able to select a date in the future nor any date beyond the past 7 days.
- Select the required Filter by options. You can filter by:
- Package Name, which is the package name
- Credit Remaining, which is the number of credits deferred
- Package Start Date, which is the start date of the package's validity period
- Package Status, which is Active, Expired, or Future
- Package Type, which is Booking or Check-in
- Customer Number, which is the customer number as per system
If you remove all filters, the report generated will display all packages.
How to use the filter by, group by and sort by functions
- No. of Customers = The number of customers or prospects who purchased each package. Each customer is counted once.
- Example 1: Jack purchased two Package A. The no. of purchaser for Package A is 1.
- Example 2: Jack purchased two Package A. Jill purchased one Package A. The no. of purchaser for Package A is 2.
- Example 3: Jack purchased two Package A and one Package B. Jill purchased one Package A. The no. of purchaser is 2 for Package A and 1 for Package B.
- No. of Packages = The number of packages sold for each package.
- Example 1: Jack purchased two Package A. The no. of packages sold for Package A is 2.
- Example 2: Jack purchased two Package A. Jill purchased one Package A. The no. of packages sold for Package A is 3.
- Example 3: Jack purchased two Package A and one Package B. Jill purchased one Package A. The no. of packages sold is 3 for Package A and 1 for Package B.
- Package Status = Active, Expired, or Future.
- Package Type = Booking or Check-in.
- Package Start Date = The start date of the package's validity period.
- Package Price = The price of the purchased package.
- Unit Price = The Package Price divided by Credit Sold.
- Credit Sold = The number of credits for the purchased package.
- Example: Package A consists of 10 credits. Jill purchased one Package A. Credits sold is 10.
- Credit Realised = The number of credits that had been realised once the booking has taken place and the customer has checked-in.
- Example: Jill purchased one Package A which consists of 10 credits. Jill has paid for 2 bookings that she attended last week and paid in advance for another 2 bookings that will take place the coming week. The Credit Realised displayed in the report is 2.
(Note: 1 credit is for 1 booking or 1 check-in.)
- Credit Refunded = The number of credits realised that have been refunded to the customer.
- Example: Continuing from the above example, the number of credits realised for Jill is 2. If a credit was refunded to Jill, the report will display the following data.
Credits realised = 2
Credits refunded = 1
- Adjustment To Date = The number of credits adjusted manually by a user.
- If credits were adjusted to a lower value from the original, it will display a negative value.
- If credits were adjusted to a higher value from the original, it will display a positive value.
- If the credits were adjusted several times, it will display the total adjusted.
- Credit Remaining = The balance number of credits after taken into consideration the credits realised, refunded, and adjusted.
- Example 1: Continuing from the above example, you gave Jill additional 3 credits for Package A as a loyalty reward program. The report will display the following data.
Credits realised = 2
Credits refunded = 1
Adjustments to date = 3
Credits remaining = 12
- Example 2: Continuing from the above example... As there is an expiry date to the package, you have to void all Jill's credits that had not been realised. So you adjusted Jill's credits to 0.
Note: All the remaining credits will become expired once past the package validity period. The system would recognise the customer's package record as no remaining credits, i.e., Credit Remaining = 0, which means no more deferred value. This record will not show up in the report.
- Deferred Gross Credit Value = The unit price multiplied by by credits remaining.
- Deferred Tax Value = The total amount of tax from the gross credit value.
- Deferred Nett Credit value = The gross credit value excluding tax.