Graded Commission Schedule

Graded Import Template

The Graded template is for policies that pay percentage of the premium paid.  The percentage rate decreases throughout the year as the cumulative paid premium increases.  Graded commission are paid on group products provided by an employer such as group life, AD&D, LTD, STD and Dental.

Click the attachment at the bottom of the page to download the Graded import template.

Sample Graded Commission Schedule
Tier
Premium
Commission Rate
FIRST
$15,000
15%
NEXT
$10,000
10%
NEXT
$25,000
5%
OVER
$50,000
1%




Tips
  1. Enter the gross premium for the policy.
  2. Enter a policy fee.  This is a non-commissionable fee that is deducted from the payment fee in the schedule.
  3. Create a Comp Plan for the policy BEFORE YOU IMPORT and add the name here.  The name should be spelled exactly how it is in the application.
  4. Product - enter the name of the product as it appears in the commission statement.  This field is used to help match a commission to a policy.  If an employer has mutliple products with the same policy number, the product field will be used to match the commission to a policy.
  5. Type - this is the type of insurance sold.  An example is Life, Disability, Medicare, Group, Voluntary Benefits, etc...  There are pre-defined types already created in the application.  You can use them here, or create your own.
  6. Sub-Type - this is subset of types.  An example for a Group type is: Life, AD&D, LTD, STD, Dental etc... There are pre-defined sub-types already created in the application.  You can use them here, or create your own.
  7. To view the current types and sub-types:
    1. Go to the Main Menu.
    2. Click Data – Types & Sub-Types.

    • Related Articles

    • Overrides and Bonuses - Graded Policies

      Other Comp for a policy can be imported with a base policy by adding it to the policy import template. An example of Other Comp is an override or bonus. Add the other comp to the template only if it pays a separate commission on the same statement as ...

    • Policy Import Templates Overview

      Client policy information can be imported using pre-defined policy import templates or entered manually. Each import template contains specific columns based on they type of commission paid on the policy. Depending on the types of policies you write, ...

    • Step 2 - Import Client Policies

      Customer policies can be imported using Excel templates with pre-defined columns based on the type of commission paid on the policy. There are five templates to choose from. Select a template based on the type of policies you are importing. Depending ...

    • Generic Import Template

      The Generic Import Template is an Excel spreadsheet with pre-defined columns. When using the template, the Generic Import Map is used to import the data. After downloading and adding commission data to the template, the statement import process is ...

    • Medicare Advantage Import Template

      The MA-PDP template is specific for Medicare Advantage and Prescription Drug Plans. The fee paid set each year by the Centers for Medicare and Medicaid Services (CMS). Depending on when an insured enrolls, the commission can be 100% of the fee or a ...