Office - Minimums

Table of Contents


Overview

  • Minimums are used to require a Club’s members to spend a certain amount of money at the Club within a specified time frame.  The Office system can generate Monthly, Quarterly, Semi-Annual, Yearly, or Custom Minimum schedules.  If a member does not spend their required amount within the specified time frame, they will be billed the remaining balance at the corresponding Month End.

Required Permissions

  • Membership

  • Add/Edit/Remove Minimums

  • Manage Members


Accessing the Tool

The first step to configuring Minimums is to set up the Minimum.  This is where the user configures the rules and frequency to be associated with the Minimum.

To access Minimums:

  1. Navigate to Membership across the top toolbar and select Minimums.

  2. The Minimums Grid will launch.

The primary functions associated with managing Minimums are embedded in the Minimums setup screen, which can be accessed by double-clicking on an existing Minimum (to edit an existing minimums), or clicking the New button (to create a new minimum).

Minimum Setup - Tab Overview

In this section we will review the various tabs within a Minimum.

General Information

  1. Enter the Name and Description of the new Minimum.

  2. Select the Billing Item.  This is the item that will be charged at Month End for any unspent minimums.

  3. Check Prepaid Minimum if members are to be billed their minimum amount in advance.

Schedule

  1. Frequency - Select the frequency of the Minimum (Monthly, Quarterly, Semi- Annual, Yearly, or Custom).

  2. Amount - Enter the amount of the Minimum.

  3. Start Month - Select the month the Minimum cycle will begin.

  4. Day Ends - Select the day the Minimum cycle ends.  Any unspent Minimum balances as of this day will be billed to the member.

  5. Annual Maximum - Specify an annual maximum. If there is not an annual maximum, check No Max.

  6. Includes Tax - If any tax charged on minimum eligible items should count toward the Minimum amount, check this box

    • Includes Service Charge - If any service charge charged on minimum eligible items should count toward the Minimum amount, check this box.

Includes These Item Groups 

The Includes These Item Groups tab is where the user will select the Item Groups that will apply toward the Minimum.  Furthermore, based on the embedded hierarchy, all Items within these Item Groups will count toward the member’s Minimum balance.

To add Item Groups to the Minimum:

  1. Select the Item Groups Lookup.

  2. Click to select the applicable Item Groups from the Lookup value.

  3. Choose Select at the bottom of the screen.

To remove an Item Group from the Minimum, highlight the Item Group in question from the selected Groups screen and choose Remove Selected.

Excluding These Areas 

The Excluding These Areas tab allows the user to exclude certain Areas from the Minimum.  For instance, if the user does not want any transactions completed within the Fitness Area to be counted toward the Minimum, they would select the Fitness Area on this tab.

To add excluded Areas to the Minimum:

  1. Select the Areas Lookup.

  2. Click to select the applicable Areas from the Lookup value.

  3. Choose Select at the bottom of the screen.

To remove an Excluded Area from the Minimum:

  1. Highlight the Area from the selected Areas screen.

  2. Choose Remove Selected.

Custom Scheduling

Minimums can also be applied on a custom basis.  For instance, with Custom Scheduling the user can specify which months out of the year the Minimum will apply to their members, or they can specify varying Minimum amounts depending on the month.

To set up a Custom Schedule:

  1. First set the Frequency on the Schedule tab to Custom, when the Frequency is set to Custom, the Start Month and Amount become Null.

  2. Navigate to the Custom Scheduling tab and enter the Minimum amount next to the corresponding month.

Create A New Minimum 

To create a new Minimum, navigate to the Minimums Grid and perform either of the following to launch the Minimum setup screen:

  1. Click the New icon on the toolbar.

  2. Right-click anywhere on the Minimums Grid and select New.

  3. The Minimum setup screen will launch.

  4. Complete the General Information, and then navigate to each of the below tabs and enter all relevant information. It is recommended to enter information on these tabs in sequential order. Please see the Tab Overview section of this document for further instructions on each tab.

    1. General Information

    2. Schedule

    3. Includes These Item Groups

    4. Excluding these Areas

    5. Custom Scheduling (if applicable)

  5. Lastly, click Save & Close to complete the setup of the new Minimum.

Minimum Group Setup 

Once a new Minimum is created, a corresponding Minimum Group will need to be created as well. A member’s inclusion in a Minimum Group is what applies the Minimum to their account.

To create a new Minimum Group:

  1. Navigate to Membership across the top toolbar and select Groups.

  2. Then perform either of the following to launch the Member Group setup screen:

    1. Click the New icon on the toolbar.

    2. Right-click anywhere on the Member Groups Grid and select New.

  3. The Member Group setup screen will launch.

  4. Enter a Name and Description.

  5. Select Minimums from the Group Type Lookup.

  6. Because this is a Minimum Group, Tax Exempt and Allow members to join this group online can be ignored.

  7. Leave the Group set to Static.

  8. When the Group Type is set to Minimums an additional tab will populate also called Minimums.

  9. Navigate to this tab and add the corresponding Minimum by selecting the Minimum Lookup. Then, click to select the applicable Minimum from the Lookup value, and choose Select at the bottom of the screen.

  10. To add members to the Minimum group perform either of the following below:

    1. Navigate to the Members tab with the Minimum Group and select the Member Lookup, click to select the applicable Members from the Lookup value, and choose Select at the bottom of the screen.

    2. Navigate to the Groups tab within the member’s profile, select the Member Group Lookup, click to select the applicable Minimum Group from the Lookup value, and choose Select at the bottom of the screen.

  11. To remove a member from a Minimum Group, perform either of the following below:

    1. Highlight the Member in question from the selected Member’s screen within the Minimum Group and choose Remove Selected.

    2. Navigate to the Groups tab within the member’s profile, highlight the Minimum Group in question from the selected Member Group’s screen and choose Remove Selected.

Membership Profile - Minimums Tab

Once a member is assigned to a Minimum Group, the appropriate Minimum information will populate on the Minimums tab within the Member’s profile.

The Minimum information attached in this section is dependent on the Minimum attached to the Minimum Group to which the Member is linked. 

Non-Editable (from Member's Profile) Member Minimum Details

  1. Minimum - Name of the Minimum attached to the Minimum Group. 

  2. Minimum Total - Assigned Minimum amount assigned to the group. 

  3. Spent in Period - How much the member has spent in the period. 

  4. Amount to Spend - How much the member has left to spend in the period. 

  5. Ending On - Ending date of the current period.

Adjustment Amount

  1. If for any reason the amount of a member’s minimum needs to be reduced on an individual basis, the user can enter an adjustment into the Adjustment Amount field. This will reduce the amount the member has to spend to reach their minimum.

  2. The Adjusted to Spend field will populate with the true reflection of what the member will need to spend in their current period.  (Note - this will properly display after adjustment amount has been saved.)

Important - Please remember to clear any adjustment amounts after Month End has been run.  Otherwise, the adjustment amount entered on the member’s profile will roll over to the next period. For more information on clearing Minimum Adjustments, please see our Membership - End of Month manual.

Minimum Reports

To review a member’s Minimum Activity on an individual basis:

  1. Best practice is to select View Minimum Activity on the Minimums tab within the member’s profile.

  2. The Member Minimum Activity Report will launch specific to the member. This report can be filtered down to the very items that counted toward the Minimum by selecting the + sign to the left of the activity or by changing the Detail Level of the report.

The Member Minimum Report can also be run on a global basis to display the Minimum Activity of all members. 

To run this report:

  1. Navigate to the Interactive Reports Module.

  2. Expand Membership.

  3. Select Member Minimum Activity.

Member Minimum Report Options:

  1. Select the Start Date.

  2. The Groups the user would like to view,

  3. The Detail Level of the report.

  4. Specify if the report should only include members with a certain amount of unspent Minimums.

  5. Select View Report.


Best Practices

  • At least monthly, use the Manage Members Grid to review for Minimum Adjustments that may need reviewed/cleared.  Customize columns to include Minimum Adjustment Amount field, and then include all amounts other than zero to review records with a minimum adjustment amount that may need adjusted and/or eliminated prior to next statement generation.

    • Please note: Minimums are set on a revolving Calendar. While you may create a new minimum in February and set a start date of July, when assigned to a member the minimum will automatically be in effect. Example: I just created a Yearly minimum that is set to start in July and it is only March. Once assigned to a member, the system sees the minimum as active and the member will be responsible to spend the minimum by the end of the current minimum year (June). To avoid this, assign new yearly minimums only on the month they are set to begin. Monthly and Quarterly minimums will start the same way, just will be due monthly and quarterly.

  • At the end of the month, you may need to clear the minimums. Please see the Month End Cleanup KB for steps to clear minimums.

 

FAQs

  • Q. Instead of decreasing an individual Member’s required spend, can I increase it?

  • A. Yes, when entering an adjustment amount (on the Minimums tab in the Member profile), enter the adjustment amount as a negative amount to increase the Adjusted to Spend field.  Entering a positive adjustment will result in a negative impact to the required spend.