This data dictionary provides clarity into each of the fields within the GP Portal Data Import template.
The most up-to-date version of the template can be found within GP Portal by going to Analytics > New Upload + > Download Template File.
| Field Name | Column | Description | Data Type | Example |
|---|---|---|---|---|
| Company Group Code | A | Group of investing entities. | Text | SC I COMB |
| Company Name | B | Investing entity name. | Text | Sample Capital, L.P. |
| Company Subcategory Type | C | Investing entity category type. | Text | SPV; Coinvest |
| Investor Type | D | Category of investor. | Text | LP |
| Investor Group Name | E | Name of the investor’s parent organization or group. | Text | Johnson Group |
| Investor No_ | F | Unique general ledger investor ID. | Text | INV12345 |
| Investor Short Code | G | Unique investor fund code. | Text | SCF10001 |
| Posting Date | H | Effective date of an entry. | Date (MM/DD/YYYY) | 02/15/2024 |
| Investor Total Commitments | I | Total capital the investor has committed to the fund. | Number | 10,000,000.00 |
| Contributions that affect remaining commitment | J | Capital calls counted against the investor’s remaining commitment. | Number | (2,000,000.00) |
| Recallable Distributions | K | Distributions that can later be recalled as capital. | Number | 500,000.00 |
| Waiver | L | Indicates whether the investor waived certain rights or fees. | Number | 0.00 |
| Unfunded Capital Adjustment | M | Adjustments applied to the investor’s unfunded balance. | Number | 100,000.00 |
| Investor Available Unfunded Commitments | N | Remaining callable capital available from the investor. | Number | 8,000,000.00 |
| Actual Contributions | O | Capital actually contributed by the investor to date. | Number | 2,000,000.00 |
| Actual Distributions | P | Cash or stock distributed back to the investor to date. | Number | 750,000.00 |
| Placement fee and syndication costs | Q | Up-front fundraising and syndication expenses allocated to the investor. | Number | 150,000.00 |
| Net Investment Income/(Loss) | R | Net profit or loss from interest, dividends, and fees. | Number | 200,000.00 |
| Realized Investment Gain/Loss | S | Gain or loss recognized on exited investments. | Number | 50,000.00 |
| Unrealized Investment Gain/Loss | T | Estimated gain or loss on investments still held. | Number | 1,200,000.00 |
| Transfer of Interest | U | Movement of fund interest from one party to another. | Number | – |
| Capital Account Balance | V | Ending balance of the investor’s capital account. | Number | 4,500,000.00 |
| Carry Balance | W | Accrued share of carried interest allocated to the investor. | Number | 300,000.00 |
| Carry Transfer | X | Portion of carry transferred to another party. | Number | 50,000.00 |
| Ending NAV – Gross Carry | Y | Ending net asset value before carried-interest allocations. | Number | (2,000,000.00) |
| Carry Realized | Z | Portion of carry that has been crystallized and paid. | Number | 20,000.00 |
| Carry Unrealized | AA | Portion of carried interest still unrealized. | Number | 300,000.00 |
| Carry Paid | AB | Cash carry actually paid out to the investor. | Number | 30,000.00 |
| ITD Contributions | AC | Contributions made since inception (“inception-to-date”). | Number | 3,000,000.00 |
| ITD Gross Contributions | AD | Gross contributions including fees and expenses ITD. | Number | 3,200,000.00 |
| Investments Value | AE | Current fair value of all investments held. | Number | 4,800,000.00 |
| CAPCALLDIST Code | AF | Code identifying a capital call, distribution, or both. | Text | CC #1 |
| Total Contributions | AG | Sum of all contributions over the life of the investment. | Number | (2,000,000.00) |
| Total Distributions | AH | Sum of all distributions over the life of the investment. | Number | 800,000.00 |
| Investment Strategy | AI | High-level approach the fund uses to invest. | Text | Venture Capital |
| Accounting Basis | AJ | Accounting method applied in financial reports. | Text | US GAAP |
| Fund Currency Code | AK | Three-letter ISO currency code of the fund. | Text | USD |
| Auditor | AL | Independent auditing firm engaged by the fund. | Text | Sample Audit LLP |
| Investor Mgt Fee Pct During IP | AM | Management-fee percentage during the investment period. | Decimal | 0.0175 |
| Investor Mgt Fee Pct Thereafter | AN | Management-fee percentage after the investment period. | Decimal | 0.0125 |
| Investor Mgt Fee % Thereafter Description | AO | Text explaining the post-period fee structure. | Decimal | None |
| Model Type | AP | Waterfall or other economic model assigned to the investor. | Text | Waterfall |
| Investor Carried Interest Pct | AQ | Percentage of profits allocated as carried interest. | Decimal | 0.02 |
| Investor Carried Interest % Description | AR | Narrative describing the carry arrangement. | Decimal | 0.00 |
| Investor Hurdle Rate or Preferred Return | AS | Minimum return due to investor before carry is taken. | Decimal | 0.00 |
| Investor Hurdle Rate/Preferred Return Description | AT | Explanation of how the hurdle or preferred return works. | Text | None |
| Investor Side Letter Date | AU | Date the investor’s side letter was executed. (MM/DD/YYYY) | Date (MM/DD/YYYY) | 01/01/2024 |
| Date of most recent partnership agreement | AV | Latest date the partnership agreement was updated. (MM/DD/YYYY) | Date (MM/DD/YYYY) | 02/15/2024 |
| Date operations commenced | AW | Date the fund began formal operations. (MM/DD/YYYY) | Date (MM/DD/YYYY) | 03/01/2024 |
| Investment Cost | AX | Aggregate cost basis of current investments. | Number | (1,950,000.00) |
| Investment Realized Distribution | AY | Cash received from realized investments. | Number | 1,200,000.00 |
| Special Profits | AZ | Profit allocations outside normal carry or fees. | Number | 100,000.00 |
| Partner Transfer | BA | Movement of ownership interest from one limited partner to another within a fund. | Number | 150,000.00 |
| Partner Transfer Investment Activity | BB | Investment positions and holdings transferred along with the partner’s ownership interest. | Number | 25,000.00 |
| Partner Transfer Contribution | BC | Capital contributions (funded and unfunded commitments) assumed by the new partner from transferor. | Number | 50,000.00 |