Ask AI
How can we help?

How to Utilize the Ownership Transactions Template

Learn how to import historical and current equity holdings, stakes, and acquisitions using CSV.

Transactions Template guidelines:

  • In ORCA, you have the capability to apply ownership multiple times to an object.
    • For instance, you can record several transactions involving the same relationship, such as Richard's purchase of a particular object (e.g., a car, a house, or a company) on more than one occasion.
    • This flexibility allows for accurate tracking of multiple instances or transactions associated with the same owner and object, as well as the capability for multiple owners associated with the same object.
  • There are validations in place e.g a person can NOT own another person
  • Depending on the traded item, the amount type differs e.g. 50%, 1 unit (1 car or 1 art), value in relation to currency 100,000 USD.
  • Decimal precision: ORCA supports up to 10 decimal places (e.g. 1.951525%). Always use a period (.) as the decimal separator.
  • Closing or ending positions: To bring an owner's position to zero on a specific date, use sold or transferred for their full stake. Do not enter an owns row with 0%, as import validation rejects zero or negative amounts.
  • Snapshot behavior of "owns" rows: An owns row is always a snapshot of the resulting total position at that point in time, not an incremental acquired amount. A later owns row replaces earlier positions from that date on. To record an incremental acquisition, enter the resulting total on the owns row (e.g. 100%), or record a transferred/bought row naming the counterparty.
  • Equal splits on lender-facing charts (shares vs. percentages): For three-way equal splits, entering 33.333% calculates an internal 100% total, but the chart displays 33.33% each (visually totaling 99.99%). To present charts to lenders that total cleanly, load ownership as shares (e.g. 100 of 300 shares). The Structure chart can then be toggled to share view, showing 100 of 300 for each owner.
  • The available actions for ownership transactions are found by Clicking the Toggle ▶️

Ownership Transactions Template

Column A - Type (Required)

  • The type will always be ‘event’

Column B - ID (Optional)

  • Can leave blank or you can provide the Unique External ID from the transaction of your accounting reporting tool

Column C - Event Type (Required)

  • The type will always be ‘ownership’

Column D - Date (Optional) - Date format = YYYY-MM-DD

  • While inputting the Date is initially optional, we recommend adding dates later to utilize the Time Travel feature. If you have the dates, please input them here. You also have the option to return to the transaction in ORCA and provide a date.

Column E - Subject (Required)

  • Use the Unique Identifier you have created from importing ‘Items / Entities’ to be the Point of Origination

Column F - Action (Required)

*NOTE* When connecting a natural Person with a Trust in ORCA, the term “owns” is translated to “is a beneficiary of.”

List of ownership actions
  • bought
  • sold
  • gifted
  • was gifted
  • transferred
  • was transferred
  • inherited
  • bequeathed
  • owns

Column G - Power (Optional)

  • List of Powers
    • full
    • economic
    • legal
  • Best Practice for Powers: When an owner holds both legal title and economic interest from the beginning, record a single row with power full. Avoid entering separate parallel legal and economic rows, and never combine full with legal or economic on the same holding, because ORCA adds power positions together. Only full ownership is factored into effective ownership calculations.

Column H - Object (Required)

  • The object would be the Legal entity or Asset. You will fill in the Unique Identifier here.

Column I - Amount (Optional)

  • The Amount (Column I) is directly related to the Amount Unit (Column J) described below.
  • ORCA supports up to 10 decimal places (e.g. 1.951525%).
  • Blank amounts: An "owns" row with a blank amount creates or records the ownership link without assigning a percentage or unit. This is useful when you know an entity is an owner but the exact stake is unconfirmed. Blank amounts do not overwrite existing percentage values.
  • Examples:
    • 100%
    • 1.951525%
    • 100,000 Shares
    • Absolute Value = $10,000,000 USD

Column J - Amount Unit (Optional)

  • List of Units
    • %
    • Shares
    • Value
    • New share Class

Column K - Share Class Name (Optional)

Column L - Total Cost (Optional)

  • The Amount (Column L) is directly related to the Price Currency (Column M) described below
  • Example: 10,000,000 USD

Column M - Price Currency (Optional)

List of Currencies:
AED
AFN
ALL
AMD
ANG
AOA
ARS
AUD
AWG
AZN
BAM
BBD
BDT
BGN
BHD
BIF
BMD
BND
BOB
BRL
BSD
BTC
BTN
BWP
BYN
BZD
CAD
CDF
CHF
CLP
CNY
COP
CRC
CUC
CUP
CVE
CZK
DJF
DKK
DOP
DZD
EGP
ERN
ETB
EUR
FJD
FKP
GBP
GEL
GHS
GIP
GMD
GNF
GTQ
GYD
HKD
HNL
HRK
HTG
HUF
IDR
ILS
INR
IQD
IRR
ISK
JMD
JOD
JPY
KES
KGS
KHR
KMF
KPW
KRW
KWD
KYD
KZT
LAK
LBP
LKR
LRD
LSL
LYD
MAD
MDL
MGA
MKD
MMK
MNT
MOP
MRU
MUR
MVR
MWK
MXN
MYR
MZN
NAD
NGN
NIO
NOK
NPR
NZD
OMR
PAB
PEN
PGK
PHP
PKR
PLN
PYG
QAR
RON
RSD
RUB
RWF
SAR
SBD
SCR
SDG
SEK
SGD
SHP
SLL
SOS
SRD
SSP
STN
SVC
SYP
SZL
THB
TJS
TMT
TND
TOP
TRY
TTD
TWD
TZS
UAH
UGX
USD
UYU
UZS
VES
VND
VUV
WST
XAF
XCD
XOF
XPF
YER
ZAR
ZMW
ZWL

Column N - Counterparty (Optional)

  • Use the Unique Identifier you have created from importing Items / Entities to be the other party or entity involved in a financial transaction or agreement.
  • Automatic crediting: When a counterparty is named on a "transferred" or "sold" row, ORCA credits that counterparty automatically with the traded amount.
  • Avoiding double-counting: You have two options when modeling transfers:
    • Option 1: Name the new owner in Column N (Counterparty) on the outgoing owner's transfer row. Do NOT add a separate "owns" row for the new owner.
    • Option 2: Leave Column N (Counterparty) blank on the outgoing owner's transfer row, and add a separate "owns" row for the incoming owner.
    • Caution: Never name the counterparty AND add a separate "owns" row, or the incoming owner's stake will be counted twice.

Column O - Notes (Optional)

  • Useful for explaining the details of this Ownership event
Did this answer your question?
😞
😐
🤩