Memberships Sold By ReportLast updated on 09/09/2022
Purpose of the Memberships Sold By Report:
This report will help you analyze membership sales within a specific date range. The report includes membership details, such as customer name, invoice number, membership name, annual price of the membership, date the membership was sold, and the membership expiration date. Membership renewals are included in this report.
Common uses for this report:
Use this report to view memberships sold by technicians or employees.
Use this report to view any commissions and/or bonuses earned on membership sales.
How to find this report:
Click Reports > Search Memberships Sold By > Click the report name. Then you will be able to set filters and run the report.
Filter by employee. This report can be run for a single employee or technician (anyone who sells memberships from the office or in the field) or all employees or technicians.
Filter by business unit of the invoice. This report can be run by a single business unit or all business units.
Filter by date range. Use the From and To fields to set a custom date range.
View or download the report
Click Update to view the report.
The report can be downloaded in three different formats:
Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)
Explanation of report columns
The report includes the following columns:
Invoice where the membership was sold.
Name of the membership plan.
Type of membership (New or Renewal).
Price of the membership sales task on the invoice.
(Report columns continued)
Date the membership begins.
Date the membership expires.
Amount earned for the membership sale. If the membership was sold by a technician, this will include commission and/or bonuses earned for the membership sale. If the membership was sold by an employee, this will include the bonus earned only.
How to configure - Commission: If you would like technicians to earn commission on membership sales, make sure the Pays Commission box is checked on the membership sale task in your Pricebook. Go to Settings > Pricebook > Services. Locate the membership sale task (this is the New Sale Task configured when you set up the membership). Select the Commission tab. Check Pays Commission, then click Save.
How to configure - Membership sales to pay bonuses: If you would like employees or technicians to earn bonuses on membership sales, enter the applicable bonus on the membership sale task in your Pricebook. Go to Settings > Pricebook > Services. Locate the membership sale task (this is the New Sale Task configured when you set up the membership). Select the Commission tab. To pay a flat rate bonus for the membership sale, enter the bonus amount in the $ Bonus field. To pay a percentage bonus for the membership sale, enter the percentage in the % Bonus field. Then, click Save.
Name of the employee or technician who sold the membership.
Date the membership was sold.
Status of the membership (Active, Expired, or Deleted).
Explanation of report totals
Total amount earned from all membership sales. If the memberships were sold by a technician, this will include commission and/or bonuses earned. If the memberships were sold by an employee, this will include bonuses earned only.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.