To access the Memberships Report, click the App Drawer button then click View All > Reports > Sales > Memberships.
The Memberships Report is a sales report that displays client memberships that are active, on hold, expired, canceled, or converted during the selected date range.
You can use the Memberships Report to view the membership details of your clients and perform actions like placing multiple memberships on hold when clients are unable to visit your business for an extended period. For more information, see Viewing clients on hold and Placing a mass hold on memberships.
The summary cards at the top of the page provide an overview of the key information in the report. This article describes how to view the Memberships Report and provides details of the columns that appear in the report.
Summary cards in the Memberships Report
Summary cards | Description |
Active Memberships | The total number of active memberships during the selected date range. |
Total Memberships On Hold | The total number of memberships on hold during the selected date range. |
Total Memberships | The total number of memberships that are active or on hold during the selected date range. |
New Memberships On Hold | The total number of memberships that were placed on hold during the selected date range. |
New Memberships | The total number of memberships that were activated during the selected date range. |
Not Activated | The total number of memberships that were sold in the selected date range with start dates that occur after that date range. |
Expired Memberships | The total number of memberships that expired during the selected date range.
Note: If you apply the Month date range filter to the report, the report will include memberships that have expired and memberships that expire during that month. |
Canceled Memberships | The total number of memberships that were canceled during the selected date range. |
Converted Memberships | The total number of memberships that were converted during the selected date range. |
Upgrade | The total number of memberships with an Upgrade conversion type during the selected date range. |
Downgrade | The total number of memberships with a Downgrade conversion type during the selected date range. |
Equal Value | The total number of memberships with an Equal Value conversion type during the selected date range. |
Lost Memberships | The total number of memberships that expired or were canceled during the selected date range. |
Headings in the Memberships Report
Heading | Description |
Client | The client who owns the membership and relevant details about this client, including their client type, waiver status, contract status, special notes, unpaid visits, and account balance. The relevant details will be noted here by small icons. Hover over any icon to learn more. |
First Name | The client’s first name. |
Last Name | The client’s last name. |
The client’s email address. | |
Phone Number | The client’s mobile phone number. |
Client ID | The client’s ID. For more information, see Assigning a client ID. |
Membership | The membership owned by the client. You can click the name of the membership to open the client’s Passes & Memberships page. |
Purchase Date | The date that the membership was purchased. |
Start Date | The date that the membership became active. If the membership was prorated, this column will display the date the membership was prorated from, not the date selected as the start date for the membership during checkout. For more information, see Prorating membership payment. |
Last Renewal Date | The date of the membership’s last renewal. If the membership has never renewed, no date is displayed. |
End Date | The date that the membership becomes inactive. If the membership has no end date, Ongoing is displayed. |
Auto-renew | Shows whether the membership has auto-renew enabled. |
Cancellation Date | The date on which a client’s membership was canceled. |
Cancellation Reason | The reason selected when canceling the membership from the Passes & Memberships page. If the staff member entered any additional notes during the cancellation, you can hover your cursor over the Notes icon to display them. |
Termination Date | If the membership has been set to terminate, the termination date will be listed in this column. |
Date of Last Bill | The date of the client’s most recent bill for the membership. |
Amount of Last Bill | The amount last paid by the client for the membership.
Note: A membership that is sold as a part of a package will display a value of $0.00 under the Amount of Last Bill column. Furthermore, if the package containing the membership auto-renews, the associated membership will display $0.00 under the Amount of Last Bill column. However, if only the membership within the package auto-renews, the payment amount will be displayed under the Amount of Last Bill column. |
Date of Next Bill | The date of the client’s next bill for the membership. |
Amount of Next Bill | The amount of the client’s next bill for the membership. |
Conversion Type | If the membership was converted to another Purchase Option, the type of conversion will be listed in this column. |
Converted To | If the membership was converted to another Purchase Option, the Purchase Option that the membership was converted to will be listed in this column. |
Status | The status of the membership during the selected date range. The possible statuses a membership can have are Active, Not Activated, Expired, Canceled, Converted, and On Hold. To learn more about membership holds, see Placing a membership on hold.
If the status of the membership changed within the selected date range, all the statuses will be displayed in order from most recent to oldest.
To view the current status of the membership, you must select Today as the date range when filtering the report. |
UID | The UID of the client who owns this membership.
This heading is hidden by default and will only appear when a staff member customizes the report to include this heading. |
Advanced filters in the Membership Report
Filter | Description |
Membership Conversions | Use this filter to determine which memberships to include in the report based on which selected memberships were converted to different Purchase Options. |
Conversion Type | Use this filter to determine which memberships to include in the report based on the selected conversion type. Conversion types include Upgrade, Downgrade, and Equal Value. |
Membership Status | Use this filter to determine which memberships to include in the report based on the membership’s status. Membership statuses can be Active, Canceled, Expired, Not Activated, Converted, and On Hold. |
Auto-Renew | Use this filter to determine which Purchase Options to include based on whether auto-renew is on or off. |
Locations | Use this filter to determine which locations to include in the report. |
Class & Event Memberships | Use this filter to determine which Class & Events Memberships to include in the report.
Class & Events Memberships are memberships with Class/Events selected as the Purchase Option service category. |
Display Canceled Memberships | Use this filter to determine whether to include canceled memberships in the report. |
Client Groups | Use this filter to determine which clients to include in the report based on their client group.
Note: This filter will pull any relevant information from the available fields. For example, if you filter for groups A, B, and C, the filter will find clients from group A, group B, group C, and any combination thereof, as opposed to only finding clients who belong to all three groups. |
Account Memberships | Use this filter to determine which Account Memberships to include in the report.
Account Memberships are memberships with Account tab selected as the Purchase Option service category. |
FitVID Memberships | Use this filter to determine which FitVID Memberships to include in the report.
FitVID Memberships are memberships with FitVID Videos selected as the Purchase Option service category. |
Appointment Memberships | Use this filter to determine which Appointment Memberships to include in the report.
Appointment Memberships are memberships with Appointments selected as the Purchase Option service category. |
Gym Memberships | Use this filter to determine which Gym Memberships to include in the report.
Gym Memberships are memberships with Gym visits selected as the Purchase Option service category. |