Membership by customer report

This report lists customers and their membership packages. This includes customer name, member number, membership packages owned, pass number, membership expiration date, and any amount due on the account.

Location

Reports > Membership Reports > Membership by Customer

 

Clicking the Recall / Schedule a saved report definition button at the top of the page takes you to the Report Definitions page, where you can select a previously saved report definition.

Filters

Package

    1. Click the Package link to pop-up the Package Search page and then enter some criteria to select the activities. The package search results will be displayed on the Select Package page.

    2. From the Select Package page, select the packages.

    3. Click Add All Selected. To remove the packages, you can select the package in the list box then click Remove at the right side.

Package Category

    1. Click the Package Category link to pop-up the Package Category List page.

    2. From the Package Category List page, select the package categories.

    3. Click Add All Selected. To remove the package categories, you can select the package category in the list box then click Remove at the right side.

Membership Start Date

    1. Click the calendar icon beside the From box and select a Beginning Date of the membership start date from the pop-up calendar.

    2. Click the calendar icon beside the To box and select an Ending Date of the membership start date from the pop-up calendar.

    3. The Day of Week field beside the calendar icon will automatically be completed.

Membership Exp. Date

    1. Click the calendar icon beside the From box and select a Beginning Date of the membership expiration date from the pop-up calendar.

    2. Click the calendar icon beside the To box and select an Ending Date of the membership expiration date from the pop-up calendar.

    3. The Day of Week field beside the calendar icon will automatically be completed.

Transaction Date/Time

    1.  Click the calendar icon beside the From box and select a Beginning Date for the transaction from the pop-up calendar. Enter a specific time in the text box on the right side of the calendar.

    2.  Click the calendar icon  beside the Through box and select an Ending Date for the transaction from the pop-up calendar. Enter a specific time in the text box on the right side of the calendar.

    3. The Day of Week field beside the calendar icon will automatically be completed.

Member  

    1. Click the Member link to pop-up the Member Search page and then enter some criteria to select the members. The member search results will be displayed on the Select Member page.

    2. From the Select Member page, select the members.

    3. Click Add All Selected. To remove the members, you can select the member in the list box then click Remove at the right side.

Customer Type  

    1. Click the Customer Type link to pop-up the Customer Type List page.

    2. From the Customer Type List page, select the customer types.

    3. Click Add All Selected. To remove the customer types, you can select the customer type in the list box then click Remove at the right side.

Customer City  

    1. Click the Customer City link to pop-up the Customer City List page.

    2. From the Customer City List page, select the customer cities.

    3. Click Add All Selected. To remove the customer cities, you can select the customer city  in the list box then click Remove at the right side.

Customer State  

    1. Click the Customer State link to pop-up the Customer State List page.

    2. From the Customer State List page, select the customer states.

    3. Click Add All Selected. To remove the customer states, you can select the customer state in the list box then click Remove at the right side.

Customer Zip / Postal Code  

    1. Click the Customer Zip / Postal Code link to pop-up the Customer Zip / Postal Code List page.

    2. From the Customer Zip / Postal Code List page, select the customer zips / postal codes.

    3. Click Add All Selected. To remove the customer zips / postal codes, you can select the customer zip / postal code in the list box then click Remove at the right side.

Demographic  

    1. Click the Demographic link to pop-up the Demographic List page.

    2. From the Demographic List page, select the demographics.

    3. Click Add All Selected. To remove the demographics, you can select the demographic in the list box then click Remove at the right side.

Package Site  

    1. Click the Package Site link to pop-up the Package Site List page.

    2. From the Package Site List page, select the package sites.

    3. Click Add All Selected. To remove the package sites, you can select the package site in the list box then click Remove at the right side.

Alternate Key Value

    1. Click the Alternate Key Value link to pop-up the Alternate Key Value Search page and then enter some criteria to select the alternate key values. The alternate key value search results will be displayed on the Select Alternate Key Value page.

    2. From the Select Alternate Key Value page, select the alternate key values.

    3. Click Add All Selected. To remove the alternate key values, you can select the alternate key value in the list box then click Remove at the right side.

Options

Summary Report

Select the Summary Report checkbox to produce a summary report. If the checkbox is not selected, a more detailed report will be produced with additional customer information such as address, age, gender, work and cell phone numbers, and residency status.

 

Note: This option is unavailable if you have selected Microsoft Excel (Tabular Format) as the Output Type below.

Sort by Street Address?

Select the Sort by Street Address? checkbox to sort statements by address. Addresses will be sorted by street number in an ascending order.

 

Note: if this option is not available and you would like to use this feature; you can contact your Active account manager.

Sort by ODD/EVEN House #?

Option to list odd house numbers first (in ascending order), then even house numbers (in descending order). Use this option if delivering the report to customer addresses on foot.

 

Note: This option will not be enabled unless the Sort by Street Address? option is enabled above.

Residency

Choose one of the following options from the Residency drop-down list  to only include enrollees on the list based on their residency status. The options include:

Retired

Choose one of the following options from the Retired drop-down list to filter reports by customer status. The options are:

Primary Members Only

Select the Primary Members Only checkbox to display only primary members in the report. These are the primary customers that the membership packages are assigned to. If this option is not selected, all members attached to the membership will be displayed, and (P) will be used to indicate the primary member.

Renewable Packages Only

Select the Renewable Packages Only checkbox to only include renewable packages in the report.

Membership Expiration Status

Choose one of the following options from the Membership Expiration Status drop-down list to include customers depending on the expiration status of their membership packages, as selected from the following options:

Show Suspended Memberships Only

Select the Show Suspended Memberships Only checkbox to do one of the following:

Show all Membership Custom Questions

Select the Show all Membership Custom Questions checkbox to only display the custom questions and customers' answers in the report.

 

Custom questions are used during the creation of a receipt to record additional information about customers with regards to that particular transaction.

 

Note: If you have selected Microsoft Excel (Tabular Format) as the Output Type below, then this option cannot be selected at the same time as Show Customer Alternate Keys.

Custom Question Text to Print

Choose one of the following options from the Custom Question Text to Print drop-down list that you want to display on the report:

Show Incomplete Waivers Only?

Select the Show Incomplete Waivers Only? checkbox to display incomplete waivers in the activity on the roster. These are waivers that still require a customer's signature in order to be considered complete.

Show Customer Alternate Keys?

Select the Show Customer Alternate Keys? checkbox to include alternate keys and information relating to the alternate keys in the report.

 

Note: If you have selected Microsoft Excel (Tabular Format) as the Output Type below, then this option cannot be selected at the same time as Show all Membership Custom Questions.

Show Customer DOB?

To display the customers' date of birth in the report, click Show Customer DOB?

Show Customer Email?

To display each customer's email address in the report, click Show Customer Email?

Show Customer ID?

To display each customer's ID number in the report, click Show Customer ID?

Show Customer Type?

To display each customer's customer type in the report, click Show Customer Type?

Place the Logo and Address

Select the location of your organization's logo and address on the report:

 

Note: This option is unavailable if you have selected Microsoft Excel (Tabular Format) as the Output Type below.

Membership Report Style

Choose one of the following options from the Membership Report Style drop-down list to choose a report style, as selected from the following options:

Show Customer Address

To show either the mailing address or the residential address for each customer in the report, select one of the following options:

 

Note: The Show Customer Address list will be disabled if the Summary Report option is selected.

Include Residential Address

To display customers' residential addresses beside their mailing addresses, select Include Residential Address.

 

Note: The Include Residential Address option is only enabled if the Membership Report Style option above is set to Renewal Invoices.

Invoice Terms

Enter in the Invoice Terms box the invoice terms (text which appears on invoices) on the report (only available for Renewal Invoices report style).

 

Note: This option is unavailable if you have selected Microsoft Excel (Tabular Format) as the Output Type below.

Payment Options

Select the Payment Options checkbox to display payment information on the report (only available for Renewal Invoices report style).

Add pass holders of this type to the Bill To section

Output Type

Choose the option from the Output Type drop-down list to select the output type or format of the report, as selected from a predefined list. The available output types are Adobe Acrobat Reader, HTML, and Microsoft Excel.

 

If you want to export this report using a plain format and no subtotals so that you can easily manipulate the figures in a spreadsheet, select Microsoft Excel (Tabular Format).

Sort Options

Choose the option from the Sort by drop-down list to arrange report records as selected from a pre-defined list. The options include:

Run report

Click the Run Report button to generate the report.

Save Report Definition

    1. Enter in the Report Title box the desired report title.

    2. Click Save to save the report definition using the current report title entered. If the report title has been changed, the original report title will be replaced by the new one.

    3. Click Save As to save another version of the report definition using a different report title.

    4. Click Recall/Schedule on top of the page to access a previously saved report definition from the Report Definitions page.