Import Carrier Commission Statement

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 available in Excel, commissions can also be imported using a Generic Import Template or added manualy.



Add

  1. Go to the Main Menu.
  2. Click Commissions.
  3. Click the commission statements icon  .
  4. Click + Import Statement.
  5. Drag and drop the commission 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.
  9. Select a Map.  Only maps for the selected carrier are 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 in the statement to a policy.  Click IMPORT NEW STATEMENT to return to the Commission Statement page and import another statement.

Edit

  1. Go to the Main Menu.
  2. Click Commissions.
  3. Click the box next to the statement.
  4. Click the edit icon  .
  5. Make changes.  Only the Statement Date and Description can be edited.
  6. Click SAVE.

Delete

Go to the Main Menu.
Click Commissions.
Click the box next to the statements to delete.
Click the delete icon  .
Click CONTINUE.  Deleting a commission will remove it from any policy linked to it.

    • Related Articles

    • 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 Go to the Main ...

    • Multiple Carrier Statements

      Sometimes a commission statement might come from a broker dealer or IMO with commissions from multiple carriers. If the statement has commissions from multiple carriers, you will need to select Multiple Carriers when creating the map. You will also ...

    • Generic Import Map

      Sometimes a carrier statement is not available in Excel. In this case, a generic import statement with pre-defined fields is available for you to import your commissions. When importing commissions using a generic import statement, select the Generic ...

    • Add Comp Plan and Carrier with Schedule Before Import

      The advantage to adding your carriers and comp plans to your database before importing your policies is accuracy. Once added, the carrier and comp plan names can be added to your policy import template. When the policies are imported, they will be ...

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