 |
Knowledge Base |
Reports - Gross Sales Detail
|
This article is an overview of the Gross Sales Detail Report. This report details all paid invoices, less refunds and returns (returns are items like bounced checks and chargebacks). *Please note that this report is a functionality that may not be enabled by default in your club. Your club may be on a different version of this report. Please contact ClubReady Support for more information or to turn this version of the report on for your club.
Requirements - A Master Admin login or a staff login with the following permissions:
To access your Gross Sales Detail Report go to Reports > Sales > Gross Sales > Detail Tab. To generate your report, select your Date Range or choose a Preset Date Range. You may choose to specify by Transaction Detail, Filter By Employee Associated With Sale, select if you want to Exclude $0 Invoices, Include $0 Invoices or Show Only $0 Invoices, filter to a specific Client UserID (optional), Pending Refunds Date (Refund Attempted Date or Released Date) or Show Drafted Downpayments as (Down, Draft). Click Run Report.
The export will contain the following columns of information:
Date - Date in which the invoice was paid
Time - Time the payment was taken
Pending Refund Release Date - The date the refund was completed.
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 in which the invoice is due
Days Late - How many days late the invoice was when paid
Invoice ID - Unique ID number of the invoice
Description - Description of the product or invoice
Invoice Type - Type of invoice (Cancel Fee, Enhancement Fee, etc)
Payment Category - What category the sale falls under (Membership, Services, Late Fee, Cancel Fee, Merchandise)
Transaction Type - Type of the payment (Recurring, Paid Up Front, In Club)
CR Draft - specifies if the invoice was paid via the Draft
Fee Type - Type of fee, if it was a fee invoice
Product Category - Product Category tied to the product
Product Barcode - Displays the product's barcode
Auto-Renew - Is the invoice paid on auto renew
Repay - Funds collected after client issues a charge back
Void- displays if the invoice was voided
Purchase Amount - total amount of the invoice paid excluding sales tax
Avg Memb EFT - Lifetime average EFT, this includes Membership drafted down payments. (NOTE: Past Dues will NOT count towards Avg Memb EFT totals since they are in a different column)
+ Sales Tax - Sales tax of the invoice
Payment Total - Amount of invoice plus any sales tax
Client Credit - Payment made with client credit
Credit Memo- Payment made with a credit memo
Gross Revenue- The amount of money that went to the club
Requirements - A Master Admin login or a staff login with the following permissions:
- Reporting - Can access reports
- Reporting - Can access sales: gross sales detail
Accessing And Generating The Gross Sales Detail Report
To access your Gross Sales Detail Report go to Reports > Sales > Gross Sales > Detail Tab. To generate your report, select your Date Range or choose a Preset Date Range. You may choose to specify by Transaction Detail, Filter By Employee Associated With Sale, select if you want to Exclude $0 Invoices, Include $0 Invoices or Show Only $0 Invoices, filter to a specific Client UserID (optional), Pending Refunds Date (Refund Attempted Date or Released Date) or Show Drafted Downpayments as (Down, Draft). Click Run Report.
Understanding the Gross Sales Detail Report
The results will appear on the web page listing your Gross Sales that occurred during the selected date range. There are separate columns for Invoice Details, Net Revenue Breakdown (Excludes Taxes), Payment Method Breakdown (Includes Taxes) and Agreement Details. This report also breaks down refunds and returns to produce your Net Revenue.
NOTE: These totals are prior to any merchant processing fees which are charged by your merchant processor and will be on a statement/report provided by that company.
To export the data, select the floppy disk and choose your method of export: CSV (comma delimited), PDF, or Excel.Date - Date in which the invoice was paid
Time - Time the payment was taken
Pending Refund Release Date - The date the refund was completed.
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 in which the invoice is due
Days Late - How many days late the invoice was when paid
Invoice ID - Unique ID number of the invoice
Description - Description of the product or invoice
Invoice Type - Type of invoice (Cancel Fee, Enhancement Fee, etc)
Payment Category - What category the sale falls under (Membership, Services, Late Fee, Cancel Fee, Merchandise)
Transaction Type - Type of the payment (Recurring, Paid Up Front, In Club)
CR Draft - specifies if the invoice was paid via the Draft
Fee Type - Type of fee, if it was a fee invoice
Product Category - Product Category tied to the product
Product Barcode - Displays the product's barcode
Auto-Renew - Is the invoice paid on auto renew
Repay - Funds collected after client issues a charge back
Void- displays if the invoice was voided
Purchase Amount - total amount of the invoice paid excluding sales tax
Avg Memb EFT - Lifetime average EFT, this includes Membership drafted down payments. (NOTE: Past Dues will NOT count towards Avg Memb EFT totals since they are in a different column)
+ Sales Tax - Sales tax of the invoice
Payment Total - Amount of invoice plus any sales tax
Client Credit - Payment made with client credit
Credit Memo- Payment made with a credit memo
Gross Revenue- The amount of money that went to the club
Refunds & Returns- displays the amount of the refund / return
Payment Method- displays the payment type used (Cash, Written Check, Credit Card through CR, External, etc. )
CR: Credit Card - Payment was made with a credit card through ClubReady
CR: Bank ACH - Payment was made with a bank account through ClubReady
Ext Terminal - Payment was made via an external terminal
Check - Payment was made with a written check
Cash - Payment was made with cash
Client Credit- Payment was made with client credit
Credit Memo - The amount the club is writing off from the revenue
List Price - Original invoice value of the item based on its settings
Discount - amount that was discounted
Wholesale Price - Wholesale price of the item if entered under product settings
Session Credits - Number of session credits tied to the invoice, if any
Primary / Secondary Sales Person - Who the primary and 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)
Card Entry Method - If a credit card was used, it will display "Card Present" or "Card Not Present".
Agreement ID - ID of the agreement
Agreement Date - date the agreement was written up
Agreement Sales Person 1 / Sales Person 2 - Name of the staff member(s) assigned to the sale of the agreement
Notes - displays note tied to the invoice
Related Articles:
Reports- Gross Sales Analysis
Reports- Gross Sales Summary
Widget- Gross Sales Snapshot
Payment Method- displays the payment type used (Cash, Written Check, Credit Card through CR, External, etc. )
CR: Credit Card - Payment was made with a credit card through ClubReady
CR: Bank ACH - Payment was made with a bank account through ClubReady
Ext Terminal - Payment was made via an external terminal
Check - Payment was made with a written check
Cash - Payment was made with cash
Client Credit- Payment was made with client credit
Credit Memo - The amount the club is writing off from the revenue
List Price - Original invoice value of the item based on its settings
Discount - amount that was discounted
Wholesale Price - Wholesale price of the item if entered under product settings
Session Credits - Number of session credits tied to the invoice, if any
Primary / Secondary Sales Person - Who the primary and 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)
Card Entry Method - If a credit card was used, it will display "Card Present" or "Card Not Present".
Agreement ID - ID of the agreement
Agreement Date - date the agreement was written up
Agreement Sales Person 1 / Sales Person 2 - Name of the staff member(s) assigned to the sale of the agreement
Notes - displays note tied to the invoice
Related Articles:
Reports- Gross Sales Analysis
Reports- Gross Sales Summary
Widget- Gross Sales Snapshot
    |