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. 

This video, here, also helps to explain transaction types


Table of Contents



Transaction Type

Amount Direction

Type of Underlying

What's happening to the Underlying (Action)

Description

Additional Information to be included (appended)

Money In

+

Cash

Inflow

Incoming cash transfers. This could be salary items or transfer of assets between accounts.

This is treated like an external inflow and is excluded for performance calculations.

-

Money Out

-

Cash

Outflow

Outgoing cash transfers. This could be discretionary spending or transfer of assets between accounts. 

This is treated like an external outflow and is excluded for performance calculations.

-

MiscIncome

+

Cash

Income

Funds received as a result of investment activity. For eg, Interest on Current Account or refund of expenses.

This is treated like an investment account related impact and is included for performance calculations.

{Optional}

MiscExpense

-

Cash

Expense

Expenses as a result of investment activity. For eg, Fees (administrative, custodial, management or other) or taxes.

This is treated like an investment account related impact and is included for performance calculations.

{Optional}

Interest

-

Deposit, Cash

Interest

Interest on Deposits or Current Accounts. Some banks may merge this together with the redemption.

We strive to split these items out for better analysis.

This is included for performance calculations.

{Optional:#ticker}

SpotFX In

+

FX Spot

FX Buy

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

Incoming Cash FX Spot. For eg, Buy 10,000 SGD vs USD (for the SGD account).

This is included for performance calculations.

-

SpotFX Out

-

FX Spot

FX Sell

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

Outgoing Cash FX Spot. For eg, Buy 10,000 SGD vs USD (for the USD account).

This is included for performance calculations.

-

Sale

+

Any Asset except Cash, Loan/Deposit

Sell

Sale of any type of security or investment. For eg, Equity, Derivatives or Bonds.

This is included for performance calculations.

#ticker#quantity#price

Purchase

-

Any Asset except Cash, Loan/Deposit

Buy

Purchase of any type of security or investment. For eg, Equity, Derivatives or Bonds.

This is included for performance calculations.

#ticker#quantity#price

Distribution

+

Any Asset except Cash, Loan/Deposit

Dividend/Coupon/Subscription

Payouts from existing investments, such as dividends or coupons or similar items.

This is included for performance calculations and will be mapped to the underlying security.

#ticker

Contribution

-

Any Asset except Cash, Loan/Deposit

Reversal dividend / Reversal coupon / Capital Call / Subscription

Payments made to the investment that are not Purchases. For eg, capital contributions to funds or capital calls for PE investments.

This is included for performance calculations and will be mapped to the underlying security.

#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. For eg, Open Loan, Rollover Loan

#ticker

Loan Repay

-

Loan

Repayment

This is used when a loan is repaid and cash is removed from current account (redemption of loans).

#ticker

Loan Cost

-

Loan

Interest

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

We strive to split these items out for better analysis.

{Optional:#ticker}

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. For eg, new deposits.

#ticker

Deposit Repay

+

Deposit

Redemption of deposit

This is used when a deposit is redeemed and cash returned to the current account (redemption of deposits).

#ticker

Reinvestment

0

Any Asset except Cash

Dividend/Coupon Reinvestment

Practically this is a combination of Distribution + Purchase.

Often used for mutual funds which reinvest the distribution amount and increase unit holdings. For eg, dividend/coupon reinvestment or dividends received in the form of shares.

#ticker#quantity

TransferFOP In

0

Any Asset (except Cash, Loan/Deposit)

Delivery Free of Payment

Security or asset transfers from another bank, account or custodian

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 assets without impacting cash.

Used for:

  • new account setup, when the assets already exist
  • transfer of assets (except cash, loan/deposit) between banks.

The original purchase price can be provided (for profit calculations). If not provided, the latest available market price is used as reference.

This is treated like an external inflow and is excluded for performance calculations.

#ticker#quantity#price/MKT

TransferFOP Out

0

Any Asset (except Cash, Loan/Deposit)

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.

This is treated like an external outflow and is excluded for performance calculations. We will close the position as of the market price of that day.

#ticker#quantity#price/MKT

TransferFOP Loan Create

0

Loan

Loan transfer into account (without cash impact)

Loan transfer into account without impacting cash.

This is treated like an external outflow and is excluded for performance calculations.

#ticker#quantity

TransferFOP Loan Repay

0

Loan

Loan transfer out of account (without cash impact)

Loan transfer out of account without impacting cash.

This is treated like an external inflow and is excluded for performance calculations.

#ticker#quantity

TransferFOP Deposit Create

0

Deposit

Deposit transfer into account (without cash impact)

Deposit transfer into account without impacting cash.

This is treated like an external inflow and is excluded for performance calculations.

#ticker#quantity

TransferFOP Deposit Repay

0

Deposit

Deposit transfer out of account (without cash impact)

Deposit transfer out of account without impacting cash.

This is treated like an external outflow and is excluded for performance calculations.

#ticker#quantity


...