Introduction
The All Contracts Report provides a comprehensive and detailed overview of all member contracts within a specified period. This powerful tool is designed to give you a complete picture of your membership base, from financial standings and payment details to contract statuses and key dates. The primary purpose of this report is to enable detailed analysis and management of member agreements, helping you track sales performance, monitor member retention, and manage financial records efficiently.
This report is ideal for Club Managers, Administrators, and Sales Staff who need access to in-depth contract information for operational, financial, and strategic planning.
Before You Start
To view this report, you must have the correct system permissions assigned to your employee role. If you cannot access the report, please contact your system administrator.
Here’s how to check and assign permissions:
- Navigate to PGM -> Clubs -> System Permissions.
- Select the Employee Role you wish to grant access to (e.g., 'Club Manager').
- A list of available reports and system functions will appear. To find the report permission, you can either:
- Use the search bar at the top and type "All Contracts".
- Browse through the different categories. This report is likely located under the Members or Sale category.
- Tick the checkbox next to All Contracts to enable access.
- Click Save.
How to Generate the Report
Once you have the necessary permissions, you can generate the report by following these steps:
- Navigate to PGM -> Reports -> All.
- The system will display a list of all available reports. To locate the All Contracts Report, you can:
- Use the search bar at the top of the page and type "All Contracts". This is the quickest method.
- Alternatively, click on the Members or Sale category to filter the list and find the report.
- Once you have found the report, click on its name to open the filter options.
Understanding the Filters
Before running the report, you will need to set the following filters to specify the data you want to see.
- Club: Select the club you want to run the report for. You can also choose "All Clubs" to see data from every club you have access to.
- Date Selector: This filter determines which date field the report will use to find contracts.
- JoiningDate: The report will include contracts where the member's sign-up date falls within your selected date range.
- StartDate: The report will include contracts where the official start date falls within your selected date range.
- CreatedDate: The report will include contracts that were created in the system within your selected date range.
- Start Date: Select the first date you want to include in the report. For example, to see all contracts from the beginning of the month, select the 1st.
- End Date: Select the last date you want to include in the report.
- Contract Type: This allows you to filter by the type of contract.
- Contract: Shows only primary membership contracts.
- AddOn: Shows only additional contracts or add-ons.
- All: Shows both Contracts and AddOns.
Report Output
The report output is a single, detailed table. Below is an explanation of each column you will see.
Contract id : Unique ContractId.
Club : Club name of the club connected to the home club of the user. This may not be the same location the purchase location of the contract.
User number : User number of the club member.
Name : First name of the club member.
Last name : Last name of the club member.
Email : Email address of the club member.
Personal ID : Personal ID connected to the club member.
Birth date : Date of birth of the club member.
Contract type : There are two types of values here.
Contract : Main contract.
Add On : Add on / Secondary contract. Courses are treated as Add On contracts.
Access rules : The name of the access rule connected to the contract.
Payment plan type : The payment plan type name connected to the payment plan.
PaymentPlanCategoryName : The payment plan category connected to the payment plan.
Payment Plan Name : The name of the payment plan.
Previous contract : The previous contract connected to the club member.
Company name : Company name connected to the corporate module.
Tax Id : Company NIP field. Taken from the company connected to the user profile from u.CompanyDataId
Membership fee : Membership fee value of the contract. This will not show Cost Per Class in courses.
Is new : There are two values connected here.
NEW : When the user created date is greater then the From date field in the report filter.
REACTIVATED : When the difference in months between the old contract end date and the new contract start date is greater then 2 months.
[No value] : None of the above values.
Created date : User created date (not the contract created date)
Join date : The sign up date of the contract.
Start date : The start date of the contract.
CommitmentPeriod : The name of the commitment period used on the payment plan.
IsCommitmentOverride : If there is a value in the MinContractTime field in the contract, this is considered as the commitment period being overridden.
CommittmentEndDate : This will use the value in MinContractTime, else it will calculate the values based on the value in the commitment period on the payment plan.
Membership Status : There are multiple values connected here.
Guest : When club member has no contract, or user type does not equal 'Member'. Note CRM members will also be counted as guests here if included in report.
Live : When the contract status equals 'Current'
Cancelled Transfer : When the contract is ended and the field on the user profile UserTransferId is not null.
xDMB : Known as x Days Money Back, where X is the days set on PGM. Using the field
ContractNewInstantCancelDaysNumberindbo.MasterCmpSettings, if the difference between contract start date and contract end date is less then this number, it will use this as the Membership Status. For example if the value is 10. It will be 10DMB. Note: the standard value of this field is -1 on Australian databases. May only affect clients who have been with us for a while.Cancelled : Where the contract is cancelled, and does not meet the above xDMB rule.
Not Started : Where the contract start date is greater then the report generation date.
Freeze : Where the contract is on freeze at the time of the report generation date.
Financial status : The following options are available. The TodayBalance field is located on the User profile.
Ok : When the TodayBalance field is either null, or TodayBalance = 0.
Credit : When the TodayBalance field is greater then 0.
Debit :When the TodayBalance field is less then 0.
Paid : Total payment transactions on the contract paid up until the To date on the report filter.
Owed : Total charge transactions on the contract up to the To date on the report filter.
UserBalance : The current value in TodayBalance Field on the user profile.
Contract Balance : The current contract balance on the contract.
Mobile number : Mobile number of the club member.
Date of first payment : The date of the first payment made on the user.
Consultant employee : The name of the employee connected to the contract.
Payment method : The current payment method on the club member. if the source is paid by a parent, this will add their name to the payment method.
Mandate Id : This is either the user bank account agreement number (selected payment providers only) or the user number of the club member.
Source : This is the user created source (not the contract creation source). The following values are available.
Guest : This is the Anonymous profile created on POSWeb with the card entry functions.
Anonymous : Created when the club first logs into POSWeb. This is the 'Sale without a club member' User.
Web : User Created on PGM or POSWeb modules.
Crm : User Created on the CRM module.
Internet : User Created on Client Portal modules or via API.
IsOnlinePayment : If a payment on the user is an online payment.
Contract discount : Name of the contract discounts connected to the club member profile.
Add on : Name of the contract extras (add on) connected to the club member profile.
Automatically renewed : If the contract has been renewed. For example a new contract is in the future and connected to this contract using the Auto-Renew feature.
Has renewal : If the contract was renewed by a previous contract. For example the previous contract is connected to this contract.
Base contract : If the contract has a base contract. This contradicts 'Has Renewal'
Has cession or upgrade : If the contract has been transferred (cession) from one member to another or the contract was upgraded. This is the new contract.
Is cession or upgrade : If the contract has been transferred (cession) from one member to another or the contract was upgraded. This is the old contract.
Base contract signup date : The sign up date of the base contract.
Base contract start date : The start date of the base contract.
SyncToMainContractId : The main contract ID that this contract is synchronised to. This is populated for additional/add-on contracts that are linked back to a main contract for synchronisation.
SyncToMainContractName : The payment plan / contract name of the main contract that the current add-on or secondary contract is synchronised to.
SyncToMainContractStartDate : The start date of the main contract used for synchronisation.
SyncToMainContractEndDate : The end date of the main contract used for synchronisation. This helps identify whether the add-on or secondary contract follows the same lifecycle as the main contract.
RecurringPayMonthDay : For monthly billers only, this is the date set for recurring fee start dates for the month. This is the day number.
Cancel date : Cancel date of the contract.
Cancel reason : Cancel reason given for the cancellation of the contract.
End date : End date of the contract.
Required deposit : Required deposit for the payment plan, this is set up on the payment plan.
Collected deposit : The collected deposit from transactions, this is the value on the contract.
Future payments : If any payments have a date greater then the To date on the report filter. This will list the payments as a future payment.
ContractClub : The club name of the contract location.
FirstHomeClub : The first club the member joined, based on the user home club transfer
Contract created date : The creation date of the contract.
Paid total : The total payments made against the contract, regardless of date.
Owed total : The total charges on the contract up until todays date.
Tags : The list of tags against the club member.
FriendCount : The amount of friends connected to the club member profile.
FriendList : The full name and user number of the friends connected to the profile.
ChildrenCount : The quantity of children connected to the club member profile.
ChildrenList : The full name and user number of the children connected to the profile.
Last visit : The last visit recorded in PGM for the club member!
Debt collection stage : If the member is on debt collection, this will display the stage name.
Exclude From E-Payment : If the member is excluded from e-payment (recurring payments), this will display that they are.
Exclude From E-Payment Until Date : If the member is excluded from e-payment to a date, this will display the date.
State : State the club member lives in.
Hints
- Export for Deeper Analysis: This report contains a large amount of data. For easier analysis, use the export option to download the report as a CSV or Excel file. This allows you to sort, filter, and create charts based on the information.
- Financial Overview: The
Paid,Owed,TotalPaid,TotalOwed, andBalancecolumns provide a complete financial history of the contract. Use them to quickly identify members with outstanding debts. - Understanding Date Filters: The
Date Selectoris a key filter. Be sure to select the correct option (JoiningDate,StartDate, orCreatedDate) to ensure you are analyzing the exact set of contracts you intend to.