Direct Debit Authorization Report

Introduction

This article is about to give more profound understanding of the Direct Debit Authorization report. The report generates information about the users who chose automatic method of payment in the form of direct debits. It contains basic data of club member, information on users payment history as well as the number of failed payment attempts (also called duplicates).

• This article will explain what triggers the duplicates and what is the mechanism. 
• This article will be helpful to PG Champion, Administrator, Finance & Accounting, Sales Manager, Club Manager, Club Owner and Front Desk staff.

Before you start

Recurring Direct Debit is an automatic form of payment by which you can charge your members for every Payment Interval. If you need more information on how it works, check this article.

Instruction

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

2. Find the Direct debit authorisation 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 - you can select one or all clubs.
• Authorisation status - you can select the Direct Debit mandate status by:
  • All,
  • Unauthorised,
  • Authorised. 

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 - Club
• Column B - User number
• Column C - Full name
• Column D - Email
• Column E - Personal ID
• Column F - Mobile number
• Column G - IsAuthorized -  Authorization statuses:
  • YES - means that the mandate was authorized;
  • NO - means that the mandate was not authorized;
  • IN PROGRESS - means that the authorization booking has been created and sent - not applicable to GoCardless;
  • PENDING - means that the authorization booking was created, but was not sent - not applicable to GoCardless;
  • TO BE AUTHORISED - other cases where the user has payment source marked as Direct Debit - this one is also not applicable to GoCardless;
• Column H - Number of error tries in last 30 days - the number of authorization attempts with booking authorization - not applicable to GoCardless.
• Column I - Date of last status update - the date when the last mandate status was received.
• Column J - Last billing error (removed from 06.03.25),
• Column K - RejectReason
• Column L - Start date
• Column M - End date
• Column N - Access rules and payment plan - Access rules currently set on the contract.
• Column O - Membership
• Column P - Payment plan - information about member's payment plan.
• Column Q - Join date
• Column R - Membership Status - status of the contract.
  • Live - membership is current.
  • Cancelled transfer - membership is ended, and the member had a home club transfer within the contract.
  • 10DMB - 10 Days Money back - this status refers to the contract being cancelled within X days of the contract sign up date. This value can be changed, please contact support using the GetSupport module to enquire about how to get this value changed.
  • Not started - contract start date is greater than today's date.
  • Freeze - contract is currently frozen.
  • Cancelled - contract end date is in the past
• Column S - Financial status - financial status of the club member (not contract).
  • Ok - club member balance is $0.00.
  • Credit - club member balance is greater than $0.00.
  • Debit - club member balance is less than $0.00. 
• Column T - Balance - current member's balance.
• Column U - Consultant employee - the name of the employee associated with the contract.
• Column V - Company name