Introduction
In Perfect Gym, the Course Summary Report is a comprehensive analytical tool designed to provide a 360-degree view of all course-related activities within your facility.Think of it as your central hub for understanding everything from new student sign-ups to their progress and skill development over time.
The report is designed to give you deep insights into how your courses are performing. You can track new enrollments, see why members are cancelling, monitor transfers between classes, view contract freezes, and analyze student progression. This helps you make informed decisions to improve your course offerings, manage class capacity, and support your members' development.
In this article, you will learn how to generate the report, interpret the various summary and detailed tabs (such as Contract and Level Summaries), and use the data to monitor student development.
This article will be helpful for Club Managers, Course Coordinators, and System Administrators.
Before You Start
To access this report, you'll first need the correct permissions assigned to your employee role. If you can't see the report, please ask your system administrator to grant you access.
Here’s how an administrator can set up the permissions:
- Navigate to the permissions settings by clicking through the following path: PGM -> Clubs -> System Permissions.
- Select the Employee Role you want to grant access to (e.g., "Course Coordinator").
- In the permissions list, you can either use the search bar to type "Course Summary" or browse through the 'Reports' category to find it.
- Once you've located the report, check the box next to it to grant access.
- Click Save.
Fast lane
This is a brief overview of the steps required to generate the report. Detailed descriptions of each section follow below.
Go to PGM -> Reports -> All
Search for Course Summary.
Select a Single Club (Mandatory).
Set Date Since -> Date Until.
Choose Activity -> Timetable Categories (Optional).
Click Generate.
Instruction
How to Generate the Report
Once you have the necessary permissions, you can generate the report.
- Navigate to the main reports section: PGM -> Reports -> All.
- You can find the report in two ways:
- Search Bar: The quickest way is to type "Course Summary" into the search bar at the top of the page.
- Categories: You can also look for the report by browsing the available categories. It is most likely located under the 'Courses' category.
Click on the report name to open the generation screen.
This will display the filters that can be used to generate the report:
Club: Select the specific club. Note: You must select a single club; "All Clubs" is not supported.
Date Since: The start date for the data collection.
Date Until: The end date for the data collection.
Activity Categories: Filter by specific programs (e.g., Swimming, Gymnastics). Leave blank for all.
Timetable Categories: Filter by specific scheduling blocks (e.g., Term 1 2025). Leave blank for all.
Press XLSX to generate the report.
Report Extract
The report is divided into several tabs (worksheets), each providing a different view of your course data. The first two tabs are summaries, and the following tabs provide detailed lists of the underlying data.
Contract Summary By Category
This tab gives a high-level overview of contract movements, broken down by timetable, activity, and level.- Club Name: The name of the club.
- TimeTable Category Name: The category of the timetable (e.g., "Term 1").
- Activity Category Name: The category of the activity (e.g., "Swimming").
- Activity Level Name: The specific skill level within the activity (e.g., "Beginner").
- Active Start Of Period: The total number of students who were actively enrolled in this level at the start of your selected date range.
- Active Within Period: The total number of unique students who were enrolled in this level at any point during the date range.
- Active End Of Period: The total number of students actively enrolled in this level at the end of your selected date range.
- Maximum Capacity: The total maximum number of spots available across all groups for this level.
- New Contracts: The count of new contracts that started within the date range.
- Cancelled Contracts: The count of contracts that were officially ended within the date range.
- Remove From Group: The count of enrollments that were removed from a group within the date range.
- Frozen Contract: The count of contracts that were frozen during the date range.
- Transfer From: The count of students who transferred out of this level.
- Transfer To Upgrade: The count of students who transferred into this level from a lower level.
- Transfer To Downgrade: The count of students who transferred into this level from a higher level.
- Transfer To Same Level: The count of students who transferred into this level from a different group of the same level.
- Level Summary By Category
This tab summarizes student progression and waitlist activity for each course level.- Activity Category Name: The category of the activity (e.g., "Swimming").
- Activity Level Name: The specific skill level within the activity (e.g., "Beginner").
- Active Start Of Period: The number of active students at the start of the date range.
- Active Within Period: The total number of unique students enrolled during the date range.
- Active End Of Period: The number of active students at the end of the date range.
- 5 Star Progression to 0 Star Progression: These columns show how many currently active students are at each progression rating. A 5-star rating (★★★★★) means a student is progressing well or has reached the highest level, while a 0-star rating (☆) suggests they have been in their current level for longer than expected.
- User Level New / Upgrade / Downgrade: The total count of students who were assigned a level for the first time, upgraded to a higher level, or downgraded to a lower level.
- Skill New / Upgrade / Downgrade: The total count of individual skill progressions within a level (e.g., moving from "Not Yet Attempted" to "Achieved").
- Assessments Created / Completed / Cancelled: A count of student assessments that were created, completed, or cancelled during the date range.
- Total On WaitList: The number of students currently on the waitlist for this level.
- Total Waitlist Enrolled: The number of students who were successfully enrolled from the waitlist during the date range.
- Total WaitList Cancelled: The number of students whose waitlist entry was cancelled during the date range.
- New Enrollments
This tab provides a detailed list of every new course contract that started within your selected date range.- Club Name: The name of the club where the contract was created.
- User Number: The student's unique identification number.
- First Name / Last Name: The student's first and last name.
- Student Date Of Birth: The student's date of birth.
- Student Age: The student's current age, displayed in years and months (e.g., "5 years 2 months").
- Student Age Decimal: The student's age as a decimal number (e.g., 5.2).
- Concession Card Type / Date: Details of the student's concession card, if applicable.
- Medical Conditions: Any listed medical conditions for the student.
- Created By Employee: The employee who created the contract. For online sign-ups, this may show as 'Online Registration' or 'PerfectGym'.
- SignUp Source: Where the sign-up originated from (e.g., "Kiosk", "Online").
- User Group: The specific class or group the student is enrolled in.
- Trainer: The primary trainer assigned to the user group.
- Start Date / End Date: The start and end dates of the contract.
- Timetable Category Name / Activity Category Name / Activity Level Name: The categories associated with the enrollment.
- Payment Plan Name: The name of the payment plan for the contract.
- Group Enrollment Rule Name: The specific enrollment rule applied.
- Contract Discount By Class / By Payment Plan: Lists any discounts applied to the enrollment.
- Membership Fee: The membership fee associated with the payment plan.
- Payment Interval: How often payments are scheduled (e.g., "Monthly").
- Cost Per Class: The calculated cost for each class after any discounts.
- Student Balance: The student's overall account balance in the system.
- Contract Balance: The specific balance of this course contract.
- Cancelled Course
This tab lists all contracts that were terminated within the selected date range.- Includes many of the same columns as the New Enrollments tab.
- Cancelled By Employee: The employee who processed the cancellation.
- Cancel Reason: The reason selected for the cancellation (e.g., "Moved away").
- Number Of Classes In Contract: The total number of classes that occurred during the enrollment period.
- Present In Class In Contract: The number of classes the student was marked as "present" for.
- Remove From Group
This tab lists students who were removed from a specific group during the date range, which often occurs during a class transfer.- The columns in this tab are nearly identical to the Cancelled Course tab, providing full details about the enrollment that was ended.
Course Transfers
This tab details every instance of a student transferring from one group to another.- Includes student details like User Number, First Name, and Last Name.
- Created Date: The date the transfer was processed.
- Created By Employee: The employee who processed the transfer.
- From Usergroup Name: The name of the group the student transferred out of.
- From Activity: The skill level of the group the student transferred from.
- ->: An arrow symbol to separate the "from" and "to" details.
- To Usergroup Name: The name of the group the student transferred into.
- To Activity: The skill level of the group the student transferred to.
- Advancement: This shows the type of transfer.
- If a student moves to a higher-ordered skill level, this will show 'Upgrade'.
- If a student moves to a lower-ordered skill level, this will show 'Downgrade'.
- If a student moves to a different group of the same skill level, this will show 'SameLevel'.
- Course Freezes
This tab lists all contracts that had a freeze period active during the selected date range. Includes student and contract details similar to other tabs.- Freeze Type: The type of freeze applied (e.g., "Medical," "Holiday").
- Freeze Reason: The specific reason for the freeze.
- Freeze Start Date / End Date: The duration of the freeze period.
- Weeks On Freeze: The total number of weeks the contract was frozen for.
- Freeze By Employee: The employee who processed the freeze.
Waitlist
This tab provides a comprehensive look at all waitlist activity, including current and past entries.- User Number / Full Name: The student's ID and full name.
- Parent User Number / Full Name: The primary parent or guardian's contact details.
- Email / PhoneNrMobile: The contact email and mobile number, showing the parent's details if available.
- Activity Category Name / Activity User Level Name: The course level the student is waitlisted for.
- Status: The current status of the waitlist entry.
- 'OnWaitlist': The student is currently waiting for a spot.
- 'Enrolled': The student was successfully enrolled into a group from this waitlist entry within the report's date range.
- 'Cancelled': The waitlist entry was cancelled within the report's date range.
- User Group Name: If the student was enrolled, this shows the group they joined.
- Created Time: When the waitlist entry was first created.
- Monday through Sunday: These columns show the student's preferred time slots for each day of the week.
- Level Progression
This tab shows the current progression status for all actively enrolled students.- User Number / First Name / Last Name: The student's details.
- Activity Category Name / Activity User Level Name: The student's current course and level.
- Level Created Date: The date the student was moved into this current level.
- Weeks In Level: The number of weeks the student has been in their current level.
- Star Rating: A visual rating of the student's progression. It's based on the time they've spent in their current level.
- ★★★★★: Student is in the highest possible level OR has been in the current level for 10 weeks or less.
- ★★★★: Student has been in the current level for 11-20 weeks.
- ★★★: Student has been in the current level for 21-30 weeks.
- ★★: Student has been in the current level for 31-40 weeks.
- ★: Student has been in the current level for 41-52 weeks.
- ☆: Student has been in the current level for more than 52 weeks.
- Star Rating As Number: A numeric version of the star rating (0 to 5).
- Tip: The main Level Progression tab only includes students who are actively enrolled at the end of the report period. This prevents old inactive students from continuing to accumulate weeks in level after leaving.
- Assessments
This tab lists all assessment activities (creations, completions, and cancellations) within the date range. Includes student and class details.- Class Date: The date of the class for which the assessment was recorded.
- Comments: Any comments left by the instructor on the assessment.
- Datetime: The timestamp when the assessment action occurred.
- Employee Name: The employee associated with the action.
- Option: Describes the action taken.
- 'Created': An assessment was started for the student.
- 'Completed': The assessment was finalized.
- 'Cancelled': The assessment was cancelled
- Activity User Level
This tab tracks changes to a student's overall skill level within an activity category.- Includes student details.
- Created Time: When the level change was recorded.
- Created By Employee: The employee who made the change.
- From Activity -> To Activity: Shows the student's previous level and the level they were moved to.
- Advancement: Shows if the change was an 'Upgrade', 'Downgrade', or a 'New' level assignment.
- Result: Explains the type of change.
- 'New': The student was assigned their first level in this activity.
- 'ChangeLevel': The student moved from one level to another.
- Assessment: Indicates how the change was made.
- 'Changed in assessment': The level was changed via a formal assessment in a class.
- 'No assessment': The level was changed manually in the student's profile.
- Class Name / Assessment Date: If changed in an assessment, provides details of the class.
- Activity Skill
This tab tracks changes to a student's progress on individual skills within a level (e.g., kicking, floating). Includes student and class details.- Activity Skill: The specific skill being assessed.
- From Progress -> To Progress: Shows the change in the skill's status (e.g., from "Attempted" to "Achieved").
- Advancement: Shows if the skill progress was an 'Upgrade', 'Downgrade', or 'New'.
- Result: Explains the type of change.
- 'New': The student's progress was recorded for this skill for the first time.
- 'ChangeSkill': The student's progress for this skill was updated.
- Assessment: Indicates if the change was made via an assessment or manually.
- User Group
This tab provides a detailed profile for every active course group within the selected date range and categories.- User Group Id / Name / Description: The ID, name, and description of the group.
- User Group Trainer Name: The name of the assigned trainer.
- User Group Start Date / End Date: The active date range for the group itself.
- Category Names: The Timetable, Activity, and Level categories for the group.
- Age Limit Name: The configured age range for the group (e.g., "5-7 Years").
- Class Semester Name: The semester the group belongs to, if any.
- Active Start / Within / End Of Period: A count of student enrollments in this specific group at the start, during, and at the end of the report period.
- Max User Number: The maximum number of students allowed in the group.
- User Group Locked: Shows 'True' if the group is locked and not accepting new enrollments.
- Next Class Start Date: The date and time of the next scheduled class for this group after the report's end date.
- Class Duration: The duration of the next class in minutes.
- Next Time Table Name: The name of the next scheduled class.
- Enrollments
This tab provides a complete list of every single student enrollment that was active at any point during your selected date range.- Club Name: The club where the student is enrolled.
- User/Parent Details: Includes the student's name, user number, and parent contact information.
- Student Details: Includes date of birth, age, and any medical or concession card information.
- Contract ID / Start Date / End Date: The details of the overarching contract agreement.
- Group Name: The specific group the student is enrolled in.
- User Group Enrollment ID / Start Date / End Date: The details of the specific enrollment in that group, which may have different dates than the contract itself.
- Category Names: The Timetable, Activity, and Level associated with the enrollment.
Group Enrollment Settings
This tab is a configuration reference for the group enrollment definitions and rules available to the selected club and timetable categories. It is useful for checking pricing, refund rules, make-up lesson settings, trial availability, cancellation permissions, and how many active contracts currently use each rule.
Definition Name / Description: The name and description of the group enrollment definition.
Is Active / Available For All Clubs: Shows whether the definition is active and whether it is shared across all clubs or limited to selected clubs.
Refund Policy / Make Up Lesson Product: Shows the refund method and the make-up product used when the refund policy is set to make-up product.
Refund Limit Type / Count / Periods: Shows the limits applied to refunds or make-up entitlements.
Start Date Behaviour: Explains how the enrollment start date is determined for the rule.
Should Make Up Products Expire: Indicates whether issued make-up products expire.
Charge Policy / Contract Payment Method: Shows how the student is charged, such as per-class contract payment rules.
Required Payment Plan Name: The payment plan required for the rule, if configured.
Allow Member To Cancel Booking: Shows whether members can cancel their own class booking under this rule.
Is Trial Lesson Available: Shows whether trial lessons are available.
Fixed Number Of Classes: The fixed class count for rules that use a fixed number of sessions.
Active Contracts: The number of active, non-deleted contracts at the selected club currently using the rule.
Price Effective From: Shows the date of a pricing schedule item only when the price change falls within the selected report date range.
Gross Price: The current gross price for the enrollment rule as of today.
Important: If Price Effective From is blank, it does not mean the rule has no price. Check Gross Price for the current price; the effective date only appears when a price change occurs during the selected report period.
Hints
Single Club is Key: Always select a single club from the Club filter. The report returns an error if you try to run it for All Clubs. If there is only one active club and no club is selected, the report can default to that club.
Blank Means All: If you leave Activity Categories or Timetable Categories blank, the report includes all non-deleted categories. Use these filters to narrow large reports.
Start with Summaries: Begin with Contract Summary by Category and Level Summary by Category, then move to the detail tabs to investigate specific counts.
Use Contract Breakdown for Progression Questions: If a student appears to have been in a level for a long time, check Level Progression - Contract Breakdown to see the separate contracts that contribute to their level history.
Check Group Level Mismatches: Compare Activity User Level Name and Group Level Name in the Level Progression tab. Differences may indicate the student’s current level and latest group level are not aligned.
Use Group Enrollment Settings for Price and Rule Audits: Review the Group Enrollment Settings tab when checking current gross price, trial availability, cancellation settings, make-up/refund policy, and active contracts per rule.
Price Effective From is Date-Range Sensitive: A blank Price Effective From means no pricing schedule item in the selected report period. The Gross Price column still shows the rule’s current price.
Variance Tracking: If Active End of Period is significantly lower than Active Start of Period, check Cancelled Contracts, Remove From Group, and Remove From Group Transfer.
Waitlist Strategy: If Total On Waitlist is high but Active Within Period is at Maximum Capacity, you may need more classes for that level and category.
Next Class Fields: Day and Time fields on enrollment, transfer, freeze, and user group tabs show the next scheduled class after the report end date. They may be blank if no future class exists.
Frequently Asked Questions
Why does the report require a single club?
The report is designed to run for one club at a time so that group enrollment rules, pricing, categories, and active contract counts are calculated against a single club configuration. If you select All Clubs, the report will return an error.
What happens if I leave Activity Categories or Timetable Categories blank?
Blank category filters mean all non-deleted categories are included for the selected club. Use these filters only when you want to narrow the report to specific programs, levels, or timetable groups.
Why do active counts differ between the summary tabs and detail tabs?
Summary tabs aggregate records by category or level, while detail tabs show the underlying student, contract, group, and enrollment rows. Differences usually come from date range logic, deleted enrollments, transfers, contract removals, or category filters. Use the detail tabs to investigate the records behind a summary count.
What does the Level Progression star rating measure?
The star rating measures how long a student has been in their current activity level. It does not measure attendance, assessment quality, effort, or skill performance. Students at the highest configured level are treated as 5-star progression.
Why is a student missing from Level Progression?
The Level Progression tab focuses on students who are actively enrolled at the end of the report period. If a student left before the end date, has no active group enrollment, was removed from a group, or is outside the selected categories, they may not appear.
When should I use Level Progression - Contract Breakdown?
Use the Contract Breakdown tab when a student’s Weeks In Level looks unusually high or when you need to audit whether the time in level spans multiple contracts. It shows each contract window that contributes to the student’s current level history.
What is the difference between Activity User Level Name and Group Level Name?
Activity User Level Name is the level assigned to the student. Group Level Name is the level assigned to the class group. If these values differ, review the student’s placement because they may be enrolled in a group that does not match their current level.
Why is Price Effective From blank in Group Enrollment Settings?
Price Effective From only shows a pricing schedule date when a price change falls within the selected report date range. A blank value does not mean there is no price. Check Gross Price for the current price.
What do the Day and Time fields represent?
Day and Time fields show the next scheduled class after the report end date for the relevant group. These fields may be blank if there is no future class scheduled.
How should I investigate deleted or removed enrollments?
Use Removed from Group (Contracts) for students removed because a contract was deleted before the contract start date. Use Removed from Group (Transfers) for students removed as part of transfer-related group movement.
Troubleshooting Guide
This section helps you resolve common issues you might encounter when generating or interpreting the Course Summary Report.
1. Data Discrepancies
Issue: The "Active End of Period" count does not seem to match your manual records.
Check Filters: Ensure Date Since and Date Until cover the exact period you are auditing. Group and enrollment records are included when they start, end, or span the selected range.
Check Active-End Logic: Active End of Period only counts non-deleted enrollments that remain active beyond the report end date.
Club Selection: Regenerate the report with the correct single Club. The report is not designed for All Clubs.
Category Filters: If Activity Categories or Timetable Categories were selected, records outside those filters will be excluded.
Deleted Records: The report excludes deleted or inactive users and excludes deleted enrollments from active counts. Removed-from-group tabs separately show enrollments deleted during the selected period when they meet the contract or transfer logic.
2. Missing Categories or Levels
Issue: Certain Activity Categories (e.g., "Holiday Program") are missing from the summary.
Filter Selection: When running the report, ensure you haven't accidentally limited the Activity Categories filter. If you select only "Swimming," the report will hide all other activities.
Group Configuration: A category will only appear if there are active User Groups associated with it that have start or end dates within your report range.
Permissions: Ensure the employee has permissions to view those specific categories in System Permissions.
3. Financial Inconsistencies
Issue: The "Student Balance" or "Contract Balance" appears incorrect.
Transaction Timing: The report calculates balances based on transactions that have a Due Date or Date on or before the current day. Payments scheduled for the future are not yet included in the balance.
Rolled Back Transactions: Any payments or invoices that were "Rolled Back" or "Excluded" in the system are automatically filtered out of the report totals to ensure financial accuracy.
4. Waitlist Availability Not Showing
Issue: A student is on the waitlist, but their preferred times (Monday, Tuesday, etc.) are blank.
Day Selection: In the system, waitlist entries must have specific days selected in the User Group Waitlist Day of Week settings. If the student was added to a general waitlist without choosing preferred days, those columns will remain empty.
5. Star Rating Confusion
Issue: A student has a 0 Star Rating (☆) but is a very active student.
Time in Level: Remember that the Star Rating is purely a measure of time spent in the current level, not the student's effort or behavior.
Example: A 0-star rating means the student has been in that level for over 52 weeks. This is a system flag to suggest they may need an assessment to move to a higher level.
Logic: Once a student is upgraded to a new level, their "Level Created Date" resets, and their Star Rating will return to 5 Stars (★★★★★).
6. Report Fails to Load
Issue: You receive an error message saying "Please select a single club."
Requirement: As defined in the system logic, the "All Clubs" filter will not work for this specific report. You must select one specific club from the dropdown menu and generate it again.