Basic Import (Share Issuance Only)

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:

Import with share transfers

Import with share transfers and share numbers

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

first_name

The first name of the investor. Ignore if the investor is a company.

last name

The last name of the investor. Ignore if the investor is a company.

email

The email address of the investor. Make sure that the email address is correct as this becomes the id on Capdesk.

registration_number

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.

company_name

Only fill out this field if the investor is a company. The legal name of the company investor.

address1

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.

city

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.

postcode

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.

country

The country of the investor. This is required and cannot be left blank. Please also use the country ISO code (2 letters).

stakeholder_category

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.

quantity

The quantity of shares bought. Please don't use decimals or negative numbers.

date

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

share_class

Insert the share class the investor has purchased. Make sure you have already created the share class. See step 1 (above).

funding_round

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.

b. Overview

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.

d. Publish

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.

8. Finish

After publishing the draft transactions, you will see all the transactions published on the transaction page.