/
Guide to Filing via Bulk Upload

Guide to Filing via Bulk Upload

The Bulk Upload feature allows you to create multiple draft transactions at one time by importing a CSV file.

Instructions

Be sure to read through all the steps prior to beginning to have the best result.

⚠️ Restrictions

  • The logged-in user must be associated with an account for the specific broker.

  • Documents must still be uploaded manually for each transaction before submission.

1. Create Your CSV File

You can quickly create a template for the CSV file in Excel. Create a new spreadsheet with a column for each of the fields, then select “Save As”, and pick “CSV” as the file type.

  1. Export each transaction you wish to file and add it to the CSV file in the exact order below:

Fields:

  • Broker NPN*

  • Transaction Type* - New, Renewal, Additional Premium, Return of Premium, Flat Cancel, Audit

  • Policy #*

  • Insured*

  • ECP - Y or N

  • RPG - Y or N

  • Effective Date

Currently, you must include the Effective Date when uploading Endorsement transactions. This will be changed in a future update. Be sure to use the Effective Date of the most recent New/Renewal transaction.

  • Endorsement Date - Leave empty for New/Renewal Transactions

  • Expiration Date

  • Broker Received Date

  • Insured Street Address 1

  • Insured Street Address 2

  • Insured City

  • Insured State

  • Insured ZIP

  • Multistate - Y or N

  • Location of Risk same as Insured - Y or N

  • Location Street Address 1

  • Location Street Address 2

  • Location City

  • Location State

  • Location ZIP

  • Line of Business - Coverage Code (e.g. AH-001)

  • Description

  • Insurer - NAIC code; if there is more than one insurer, separate with the “|” symbol

  • Percentage - If there are multiple insurers, the percentage for each should be separated by “|” and can have one decimal place (e.g., 99.5)

  • Premium - No decimal

  • Broker Fee - No decimal

  • Other Fee - No decimal

The fields marked with * must be populated in order for your upload to be accepted. Other fields may be left empty and updated later.

  1. When all transactions have been added, Save As CSV and note the file name and location.

2. Start a Bulk Upload and Import your File

  1. Choose one of the following options in the Broker Portal:

    • Option 1: On the Dashboard (Home Page), select Bulk Upload from the Filings panel.

    • Option 2: On the Manage Filings screen, select Bulk Upload from the page header.

  2. Either drag and drop your saved CSV file into the upload box, OR click Select CSV File to browse and open it from your computer.

  3. Confirm the file name is displayed correctly.

  4. Click Import.

If errors are detected, you must remove the file, fix the issues, and re-import.

Possible Errors:

  • NPN not found, or logged-in user not associated with that broker.

  • Missing required fields: Broker NPN, Transaction Type, Policy #, or Insured.

Result:

  • All uploaded transactions will appear in Draft status on the Manage Filings screen.

Next Steps:

  • Open and review each draft transaction

    • Verify all information is correct for that transaction.

If the system was unable to find the Line of Business or Insurer for any of the uploaded transactions, that field will be blank and need to be populated manually.

  • Upload required documents.

  • Submit as with any manually entered filing.

Related articles