Bulk File Processing

Efficiently validate multiple records by uploading bulk files. Follow the steps below to process your data seamlessly.

Accessing Bulk Upload

Navigate to the "Bulk" link in the top header to access the bulk file upload feature.

Uploading a File

To upload a bulk file:

  1. Choose File: Click "Choose File" and select the bulk file you wish to process.
  2. Select Validations: Choose the validations applicable to your upload:
    • IRS: IRS TIN Matching
    • EIN: EIN Lookup
    • GIIN: GIIN Validation
    • LEI: LEI Validation
    • ADDRESS: Address Validation
    • LIST: Sanction List Matching
  3. Upload: Click "Upload".
  4. Processing: The system will process your file and notify you of any issues or errors.

File Format Requirements

Ensure your bulk files meet the following criteria for successful processing.

Supported File Types

  • Excel: .xlsx
  • Delimited Files: .csv, .tsv, .txt (using TAB, Pipe, or Semicolon delimiters)

Required Headers

Each validation type requires specific headers:

  • IRS TIN Matching: "TIN", "Name"
    • Optional: "TIN Type" (use 1 for EIN, 2 for SSN)
  • EIN Lookup: "TIN"
  • GIIN Validation: "GIIN"
  • LEI Validation: "LEI"
  • Address Validation: "Address", "City", "State", "Zip"
  • Sanction List Matching: "Name"

Optional Headers

Enhance data accuracy by including additional headers:

  • Name Fields:
    • Combined: "Name" or "Full Name"
    • Separate: "First Name", "Last Name"
  • Address Fields:
    • Combined: "Address" or "Address 1"
    • Additional: "Address 2"
  • Zip Code Fields:
    • Combined: "Zip" or "Zip 5"
    • Extended: "Zip 4"

Possible Values for irs

Value Description
2 TIN entered is not currently issued.
3 TIN/Name combination does not match IRS records.
6 TIN/Name combination matches SSN records.
7 TIN/Name combination matches EIN records.
8 TIN/Name combination matches both SSN and EIN records.

Related