Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

On this page, we'll explain and provide examples for each Transaction Type and corresponding Hash Tag. 

 

Table of Contents


 

Transaction Type

Type of Underlying

What's happening to the Underlying (Action)

Description

Additional Information to be included (appended)

Money In

Cash

Inflow

External Cash inflow into the account. This could be salary items or transfer of assets between accounts

-

Money Out

Cash

Outflow

External Cash outflow from the account. This could be discretionary spending or transfer of assets between accounts 

-

MiscIncome

Cash

Income

{Optional}

MiscExpense

Cash

Expense
Investment related income into the account. This could be current account interest or refund of expenses.

{Optional}

MiscExpense

Cash

Expense

Investment related expenses. This could be fees (adminstrative, custodial, management or other) or taxes.

{Optional}

Purchase

Any Asset except Cash, Loan/Deposit

Buy

Purchase of any type of security or investment

#ticker#quantity#price

Sale

Any Asset except Cash, Loan/Deposit

Sell

#ticker#quantity#price

Distribution
Sale of any type of security or investment

#ticker#quantity#price

Distribution

Any Asset except Cash, Loan/Deposit

Dividend / Coupon

Payments made as compensation from investments. This could be Dividends, Coupons or similar items.

#ticker

Contribution

Any Asset except Cash, Loan/Deposit

Reversal dividend/ Reversal coupon/ Capital Call

Payments made into the investment that are not purchases. This is usually used for capital contributions to funds

#ticker

Reinvestment

Any Asset except Cash

Dividend/Coupon Reinvestment

#ticker#quantity

TransferFOP Out

Any Asset (except Cash, Deposit/Loan)

Delivery Free of Payment

Security or asset transfers to another bank, account or custodian

#ticker#quantity#price/MKT

Deposit Create

Deposit

New deposit

#ticker

Deposit Repay

Deposit

Redemption of deposit

#ticker

Interest

Deposit, Cash

Interest

Practically this is a combination of Distribution + Purchase.

Often used for mutual funds which reinvest the distribution amount and increase unit holdings.

#ticker#quantity

TransferFOP In

Any Asset (except Cash, Deposit/Loan)

Delivery Free of Payment

Security or asset transfers from another bank, account or custodian

#ticker#quantity#price/MKT

Practically this is a combination of Money In + Purchase.

Since a standard purchase reduces cash in the current account, this function allows easy transfer of assetswithout impacting cash.

Used for a) new account setup, when the assets already exist and b) transfer of assets between banks.

Price can be provided (for profit calculations), if not provided the latest available market price is used as reference.

#ticker#quantity#price/MKT

TransferFOP Out

Any Asset (except Cash, Deposit/Loan)

Delivery Free of Payment

Security or asset transfers to another bank, account or custodian

Practically this is a combination of Money Out + Sale.

Since a standard Sale increases cash in the current account, this function allows easy transfer of assets (except cash, loan/deposit) without impacting cash.

Used for transfer of assets (except cash, loan/deposit)between banks.

Price can be provided (for profit calculations), if not provided the latest available market price is used as reference.

#ticker#quantity#price/MKT

Deposit Create

Deposit

New deposit

Deposits are special assets that always have a market value of 100%.

This is used when a deposit is placed and cash is taken out of the current account.

#ticker

Deposit Repay

Deposit

Redemption of deposit

This is used when a deposit is redeemed and cash returned to the current account. 

#ticker

Interest

Deposit, Cash

Interest

Interest on deposits accounts. Some banks may merge this together with the redemption.

We strive to split these items out for better analysis.

{Optional:#ticker}

Loan Create

Loan

Drawdown

New loan

Loans are special assets that always have a market value of 100%.  

This is used when a loan is taken out and cash is provided into the current account.

#ticker

Loan Repay

Loan

Repayment

This is used when a loan is repaid and cash is removed from current account.

#ticker

Loan Cost

Loan

Interest

Interest on loans. Some banks may merge this together with the redemption or rollover.

We strive to split these items out for better analysis.

{Optional:#ticker}

Loan

TransferFOP Deposit Create

Loan

Drawdown

New loan

#ticker

Loan Repay

Loan

Repayment

#ticker

Loan Cost

Loan

Interest

{Optional:#ticker}

TransferFOP Deposit Create

Deposit

Deposit transfer into account (without cash impact)

This is used when a deposit is transferred into account without impacting cash.

#ticker#quantity

TransferFOP Deposit Repay

Deposit

Deposit transfer

into

out of account (without cash impact)

This is used when a deposit is transferred out of account without impacting cash.

#ticker#quantity

TransferFOP

Deposit Repay

Loan Create

Deposit

Loan

Deposit

Loan transfer

out of

into account (without cash impact)

This is used when a loan is transferred into account without impacting cash.

#ticker#quantity

TransferFOP Loan

Create

Repay

Loan

Loan transfer

into

out of account (without cash impact)

This is used when a loan is transferred out of account without impacting cash.

#ticker#quantity

TransferFOP Loan Repay

Loan

Loan transfer out of account (without cash impact)

#ticker#quantity

SpotFX In

FX Spot

FX Buy

SpotFX In

FX Spot

FX Buy

Foreign currency transactions. Used when once currency account in the Account is debited and another currency account is credited.

Use this tag of the account that is being credited.

-

SpotFX Out

FX Spot

FX Sell

Foreign currency transactions. Used when once currency account in the Account is debited and another currency account is credited.

Use this tag of the account that is being credited.

-

 

Money In

This is meant for money flows that are not part of the portfolio returns. Funds coming in from external and will not be included in the profit calculation.

...