Commission Schedules

Objective

After completing this lesson, you will be able to create a Commission Schedule

Introduction to Commission Schedules

In this unit, we will learn to calculate payouts for each producer. We’ll cover commission schedules and formulas, the basics of transactions and the process of bringing transactions into APM, as well as schedules and formulas. Next, we’ll cover the Payout process and the associated steps. We’ll then move into processing vouchers and the details of the voucher task. We’ll finish up this topic with statements, extracts, and reporting.

Commission Schedules

Commission Schedules are an important building block for any APM Configuration. A Schedule is a group of rules that is used to enforce the compensation agreement between the client and the broker. Think of a schedule like a compensation plan at the heart of the APM commission system: without a schedule, a payee cannot be compensated. There are a number of concepts that are common to all commission related processing. While the underlying details will vary by organization, the primary commission drivers are common to most commission system processing. These include the major business entities involved in a transaction and the resulting generation of commission payment(s).

A schedule typically consists of one or more Schedule Grids and one or more Formulas.

  • A schedule grid is a single compensation rule that defines the field values that will be compared to the transaction in order to locate the best match. All of the schedule grids associated with a schedule will be searched until the best match is identified. Once identified, the formula on that Schedule Grid will be used to compute the commission amount.

  • A formula is the specific computation method that results in a commission rate. APM allows a number of different ways to calculate in a formula, such as split, flat, tiered, and expression. Formulas can be associated with either a schedule detail or a schedule grid.

Schedule Types

There are three Schedule Types, which determine how the best matched compensation rate will be identified: Grid, Match Rules, and Weighted.

  • Grid indicates that the field values on the transaction will be compared to the field values on each schedule grid in order to locate the schedule grid with the greatest number of matches. If multiple schedule grids match on the same number of field values, the schedule grid with the lowest sequence will be used. No field has a higher priority than another.

  • Match Rules indicates that the transaction must exactly match the match rule(s) assigned to the sequence in order for that sequence to be used.

  • Weighted indicates that the field values on the transaction will be compared to the field values on each schedule grid in order to locate the schedule grid with the highest priority match. If this Schedule Type is selected, the client must also specify the fields that will be used to locate the best matched Schedule Grid. The order in which the fields are defined on the Schedule Master will determine the field’s priority (weight value). The field at the top of the list has the highest priority, while the field at the bottom of the list has the lowest priority. The field’s weighted value doubles for each field listed from lowest to highest.

Assigning Schedules

Where do we assign the schedule?

The most efficient entity on which to assign a schedule is the Broker Detail. However, a schedule can be assigned to a number of entities, including the Customer, Policy, Customer Ownership, Broker, or Broker Detail.

Let’s look at an example. SafeCare Insurance has an agreement with its brokers in which standard commission for a group policy is 5%, while commission for an individual policy is 8%. To make this work, we would first create a formula for each type of policy. We would then create a schedule that uses a match rule to determine which formula to use.

Exercise: Create Basic Formulas

In this exercise, we will create two formulas that will determine the commission for individual and group sales in California. 

Steps

  1. Create a basic formula.

    1. Open Manager → Payment Plans → Formula Search

    2. Select Add (+)

    3. Enter the Formula ID: F_Group_CA_Rate

    4. Enter the name: Group California Rate Formula

    5. Select Save.

  2. Enter the formula details:

    1. In the Formula Detail section, select (+).

    2. Enter the following details

      • Effective date: 01/01/2022
      • Type: Flat
      • Commission Basis: Premium
      • Commission Percent: 5%
      • Payout Rate Type: Fixed
      • Payout Rate: 100

    3. Select Save.

    4. Select Close.

    5. Use the same steps to create formula called F_Ind_CA_Rate that pays a flat 8% rate for Individual policies.

Exercise: Create a Commission Schedule

In this exercise, we will create a commission schedule that will use the formulas we created in the previous exercise. This schedule will include two match fields: State and Business Type. These will allow us to return the correct formula depending on the state, and whether the Business Type is Group or Individual.

ExerciseStart Exercise

Steps

  1. Create the schedule

    1. From the Manager portal, select Payment Plans – Schedule Search.

    2. Open the STANDARD schedule.

    3. Enter the following information for the new schedule:

      • Schedule ID: STANDARD
      • Name: Standard
      • Schedule Type: Weighted
      • Hierarchy Schedule: Writing Agent
      • Adjustment Type: Manual Adjustment

    4. Add the two Match fields.

      • In the Schedule Match Fields search box, type State.
      • Select the right arrow to move the State field to the right column.
      • Repeat this step to add the Business Type field to the right column.

    5. Select Save.

  2. Add a rule that returns the F_Group_CA_Rate formula if the Business type is Commercial Group and the state is California.

    1. Select the Schedule Rules tab.

    2. Select (+) to add a new rule.

    3. Enter the following information in the new rule:

      • Seq: 10
      • Eff Date: 1/1/2022
      • State: California
      • Business Type: Commercial Group
      • Formula ID: F_Group_CA_Rate

    4. Select Save.

    5. Select the Schedule Rules tab to return to the list of rules.

    6. Repeat these steps to add a second rule that returns the F_Ind_CA_Rate if the state is California and the Business Type is Commercial Individual.

  3. Activate the STANDARD Schedule.

    1. Return to the Schedule Master.

    2. Select Activate.

  4. Assign the STANDARD Schedule to the brokers.

    1. From the Manager portal, select Producers - Producers.

    2. Search for Producer ID MM-001 (Max Martinez) and open the record.

    3. Select the Producer Details tab.

    4. In the Results section, populate the Schedule ID with STANDARD.

    5. Select Save.

    6. Repeat this process to assign the STANDARD schedule to Deborah Willis.

Log in to track your progress & complete quizzes