This article will walk you through generating and understanding the Gross Sales Detail Report at the Corporate level. This report details all paid invoices, less refunds and returns (returns are items like bounced checks and chargebacks).
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.
1. Access Your Report
Navigate to Reports > Sales > Gross Sales Detail.
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
The results will appear on the webpage listing gross sales, broken down by location, that occurred during the selected date range.
Location - The name of the club.
Down - All Memberships, Add-Ons, Services, Fees and Manual Invoice payments paid up front. Detail export further defines if Down was paid Up Front or Deferred.
EFT - All Memberships, Add-Ons, Services, Fees and Manual invoice payments drafted by ClubReady or paid In Club. Detail export further defines if EFT was Drafted (by CR) or paid In Club.
Products - All products. Excludes Collections.
Collections - All Collections.
Credit Purchased - Credit placed on account + Tax on Refunds to Client Credit.
Credit Used - Amount of client credit and credit memos applied to pay for all Down, EFT, Products, Collections and Credit Purchased.
Returns - All Returns.
Refunds - All Refunds (excluding refunds to client credit).
Net Revenue - Down + EFT + Products + Collections + Credit Purchased - credit Used - Returns - Refunds.
NOTE: Totals shown in the summary screen show the full Purchase Amount and client credit usage is separated out into its own column.
There are 2 export options that allows you to export this data to an Excel spreadsheet. Also, you may export individual locations by clicking on the Excel icon to the left of the club name.
All Detail - This report will provide the Gross Sales by Payment Category and Gross Sales by Transaction Type. The Payment Category option is calculating credits purchased, payments (including memberships, add-on, services, fees and manually added invoices), products and collections minus credits used, refunds and returns. The Transaction Type option will calculate credits purchased, down payment, EFT (draft and in club), products and collections minus credits used, refunds and returns. The export will also include Payment Breakdown and Detail.
Location Summary - this report shows the Division Summary, Detail by Location and Sales Tax.
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