Fund-Investor Assignment Overview

The Fund-Investor Assignment feature is available on the Funds Page and allows you to assign existing investors to existing funds. However, there are prerequisites that must be met before making the Fund-Investor assignment. Refer to the Preparation section below for details and instructions on How to Use this feature correctly. An additional Troubleshooting section is located at the bottom of the page to assist you in successful fund-investor assignment.

IMPORTANT: You cannot add new contacts, new investors or new funds, or remove them from the system with this feature.

REMINDER: With this feature you can only:

  • Assign existing investors to existing funds.
  • Have one commitment per investor in the fund.

Preparation

Before processing any Fund-Investor-Contact assignments, there are prerequisites that must be met. These include:

  • Contacts and Investors must already exist in the system.
  • Investor-Contact assignments must already be completed.
  • Funds must already exist in the system.

NOTE: Investors assigned to a fund can only be viewed in that Fund's Financials tab.

How to Use

  1. On the Funds page, click the Download button and select Investor Assignment.

    Notice the green banner at the top of the page indicating a notification will appear in the notification center once completed. Click the notification to download the file.

    Next, open the file and make the necessary adjustments to the template and prepare it for upload.

    Column Headers will appear in the order indicated below: Fund ID, Fund Name, Investor ID, Partner ID, Investor Name

    Mandatory fields for Upload:

    1. Fund ID
    2. Investor ID

  2. Click the Upload button and select Investor Assignment. The file picker opens to select the related file (XLSX and CSV formats only).

  3. Once the file passes all validations a new investment record for each Investor ID in the related fund is created with a $0.00 commitment.

Troubleshooting

If there are any failures, a yellow banner appears to alert you with a brief explanation. The types of errors you may encounter are listed below as well as their solution:

ERROR MESSAGE

SOLUTION
Error: Unable to upload data. Only XLSX format is supported
Check the file format and make sure it is XLSX.
Fund-Investor assignment: error uploading myfile.xlsx. No data was uploaded. The file must have exactly 5 columns.
Make sure all 5 columns are there.
Fund-Investor assignment: error uploading myfile.xlsx. No data was uploaded. Mandatory information missing on cell number(s) P1, Q1, R1,T1
Make sure the upload file includes data.
Fund-Investor assignment: error uploading myfile.xlsx. No data was uploaded. Invalid Fund IDs on cell number(s) P1, Q1, R1, T1
Make sure that the Fund IDs all exist in the system and reupload. Fund IDs are found in the left most column in the Funds page.
Fund-Investor assignment: error uploading myfile.xlsx. No data was uploaded. Invalid Investor IDs on cell number(s) P1, Q1, R1, T1
Make sure that the Investor IDs all exist in the system, and reupload. Investor Ids are found in teh left most column in the Investors page.
Fund-Investor assignment: error uploading myfile.xlsx. No data was uploaded. Duplicate Investor-Fund assignments found on rows: 2, 4, 6
Remove any duplicate fund-investor assignments in the sheet and make sure the investor is not already assigned to the fund. (check the Financials tab to verify)
Fund-Investor assignment: error uploading myfile.xlsx. No data was uploaded. Investor IDs in the following cell number(s) do not have any contacts assigned: P1, Q1, R1, T1
Make sure that you have at least one contact assigned to the investor, and reupload.
Fund-Investor assignment: error uploading [filename] because due to incomplete configuration. Set the GS “investment_date_field ” and “fund_deployed_field” and try again.
Contact Customer Support.

Related Articles