Introduction
The Corrections report is a financial audit tool designed to track manual and system corrections applied to member transactions. This report supports the financial monitoring process by offering transparency and accountability for any adjustments, deletions, or rollbacks of member balances. The purpose of using this report is to maintain accurate financial records and investigate any discrepancies by seeing exactly who made a correction, when it was made, and why.
In this article, you will learn how to configure permissions for this report, how to generate it, and how to interpret the specific financial data columns and filters.
This article will be helpful for Financial Controllers, Club Managers, and Accounting Personnel.
Before you start
To ensure employees can access and generate the report, you must verify their system permissions.
Navigate to PGM -> Clubs -> System Permissions.
Select the Employee Role (e.g., Club Manager, Accountant).
In the search bar, type Corrections.
Locate the permission for the Corrections and check the box.
Save your changes.
Fast lane
Here is a brief overview of the steps to generate the report. The following sections contain more detailed information.
Navigate to PGM / Reports / All.
Search for "Corrections" or look under the Finances category.
Click on the report name to open the filter settings.
Select the Club, Date range, and Transaction Status.
Click on XLS to generate the report.
Instruction
How to generate the report
To access the report, go to PGM -> Reports -> All.
Locate the Report
Use the Search Bar at the top of the page and type Corrections.
Alternatively, use the category filters on the left by checking the Finances category.
Click on the report name to open the generation screen.
This will display the filters that can be used to generate the report:
Club: Select the specific club location you want to report on. You can leave blank to include transactions from all clubs that the current employee has access to.
Date Since: The start date and time for the period you wish to report on. This date range is used to look for: (1) The original transaction date for non-deleted corrections; or (2) The deletion time for deleted corrections.
Date Until: The end date and time for the period you wish to report on.
Employee: Filter the report to only show corrections created by a specific employee or all employees.
Transaction Status: Filter the report based on whether the correction transaction has been subsequently deleted.
Example: Select 'All' (to show both deleted and non-deleted corrections), 'NotDeleted' (to show only current corrections), or 'Deleted' (to show only corrections that have been deleted).
Press XLSX to generate the report.
Report extract
The report provides a single, detailed view of all user transaction corrections that match your filter criteria.
Corrections Detail
This section lists the individual details of each corrected user transaction.
Club Name: The name of the club where the member's account is managed.
Employee Name: The name of the employee who originally created the correction transaction.
Date: The date of the transaction.
Note: This date is pulled from the full date/time field but is shown without the time for grouping purposes.
Add Date: The exact date and time when the user transaction was added to the system.
User Number: The unique membership ID or user number for the member.
User Name: The full name of the member (First Name + Last Name) associated with the transaction.
Payment Plan Name: The name of the member's current payment plan.
Note: If no payment plan is linked, this will be blank.
Description: A short description of the user transaction.
Date With Time: The full date and time of the transaction, including hours, minutes, and seconds.
Member Fee: The gross amount of the member fee associated with the payment plan at the time the transaction was effective.
Note: This value is zero if no applicable member fee history is found.
Correction Amount: The gross amount of the correction transaction. A positive value increases the member's balance, and a negative value decreases it.
Balance Before: The member's accumulated balance immediately before this correction transaction was applied.
Note: This is calculated by summing all previous non-excluded transactions for that member.
Balance After: The member's new balance after this correction transaction was applied.
Logic: Calculated as
Balance Before+Correction Amount.
Transaction Status: Indicates if the transaction has been deleted.
Logic: This column shows the transaction status. If the transaction has been deleted, it will appear as 'Deleted'. Otherwise, it will be blank.
Del Employee Name: The name of the employee who deleted the correction transaction.
Note: This will be blank if the transaction has not been deleted.
Deleted Time: The date and time when the correction transaction was deleted.
Note: This will be blank if the transaction has not been deleted.
Deleted Reason: The reason provided for deleting the correction transaction.
Note: This will either be the text entered by the employee or the value from the system dictionary if a pre-defined reason was selected. It will be blank if the transaction has not been deleted.
Hints
Date Range Interpretation: The report looks for two types of dates within your
Date FromandDate Tofilter:The original transaction date for corrections that are not deleted.
The deletion date for corrections that are deleted.
Filtering for Corrections: The transactions included in this report are specifically those marked as a 'Manual' correction or a 'System Correction'.
Mode Parameter: If you select a value for the
@Modefilter other than NULL (blank), the report output will change to a simple count of the transactions that meet your criteria, instead of providing the detailed list.