When managing corporate entities, family structures, or investment portfolios, ownership arrangements naturally evolve. This guide walks through the best practices for modeling equity changes, sales, transfers, and corporate reorganizations in ORCA so your structure charts and historical timelines remain completely accurate.
Core Principles of Ownership in ORCA
ORCA tracks ownership dynamically through time-stamped events rather than static tables. Understanding three core mechanics will help you structure every transaction:
- Time-stamped history: Every ownership row carries an effective date. ORCA uses these dates to render your structure at any given point in time using the Time Travel feature.
- Additive tracking: Positions are additive. A new ownership event does not overwrite or delete historical records; it establishes the owner's position from that date forward.
- Positive amounts only: ORCA requires all ownership amounts to be positive numbers. Importing an ownership row with 0% will result in a validation error.
Ending or Reducing an Ownership Position
Because 0% cannot be imported directly, closing out an outgoing owner requires a disposition event:
- Full divestment: To bring an owner's position to zero on a given date, record a transaction with the action
soldortransferredmatching their entire existing stake (e.g. 100% or 33.3333%).
- Partial divestment: To reduce a position (for example, from 50% down to 25%), record a
soldortransferredtransaction for the amount being divested (25%). ORCA automatically adjusts the remaining stake to 25% from the transaction date onward.
Handling Transfers and Counterparties
When ownership shifts from one party to another, you have two valid modeling strategies:
Strategy 1: Separate Closing and Opening Rows (Recommended)
This is the cleanest approach when restructuring complex entities involving multiple outgoing or incoming owners:
- Record a
transferredorsoldrow for each outgoing owner for their full current stake, leaving the Counterparty column blank.
- Record an
ownsrow for each incoming owner with their new percentage on the same effective date.
Strategy 2: Direct Bilateral Transfer via Counterparty
When transferring equity directly from one entity to another:
- Record a
transferredorsoldrow for the outgoing owner.
- Enter the incoming owner's unique ID in the Counterparty column.
- ORCA automatically debits the outgoing owner and credits the counterparty with that exact amount.
Caution - Avoid Double-Counting: If you name the incoming owner in the Counterparty column, do not add a separate owns row for that incoming owner on the same date. Doing both will credit them twice.
Worked Example: 2020 Multi-Owner LLC to 2024 Holding Structure
Consider an LLC originally formed on 2020-01-01 owned equally by three individuals (33.3333% each). On 2024-06-01, a holding company acquires 100% of the LLC.
To model this accurately in the Ownership Transactions template:
- 2020 Initial Load:
- Owner 1 |
owns| LLC | 33.3333 | % | Date: 2020-01-01 - Owner 2 |
owns| LLC | 33.3333 | % | Date: 2020-01-01 - Owner 3 |
owns| LLC | 33.3334 | % | Date: 2020-01-01
- 2024 Restructuring Load:
- Owner 1 |
transferred| LLC | 33.3333 | % | Date: 2024-06-01 | Counterparty: [blank] - Owner 2 |
transferred| LLC | 33.3333 | % | Date: 2024-06-01 | Counterparty: [blank] - Owner 3 |
transferred| LLC | 33.3334 | % | Date: 2024-06-01 | Counterparty: [blank] - Holding Company |
owns| LLC | 100 | % | Date: 2024-06-01 | Counterparty: [blank]
With these rows, Time Travel prior to June 2024 reflects the three individuals, while June 2024 forward shows 100% holding company ownership.
Special Cases: Blank Amounts and High Decimal Precision
- Blank Amounts: If you record an
ownsevent with the Amount column left blank, ORCA connects the entities with an ownership line in the structure chart without showing a percentage. This is ideal when an ownership connection is established but the specific capitalization or share count is not yet determined.
- High Decimal Precision: ORCA accommodates institutional precision up to 10 decimal places (e.g.
1.951525%). Always use a period (.) as the decimal separator.
