Maps

Maps

Before a commission statement can be imported, a carrier Map must first be created.  The map provides a diagram of which fields are imported from the commission statement into the application.  Once a map is created, it can be used over again each month.  Fields in a map cannot be changed once the map is saved If the carrier statement changes, a new map will need to be created to reflect the changes to the statement.  Auto-Update is a feature in the map that updates policies from commission import data.  This feature can be edited in the map at any time.



Add

  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 comp plans, select Multiple Comp Plans.
  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.  In the example below, the first commission data row is (8).

  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 and Commission Paid #1 are required fields.  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.  Once your map is saved, it cannot be edited.  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.  Only the Auto-Update feature for the map can be edited.

Delete

  1. Go to the Main Menu.
  2. Click Commissions.
  3. Click the maps icon .
  4. Click the box next to the map to delete.
  5. Click the delete icon .  Deleting a map is not recommended if it has been used successfully to import a statement.

    • Related Articles

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

      AgencyComp can calculate, estimate, analyze, and track premium and commission for all policies. Follow the steps below to get started quickly. Step 1 - Add Carriers and Comp Plans (02:56) Step 2 - Import Client Policies (08:15) Step 3 - Add Maps ...
    • 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 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 ...
    • 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 ...