Fee Import Template

Fee Import Template

The Fee template is specific to policies that pay a fee.  The fee is a dollar amount that is paid as earned or advanced.  The fee can vary from year to year and is multiplied by the number of enrolled lives.  The fee is entered at the comp plan level and the number of enrolled lives is entered on the template or at the policy level.  Typical products include individual or group medical.

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

Sample Fee Schedule
Begin Year
End Year
Fee
Mode
Advanced Rate
1
1
$22.50
Monthly




Tips

  1. Enter the number of lives for the plan.  The number of lives is multiplied times the rate to determine the total commission.
  2. 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.
  3. Enter the premium for the policy.
  4. Enter the mode for the premium frequency.
  5. 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 and can be included in the Analytic reports.
  6. 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.
  7. Sub-Type - this is subset of types.  An example for a Health type is: Individual, short term disability, etc... There are pre-defined sub-types already created in the application.  You can use them here, or create your own.
  8. To view the current types and sub-types:
    1. Go to the Main Menu.
    2. Click Data – Types & Sub-Types.

    • Related Articles

    • 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 ...

    • Target Premium Import Template

      The Target Premium template is specifically for universal life and whole life policies. These policies pay a base commission rate on the “target premium” and a smaller rate on the “excess premium”. The Base and Excess rate can vary from year to year. ...

    • 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 ...

    • 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 ...

    • Pct of Premium Import Template

      The Percentage of Premium template is for policies that pay commissions based on a percentage of the paid premium. Typical products for this template are term life, disability, LTC, and voluntary benefits. Click the attachment at the bottom of the ...