Format #1 - Rows of Regular Pro-Rata Events
Note the column headings in the sample Excel worksheet below. The upload routine needs these headings. They must match. If the columns are in different left-right order, they will be re-arranged automatically. Each row represents one Event. Events can have various Classes, Types, Dates, Descriptions, Amounts, etc.
Class is the symbol as it appears in Company Profile / Equity tab.
Type must be one of the following: Contribution, Distribution, Gain (Loss) Accrual, Redemption, Return of Capital, Cash Dividend (for corporations), Principal Funded, Principal Repayment, Interest Payment, Interest Accrual, Withholding (for debt instruments).
Date and Description are fields associated with the Event. Descriptions provide detail.
Gross Amount is the total dollar amount for the Event, presumably to be allocated among participants.
Rounded To drives the automatic rounding algorithm, which may "tweak" the largest allocation. Rounded To default is $0.01, although $1 and $10 are common.
Allocate? set to Yes or True instructs the Gross Amount to be divided pro rata among participants. Otherwise allocations will not occur. Allocated amounts can be adjusted easily after the Event is created.
Adjust? set to Yes or True means that cap table (or capital account) balances will be adjusted according to the allocations. Otherwise the cap table will remain unchanged. (Events that almost always should trigger cap table adjustments include: Redemption, Return of Capital, and Principal Repayment. Events that almost never should trigger cap table adjustments include: Distribution, Cash Dividend, Interest Payment, or Withholding. For Contribution and Principal Funded, it really depends on whether or not the cap table already incorporates these dollars, usually as part of initial set up and configuration.
Format #2 - Columns of Irregular Non-Pro-Rata Events
Note Column A in the sample Excel worksheet below. The upload routine needs this column, with email addresses starting in cell A6. Columns to the right of Column A represents Events. Each Event needs a Class, Type, Date, Description, Adjust? (required), and then the individual Allocation amounts assocated with each email address for each Event.
Class is the symbol as it appears in Company Profile / Equity tab.
Type must be one of the following: Contribution, Distribution, Gain (Loss) Accrual, Redemption, Return of Capital, Cash Dividend (for corporations), Principal Funded, Principal Repayment, Interest Payment, Interest Accrual, Withholding (for debt instruments).
Date and Description are fields associated with the Event. Descriptions provide detail.
Adjust? set to Yes or True means that cap table (or capital account) balances will be adjusted according to the allocations. Otherwise the cap table will remain unchanged. (Events that almost always should trigger cap table adjustments include: Redemption, Return of Capital, and Principal Repayment. Events that almost never should trigger cap table adjustments include: Distribution, Cash Dividend, Interest Payment, or Withholding. For Contribution and Principal Funded, it really depends on whether or not the cap table already incorporates these dollars, usually as part of initial set up and configuration.
Email Addresses must be on your cap table already. The numbers to the right of each email are the individually allocated dollar amounts, associated with that email address, for each Event. Blanks will be ignored and skipped.