How to export a report with all investment information
The Carta All investment report shows you the detailed transaction history of each certificate, such as the investment date, value, preference multiple etc.
On the sidebar in your investment firm page, go to Reports and Documents > Reports.
On the All investment information row, enter the desired date of the report and click Export.
Select which columns to include on the report. To select all, check the Columns box.
Click Generate report.
.
Below are definitions for each of the column terms within the master spreadsheet:
Fund: the name of the holding entity.
Company: the name of the issuing entity.
Label: the security's unique ID.
Security Type: the name of the share class or note block.
Issue Date: the date of issuance.
Accepted Date: the date of acceptance into your fund or portfolio.
Custody: the custody status of your shares.
Issued by Carta = "Carta - Digital,"
Not held by Carta = "N/A,"
Physical stock certificates held by Carta = "Carta - Paper".
On Carta: denotes whether or not the issuing company is a Carta customer.
Initial or Follow-On: denotes whether the investment was an initial investment or a follow-on investment.
# Shares: the number of shares/units issued.
Cost/Share: the cost divided by the number of shares/units issued.
Cost: the total cost of the security.
Value/Share: the total value divided by the number of shares/units issued.
Value: total value of the security.
Gain (Loss): the value minus cost.
Multiple: the value divided by the cost.
Unrealized or Realized: denotes whether the security is still active or inactive.
Realized Date: the date the security became inactive.
Value Post-Money: value/share multiplied by fully diluted shares outstanding (as of the last round).
Initial FD Ownership %: denotes fully-diluted company ownership percentage at the time of issuance.
Current FD Ownership %: denotes your current fully-diluted company ownership percentage.
Note Investment Interest Rate: the interest rate of the convertible note.
Note Investment Discount %: the discount percentage of the security.
Note Investment Valuation Cap: the security valuation cap.
Note Investment Maturity Date: the date the security matures.
Board Membership: denotes whether anyone in the organization is a board member.
Board Member: denotes who in the organization is a board member.
Liquidation Preference Multiple: refers to the multiple on the initial investment a holder of a series of preferred stock will receive prior to holders of common stock in the event that the company is sold.
Participating Preferred: denotes if the security participates in preferred and common payouts.
Conversion Ratio: the ratio at which preferred shares convert into common shares.
Preference Cap: maximum multiple on the original investment through which preferred stockholders participate.
Current Status: the status of the investment, whether that is Active/Inactive or Archived/Unarchived.