Membership Summary report templateLast updated on 03/22/2022

• To open a membership record, click the corresponding invoice number to open the invoice in a new tab and then click View Membership.

• The report includes membership status changes that occur within the report date range. For example, you can report on the number of memberships that were canceled in the past year. If a membership enters multiple statuses within the date range of the report, it will appear under the column of its last status within the date range. You can view the exact date of a status change in the Membership Status History section of the membership record.

Follow the steps to create a custom report based on the Membership Summary template and select the columns to include in your report:

• Name—Name of the membership type

• Active Type—Whether or not the membership type is currently active

• Active At Start—Count of active memberships at the beginning of the report date range

• Suspended—Count of memberships suspended during the report date range

• Canceled—Count of memberships canceled during the report date range

• Expired—Count of memberships that expired during the report date range

• Deleted—Count of memberships deleted during the report date range

• Renewed—Count of memberships renewed during the report date range

• Reactivated—Count of memberships reactivated during the report date range

• New Sales—Count of new memberships sold during the report date range

• Manual—Count of memberships created from the office using the Add Membership button during the report date range Note: The Add Membership button is no longer available. This column is used for historic reporting.

• Active At End—Count of active memberships at the end of the report date range 

• Amount Billed—Amount billed to date on the membership type

• Membership Total Revenue—Total amount of revenue for the membership type

Tip: You can hover over any of the column labels to see a description of the column data.

Deselect a column to omit it from your report.

Before you run your report, set filters to focus your results:

1. Click the From - To field to set a range of dates to run the report on. You can:

   • Use the calendar to select a specific date range and click Apply.

   • Use the left menu to select a preset date range:

     • Today: From 12:00 AM to the current time

     • Yesterday: Previous day, from 12:00 AM to 11:59 PM

     • Last 7 Days: Previous seven days, including the current date

     • Last 14 Days: Previous 14 days, including the current date

     • Last 30 Days: Previous 30 days, including the current date

     • Month to Date: From the first of the current month to the current day

     • Last Month: Entire month before the current month. For example, if the date is February 5, the entire month of January.

     • Last 90 Days: Previous 90 days, including the current date

     • This Quarter: Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30.

     • Last Quarter: Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31.

     • Quarter to Date: From the first day of the current quarter to the current day

     • Year to Date: From January 1 of the current year to the current day

     • Last 365 Days: Previous 365 days, including the current date

2. Use the Business Unit drop down to select the business unit for the report. This filter will default to all business units assigned to the membership.

3. Use the Zip Code drop down to select zip codes you want to appear on the report. This filter will default to all zip codes reflected on the location on the membership invoice.

4. Check the Include Inactive Membership Types box if you want to include inactive memberships types on the report.

5. Click Run Report.

Tip: Click Edit Columns to add and remove columns. For further customization, you can also arrange and filter your results.

You can drill down in the Membership Summary Report to get historic insight into your memberships.

1. Click an underlined entry you want to drill down into. For example, click an entry in the Active at Start column. The entry is highlighted.

2. In the highlighted entry, click Expand . A table opens in the report showing details for that entry including the following: 

   • Customer Membership ID—Membership ID. Click on the Membership ID link to open the customer’s membership record in a new tab 

   • Membership Type—Type of membership 

   • Business Unit—Business Unit this membership belongs to

   • Customer Name—Name of the customer. Click on the Customer Name link to open the customer record in a new tab

   • Location Address—Service location covered under the membership

   • Invoice #—Invoice number for this membership. Click on the Invoice # link to open the invoice record in a new tab

   • Sale Type—Type of sale for the membership. Click on the Sale Type link to open the customer’s membership record in a new tab

   • Sold By—Name of the employee who sold the membership

   • Status Change As Of Date—Date the membership entered into the status it is listed under on this report

• See Create and edit custom reports

• See Export a report

• See Schedule custom reports