How to Utilize Items / Entities Template

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

Examples:

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

Examples:

Example #1 = Accelerator_Tech_Fund

Example #2 = Company0111

You may replace the underscore ( _ ) with a dash (-) or period ( . )

Asset: House in Zurich

Examples:

Example #1 = House_in_Zurich

Example #2 = House_123

You may replace the underscore ( _ ) with a dash (-) or period ( . )

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 - 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 K - Compliance Notes (Optional)

Column L - Relationship Notes (Optional)