This is a guide on how to make a basic CSV import of your investors on Capdesk. If you want to download the csv file made below, see the attachments at the bottom of this article.
Note: The below guide is for companies without share numbers and transfers. Here is some links to other tutorials:
Basic Import of Investors
Step 1 Create share class
In order to link an investor to a share class. You will need to create the share class first. Here is a guide on how to make a share class.
Below you can see a few share classes created (Ordinary, Ordinary A, etc.) These will be used in the CSV upload.
Step 2 Create a spreadsheet
Create a spreadsheet using Excel, numbers or any other program.
Step 3 Insert column names
In order to successfully import the CSV file, you need to use these exact column names:
first_name , last name , email , registration_number , company_name , address1 , city , postcode , country, investor_category , price , quantity , date , share_class , funding_round
Here is an illustration to help you understand the functions of the different columns
Step 4 Insert investors
The first name of the investor. Ignore if the investor is a company.
The last name of the investor. Ignore if the investor is a company.
The email address of the investor. Make sure that the email address is correct as this becomes the id on Capdesk.
Only fill out this field if the investor is a company. Fill in the registration number of the company. Make sure it is the correct registration number as this becomes the companies unique ID on Capdesk.
Only fill out this field if the investor is a company. The legal name of the company investor.
The address of the investor. This can be left blank if you do not know the address. When the investor signs up to Capdesk, they can update / add their address.
The city of the investor. This can be left blank if you do not know the city. When the investor signs up to Capdesk, they can update / add the city.
The postcode of the investor.
This can be left blank if you do not know the city. When the investor signs up to Capdesk, they can update / add the postcode.
The country of the investor. This is required and cannot be left blank. Please also use the country ISO code (2 letters).
This is an open text field and you can input any text that you would like. For example, "founder", "angel", "vc", "crowd_investor", "lender", "investor", "employee", "partner","board_member", "chairman". This can be left blank.
price - The price per share
The price paid per share. Please use a positive number.
The quantity of shares bought. Please don't use decimals or negative numbers.
The date when the shares were purchased. Please use the same format for all dates.
Make sure the dates are all after the founding date you have set in the company settings
Insert the share class the investor has purchased. Make sure you have already created the share class. See step 1 (above).
You can group your investment into funding rounds. Just write a name of a funding round and a funding round will be created and linked to the investment. Keep in mind that a default funding round 'Founding Round' is already added by default, so use this tag for the first issuance of shares.
Step 4 Save as a CSV file
When you have finished the spreadsheet. Save the file as a .CSV. You do this by clicking save as in your editor.
Note: Make sure to clear formatting and contents of all cells not in use!
Step 5 Upload file
Navigate to "Shares" -> green "Shares" button -> "Import Shareholders" and select the file you want to upload.
The system will now begin to process the file. This might take a while depending on how long your list is.
Step 6 Result
When uploading your file you will get one of these messages:
a. (Error) The data file provided for import is invalid. You can review the validation errors by downloading the file below
i. This message means that the system has found a mistake in your file. In order to see what the mistake is click 'Download Processed CSV' this will download a csv sheet showing you a error message
ii. When open the file you will find a lot of new columns (all available columns) - don't be confused. Locate the new column called 'is_valid'. Here you will see the text TRUE or FALSE. True means the row is correct. False means the row contains an error. Next to the Error column, you will find a column called messages. This will give you an explanation of what is wrong in the row. In the example below an unknown share class has been created due to a spelling mistake 'Ashares'. As we have not created the share class A shares in the system, we get an error
iii. Correct the mistake in the original CSV file (NOT THE DOWNLOADED ERROR MESSAGE FILE) and upload again.
iiii. Continue this process until the system approves
b. (Success) Data successfully imported.
This message means you have successfully uploaded your file.
Step 7 Review transactions and publish
The system has now created all your transactions as a draft, which means they are not published and none of your investors has been notified.
Now you have the choice to:
a. Review transactions:
Click the button 'Share Transactions' to see a bit of all the draft transactions the system has created. Keep in mind these are not published and can always be deleted without any consequences.
Click on "Cap Table" to view all draft transactions on the investor's list. This is a nice way to see whether or not the percentages and shares match your estimates.
c. Delete Unpublished data
Clicking this button will delete all your draft transactions. This will have no consequences. You can always import the transactions again.
By clicking this button you will publish all transactions and an invitation email will be sent to all the investors!
Be careful with this as it can take a while to 'revoke' all the transactions afterwards.
After publishing the draft transactions, you will see all the transactions published on the transaction page.