This article will walk you through the Location Summary and Chain Detail tabs when viewing the Gross Sales report at the Corporate level.
Please Note:
- The retrieval of reports is limited to a 10-year timeframe from the current date, and the download process may vary in duration depending on the selected time frame.
- Reports are not customizable.
- This report reflects outcomes in real-time.
- This report is only available within the corporate portal.
Content:
Location Summary Tab
Chain Detail Tab
Location Summary Tab
1. Access The Report
Navigate to Reports > Sales > Gross Sales > Location Summary.
Select your Date Range or choose a Preset Date Range. You may choose to filter by Division / District / Club. Select if you want to Exclude $0 Invoices, Include $0 Invoices or Show Only $0 Invoices. Click Run Report.
2. Understanding Your Report
Location Summary will provide tabs for Division Summary, Detail by Location and Sales Tax. Use the arrows above the report to view the different pages.
Division Summary: This tab is calculation Division revenue based on credit purchased, payments (memberships, add-ons, services, fees and manually added invoices), products and collections minus credit used, refunds and returns.
Detail by Location: This tab is calculating Location revenue based on credit purchased, payments (memberships, add-ons, services, fees and manually added invoices), products and collections minus credit used, refunds and returns.
Store ID: ClubReady ID for the club
Location Name: Name of club location
Division: The division the location belongs to
Payments: Total of membership, add-on, services, fees, and manual invoice payments taken during the report date range.
Down Total: The amount of Payments (membership, add-on, services, fees, and manual invoices) taken as down payments.
Down - Paid Up Front: The amount of down payments that were paid up front.
Down - Deferred: The amount of down payments that were deferred.
EFT Total: The amount of Payments (membership, add-on, services, fees, and manual invoices) that were EFT.
EFT - Draft: The amount of EFT payments that were drafted by ClubReady.
EFT - In Club: The amount of EFT payments that were paid by POS in the club.
Membership: Amount collected for sales packages created as a Membership.
Membership Down: Amount collected for Memberships marked as down payment.
Membership EFT: Amount collected for Memberships marked as draft.
Add On: Amount collected for sales packages created as a Membership Add On.
Services: Amount collected for sales packages created as a Service.
Manual Invoices: Amount collected for manually created invoices (invoices created by staff with permissions).
Fees: Total amount collected in invoices classified as a fee.
Cancellation: Amount collected for cancellation fees.
Enhancement: Amount collected for enhancement fees.
Freeze - Monthly: Amount collected for monthly freeze fees.
Freeze - Setup: Amount collected for one - time freeze fee.
Misc.: Amount collected for invoices created as a miscellaneous fee.
Setup: Amount collected for setup fees included in sales packages.
Client Credit Purchased: The amount of credit that a member purchases for his/her account that can be applied to a payment at a later date.
Products: The amount paid for products.
Past Due: Amount taken for invoices that have been placed into a collections category based on your Late Pay Settings.
Total Payments Made: The sum of Payments (membership, add-on, services, fees, and manual invoices), Client Credit Purchased, Products, and Collections.
Payments Using Client Credit: The amount of client credit applied towards total payments.
Payments Using Credit Memos: The amount of credit memos applied towards total payments.
Subtotal - Gross Revenue: The amount of total payments (membership, add on, services, manual invoices, fees) + client credit + products + collections payments using client credit & credit memos. This amount is prior to refunds and returns made.
Returns: Total of returns completed (credit card chargebacks or bad checking accounts).
Refunds: Total of refunds made back to the clients.
Subtotal - Refunds & Returns: Total of returns and refunds made.
Net Revenue: The amount of total payments (membership, add on, services, manual invoices, fees) + client credit + products + collections payments using client credit & credit memos refunds returns.
Chain Detail Tab
1. Access The Report
Navigate to Reports > Sales > Gross Sales.
Select your Date Range or choose a Preset Date Range. You may choose to filter by Division / District / Club. Select if you want to Exclude $0 Invoices, Include $0 Invoices or Show Only $0 Invoices. Click Generate Gross Sales Report.
2. Understanding Your Report
All Detail Export: This report will provide details tied to each individual invoice for the date range selected. There will be different tabs for this spreadsheet: Gross Sales by Payment Category, Gross Sales by Transaction Type, Payment Breakdown and Detail.
Gross Sales By Payment Category: This tab is calculating revenue regardless of how a payment was made (down or EFT). It looks at credit purchased, payments (including memberships, add-on, services, fees and manually added invoices), products and collections minus credit used, refunds and returns.
Gross Sales By Transaction Type: This tab is intended to show a revenue breakdown based on down and EFT payments. It takes credits purchased, down payments (up front and deferred), EFT (draft and in club), products and collections minus credit used, refunds and returns.
Payment Breakdown: This report will show all payments collected Through CR and Not Through CR. For Full Service Clubs you will see Reconciled amounts and what has not yet been reconciled. It will also include a Past Due Breakdown showing Payment Total and Days Late for those invoices.
Date: Date on which the invoice was paid.
Time: Time the payment was taken.
User ID: User ID of the member, if the transaction is tied to a member.
Barcode: Barcode of the member, if the transaction is tied to a member.
Last Name/First Name: First and Last name of the member, if the transaction is tied to a member.
Membership Type: Membership type tied to the member.
Due Date: Date on which the invoice was due.
Days Late: Will display how old is the invoice at the moment of payment.
Invoice ID: Unique ID number of the invoice.
Description: Description of the product or invoice.
Invoice Type: Type of invoice (Credit Purchased, Payment, Product, Collections, Refund, or Return). These match the payment categories on the first summary tab of the report (Gross Sales by Payment Category).
Payment Category: What category the sale falls under (Membership, Add-on, Services, Fee, or Manual Invoice). These match the categories in light gray on the first two summary tabs. For refunds, this will also show if the refund was for a product.
Transaction Type: How the transaction was made for payments (membership, add-on, services, or fees), product, or collections. This column will specify paid up front or deferred if it was a down payment, and it will specify draft (through CR) or in club (paid at POS) if it was an EFT payment. Additionally, if credit is placed on a members account through a refund, this will specify that the Transaction Type is Refund for a client credit Invoice Type.
Fee Type: Type of fee, if it was a fee invoice.
Product Category: Product Category tied to the product. This report will show up to 3 levels of categories that a product is assigned.
Product Barcode: Assigned barcode for this item.
Auto-Renew: If the invoice paid is set to auto renew.
Repay: If this invoice was attempted to be paid multiple times.
Purchase Amount: Amount of the invoice without sales tax.
+Sales Tax: Sales tax of the invoice.
Payment Total*: This shows the amount of the payment that is considered club revenue. For refunds to client credit, this will be the sales tax amount. For refunds and returns, there will not be a payment amount, and for all other payments this will be the Purchase Amount.
Client Credit Used*: The amount of client credit applied towards the payment.
Credit Memo*: The amount of credit memos applied towards the payment.
Gross Revenue*: Total invoice gross for the club.
Refunds & Returns*: Any refunds or returns processed.
(*These columns are meant to be used to calculate total revenue.)
CR: Credit Card: The amount of the total purchase amount made with credit card through ClubReady.
CR: Bank ACH: The amount of the total purchase amount made with a bank account.
Ext. Terminal: The amount of the total purchase amount made external to ClubReady.
Check: The amount of the total purchase amount made with a check.
Cash: The amount of the total purchase amount made with cash.
Credit Memo: The amount of the total purchase amount made using a credit memo.
Client Credit: The amount of the total purchase amount made using client credit.
List Price: Original invoice value of the item based on its settings.
Discount: New amount of the item if it was discounted.
Wholesale Price: Wholesale price of the item if entered under product settings.
Original Invoice Detail: Refunds only. Detail on the invoice that was refunded.
Session Credits: Number of session credits tied to the invoice, if any.
Primary Sales Person: Who the primary sales person was when ringing up this invoice.
Secondary Sales Person: Who the secondary sales person was when ringing up this invoice.
Ran By: Name of the staff member who ran the sale (if this is blank, the payment was rung up during agreement write up without a staff member logging into a POS terminal, or it was ran by the draft).
POS Terminal: Which point of sale terminal the transaction was rung up on (if this is blank, the payment was rung up during agreement write up without a staff member logging into a POS terminal).
Reconciled - Full Service Clubs Only: Amount of reconciled payments.
Card Entry Method: If a card was used, this will show as "Card Present" or "Card Not Present."
Agreement ID: ID of the agreement (If the invoice is tied to an agreement).
Agreement Date: Date the agreement was sold (If the invoice is tied to an agreement).
Agreement Salesperson 1: Primary sales person who sold the agreement (if the invoice is tied to an agreement).
Agreement Salesperson 2: Secondary sales person who sold the agreement (if the invoices is tied to an agreement).
Notes: Notes associated with this sale.
Requirements - A 'Master Admin' login or a staff login with the following permissions.
- Corporate - Reporting: Can access reports (must be enabled to see any reports)
- Corporate - Reporting: Can access sales: gross sales log