Memberships Report

The Memberships Report is a sales report that displays a list of client memberships that were active, expired, placed on hold, or canceled during the selected date range. You can use the Memberships Report to view the membership details 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. To learn how to customize and filter the report, see Viewing a report.

In this article:

    To view the Memberships Report

    1. Click the App Drawer button .
    2. In the App Drawer, click View All.
    3. In the list, click Reports. You can filter the list by entering Reports into the Search field.
    4. On the Reports menu, click Sales.
    5. On the Sales menu, click Memberships. The Memberships Report is displayed.

    Summary cards in the Memberships Report

    Summary cardsDescription
    Active MembershipsThe total number of active memberships during the selected date range.
    All Memberships On HoldThe total number of memberships on hold during the selected date range.
    Total MembershipsThe total number of memberships held by clients during the selected date range.
    New Memberships on HoldThe total number of new memberships that have been placed on hold during the selected date range.
    New MembershipsThe total number of memberships that were activated during the selected date range.
    Not ActivatedThe total number of memberships that were sold in the selected date range with start dates that occur after that date range.
    Lost MembershipsThe total number of memberships lost during the selected date range. A lost membership refers to when a client cancels any of their memberships or allows any of their memberships to expire.

    Headings in the Memberships Report

    HeadingDescription
    ClientThe 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 NameThe client’s first name.
    Last NameThe client’s last name.
    EmailThe client’s email address.
    Phone NumberThe client’s mobile phone number.
    Client IDThe client’s ID. For more information, see Assigning a client ID.
    Purchase OptionThe membership owned by the client. You can click the name of the membership to open the client’s Passes & Memberships page.
    Start DateThe 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.
    End DateThe date that the membership becomes inactive. If the membership has no end date, Ongoing is displayed.
    Cancellation DateThe date on which a client’s membership was canceled.
    Termination DateIf the membership has been set to terminate, the termination date will be listed in this column.
    Date of Last BillThe date of the client’s most recent bill for the membership.
    Amount of Last BillThe amount last paid by the client for the membership.
    Date of Next BillThe date of the client’s next bill for the membership.
    Amount of Next BillThe amount of the client’s next bill for the membership.
    StatusThe status of the membership within the selected date range.

    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.

    UIDThe 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

    FilterDescription
    Membership StatusUse this filter to determine which clients to include in the report based on their membership status. Membership statuses can be ActiveCanceled, ExpiredNot Activated, and On Hold. For more information on membership holds, see Placing a membership on hold.
    Auto-RenewUse this filter to determine which Purchase Options to include based on whether auto-renew is on or off.
    LocationsUse this filter to determine which locations to include in the report.
    Class & Event MembershipsUse 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 MembershipsUse this filter to determine whether to include canceled memberships in the report.
    GroupsUse this filter to determine which clients to include in the report based on their client group.
    NoteThis 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 MembershipsUse 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 MembershipsUse 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 MembershipsUse 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 MembershipsUse 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.
    Was this article helpful?
    (128 out of 130 people found this article helpful )

    What can we do better?

    Thank you!