All Collections
Manager Platform Guide
Introduction
Manager Platform Guide - How can I import Data into Groundbreaker?
Manager Platform Guide - How can I import Data into Groundbreaker?

Discover how to transfer your data onto the Groundbreaker Platform

Joni Reeves avatar
Written by Joni Reeves
Updated over a week ago

You have options for managing your Groundbreaker Data Import. You can add your historical data yourself or choose to have Groundbreaker load it for you. Talk to the Groundbreaker team about import options and associated fees.

Regardless of which path you take, this article will describe and explain how to organize your data for a successful import process. Once your data is available on the Groundbreaker platform, you will have increased visibility into your business and can give your investors an automated and clear view of their positions. The data you can provide is the following:

  • Contacts

  • Investment Entities

  • Investor Accounts

  • Investments

  • Distributions

When you choose to have Groundbreaker upload your data, a specialist from our team will send you the location of a secure folder with the spreadsheet where you can upload spreadsheets and other documents. Our team can take a look at your data and work with you to transform it into a structure that is aligned with Groundbreaker layout requirements. We`ll share a template you can use to organize all the data. Once both sides have reviewed the information and its format, we'll proceed with the import process.

Requirements

To have a successful import, there are some key factors to consider.

Cell Format - The data you enter must conform to the format expected for that data column. Enter only numbers for numerical fields and dates for date fields. Text fields allow you to enter letters, numbers, and special characters. The cell format is defined below for each data field.

Data References - it is critical that when you enter data into text fields, especially when data relationships are created based on those fields, you are consistent about the text you enter. For example, when you provide a contact name “Sam Jones” and he owns the investor account “SJones LLC”, anywhere his investor account is entered, the text must contain “SJones LLC” and not any variations like “Sam Jones LLC”, or “S<space>Jones LLC”. The necessary and correct relationships between the data cannot be created when one of the fields contains extra spaces, a different spelling, or extraneous characters.

Importing Contacts

Your contacts include both prospects and current investors. The data you need to provide for Contacts is:

  • First name

    • Plain text field

    • Required

    • Ex: Sam

  • Last name

    • Plain text field

    • Required

    • Ex: Jones

  • Email address

  • Phone number

    • Plain text in a phone number format with numbers and spaces

    • If blank, the system will use 570 578 2488

    • Ex: 817 665 4111

Groundbreaker Data Import: The spreadsheet template has a Contacts tab where you can enter, review and edit the required data. Optional fields, like tags and address, are available as well.

Providing Investor Data

If you are importing information about existing investments and/or distributions, then you will provide data about the investors’ accounts, what they invested in, and the amounts of investments and distributions.

Investor Accounts

Investor Accounts are the legal entities created by the investors for managing their investments. All documents, investments, and distributions for an investor must be associated with an investment account.

  • Contact Full Name

    • Plain text field

    • Required

    • Ex: Sam Jones

  • Contact email

  • Investor Account name

    • Plain text field

    • Required

    • Ex: SJones LLC

  • Investor Account type (e.g. LLC, Corporation, Individual, etc.)

    • Pick list

    • Required

    • Ex: Limited Liability Company (LLC)

  • EIN or SSN number

    • Plain text with numbers and dashes

    • Required

    • Ex: 111-22-3333

  • Date of Birth

    • Date Field - format mm/dd/yyyy

    • Required if the Investor Account Type is "Individual"

    • Ex: 10/29/1998

  • Investor Account Address

    • Plain text field

    • Required

    • Ex: 900 Michigan Ave

  • Investor Account City

    • Plain text field

    • Required

    • Ex: Chicago

  • Investor Account State

    • Pick list

    • Required

    • Ex: IL

  • Investor Account ZIP Code

    • Plain text field

    • Required

    • Ex: 60611

Groundbreaker Data Import: The Spreadsheet template has an Investor Accounts tab where you can enter, review, and edit the data.

Because investors can have multiple accounts, the same name and email may appear as the contact for more than one Investor Account.

Investment Entities

Investment Entities are the legal entities you have created to manage the assets offered for investment. All documents, investments, and distributions for an offering must be associated with an investment entity.

  • Investment Entity name

    • Plain text field

    • Required

    • Ex: Apartment Syndicators - Nevada

  • EIN, SSN or ITIN number

    • Plain text with numbers and dashes

    • Required

    • Ex: 11-3333333

  • Investment Entity address

    • Plain text field

    • Required

    • Ex: 123 Manchester Ave

  • Investment Entity City

    • Plain text field

    • Required

    • Ex: Reno

  • Investment Entity State

    • Plain text field

    • Required

    • Ex: NV

  • Offering Name (the marketing name that will display in your investor portal)

    • Plain text field

    • Required

    • Ex: Reno Apartments

Groundbreaker Data Import: The Spreadsheet template has an Investment Entities tab where you can review and edit the data.

Investments

Investments are the amounts invested and must be associated with an investment entity and investor account.

  • Investment Entity receiving the investment

    • Plain text field

    • Required

    • Must exactly match an Investment Entity name on the Investment Entities tab

    • Ex: Apartment Syndicators - Nevada

  • Investor Account name

    • Plain text field

    • Required

    • Must exactly match an Investor Account name on the Investor Accounts tab

    • Ex: SJones LLC

  • Investment Amount

    • Currency field

    • Required

    • Ex: $10,000.00

  • Date Contributed (Investment close date)

    • Date Field - format mm/dd/yyyy

    • Required

    • Ex: 10/29/2020

Groundbreaker Data Import: The Spreadsheet template has an Investments tab where you can enter, review, and edit the data.

Distributions

Distributions are the amounts paid to investors and must be associated with an investment entity and investor account.

  • Investment Entity making the distribution

    • Plain text field

    • Required

    • Must exactly match an Investment Entity name on the Investment Entities tab

    • Ex: Apartment Syndicators - Nevada

  • Investor Account name

    • Plain text field

    • Required

    • Must exactly match an Investor Account name on the Investor Accounts tab

    • Ex: SJones LLC

  • Distribution Amount

    • Currency field

    • Required

    • Ex: $400.00

  • Date of Distribution Payment

    • Date Field - format mm/dd/yyyy

    • Required

    • Ex: 3/17/2021

  • Distribution Name

    • Plain text field

    • Required

    • Ex: 2021 Q1 Distribution

Groundbreaker Data Import: The Spreadsheet template has a Distributions tab where you can enter, review, and edit the data.

Support Information

If you have more questions or feedback, please use the live chat in-app (located in the bottom right corner) or contact support@groundbreaker.co.

Did this answer your question?