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

  • Each filing must still be reviewed and submitted individually from within the Broker Portal.

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:

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

  • Broker NPN*

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

  • Policy #*

If this filing is an endorsement, be sure to use the underlying new/renewal transaction’s Policy #, even if the number is different on the endorsement. This allows the system to associate the endorsement with that underlying policy. You can edit the policy number if needed after the upload has completed.

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

  • Is this a Homeowner Policy (Y or N) - If required by the LOB, populates the checkbox

  • 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

  • Custom transaction ID

  • Documents - Document Name: File Type; Document name must include the suffix (e.g., .pdf); File Types are Dec Page, Endorsement Document, ECP Certificate, Due Diligence Form, Other; If multiple documents are being uploaded, separate each documenet/file type pair with the | symbol.

Example document field use:

image-20260519-182518.png

If a listed document cannot be found in the ZIP file upload, or if documents are listed on the CSV but no ZIP file is uploaded, you will be alerted and will need to resubmit the CSV and ZIP file.

  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. Optional: Drag and drop a ZIP file containing the documents for the transactions on the CSV document.

  4. Confirm the file name is displayed correctly.

  5. Click Import.

Result:

  • The Bulk Upload Results screen displays in the current tab listing the import result.

    • If no errors occurred, the grid will display each filing, how many documents were associated with each, and the malware scan result. Clicking on the icon to the right of the grid will open that filing in the current tab.

    • If there were errors, then the rows with errors will be listed and a description of the error.

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.

  • Document names listed are not found in the ZIP file

  • All successfully 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 if they were not uploaded with the CSV file.

  • Submit as with any manually entered filing.

Related articles