Item and Entities guidelines:
- Each entity has an External ID (identifier).
- For each entity, you are required to assign an asset class.
- A country can be assigned to each entity.
- The maturity date and issue date is available for loans and mortgages.
- For each entity, you need to assign an asset class. The complete list of asset classes found by Clicking the Toggle ▶️
Items / Entities Template
Column A - Type (Required) - The type will always be “entity”
Column B - ID (Optional) - Although the inclusion of an ID is optional, we highly recommend creating a unique identifier for the External ID. This identifier will serve as the cornerstone for linking details from other imports. Ensuring a well-structured approach in Column B will significantly benefit your future import processes
- To note
- You can match the ID numbers that your Accounting software provides
- You can use Letters and Numbers
- Do not input any space in the External ID
- Example External IDs:
- Person: Richard Thomas Miller
- Example #1 = RTM
- Example #2 = 013
- Example #3 = Rich_Thom_Mill
- You may replace the underscore ( _ ) with a dash (-) or period ( . )
- Company Name: Accelerator Tech Fund
- Example #1 = Accelerator_Tech_Fund
- Example #2 = Company0111
- You may replace the underscore ( _ ) with a dash (-) or period ( . )
- Asset: House in Zurich
- Example #1 = House_in_Zurich
- Example #2 = House_123
- You may replace the underscore ( _ ) with a dash (-) or period ( . )
Examples:
Examples:
Examples:
Column C - Class (Required)
List of classes
person | company | anstalt | trust |
foundation | fund | hedge fund | private equity fund |
private debt fund | private label fund | venture capital fund | real estate fund |
non profit organization | house | condominium | hotel |
commercial | retail | industrial | land |
mineral interests | farm | ranch | art |
jewelry | watch | gemstone | antiquities |
livestock | non livestock | collection | other lifestyle |
automobile | motorcycle | boat | ship |
yacht | aircraft | other vehicle | gold |
silver | commodity | cash account | crypto account |
savings account | portfolio | certificate of deposit | money market |
advisory portfolio | discretionary portfolio | custody account | security |
physical cash | loan | mortgage | commitment |
payable-receivable | private safe | deposit box | insurance |
health insurance | property insurance | life insurance | pension fund |
retirement account | annuity | patent | membership |
other |
Column D - Name (Required) - Upon completion of the 'Name Field,' the entered content will serve as the visible display name for the Card of the entity.
Column E - Notes (Optional) - This appears in the Card details but remains hidden during blending in and out.
Column F - Email (Optional)
Column G - Phone # (Optional)
Column H - Website (Optional)
Column I - Account number (Optional)
Column J - Date of Issue (Optional) - This is related to the date of issue for a Loan
- Date format: YYYY-MM-DD e.g. 2023-12-31
Column K - Maturity Date (Optional) - This is related to the maturity date for a Loan
- Date format: YYYY-MM-DD e.g. 2023-12-31
Column L - Card Notes (Optional)
- Filling in this field will display in the Structured Notes of the entity and the details will appear when blending in and out
Column M - Compliance Notes (Optional)
Column N - Relationship Notes (Optional)