Introduction
This article explains the POS Refund Report, a valuable tool for understanding your club's sales and refund activities.
Before you start
To access the report, ensure employees have the following system permissions in PGM -> Clubs -> System permissions.
- Reports
- Members
- POS Refund Report
- Members
What is This Report?
The POS Refund Report provides a detailed view of both product sales and any corresponding refunds. It's designed to help you track transactions, understand refund patterns, and link refunds back to their original sales.
Who is This Report For?
This report is primarily useful for:
- Business Analysts: To identify trends, analyze product performance, and understand financial impacts.
- Operations Managers: To monitor employee performance, track POS terminal activity, and review refund reasons.
What Information Does the Report Provide?
The report offers comprehensive details on each transaction line, separating information into two main categories:
1. Refund Details:
- Refund Club: The club where the refund was processed.
- User Information: The user's unique number and full name.
- Refund Date & Time: When the refund occurred.
- Refund Location: The specific POS terminal used for the refund.
- Refund Employee: The staff member who processed the refund.
- Refund Receipt Number: The unique identifier for the refund transaction.
- Refund Comment: Any notes or reasons recorded for the refund.
- Product Information: The category and name of the product that was refunded.
- Payment Plan/Contract Details: If the refund relates to a contract or payment plan, details about it.
- Refund Payment Type: How the refund was issued (e.g., cash, card).
- Refund Quantity: How many units of the product were refunded.
- Refund Amount: The total monetary value of the refund.
- Line Description: A description of the specific item line that was refunded.
2. Original Sale Details:
- Sale Club: The club where the original sale took place.
- Sale Date & Time: When the original sale occurred.
- Sale Location: The POS terminal used for the original sale.
- Sale Employee: The staff member who processed the original sale.
- Sale Receipt Number: The unique identifier for the original sales transaction.
- Sale Payment Type: How the original sale was paid for.
How to Use the Report
Go to PGM->Reports->All
In the members tab, select Pos Refund Report or use the search bar.
To generate this report, you'll need to provide the following information:
- Club: You must select a single club for this report. It cannot be generated for "all clubs" simultaneously. If your system only has one active club, it will automatically be selected.
- Date Since: The starting date for the period you want to report on. The report will include transactions from this date onwards.
- Date Until: The ending date for the period you want to report on. The report will include transactions up to this date.
Important Notes:
- Refund Values are Negative: To clearly distinguish refunds from sales, all refund quantities and amounts will appear as negative values in the report.
- Two Report Views: The report provides two separate worksheets for analysis:
- "PosRefund-ByRefundDate": Shows transactions where the refund date falls within your specified date range.
- "PosRefund-BySaleDate": Shows transactions where the original sale date falls within your specified date range. This helps you analyze refunds against the period when the initial purchase was made.
By utilizing this report, you can gain deeper insights into your club's sales and refund dynamics, helping you make informed business decisions.