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.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2Faba5529a-e8ff-4d4c-b470-a458e68a7de3%2F6287c93c-07c6-4078-bf2e-716bedba349e%2FUntitled.png?table=block&id=830852cf-032c-4a4b-bfcf-530e7d888d75&cache=v2)
Column E - Notes (Optional) - This appears in the Card details but remains hidden during blending in and out.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2Faba5529a-e8ff-4d4c-b470-a458e68a7de3%2F2d476b61-ea3f-471b-973d-d6c6dfa5c6d1%2FUntitled.png?table=block&id=76f7ed99-a9c3-425b-bbb3-23878d04d6d5&cache=v2)
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
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2Faba5529a-e8ff-4d4c-b470-a458e68a7de3%2F6729b3ea-cc00-4c71-a477-bdff924ed7ad%2FUntitled.png?table=block&id=7662afff-2775-49e7-9ed4-75e1245ff74b&cache=v2)
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
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2Faba5529a-e8ff-4d4c-b470-a458e68a7de3%2F4393df88-5201-4b69-ac05-7007276b1b2a%2FUntitled.png?table=block&id=85c10458-234c-4979-82b7-1b08a4cbc35e&cache=v2)
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2Faba5529a-e8ff-4d4c-b470-a458e68a7de3%2Ff31a1da0-8631-4595-a87b-f6054feb4da0%2Fstructure_notes_2.gif?table=block&id=78c94d30-33a4-43d3-96b6-1deaff129b60&cache=v2)
Column M - Compliance Notes (Optional)
Column N - Relationship Notes (Optional)