Multiple Carrier Statements

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 need to identify which column holds the carrier names.



Create a Multiple Carrier Statement Map

  1. Go to the Main Menu.
  2. Click Commissions.
  3. Click the maps icon .
  4. Click ADD MAP.
  5. Browse for the carrier statement or drag and drop one into the box.
  6. Select a Carrier.  If your statement has multiple carriers, select Multiple Carriers.

  7. Enter a map name.
  8. Indicate the tab number in the Excel file that contains the commission data.  In the example below, tab number (2) contains the commission data.
  9. Indicate the first row of commission data.  Row (8) is the first row with commission data in the example below.
  10. Make selections for Auto-Update.  This feature automatically updates the carrier, product, effective date, and premium for a matched policy during the posting process.  Posting is the process of matching a commission to a policy after the commission statement is imported.  Data from the commission statement will automatically update these selected fields when a commission is matched to a policy.  These selections can be changed later.  The Auto-Update fields can also be applied manually when a commission is matched to a policy after the statement has been imported.
  11. Click NEXT.
  12. Map the fields in your statement to the fields in AgencyComp.  Policy Number, Paid Date, Commission Paid #1 and Carrier fields are required.  If your statement does not have a paid date column, click the box next to the Paid Date field.  The statement date entered when importing a statement will be used for the paid date for all commissions in the statement. The primary fields used to match a commission to a policy are the policy number, effective date, product, revenue type, client and agent.  Try to match as many fields as possible to make it easier to match a commission to a policy during the import process.
  13. Click PREVIEW to make sure your fields match to the AgencyComp fields.  If the carrier makes any changes to the commission statement, a new map will need to be created.
  14. Click SAVE MAP & RETURN to return to the Maps page to create a new map.  Click SAVE MAP & IMPORT to import the statement used to create the new map.  Once a map is saved, it cannot be edited!

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

    • Multiple Agents - One Policy

      An agent is the person or persons receiving commission on a policy. If premium or commission is being tracked for multiple agents on the same policy, duplicate policies should be added with each agent's share of the premium.

    • Add Carrier and No Comp Plan Name

      A carrier is required when importing your policies, but a comp plan is not. You can add a comp plan to your policies after they have been imported using the Bulk Change – Comp Plans method. This method is more time-consuming than ther other two ...

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

    • Add Comp Plan and Carrier with No Schedule Before Import

      A carrier and comp plan can be linked to a policy during the import process even if there is no schedule created for the comp plan. If a comp plan name is added to the template with no schedule in the application, it will be still imported and linked ...