Historical Data Upload Instructions: Part 1 - Data Templates

For step-by-step instructions using the data loader, see Part 2 - Data Upload. 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.

Template Usage

For each template, fill out each field. Fields with asterisks (*) are required. 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 - Shipping Country

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

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)