Income Settlement Report

Introduction

This article will familiarize you with the Income Settlement report which can be generated in PGM. Using this report, you can generate a detailed list of transactions along with information about their due dates, receipt number, and transaction type. Your specific Perfect Gym license will determine the reports available to you.

• Income settlement report allows you to generate a detailed list of incomes received by each member.
• This article will be helpful to PG Champion, System Administrator, Finance & Accounting Team, Sales Manager, Club Manager, Club Owner and Front Desk staff

Before you start 

Depending on your system permission, you may not be able to view some reports for security reasons. You can modify the visibility of these reports within System Permissions. Contact your PG Champion to modify the visibility and the system permissions for a given report. 

To access this report, please add the following employee permissions to the suitable employee roles Reports/Finances/IncomeSettlement. Go to PGM -> Clubs -> Employees -> System permissions.

• Reports
  • Finances
    • Income settlement

Instruction

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

2. Either use the search bar, type in Income settlement or select the Finances tab and find the report.

3. This will display the filters that can be used to generate the report:

• Club - Select which club/s this report will generate for. If left blank, this will select all clubs your employee profile has access to,
• Since / Until - Select the date range in which you want to generate the Income settlement

4. Press XLSX to generate the report.

Report extract

The system will generate the report with a detailed list of all contracts based on the filters used.

• Column A - Receipt number - the number of the receipt of a certain transaction,
• Column B - User number - user number of the club member,
• Column C - First name - first name of the club member,
• Column D - Last name - last name of the club member,
• Column E - Transaction type - the type of the transaction,
• Column F - Net Amount - total net transaction amount,
• Column G - Gross Amount - total gross transaction amount,
• Column H - Payment Type - transaction payment type,
• Column I - Payment plan - payment plan name of the contract,
• Column J - Home Club - the name of the home club of the member, 
• Column K - First payment date - first payment date in the interval selected in the date range filter,
• Column L - Period start date - start date of a certain transaction,
• Column M - Period in days - the number of days in a payment interval of a certain transaction,
• Column N - Amount to be settled - amount that has to be settled in a certain transaction.