For information on installing and using Data Loader, please refer to Understanding the Salesforce Data Loader. Mappings are located at the bottom of this article. If you need any assistance adding fields to the template, please feel free contact FundPanel Support. Templates are located at the bottom of this article.

TABLE OF CONTENTS

• Step-by-Step Instructions for Uploading Portfolio Data
  • Step 1: Upload Company Summaries
  • Step 2: Upload Round Details
  • Step 3: Upload Transactions
  • Step 4: Upload Valuations
  • Step 5: Upload Portfolio Contacts
  • Step 6: Upload Capitalizations

• Company Summary Template
• Round Detail Template
• Transaction Template
• Valuation Template
• FAQ

Step-by-Step Instructions for Uploading Portfolio Data

These steps should be completed in order to avoid conflicts

Step 1: Upload Company Summaries

1. Choose the Insert action
2. For Select Salesforce object: search and highlight Company Summary (aduro__Company_Summary__c)
3. Click browse and select your .csv file and click Next
4. Verify the number of records to be uploaded looks correct and click OK
5. Click Choose an Existing Map and select the Company Summary Mapping file
6. Make sure a location is selected then click Finish and review any errors

Step 2: Upload Round Details

1. Choose the Upsert action
2. For Select Salesforce object: search and highlight Round Detail (aduro__Round_Detail__c)
3. Click browse and select your .csv file and click Next
4. Verify the number of records to be uploaded looks correct and click OK
5. Match aduro__Round_Detail__c to Id then click Next
6. Skip the second matching step and click Next
7. Click Choose an Existing Map and select the Round Detail Mapping file and click Next
8. Make sure a location is selected then click Finish and review any errors

Step 3: Upload Transactions

1. Choose the Upsert action
2. For Select Salesforce object: search and highlight Transaction (aduro__Transaction__c)
3. Click browse and select your .csv file and click Next
4. Verify the number of records to be uploaded looks correct and click OK
5. Match aduro__Transaction__c to Id then click Next
6. Match RecordType to Name
7. Match aduro__Round_Detail__r to aduro__External_Id__c
8. Skip the second matching step and click Next
9. Click Choose an Existing Map and select the Transaction Mapping file and click Next
10. Make sure a location is selected then click Finish and review any errors

Step 4: Upload Valuations

1. Choose the Upsert action
2. For Select Salesforce object: search and highlight Valuation (aduro__Valuation__c)
3. Click browse and select your .csv file and click Next
4. Verify the number of records to be uploaded looks correct and click OK
5. Match aduro__Valuation__c to Id then click Next
6. Skip the second matching step and click Next
7. Click Choose an Existing Map and select the Transaction Mapping file and click Next
8. Make sure a location is selected then click Finish and review any errors

Step 5: Upload Portfolio Contacts

1. Choose the Upsert action
2. For Select Salesforce object: search and highlight Contact (Contact)
3. Click browse and select your .csv file and click Next
4. Verify the number of records to be uploaded looks correct and click OK
5. Match Contact to Email then click Next
6. Skip the second matching step and click Next
7. Click Choose an Existing Map and select the Portfolio Contact Mapping file and click Next
8. Make sure a location is selected then click Finish and review any errors

Step 6: Upload Capitalizations

1. Choose the Insert action
2. For Select Salesforce object: search and highlight Capitalizations (aduro__Capitalization__c)
3. Click browse and select your .csv file and click Next
4. Verify the number of records to be uploaded looks correct and click OK
5. Skip the second matching step and click Next
6. Click Choose an Existing Map and select the Capitalization Mapping file and click Next
7. Make sure a location is selected then click Finish and review any errors

Template Usage

For each template, fill out each field. Fields with a green background are required. Orange fields where there is no relevant data should be left blank.

When finished, save the template as a .csv file!

Company Summary Template

• Column A - Company Summary Name (required)
• Column B - Sector
• Column C - Address

Round Detail Template

• Column A - External Id
  • Naming scheme does not matter, this is only needed for adding Transactions. May be left blank if no transactions will be added.
• Column B - Company Summary (required) 
  • Must match Company Summary name EXACTLY (down to the periods and commas)
• Column C - Record Type (required)
  • Must match EXACTLY
    • Equity
    • Convertible Security
    • Fund
    • Warrant
• Column D - Round (required) 
  • Must be named EXACTLY (e.g. Convertible Promissory Note)
• Column E - Date (required) 
• If SAFE or Note
  • Column F - Valuation Cap 
• If Note
  • Column G - Expiration Date
  • Column H - Interest Rate
  • Column I - Conversion Discount

Transaction Template

• Column A - Round Detail External Id (required) 
  • Must match the External Id from the Round Detail Template EXACTLY
• Column B - Fund Name (required) 
  • Must match Fund name EXACTLY (down to the periods and commas)
• Column C - Record Type (required)
  • Must match EXACTLY
    • Capital Call
    • Disposal
    • Distribution
    • Interest
    • Investment
    • Management Fee
    • Other Income / (Loss)
    • Proceeds
    • Realized Gain/(Loss)
    • Stock Split
• Column D - Date (required) 
• Column E - Amount Invested (required) 
• Column F - Shares Purchased (if Equity)

Valuation Template

Historical valuations can be input into FundPanel once the above steps have been completed.

Do NOT include base cost
Valuations MUST be in chronological order

• Column A - Round Detail External Id (required) 
  • Must match the External Id from the Round Detail Template EXACTLY
• Column B - Valuation Type (required) 
  • Must match EXACTLY
    • Price per share
    • Percent of cost
    • Pro rata
• Column C - Valuation Date (required)
• Column D - Price per share (required if type is price per share) 
• Column E - Percentage of cost (required if type is percent of cost) 
• Column F - Pro rata (required if type is pro rata)

FAQ

To ensure these templates are entered as effectively as possible, here is a quick Q&A provided by the FundPanel team:

Should I enter all convertible note details or is the preferred shares information sufficient? 

FundPanel can provide a complete history of your IRR, however it requires accurate historical data to entered into FundPanel. This is especially important when importing rounds and their related transactional data. 

Prior to conversion, convertible securities are logged initially as a separate round in FundPanel. When recording a note conversion, it is important to use the original convertible note's round date on the preferred shares round. In the next section following round details, we will capture the transaction within the preferred shares round, wherein the conversion date will be entered.

How do I enter accrued interest? 

If there is any accrued interest, this would be posted as a separate interest transaction, using the same conversion date. This interest transaction is posted within the same preferred shares round containing the conversion. 

Is there any benefit to entering nonactive investments such as write offs or exits?