Step 4 - Import a Commission Statement

Step 4 - Import a Commission Statement

Once a carrier map has been created, a commission statement can be imported. Only statements in Excel can be imported.  Commissions can also be imported using a Generic Import Template or added manually.



Import Commission Statements
  1. Go to the Main Menu.
  2. Click Commissions.
  3. Click the Commission Statements icon .
  4. Click + Import Statement.
  5. Drag and drop a file into the box or browse for one.
  6. Select a Statement Date. This can be the date the statement was received or any other date.
  7. Add a Statement Description (optional).
  8. Select a Carrier.  If your statement has multiple carriers, select Multiple Carriers.
  9. Select a Map. Only maps for the carrier selected will be available.  A statement cannot be imported without a map for the carrier.
  10. Click IMPORT.
  11. Click POST COMMISSIONS to open the statement in Posting. Posting is the process of linking a commission from the statement to a policy.  Review Step 5 before clicking this button!
  12. Click IMPORT NEW STATEMENT to return to the Commission Statement page and import another statement.

    • Related Articles

    • Import Carrier Commission Statement

      A carrier map is required to import a commission statement. If a map has not been created for a statement, please review the Maps section before importing your statement. Only commission statements in Excel can be imported. If a statement is not ...

    • Step 3 - Add Maps

      A Map is required to import a carrier commission statement. The map provides a diagram of which fields are imported from the commission statement. Once a map has been created, it can be used over again each month. Each carrier statement will require ...

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

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

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