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

    • Step 2 - Import Client Policies

      Customer policies can be imported using our Policy Import Template. Simply copy and paste data directly from your commission statement into the template to quickly load policies into the system. Download a Policy Import Template Go to the Main Menu. ...

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

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

    • Step 4 - Landmines

      Make sure a carrier map has been created first before trying to import a commission statement. If a map for the statement does not exist, the statement will not import. A Generic Import Map has already been created. Select it when using the generic ...

    • Step 5 - Post Commissions

      Posting is the process of linking a commission from a statement to a policy. When a commission statement is imported, most commissions are automatically linked to policies. When a commission statement is imported, click POST COMMISSIONS when prompted ...