How Do I Set Up a Discount Schedule?

IN THIS ARTICLE:
Learn about using Discount Schedules to configure multi-class/multi-sibling discounts. Also learn about offering additional Special Discounts, which can be enabled on a per-family basis.

When calculating discounts, the system will only consider class enrollments linked to the same location.  This means that if one or more students in the family are taking classes at multiple locations, discounts are not calculated based on enrollments at other locations.

What are Discount Schedules?

Discount Schedules are tables used to reference how students' classes should be ordered for calculations, how much should be discounted (multiple class and/or multiple student discounts), and if any Special Discounts apply to the classes that will use the Discount Schedule.

When determining this, all ACTIVE type class enrollments for a student are counted (across all programs) and then ordered (from most expensive to least expensive), unless one of the following options is enabled under SETTING>SETUP>CLASS SETTINGS>GENERAL CLASS SETTINGS.:

Regardless of whether or not these options are enabled, only classes that are set up to use discounts and have a Discount Schedule attached to them will be discounted.

For example, Molly Smith is enrolled in the following 3 classes:

  • Beginners Tumble Monday 5:30PM $125/mo
  • Beginners Trampoline Tuesday 6:00PM $175/mo
  • Beginner & Intermediate Combined Practice Thursday 4:15PM $95/mo

Her classes would be ordered as follows, when pulling discounts (most expensive to least expensive):

  • Class 1 (Row 1)- Beginners Trampoline Tuesday 6:00PM $175/mo 
  • Class 2 (Row 2)- Beginners Tumble Monday 5:30PM $125/mo
  • Class 3 (Row 3) - Beginner & Intermediate Combined Practice Thursday 4:15PM $95/mo

Even if each of these classes is attached to a different discount schedule, the discount amount for each class will always reference the assigned row.

Details Tab

To create a Discount Schedule for multiple class and/or multiple student discounts, go to SETTINGS>SETUP>CLASS SETTINGS>DISCOUNT SCHEDULES.
Existing discount schedules will be listed here, along with information about their setup options:
discount_schedule_details.png
To create a New Discount Schedule:
  1. Click "Add New Discount Schedule."
  2. Name your discount schedule (ex: "Recreational Discounts")
  3. Count Classes/Hours By: This field controls the way that classes, or hours are counted in the table where the discounts are defined. Each class is considered a row in that table. The counting option is then used to locate within that table, which discounts to use for class enrollments.
    • There are three ways to count: "One at a Time", "One at a Time Per Student" or "Total".
      • One at a Time - each class enrollment will be assigned a row on the table and each enrollment will assume the discount in that corresponding row/cell.
        • NOTE: If this option is selected, it is expected that if the class bills hourly, the system will count the actual duration of each class one at a time, This means that if the class runs from 9:30am-11:30am, it would count two total hours, not count each hour once.
      • One at a Time Per Student - each student's class enrollment is assigned a row in the table and each enrollment will assume the discount in that corresponding row/cell. (This setting only affects scenarios when you also choose to “Count Students By Total” and there are multiple active students in the family; otherwise the system works the same as if you just chose “One at a Time.”)
        • NOTE: If this option is selected, it is expected that if the class bills hourly, the system will count the actual duration of each class one at a time, This means that if the class runs from 9:30am-11:30am, it would count two total hours, not count each hour once.
      • Total - all of a student's classes will use the same discount from the table cell matching the total number of classes they are enrolled in.
  4. Count Students By: Similar to count classes/hours, this setting deals with how to count students in a family.
    • There are two ways to count: "One at a Time" or "Total".
      • One at a Time - each unique student in a family is assigned a column in the discount schedule. So student one will receive the discounts in column one, student two will receive the discounts in column two, etc.
      • Total - all of the family's students will be assigned to a single column of discounts within the discount table which corresponds to the total number of enrolled students in that family.
  5. Students Ordered By: (assuming you count students one at a time)
    • There are two ways to order students in the discount schedule: "Most expensive class" or "Highest Total Tuition"
      • Most Expensive Class - the student with the highest tuition rate out of all family enrollments will be set as student 1 in the discount table. The rest of the students will be ordered by descending tuition rates.
      • Highest Total Tuition - then the student in the family with the highest combined tuition rate across all of his/her enrollments is considered student 1 and the rest of the students will be ordered by descending tuition totals.
        • If "Highest Total Tuition" is selected, the system should use a secondary sort order by "Most Expensive Class."
          • If the option selected in "Students Ordered By" causes two students to be ranked equally, the system should use a secondary sort and further order them based on the option that was not selected.
          • If "Most Expensive Class" is selected, the system should use a secondary sort order by "Highest Total Tuition."
        • NOTE: The way the class is configured for Billing purposes may also affect how students are ordered for discounts.
          • If the students are enrolled in classes that bill by timeslot calculated by the number of timeslots in a week, and the classes use different tuition rates, then the system will abide by the "Order Students By" setting.
          • However, if the students are enrolled in classes that bill by timeslot calculated by the number of timeslots in a week, and both classes use the same tuition rate, the system will order the students according to their enrollment start date.
  6. Minimum Charge Amount: This is a dollar or percentage amount of tuition that must be met. In other words, if the tuition for a class can never be discounted below a specific dollar fee or percentage of the tuition rate, that amount is entered here. (If you do not have a minimum charge requirement for classes, you can skip this setting.)discount_schedules00.png
    • NOTE: While the "Minimum Charge Amount" will be enforced by default, staff members will be able to override this amount when manually creating charges on the family ledger.

Tables Tab

When creating a Discount Schedule, there is always a Default table included. If a class uses a billing schedule for which no specific table exists in the Discount Schedule, it will use this default table.

discount_schedules01.png

You can also add new tables for specific billing schedules by choosing one from the drop-down menu at the top of the page. Because each class or program can only have one discount schedule attached, this enables customers with multiple billing schedules (billing/payment plans) to offer different discounts for different tuition rates. Adding a billing schedule will create a new table in the tabs below.

To begin, select the tab for the table you wish to edit. Below, the Monthly billing schedule discount table has been selected. The discounts in this table will only be applied to classes/enrollments set up to use both this Discount Schedule and the Monthly billing schedule.
discount_schedules02.png
Within the Discount Schedule table:

  • Columns - represent siblings
  • Rows - represent additional classes

Using our previous example of Molly, if she were the first student and all of her classes used this discount schedule - we would use the pricing in column 1. If you remember, her classes were:

  • Class 1 (Row 1)- Beginners Trampoline Tuesday 6:00PM $175/mo - Column 1,
    • Row 1 is blank, so Molly would not get a discount for Class 1.
  • Class 2 (Row 2)- Beginners Tumble Monday 5:30PM $125/mo - Column 1,
    • Row 2 has a 10% discount, so she would get 10% off of $125 (or a $12.50 discount).
  • Class 3 (Row 3) - Beginner & Intermediate Combined Practice Thursday 4:15PM $95/mo - Column 1,
    • Row 3 has a 10% discount, so she would get 10% off of $95 (or a $9.50 discount).

If Molly had a sibling, that sibling's classes would also be ordered, and he or she would receive the discounts in Column 2 - with the most expensive class being 15% off and the remaining classes being discounted by 20%.

NOTES:

  • If there is not a row or column for the number of students or class enrollments accounted for in the Discount Schedule, iClassPro will use the last discount entered above or to the left of where the row/column would be to determine the discount.
    • This means that if you have a total of two students taking three total classes, and Column 2 only has a value specified in cell 2:1, the system will fall back to using whatever discount is defined in cell 1:3.
      • If you wish to apply a specific discount to multiple classes/hours/timeslots when counting by total students, be sure that you completely fill out the appropriate columns.
  • Use the "Add a Row"/"Add a Column" buttons to add more rows & columns.
  • Use the red X next to a row or column to remove it from the table.
  • Discounts support values up to four decimal places.

Special Discounts Tab

STEP 1: Entering Special Discount rates

discount_schedules03.png

Click on special discounts to set discount dollar amounts or percentages for Employee, Service, Members, or Earlybird Discounts and click save.

  • Employee Discount: intended to be used for the families of the employees at your business.
  • Service Discount: intended to be used for military/first responder families.
  • Member Discount: intended to be used for families who have a membership at your business (based on your own "membership" criteria).
  • Earlybird Discount: Used to give a discount for paying tuition by an early bird date (NOT for early registration).

NOTES:

If multiple discounts apply to a single enrollment (such as a mutli-class discount and a special discount), both discounts will be based on the original tuition amount.

For example, if the base tuition was $93.00 and the enrollment qualifies for both a 30% multi-class discount and a 50% employee discount, the math would be calculated as follows:

$93 x 50% = $46.50 (multi-class discount)
$93 x 30% = $21.90 (employee discount)

$93 - $46.50 - $21.90 = $18.60 total tuition charge.

STEP 2: Apply Special Discounts to Families

To receive special discounts, a family must have their eligibility marked on the family information page. Go to the families page, find the family you wish to edit, and click the Pencil icon to edit the family.

Scroll to the bottom of the window, click the blue View More option, and then click the Special Discounts link to display the section shown on the right. Select Yes for the discounts the family is eligible for. Then click save.

discount_schedules04.png

Note: Earlybird Discount eligibility dates can only be set when creating charges.

Applying Discount Schedules to Programs

Go to SETTINGS>SETUP>GENERAL SETTINGS>PROGRAM

Double click a program to edit it and attach the discount schedule.
discount_schedules05.png

Remember to save any changes.

Overriding a Discount Schedule for a Specific Class

Go to the classes page, click the pencil icon next to the class that uses a different discount schedule from its program. 

Click on the Billing tab in the class information. At the bottom of the window, select the Discount Schedule you would like to be used for this class.
discount_schedules06.png

Remember to save any changes.

Limit Discounts To Enrollments With Same Billing Schedule

The ”Limit Discounts To Enrollments With Same Billing Schedule” option under SETTINGS>SETUP>CLASS SETTINGS>GENERAL CLASS SETTINGS will affect how the system ranks students/enrollments for discount purposes.

mceclip1.png

If this setting is enabled, enrollments will only be counted towards discounts if they are in classes with the same billing schedule and which use the same billing type (flat rate/hourly/timeslot). 

Examples:

  • Scenario 1: there are two students in a family, each with a single enrollment. One is enrolled under the MONTHLY billing schedule; one is enrolled as SESSION.  For discount purposes, both will be ranked as Student 1, Class 1 since the enrollments use different billing schedules.
  • Scenario 2: there are two students in a family, each with a single enrollment. Both are enrolled under the MONTHLY billing schedule; however, one class is set to bill by TIMESLOT and one is set to FLAT RATE.  For discount purposes, both will be ranked as Student 1, Class 1 since they use different billing types.
  • Scenario 3: there is a single student in a family, enrolled in two classes. One enrollment uses the MONTHLY billing schedule; the other uses SESSION.  For discount purposes, both will be ranked as Student 1, Class 1 since the enrollments use different billing schedules.
  • Scenario 4: there is a single student in a family, enrolled in two classes. Both are enrolled under the MONTHLY billing schedule; however, one class is set to bill by TIMESLOT and one is set to FLAT RATE.  For discount purposes, both will be ranked as Student 1, Class 1 since they use different billing types.

NOTE: Enabling this setting will affect both Discount Schedules and Tuition Schedules.

Ignore Overridden Tuitions When Calculating Discounts

This setting determines whether enrollments with tuition overrides will be included when calculating discounts.

  • If enabled, this setting will force the system to ignore any enrollments with tuition overrides when calculating discounts.
  • If left disabled, the system will calculate a price based on [OVERRIDE / # of timeslots or hours in billing period] if the class bills hourly or by timeslot.
    • If the class bills monthly, the system will charge the flat tuition override (minus any proration if the “Enable Start Date / End Date Proration For Overridden Tuition” or “Enable Blackout Dates For Overridden Tuition” options are enabled).

SPECIAL CONSIDERATIONS: Ordering students/enrollments for discounts

Matching sort values

While the Discount Schedule setup allows you to specify a "Students Ordered By" value that establishes how you wish to order students for discounts, occasionally the system may run into a situation where these values match (for example, two students enrolled in the same class would have the same tuition amount).

When the system encounters these situations, it falls back on the following values to order the students for discounts:

  1. Based on enrollment pricing in descending order. (i.e., highest tuition to lowest).
    • For classes using Tuition Schedules, the system will use the amount in the first cell for the pricing.
  2. If the tuition prices are the same, the system will look at any proration. If a student's enrollment is being prorated in the billing cycle, the student with the lower cost gets the higher discount.
  3. If the proration of the enrollments is the same, the system will order the students according to the enrollment start date, in ascending order (i.e., from the enrollment with the oldest start date to the most recent).
  4. If the enrollment start date is the same, the system will order the students according to the enrollment creation date, in ascending order (i.e., from the enrollment with the oldest creation date to the most recent).
    • NOTE: The enrollment creation date is stored with a timestamp. Therefore, if the date itself is the same, the system will then consider the time as well.
  5. If the enrollment creation date is the same (for example, if the enrollments were submitted and created at the same time via the Customer Portal/Mobile App), then the system will order the students according to the internal Student ID in ascending order. (i.e., from the student with the smallest/lowest student ID to the largest.)

Transferred enrollments (Time Slot billing)

Transferred enrollment chains that happen in the same week will be summed together and share the same ranking for discounts.

For example, Let's say that classes are set to bill by "Time Slot">"Count by Week", and a student has the following longstanding enrollments:

  • Enrollment 1 (E1): Tuesday- $40 Tuition - Meets 1/2/24
  • Enrollment 2 (E2): Thursday- $30 Tuition - Meets 1/4/24

If the student then transfers the enrollment on Thursday (E2: $30 Tuition, drop date of 1/5) to an enrollment on Saturday (E2: $30 Tuition, start date of 1/6), the software links the two enrollments together. 

The original/transferred enrollment will be considered Class 1 for this week, the system combines the tuition values for the original class + the transferred class, making the total for the week higher than E1 as listed above. (This means that the $30 original tuition for E2 + $30 transferred tuition for E2 is greater than the $40 tuition for E1).

This means that during the Class Tuition Charge preview for the week of the transfer, the system ranks this transfer as first (enrollment 1) for discounts, even though the Discount Schedule says to order classes by "Most Expensive Class."

Need more assistance?

Customer support is available at 1-877-554-6776 Mon - Fri, 9 am to 9 pm (CT) and Sat, 9 am to 6 pm (CT).