Introduction
This article explains how administrators can generate the BACS report for franchise clubs within a specified period using the Franchise module in Perfect Gym. The report's data are strictly related to the uploaded payout files and items added to the club statements during this process.
- This article will be helpful for administrators, who generate the BACS report for clubs in a chosen period, when using the Franchise module.
Before you start
Please make sure that:
1. You have enabled the necessary permission: Franchises -> Club Statement -> FranchisesClubStatementsExportBacsFile
2. The bank details and company information for each club have been configured in the Configuration Tab. Read more in this article
Fast lane
- Go to PGM -> Franchise ->Club Statement.
- Click the Actions button and select Export BACS file.
- Choose the date range.
- Select the Payout File Upload Date.
- Click Export to download the report as an Excel file.
Instruction
How to generate the BACS report in the Franchise module in PGM?
- Go to the PGM -> Franchise -> Club Statement
- Go to Actions button and choose the Export BACS file
- Choose the dates for which you want to import the data.
The format of the date is DD/MM/YYYY 00:00, so if you uploaded the file on 2nd of January, the 'date to' should be 03.01.2025.
Select the payout file data, as this is the point when money transfer items are added to the club statement. The title of the item is taken from the uploaded file.
4. Click Export to download the report as an Excel file.
Field Descriptions:
-
Bank Sort Code – this value should be set individually for each club in the Configuration Tab. If left empty, no value will be displayed in the report.
-
Bank Account Number – configured per club in the Configuration Tab. If not specified, it will automatically use the club’s default bank account number.
-
Company Name – sourced from the Configuration Tab. If no custom name is set, the system will use the default company name linked to the club.
-
Location – determined by the club’s setup in the Configuration Tab. If not manually defined, the club's standard location will be used.
-
Value To Paid - represents the amount generated after uploading the payout file. This value is then included as a money transfer item in the club statement.
If you select a date range covering more than one payout file upload, the amounts will appear as a list — one line for each uploaded file.
Hints
-
You can download the BACS report at any time during the month.
-
The report can be generated for various date ranges, depending on your needs.