Skip to main content

Investor CSV Import

  • Updated

Overview

The CSV Import allows bulk imports of Investor Data into the control panel via a standard CSV.

Types of Imports

There are generally two types of import that are executed:

1. Bulk imports of new investors that need to complete KYC & Accreditation on the platform through Securitize iD and InvestReady (or via self-accreditation).

2. Bulk imports of investors that have been KYCd and Accredited off-platform to:

  1. Sign the Subscription Agreement
  2. Fund the offering 
  3. Register a Wallet

Type 1 Import

When investors are imported to complete KYC through Securitize iD they will provide their information directly to Securitize iD and then Securitize iD will provide that data back to the control panel as it is updated.

As a result, a minimal import can be executed for these investors with the following fields:

  • First Name (Mandatory for Individuals, Text, otherwise -) 
  • Last Name (Mandatory for Individuals, Text, otherwise -)
  • Entity (Mandatory for Entities, Text, otherwise empty)
  • Email (Mandatory, Valid Email)
  • State of Residence (Mandatory for US, 2 character abbreviation, otherwise empty)
  • Country of Residence (Mandatory, ISO 3166-1 Alpha-2)

 Note that if the investor updates any of their information during the Securitize iD process (for example they update their first name from Mike to Michael) this information will be corrected after the import.

Type 2 Import - Securitize is acting as the Transfer Agent

The import should include all of the necessary fields required by Securitize as well as the relevant information from the Investor regarding their KYC, Accreditation, and Subscription Agreement Status such that the investor does not need to complete that information again.

  • First Name: (Mandatory for Individuals, Text)
  • Middle Name (Optional, Text)
  • Last Name (Mandatory for Individuals, Text)
  • Gender (Optional, Text)
  • Investor Type (Mandatory, Enumerated List: individual, entity, fbo-individual, fbo-entity)
  • Entity Name (Mandatory for Entities, Text)
  • Entity DBA (Mandatory for Entities, Text)
  • Entity Type (Mandatory for Entities, Enumerated List: revocable-trust,irrevocable-trust,limited-general-partnership,corporation,llc,other)
  • Custodian (Mandatory for Custodial Accounts, Text)
  • Email (Mandatory and Unique, Text)
  • Phone Prefix (Optional, Numeric)
  • Phone (Optional, Numeric)
  • Birthdate (Mandatory, Date MM/DD/YYYY)
  • Address (Mandatory, Text)
  • Additional Info (Optional, Text)
  • Postal Code (Mandatory, Text)
  • City (Mandatory, Text)
  • State (Mandatory for US, 2 Character Abbreviation)
  • Country (Mandatory, ISO 3166-1 Alpha-2 Abbreviation)
  • Tax ID (Mandatory, Text)
  • Tax Country (Mandatory 3166-1 Alpha-2 Abbreviation)
  • Tax ID2 (Optional, Text)
  • Tax Country 2 (Optional, 3166-1 Alpha-2 Abbreviation)
  • Tax ID3 (Optional, Text)
  • Tax Country 3 (3166-1 Alpha-2 Abbreviation)
  • KYC Status (Mandatory, Enumerated List: verified, If not importing KYC details import as none)
  • KYC Date (Optional, Date KYCd)
  • KYC Expiry Date (Optional, Date KYC Expires)
  • Accreditation / Qualification Status (Mandatory, Enumerated List: confirmed, no_accepted, If not importing Accrediation import as none)
  • Accreditation / Qualification Date (Date accredited)
  • Accreditation / Qualification Expiry Date (Date expiration expires - typically 90 days from Date completed)
  • Subscription Agreement: Either Should be complete or not included
    • Subscription Agreement Status (Enumerated List: none, confirmed)
    • Subscription Agreement Date (MM/DD/YYYY)
    • Pledged Amount (Number, 10.01, 10000, 1000000.01)
    • Investment Amount (Number, 10.01, 10000, 1000000.01)
    • Investment Date (DD/MM/YYYY HH:MM)
    • Currency (Valid Currency 3 character abbreviation)
  • Assigned Tokens (Optional, Number, decimals <= Token decimals)
  • Assigned Bonus Tokens (Optional, Number, decimals <= Token decimals) 
  • Token Wallet Address (Optional, Valid address)
  • Document Type (Optional, Enumerated List: passport,driving-licence,national-identity-card,residence-permit,visa,passport-card,work-permit,state-id,uk-biometric-residence-permit,tax-id,voter-id,certificate-of-naturalisation,home-office-letter,immigration-status-document,birth-certificate,other,selfie,certificate-of-formation,articles-of-organization,operating-agreement,address-proof,shareholders-list-and-authorised-signers-list,by-laws)
  • Labels (Optional, List: a,b,c)
  • Identity Document Number (Text)
  • Country of Birth (Text)
  • City of Birth (Text)

Date and Data Formats

Data and data formats are as follows:

  • Countries: 2 Digit ISO2. See the ISO 3166-1 Alpha-2 column on this Wikipedia page
  • US States: 2 Digit Abbreviation (NY, FL, TX, CA)
  • Currencies: JPY,USD,THB,GBP,EUR,ETH,DAI,BCH,BTC,AUD
  • Dates: there are 3 accepted formats for all dates except 
    • December 25, 1991 - Month, DD, YYYY
    • 12/25/1991 - MM/DD/YYYY
    • 1/2/1991 - M/D/YYYY
  • Deposit Amount: INT or Decimal (00.00)
  • Investment Date - DD/MM/YYYY HH:MM - 29/08/2020 17:48

Resources