Follow

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. 

addshareclass.JPG

 

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

 

Screen_Shot_2017-06-19_at_16.22.00.png

Here is an illustration to help you understand the functions of the different columns 

Screen_Shot_2017-06-22_at_17.13.16.png

Step 4 Insert investors

first_name

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

Screen_Shot_2017-06-19_at_16.28.00.png 

last name 

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

Screen_Shot_2017-06-19_at_16.29.40.png

email

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

Screen_Shot_2017-06-19_at_16.33.53.png

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. 

Screen_Shot_2017-06-19_at_16.41.17.png

company_name 

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

Screen_Shot_2017-06-19_at_16.47.36.png

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.

Screen_Shot_2017-06-19_at_16.47.36.png

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.

Screen_Shot_2017-06-19_at_16.57.53.png

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.

Screen_Shot_2017-06-19_at_16.59.28.png

country

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

Screen_Shot_2017-06-19_at_17.21.27.png

investor_category 

Choose the category of the investor. You can choose the following categories:  "founder", "angel", "vc", "crowd_investor", "lender", "investor", "employee", "partner","board_member", "chairman", "shareholder". This can be left blank.

Screen_Shot_2017-06-19_at_17.29.15.png

price - The price per share

The price paid per share. Please use a positive number.

Screen_Shot_2017-06-19_at_17.34.08.png

quantity 

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

Screen_Shot_2017-06-19_at_17.40.37.png

date 

The date when the shares were purchased. Please use the same format for all dates. We recommend the following format: 

yyyy/mm/dd

Make sure the dates are all after the founding date you have set in the company settings

Screen_Shot_2017-06-19_at_17.44.53.png

share_class 

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

Screen_Shot_2017-06-19_at_17.46.25.png

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.

Screen_Shot_2017-06-19_at_17.49.44.png

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 cellls not in use! 

Screen_Shot_2017-06-19_at_17.52.15.png 

Step 5 Upload file

Navigate to "Cap Table" -> 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. 

Screen_Shot_2017-06-19_at_17.59.20.png

Step 6 Result

When uploading your file you will get one of these messages:

a. (Errror) The data file provided for import is invalid. You can review the validation errors by downloading the file below

Screen_Shot_2017-06-19_at_18.00.43.png

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 alot 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 Ashares in the system, we get an error

Screen_Shot_2017-06-19_at_18.01.51.png

Screen_Shot_2017-06-19_at_18.02.01.png

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 succesfully uploaded your file.  

Screen_Shot_2017-06-19_at_17.55.24.png

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. 

Screen_Shot_2017-06-20_at_09.17.59.png

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. 

Captable.JPG

 

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. 

Screen_Shot_2017-06-20_at_09.35.23.png

 

0 Comments

Please sign in to leave a comment.
Powered by Zendesk