Perform a Batch Upload of Third Parties

Important: This feature is available to Level 1 users only.

Batch Upload provides the ability to add or update multiple third parties at one time. Additionally, you can request reports or monitoring for the third parties included in the upload. To perform a batch upload, enter the third party information into an Excel file, and then upload the file into RiskRate.

Important: Before getting started, please carefully read and go through Considerations for Batch Upload and Batch Upload Template Instructions.

Step 1: Download Batch Upload Instructions

  1. From the Admin menu, click Batch Upload. The Batch Upload page displays.
  2. Click Download Batch Upload Instructions.
  3. Carefully read the "Batch Upload and Screening Instructions" (downloaded file) prior to performing a batch upload and before continuing.

Step 2: Download Batch Template

  1. From the Admin menu, click Batch Upload and then from the header, click and then Batch upload Third Parties. The Batch Upload Wizard displays.
  2. Under Do you need a template file?, do one of the following:
    • Click Yes, and then click Organization or Person. Click Download Batch Upload Template to start the download. Follow the prompts to open the downloaded template.

      • Notes:

      • If you need to upload third parties that are organizations and third parties that are persons, you'll need to perform separate uploads for each third party type.
      • Because our data partner stores the screening information for organizations and persons in two separate databases, it is important that you use the correct upload template to upload third party information. In addition, if a person is also registered as a DBA (doing business as), LLC, or incorporated entity, you should upload (or manually create) that entity both as a person and as an organization so that both screenings can be done.

    • If you downloaded a batch upload template previously and want to use that template to add or update third parties, click No.

Step 3: Perform Batch Upload

  1. From the Batch Upload Wizard, do one of the following:
    • If you just downloaded and opened the batch upload template, enable it for editing and then enter the third party information. See Batch Upload Template Instructions for details.
    • If you are using a previously downloaded batch upload template, open it and add third parties or modify existing third party information.

    Important: If using Batch Upload to modify information for existing third parties, make sure that you include the third party ID of each third party you need to update in the batch upload template. This will prevent the creation of duplicate third parties. (For details on how third party IDs affect a batch upload, see Batch Upload Template Instructions.)

  2. Click Continue.

    3. Note: If the Batch Upload wizard is no longer displayed, simply repeat steps 1 through 4 above, but select No for Do you need a template file?. Click Continue, and then click Organization or Person, depending on the type of template you downloaded previously.

  3. Do one of the following:
    • Click Select and Upload File, find and click the file you want to upload, and then click Open.
    • Open Windows Explorer, find the file you want to upload, and then drag and drop the file onto the Drop file here box in the RiskRate Submit Upload File page.

  4. After the file information appears on the screen, click Upload.
  5. RiskRate does a preliminary check of the file and displays one of the following prompts, depending on the outcome:
    • If the file contains one or more errors, you are returned to the Submit Upload File page with the errors displayed on the right. Each error in the list includes a description and the error's location in the worksheet. Fix the listed errors then upload the Excel file again.

      Note: If there are multiple types of errors, you may need to repeat this process until all errors are fixed.

    • If the file contains no errors, you'll see the prompt below. Click OK, and then click Continue.

  6. In answer to the next question, click the option that is true about the third parties listed in the Excel file you uploaded.

    7. Note: For details on how third party IDs affect a batch upload, see Batch Upload Template Instructions.

  7. Do one of the following:
    • If you selected All records include a Third Party ID, you are asked if you want the records of any third parties with matching IDs that already exist in RiskRate updated with the information contained in the upload file. Click Yes or No.

    • If you selected No records include a Third Party ID, you are warned that uploading third parties without third party IDs could result in the duplication of third party records. You are then asked if you want to continue with the upload without third party IDs in the upload file. If you click Yes, move on to the next step. If you click No, click Back and then, after adding third party IDs to the upload template, repeat steps 8 through 11.

    • If you selected Some records include a Third Party ID, two additional questions appear. The first asks if you want the records of any third parties with matching IDs that already exist in RiskRate updated with the information contained in the upload file. Click Yes or No.

      The second warns that uploading third parties without third party IDs could result in the duplication of third party records. You are then asked if you want to continue with the upload without third party IDs in the upload file. If you click Yes, move on to the next step. If you click No, click Back and then, after adding third party IDs to the upload template, repeat steps 3 through 7.

  8. At this point you can select what report, if any, you want to request for all of the third parties in the upload file. Do one of the following.
    • Click Yes, whether the requested report includes an assessment, and then select the type of requested report. (In the example below, a Business Sponsor Interview is requested for this batch upload.)

      Note: The reports available for selection were configured when your RiskRate system was set up. Additionally, RiskRate allows the ability to request third party interviews via batch upload. Contact NAVEX Customer Support by submitting a request in the Community to enable this configuration and/or if additional report changes are requested. Specific third party contact information is required for reports that automatically request interviews. See Batch Upload Template Instructions for more information.

    • Click No, just add and/or update these third parties.
    • Click No, just turn on monitoring for these third parties. This allows a user to add third parties and activate monitoring without requesting a screening. Users will be able to select the appropriate monitoring type based on options that were configured during the implementation process.

  9. Click Perform Batch Upload.
  10. A Batch Upload success message displays. Click OK to continue.
  11. A Batch Upload Confirmation prompt shows what actions will be taken if you continue. The display message shows how many third parties will be created and/or updated. It also shows (up to) the total number of ordered reports, and that Reputation screenings will not be ordered for entities that are currently monitored. Click Yes to continue.

    12. Another confirmation prompt informs further validation and an email confirmation with status and next-step instructions will follow. Click OK to continue.

    A status bar appears while the batch upload is processed. When the process is finished, you are returned to the Batch Upload History page with the new batch upload listed.