Skip to main content

Report - Payment Plans

Updated

Introduction

The Payment plans report showes the summary of payment plans provided for members. The report generates information about the number of contracts signed in a particular payment plan, the date of its creation, the cost of the membership fee, as well as information about the minimum duration of the contract.

  • This article provides a detailed overview of the Payment Plans report
  • This article will be helpful for PG Champion, Club Owners and Sales Team

Before you start 

To access this report, please add the following employee permissions to the suitable employee roles in PGM -> Clubs -> Employee permissions.

  • Reports
    • Finances
      • Payment Plans

More information about payment plans can be found here.

Fast lane

  1. Navigate to PGM -> Reports -> All.
  2. Search for Payment Plans or select the Finances tab to find the report.
  3. Apply the desired filters (e.g., clubs, date range).
  4. Generate the report in XLS format.

Feature description

To access the report, go to PGM -> Reports -> All.

You can use the search filter and find Payment Plans or select Finances tab and find the report.

In the report filters, the below filters are present.

  • Clubs - Select which club this report will generate. If left blank this will generate a report for all clubs your employee profile can view.
  • From / To - Select a date range to show the values within the date range.

Report Extract

Press XLSX to generate the report.

Multiple tabs may be generated here, this depends on the filters and features used within the system.

1. Payment plans

This tab will always generate, will provide a list of all payment plans which match the filters used in the report generation.

  • PaymentPlanId - The unique payment plan id.
  • Payment Plan Name - Name of the payment plan.
  • Start date - Start date of the payment plan.
  • End date - End date of the payment plan.
  • Is active - Is the payment plan active.
  • Is deleted - Is the payment plan deleted.
  • Membership fee - The current membership fee as per the from date.
  • VAT Rate - The tax rate of the membership fee.
  • Secondary vat rate - If there are secondary tax rates, this will display that tax rate here.
  • Administration fee - The current admin fee as per the from date.
  • VAT Rate - The tax rate of the admin fee.
  • Join Fee - The current join fee as per the from date.
  • VAT Rate - The tax rate of the join fee.
  • Freeze fee - The freeze fee connected to the payment plan.
  • VAT Rate - The tax rate of the freeze fee.
  • Is freeze allowed - If the payment plan can use the freeze module.
  • Contracts count - The count of contracts created from this payment plan. This is set for the whole site regardless of club filter.
  • Not ended contracts count - The count of contracts that are current. This is set for the whole site regardless of club filter.
  • Created date - The created date of the payment plan.
  • Created by - The employee who created the payment plan.
  • Payment interval - The payment interval name on the payment plan.
  • Min contract time - The minimum contract period on the payment plan.
  • Minimum resignation period - The minimum resignation period of the payment plan
  • Access rules - Name of the access rule connected to the payment plan.
  • Category - Name of the payment plan category connected to the payment plan.
  • Payment plan type - Name of the plan type connected to the payment plan.
  • SourceName - Name of the sources where the payment plan is visible.
  • AddOn Name - Name of the Contract Add ons connected to the payment plan.
  • EmployeeRoles - Name of the employee roles who can view this payment plan.
  • PgmPpLink - The URL link of the payment plan to edit the payment plan.
  • AssignedClubs - Name of the clubs that can sell this payment plan.
  • FreezeTypeName - Name of the freeze types connected to this payment plan (must be valid within the Date From field)
  • ContractDiscountName - Name of the contract discounts connected to this payment plan (must be valid within the Date From field)
  • IsAdditionalPaymentPlan - Is the payment plan counted as a secondary/additional contract.
  • SynchronizeWithContract - Will the contract be synchronized to the main contract at the time of contract creation.
  • Min age - Minimum age required to sign up to contract.
  • MaxAge - Minimum age required to sign up to contract.
  • DirectDebitRecurringRequired - Payment plan requires a direct debit (bank account) payment source for recurring payments.
  • CreditCardRecurringRequired - Payment plan requires a credit card payment source for recurring payments.
  • CashPaymentSourceRequired - Payment plan requires a cash payment, this payment can come from PGM, POSWeb, Client Portal or API, from Cash, Credit Card, online gate or other sources.
  • CorporateInvoicingRequired - Payment plan requires a company payment source, designed for the corporate module.
  • AllowablePOSDebit - The amount of debt a club member has for POS Cashless transactions.
  • FamilyPacketPlanType - Two options may be visible here, this relates to the parent/child relationships of a payment plan.
    • Packet - The parent of the payment plan of the family packet system.
    • Packet Element - The child payment plan of the family packet system.
  • PaymentIntervalFromContractStartDate - If the recurring billing date will start from the contract start date.
  • PaymentIntervalFromSelectedDay - If the recurring billing date will start from a fixed hardcoded date.
  • LastRecurringDate - The last recurring billing date if PaymentIntervalFromSelectedDay is used. This will calculate the last billing date based on the first debit date of the plan type, and using the payment interval for the calculation.
  • IsEndProrata - If the end date of the contract does not at the end of the recurring fee billing cycle, this will pro-rata the last membership fee to only the days left remaining in that period.
  • ProrataAlgorithm - The algorithm used in pro-rata calculations.
  • AutomaticRenew - Will the contract automatically renew to a new payment plan at the end of the contract.
  • AutomaticRenewToPaymentPlan - The name of the payment plan the contract will automatically renew to.
  • CanRenew - Can the payment plan be manually renewed to a new contract.
  • IsEarlyTerminationFee - Does the payment plan have an early termination fee if the contract was cancelled within the minimum commitment period.
  • EarlyTerminationFeeFixedValue - The fixed value used if early termination fee is triggered.
  • EarlyTerminationFeeValue - The value used if early termination fee is triggered, the type will determine if the value is a percentage or set amount.
  • EarlyTerminationFeeType - The value here could be Percentage or Value.
  • EarlyTerminationFeePolicy - How the termination fee is set.
    • Past - Length of contract used will be used as the calculation.
    • Remaining - Length of contract remaining will be used as the calculation.
    • LowerOfTwoPastOrRemainingFeeSum - The lower value of the Past or Remaining will be used as the calculation.
  • EarlyTerminationFeeVatRate - The VAT rate of the early termination fee.
  • StopChargingAfterMinPeriod - Once the contract has past the minimum commitment period, will the contract add additional recurring membership charges to the contract.
  • IsUpfrontPayment - The first membership fee of the contract will have a due date of the sign up date.
  • IsInitialFeeRequiredDuringOnlineRegistration - Will payment be required at the time of signup. If credit card (recurring) was used at the sign up source, this will automatically request payment through the source, alternate this will use the payment gate during the client portal online process.
  • PaymentInAdvanceSummary - Set all membership payments to the contract sign up date.
  • PaymentInAdvanceDueDateSchema - Set all membership payments to the contract sign up date, or a unique due date schema pre-set (if used).
  • PreSelectedInCP2 - If the payment plan is pre-selected during the client portal process.
  • AgreementTemplate - Name of the RDLC file used to generate a contract.
  • TemplateOfRules - Names of the PDF files that will be attached to the contract PDF file.

2. PaymentPlanBenefits

This tab will only display if the site has implemented the custom feature “Benefits“ on their site and only for payment plans listed in the tab Payment Plans

More information about payment plan benefits can be found here.

  • PaymentPlanId - The unique payment plan id.
  • PaymentPlanName - Name of the payment plan.
  • Benefit Name - This will create columns for each benefit listed, if the value is True then this payment plan will show the value on client portal.

3. FutureMembershipFeeChanges

This tab will only display if there is a membership fee change set in the future. Will display the current vs new price changes.

  • PaymentPlanId - The unique payment plan id.
  • Payment Plan Name - Name of the payment plan.
  • CurrentMembershipFeeBrutto - Current gross price (include tax) of the membership fee as of report generation date.
  • VAT Rate - Current tax rate as of report generation date.
  • CurrentMembershipFeeNetto - Current net price (excluding tax) of the membership fee as of the report generation date.
  • CurrentMembershipFeeVat - Current tax amount of the membership fee as of the report generation date.
  • ->
  • EffectiveFrom - Date of the price change.
  • MemFeeBrutto - New gross price (include tax) of the membership fee from the EffectiveFrom date.
  • VAT Rate - New tax rate from the EffectiveFrom date.
  • MemFeeNetto - New net price (excluding tax) of the membership fee from the EffectiveFrom date.
  • MemFeeVat - New tax amount of the membership fee from the EffectiveFrom date.

4. FutureAdminFeeChanges

This tab will only display if there is a Admin fee change set in the future. Will display the current vs new price changes.

  • PaymentPlanId - The unique payment plan id.
  • Payment Plan Name - Name of the payment plan.
  • CurrentAdminFeeBrutto - Current gross price (include tax) of the Admin fee as of report generation date.
  • VAT Rate - Current tax rate as of report generation date.
  • CurrentAdminFeeNetto - Current net price (excluding tax) of the Admin fee as of the report generation date.
  • CurrentAdminFeeVat - Current tax amount of the Admin fee as of the report generation date.
  • ->
  • EffectiveFrom - Date of the price change.
  • AdminFeeBrutto - New gross price (include tax) of the Admin fee from the EffectiveFrom date.
  • VAT Rate - New tax rate from the EffectiveFrom date.
  • AdminFeeNetto - New net price (excluding tax) of the Admin fee from the EffectiveFrom date.
  • AdminFeeVat - New tax amount of the Admin fee from the EffectiveFrom date.

5. FutureJoiningFeeChanges

This tab will only display if there is a Joining fee change set in the future. Will display the current vs new price changes.

  • PaymentPlanId - The unique payment plan id.
  • Payment Plan Name - Name of the payment plan.
  • CurrentJoiningFeeBrutto - Current gross price (include tax) of the Joining fee as of report generation date.
  • VAT Rate - Current tax rate as of report generation date.
  • CurrentJoiningFeeNetto - Current net price (excluding tax) of the Joining fee as of the report generation date.
  • CurrentJoiningFeeVat - Current tax amount of the Joining fee as of the report generation date.
  • ->
  • EffectiveFrom - Date of the price change.
  • JoiningFeeBrutto - New gross price (include tax) of the Joining fee from the EffectiveFrom date.
  • VAT Rate - New tax rate from the EffectiveFrom date.
  • JoiningFeeNetto - New net price (excluding tax) of the Joining fee from the EffectiveFrom date.
  • JoiningFeeVat - New tax amount of the Joining fee from the EffectiveFrom date.

 

Related articles