How to add offline distributions to the platform? (Manual Transactions, Prior Transactions, Distributions))

Once your investors start creating transactions in the platform, or you have imported offline transactions, you can log any distributions that my have been processed for your offers.

• For more information on importing transactions, click here

NOTE: To record distributions that have been reinvested in the offer, you will want to follow the process outlined here

You can add distributions individually, or in bulk.

Individually:

You can update your Accounts with any distributions that may have occurred outside the platform.

To do so:

1. Select Accounts from the left menu
2. Click into the account you would like to update
3. Choose the Transactions tab
4. Click Add a Transaction
5. Provide the following information:
   • Offer
   • Amount
   • Date
   • Type = Distribution  
   • Status = Complete
     • You also have the option of indicating whether a distribution is for Cash or Shares
     • If you choose Shares, you can include Price Per Share and Number of Shares
6. Click Submit

If you would like to associate the distribution with a specific contribution, you will have the option to do so using the Related Transaction drop-down menu.  Relating a distribution to a contribution will nest the transactions together.

In Bulk:

You can upload transactions using an Excel import.  

A good way to locate all the investors who have contributions in your offer is to conduct an export first.

To do so:

1. Select Transactions from the left menu
2. Use the plus icon to be sure the following columns are added to the table (plus any others that will help you review your data):
   • Account Number
   • Amount
   • Offer
   • Date
   • Type
   • Status
   • Transaction ID
     • To nest your distributions, you will need the ID of the corresponding contribution
3. Click Filters
4. Filter by the offer name and Contribution type, to find all the contributions in a specific offer
5. Select all
6. Click Export
7. Choose Export Selection

Once you have your export in Excel, you can enter the distribution amount for each investor and change all Contributions to Distributions.

Once your file is ready, you can import the distributions into the platform.

To do so:

1. Select Transactions from the left menu
2. Click Import
3. Ensure the columns included in your Excel file match the required order
4. Confirm you have all required data:
   • Account Number
   • Offer Symbol
   • Amount
   • Date
   • Type = Distribution
   • Status = Complete
   • Related Transaction ID, if you would like to nest your distributions
   • Share price, if you are processing distributions of Shares and would like to indicate a price other than what is set on the offer
5. Add any other Columns from the drop-down menu that match the columns on your file
6. Upload your file
7. Click Import Transactions

NOTE: You will need to be sure to check the box: My spreadsheet includes existing account numbers. This is required when you have investors with more than one account.  For example, you may have an investor with both an Individual and an Entity account type, and you will want to be sure the transactions are associated with the correct account.