Generic Import Template

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 the same as when using a carrier commission statement.  The only difference is that when you import your file, you will select the Generic Import Map.

Click the attachment below to download the Generic Import Template.



Download a Generic Import Template

  1. Go to the Main Menu.
  2. Click Commissions.
  3. Click the Commission Statements icon  .
  4. Click + Generic Import Template to download the template.
  5. Open the template and save it to your computer.
  6. Complete the required fields and save the file.  Policy number, Pay Date and Commission/Fee Paid 1 are required fields.  You may want to complete as many optional fields as possible since they are included in some reports.

  7. Only enter the carrier name for each policy in the Carrier column if you are importing commissions from multiple carriers.  Otherwise, leave this column blank.  

  8. Next, follow the normal steps for importing a commission statement.
  9. When prompted, select the Generic Import Map.  This map is built-in and will automatically match commissions from the generic import template to your policies.  The generic import map will only work with a generic import template.

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

    • Import Multiple Carrier Commission Statements

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

    • Generic Import Map

      Sometimes a carrier statement is not available in Excel. In this case, a generic import statement with pre-defined fields is available for you to import your commissions. When importing commissions using a generic import statement, select the Generic ...

    • Bulk Change - Termed Policies

      Termed is a status that for a policy that is no longer active and not paying commissions. A termed date is required for a policy with a Termed status. The bulk term tool can terminate multiple policies at one time and add a specific term date. Bulk ...

    • Riders

      Riders for a policy can be added to a policy import template or manually added to a policy. An example of a rider is a Children's Term Rider that is added to a parent's life insurance policy. Add the rider to the policy only if it pays a separate ...