Step 3 - Landmines

 Some commission statements include data on multiple tabs.  Make sure to identify the correct tab on the statement that holds the commission data.  Identify the first row of commission in the statement.  It's usually the first row under the column headings.

 Enter the correct column for the Paid Date.  This is the date the policy paid the commission.  This date is used in many of the reports.  If there is no paid date column, click the box next to the field.  When you import a statement, you’re asked for a statement date.  The statement date entered will be the paid date for all commissions in the statement.

 We recommend mapping as many fields as possible to improve commission matching and support the creation of new policies that are not already in the application.  Mapping optional fields helps populate reports and improves the system’s ability to match pending commissions that are not automatically linked during statement import.  Leave the Carrier field blank unless you are creating a map for a commission statement that contains multiple carriers.

• Related Articles

• Step 6 - Landmines

  Reports can only be created for a maximum 10-year time period. Actual commission calculations are based on the Paid Date from the commission statement. This field is required when creating a carrier map. Projected commission calculations use the ...

• Step 5 - Landmines

  Once a map is created and saved, it cannot be edited. If a carrier changes the format of their commission statement, a new map must be created. A carrier map is not required to add or post a manual commission. Always include a policy number for each ...

• Step 2 - Landmines

  Enter policy data for one carrier at a time into the import template. It’s easier to match the comp plans to the policies. Enter the name of the comp plan into the template exactly how it was spelled when it was added to the application. Enter the ...

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