Report - E-Payment Settlement Summary

Introduction

This report will summarise when payments are made into PerfectGym by a payment provider.  This may help with the reconciliation of settlements.

Note: This report will not display any additional fees taken out by a payment provider.

Before you start 

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

• Reports
  • Finances
    • EPayment Settlement Summary

Instruction

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

2. Find the E-Payment Settlement Summary report by either using the search filter, or selecting the Finances tab. 

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

• Club - Select clubs assigned to members or leave the filter empty to generate a report for all clubs.
• From/To - Select the date range in which payments were made into PerfectGym by a payment provider.
• Show Details - This will produce a new tab which will display a list of all transactions on the report.

Show Details is a new feature coming soon!

4. Press XLSX to generate the report.

Report Extract

The report will open up with four tabs.

Settlement By Date

This tab will summarise the payments made by recurring billings by the payment date only.  If selecting multiple clubs, this will separate each club in its own table.

• Club - The club that generated the debit.
• Provider Type - The source of the payment (Direct Debit or Credit Card).
• Date - Date of the payment.  The report will generate a new column for each day a payment is made.

Settlement By Generation Date

This tab will summarise the payments made by recurring billings by the generation date.  If selecting multiple clubs, this will separate each club in its own table.

The values shown here is for any payments that were received between the two dates shown. This may include recurring fees which were created/generated/balance for date outside of this period.

• Club - The club that generated the debit.
• E-Payment Name - The file name generated of the payment.  This will display information about the type of file generated and the time of processing.
• Created Date - The date the generation file was created.
• Balance Date - Balance date used on the recurring billing. 
• Charged Amount - The total amount sent to the payment provider.
• E-Payment Total OK - The total amount on that recurring billing that was successful by the payment provider.
• E-Payment Total In Progress - The total amount on that recurring billing which is still currently in progress by the payment provider.
• E-Payment Total Error - The total amount on that recurring billing that was rejected by the payment provider.
• Date - Date of the payment.  The report will generate a new column for each day a payment is made.

Settlement Credit Card / Direct Debit

The last two tabs will split the tab Settlement By Generation Date by displaying only values which are done by credit card or direct debit.

Details

If you have selected Show Details on the report, this will produce a new tab displaying all information about all payments made on this report.

• Epayment Name - Name of the file the payment was a part of.
• Payer User Number - User number of the payment source holder.
• Payer Full Name - Full name of the payment source holder.
• Payer Email - Email address of the payment source holder.
• Payer Phone - Phone number of the payment source holder.
• Provider type - If the payment was made by Bank (Direct Debit) or Credit Card.
• Created date - Creation date of the payment file.
• Balance Date - Balance date of the payment file. This is to determine which transactions are selected on to be sent to a payment provider to be paid.
• Charged amount - The total amount to be charged.
• Processing Status - This is the status of the payment.
  • New - Payment has not been sent to the payment provider.
  • InProgress - Payment has been sent to the payment provider, however, no results have been returned.
  • Ok - Payment is successful.
  • Error - Payment is not successful.
• Last Payment Update - The date of the last status of the payment. If payment is OK or Error, this is the date of the results from the payment provider if this is automated (Manual file uploads are dated to when the file was uploaded).
• Epayment Total Ok - Total amount if payment was OK /  Successful.
• Epayment Total In Progress - Total amount of payments that are still in progress.
• Epayment Total Error - Total amount of payments that failed.
• Provider Internal Payment Id - Selected payment providers will provide an external reference number, this is the id of that payment.