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!