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
ownsrow is always a snapshot of the resulting total position at that point in time, not an incremental acquired amount. A laterownsrow replaces earlier positions from that date on. To record an incremental acquisition, enter the resulting total on theownsrow (e.g. 100%), or record atransferred/boughtrow 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 parallellegalandeconomicrows, and never combinefullwithlegaloreconomicon the same holding, because ORCA adds power positions together. Onlyfullownership 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
