How to Import a Cap Table into Capshare

Here is a step by step guide to importing your data into Capshare.  It’s similar to using a spreadsheet, only more powerful.

After logging in, you should land on the first step of the import, Primary Issuances.

Spreadsheet Interface



This screen looks, feels, and behaves much like a typical spreadsheet.

You can copy and paste data between cells and from other data sources.

Cells with a downward arrow on the right side are dropdown menus that allow you to select from pre-existing data.

Clicking on the arrows at the top of the screen takes you from step to step.

how-to-import-a-cap-table-into-capshare-1

Step 1: Common Shares

To create a common issuance, just select the first cell in the upper-left corner of the spreadsheet and type in a shareholder name.

The cells for Date, Shares and Price Per Share will turn red.  Red cells indicate missing or invalid data:

how-to-import-a-cap-table-into-capshare-2

After you fill out the remaining cells, you’ll see a spinner to the left of the row indicating that the record is saving. A green checkmark will appear to the left of the row once the record is saved:

how-to-import-a-cap-table-into-capshare-3

NOTE: You can enter in a certificate name like “CS-1” if you want, but we’ll auto generate it if you leave it blank.

Advanced

At the very bottom of the screen next to the sheet tabs you’ll notice a toggle button:

how-to-import-a-cap-table-into-capshare-4

Clicking this toggle will expand the spreadsheet to include a few more columns to provide you with more advanced functionality:

how-to-import-a-cap-table-into-capshare-5

The advanced fields give you the ability to record restricted stock issuances by specifying a Vesting Plan, Equity Plan, 83(b) Election File Date, and so forth.  You can also specify exemption dates and add notes as well.

NOTE: You’ll notice that we’ve pre-populated the Federal Exemption field with Rule 701, which is the standard exemption in most cases.

Step 2: Preferred Shares



Using the tabs at the bottom of the screen, click on the “Preferred Issuances” tab to navigate to the preferred spreadsheet:

For the “Security Name” column, enter in the name of the security that the issuance belongs to.  You can adjust the security settings at a later step.

Advanced

The advanced toggle gives you more columns with things like Certificate ID, Approval Date, Exemptions, and Notes.

NOTE: You can enter in a certificate name like “PS-1” if you want, but we’ll auto generate it if you leave it blank.

 Step 3: Options

Using the tabs at the bottom of the screen, click on the “Option Grants” tab to navigate to the options spreadsheet:

In the “Equity Plan Name” column, just enter the name of the plan the option grant belongs to.  You can adjust settings at a later step.

For the “Vesting Plan” column, we’ve automatically created a couple standard plans to choose from.  Or you can type in a custom plan that you can customize at a later step.

Advanced

The advanced toggle gives you more columns for things like exemptions, specifying early exercisability, approval dates, etc. You can also specify the option’s underlying security, which is Common by default.

Step 4: Warrants & Convertible Securities

Hopefully you’re getting the hang of things by now.  The steps for uploading warrants and convertible securities is similar to all the previous steps.

Warrants

You’ll notice the “Underlying Security” column on the Warrants sheet.  Here you specify the security for which the warrant holder has a right to purchase.

Convertible Securities

Step 5: Secondary Transactions

Next, click on the “Secondary Transactions” step at the top of the import page (we’ll just walkthrough the exercises tab to help you get the hang of it):

how-to-import-a-cap-table-into-capshare-9

Use the first column to select the “Grant ID” of the option or warrant you want to exercise.  This is populated from grants you’ve already recorded:

how-to-import-a-cap-table-into-capshare-10

Advanced

The advanced columns give you the option to specify the name of the certificate that the option or warrant exercises into.  If this is not specified, we’ll automatically generate certificates for you.

NOTE: Any unvested shares that are exercised for options will automatically be converted into restricted stock with the appropriate vesting schedule.

Step 6: Shareholders

Click on the “Shareholders” step at the top of the screen.  Here is where you can easily add information about all your shareholders.  You’ll notice that the sheet is already populated with the shareholders you’ve issued shares to in the previous steps.

how-to-import-a-cap-table-into-capshare-11

This step is optional, but if you plan on inviting shareholders to view their shares or are performing a stock expense report, you’ll want to fill out things like email address, shareholder type, and department.

Step 7: Securities

Clicking on the “Securities” step of the import screen takes you to a list of all the securities you created when issuing shares in the previous steps:

how-to-import-a-cap-table-into-capshare-12

Hover over one of the rows to show the edit and delete buttons on the right.  Click Edit to reveal the available options for that security.

Here is where you’ll specify things like authorized shares, liquidation preferences, dividends, etc.  After you’ve made changes to a security, click the Save button at the bottom of the form.

Step 8: Equity Plans & Vesting Plans

The “Equity Plans” step of the import screen shows you all the Equity Plans you created when issuing shares, as well as Vesting Plans and Expiration Policies.

Hover over a row for your equity plan to reveal the Edit and Delete buttons.  Click Edit to open the form where you can change the details of the option plan.

Now click on the Edit button for the “4-Year Cliff” vesting plan.  You’ll see a form that looks like this:

how-to-import-a-cap-table-into-capshare-13

You’ll notice that vesting plans are highly customizable.  You can specify a Change of Control Trigger, Rounding Policy, Day of the Month on which vesting occurs, etc.  You can create any combination of vesting periods to create custom vesting schedules.

Step 9: Seniority

The “Seniority” step is where you specify the order in which the preferred securities receive their preferences.  The higher the tranche number, the higher the seniority.

For example, if Series B receives their preference before Series A, you would place Series B in Tranche 2 and Series A in Tranche 1.

TIP

Not sure what the preference stack looks like on your cap table? The best place to look is the company’s certificate of incorporation. There’s usually a section on liquidation preferences that lays out the order in which the different preferred securities receive their preferences.

You might have to wade through some legal verbiage to figure it out, but it’s there in the wording.

If you ever have any questions on topics like this, feel free to reach out to us. You can chat with us in real-time at www.capshare.com or email us at support@cashare.com any time.

Step 10: Invite others to the cap table

This is the last step in the import process. You’ll notice that we’ve already listed all the shareholders on the cap table. If you’ve entered their email addresses in the Shareholder step, you’ll see their emails listed here.

Find a shareholder on the list you want to invite. If they don’t have an email yet, click the “Add Email” button on the shareholder’s row:

how-to-import-a-cap-table-into-capshare-14

Next, select what permission level you want to give them by dragging the permission slider:
how-to-import-a-cap-table-into-capshare-15

There are three access levels available:

Restricted:  Access is restricted to personal holdings and documents. They cannot make any changes or see their holdings relative to anyone else.

View:  View access allows the user to see the entire cap table, but they cannot make any changes to the data.

Edit:  Edit access allows the user to see the entire cap table and make changes to the data. They can also invite or remove other users.

Once a shareholder has an email address, just click the “Send Invite” button on right side of the row:

how-to-import-a-cap-table-into-capshare-16

To invite multiple shareholders at once, select them by clicking on their row (selected rows turn blue with the checkmark checked on the left), then click the “Actions” button in the top right:

how-to-import-a-cap-table-into-capshare-17

Finally, if you want to add someone who is not already on the cap table, click the “Add User” button:

how-to-import-a-cap-table-into-capshare-18

A dialogue will appear allowing you to enter in a name, email address and access level for the person you want to invite.





 

Conclusion

Click the “Finished” button in the top right to exit the import.  You’re done!

From here you can click on the menu icon in the very top left of the screen to expand the navigation drawer and start exploring Capshare’s features.

Run into any snags? Something wasn’t clear? Feel free to contact us for support or tell us how we can improve this tutorial.

You can also chat with us right from the app by using the blue chat tool in the bottom right of the screen.

how-to-import-a-cap-table-into-capshare-19

We hope you enjoy using Capshare!

Was this article helpful?

Related Articles