Add Multiple Companies Using Template
You can easily create your Eqvista account and your company’s profile to issue shares and securities to the shareholders.
How to Add Multiple Companies Using Template?
On Eqvista, you can add multiple companies using a template or manually in simple steps. To help you better, here is a step-by-step guide on how to add multiple companies using a template on Eqvista.
Step 1: Log into your account on Eqvista, or create an account if you have not yet signed up.
Once you have logged into your account, you will be directed to the dashboard and select a company you have already created. On the dashboard, click on company name on the left-hand side to get a drop-down menu and select “Add Company or Service”.
Step 2: Once you have logged into your new Eqvista account or clicked on the option “Add Company or Service”, you will be directed to the following page.
Note: You can also add a single company by filling in your company details. Check out the support article to learn more about single company setup.
To onboard multiple companies, click on “Switch to Bulk Import”.
Step 3: Then, you will be directed to provide your basic company information by selecting the option:
- Work with existing companies: Select from the companies you already manage on Eqvista.
- Create new companies: Onboard entirely new legal entities into Eqvista.
In this case, we have selected the option “Create new companies”.
Note: You can work with existing companies by clicking “Work with existing companies”. Check out the support article to learn more about work with existing companies option.
Note: You can also add a single company by clicking on “Switch to Single Setup”. Check out the support article to learn more about single company setup.
After selecting your option, click on “Continue to Service Selection”.
Step 4: Once you click, you will be directed to select your services by choosing the modules that best fit your company.
Note: If you’re unsure about the services or need assistance, click on the “Book a call” button.
After choosing your services, click on “Continue to Data Source”.
Step 5: Then, you will be directed to choose the method to add your companies – upload the completed template or enter each company’s details manually.
In this case, we have selected the option “Upload spreadsheet”.
Note: You can enter each company’s details manually by clicking “Enter data manually”. Check out the support article to learn more about adding companies manually.
1. Prepare Data
Download our optimized Excel template containing the exact schema required by clicking on “Download Template”. To view the columns of the template, click on “+15 more columns”
Once you click “Download Template”, the template gets downloaded as an Excel sheet in your Downloads.
Double-click the Excel sheet to open the downloaded template.
2. Upload Complete File
Once you have prepared your data using the template, click on “Browse File” to upload the complete file. The supported file formats are XLSX and XLS, with a maximum file size of 50 MB.
Choose the file that you want to add and click on “Open”.
When you click on “Open”, the file will be uploaded as shown below.
After uploading the file, click on “Continue to Data Verification”.
Step 6: Then, you will be directed to the page where the data of the imported file will be reviewed. It will display the errors along with an option to edit by clicking on the edit symbol.
Once you click, a panel will appear to edit your company information.
Once done, click on “Save Company Information”.
Step 7: After editing your company information, the status changes to “Valid” and click on “Finish Onboarding”.
Step 8: Connect each company’s financials from QuickBooks to build its real-time valuation. QuickBooks is optional, and any company you leave unconnected will use the figures from your import instead.
Note: Connect a company to import its financials and build a real-time valuation automatically. Check out the support article to learn more about connecting QuickBooks in real-time valuation.
In this case, we will connect to QuickBooks by clicking on “Connect QuickBooks”.
Note: You can click “Set period for all” to fill in the period start and period end for all the companies.
Quickbooks Integration
Once you click “Connect QuickBooks”, a panel will appear to fill in the period start and period end to pull financial data from QuickBooks for a custom date range.
Once done, click on “Connect & Import”.
Then, you will be redirected to enter the email or User ID of QuickBooks as shown below.
Once you click “Sign in”, you will be redirected to enter your password and click on “Continue”.
Once you do this, you will be directed to the following page. By selecting “Connect”, you agree that we can share your QuickBooks Online data with Eqvista.
The QuickBooks integration displays the status “Connected” along with a few functions and an option to “Disconnect”.
#1 Verify Data
Once you click “Verify Data”, you will be directed to verify the financial data pulled from QuickBooks for the entered period.
Once you click “Confirm Data”, the status changes from “Connected” to “Verified” as shown below.
#2 Change Period
When you click “Change Period”, a panel appears to change the period start and period end to pull financial data from QuickBooks.
Step 9: After you have added all the details, click on “Finish Onboarding”.
Once you click on “Finish Onboarding”, a pop-up panel appears along with the option “Go to Dashboard”.
Step 10: Then you will be directed to the dashboard of the company. The added companies can be viewed by clicking on the company name on the left-hand side to get a drop-down menu, and company names appear on the list.
Note: You can upgrade your account to premium subscription to have access to unlimited features. To know more about it, check out the FAQ!
Step 11: The services added for the company are cap table management and 409A valuation.
The 409A valuation can be viewed by clicking on “409A Valuation” on the left side of the dashboard or by clicking on “Manage Fair Market Value (FMV)”.
All the valuation results will be updated here, and a graph will be shown.
Note: A 409A valuation is applicable for 12 months or year after the valuation date unless there is a significant material event.
By clicking on “Add Fair Market Value“, you can add fair market value. To share and edit the fair market value entered, check out the respective support article.
The “TBD” can only be deleted by clicking on “Actions”.
You will receive an email confirming that your request has been successfully submitted along with an option to “Schedule Meeting”.
Step 12: Since QuickBooks has been connected to access your financial data and automatically generate quarterly real-time valuations.
The real-time valuation generated by QuickBooks can be viewed by clicking on “Real Time Valuation” on the left side of the dashboard.
Then, you will be directed to the page displaying the fair market value of real-time valuation and the source as “QuickBooks”.
The QuickBooks integration displays the status “Connected” along with details of the next real time valuation schedule, and an option to “Disconnect”.
Note: On this page, you can view the real-time valuation graph. To share your real-time valuation report, click on “Share”. Check out the respective support articles to learn more about it.
If you want to understand Eqvista, check out our support articles or contact us today!
