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

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.

-

Money Out

-

Cash

Outflow

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

-

MiscIncome

+

Cash

Income

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

{Optional}

MiscExpense

-

Cash

Expense

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

{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.

{Optional:#ticker}

SpotFX In

+

FX Spot

FX Buy

Foreign currency transactions. Used when

once

one currency account in the Account is debited and another currency account is credited.

'

Incoming Cash FX Spot.

Eg.

For eg, Buy 10,000 SGD vs USD (for the SGD account).

-

SpotFX Out

-

FX Spot

FX Sell

Foreign currency transactions. Used when

once

one currency account in the Account is debited and another currency account is credited.

'

Outgoing Cash FX Spot.

Eg.

For eg, Buy 10,000 SGD vs USD (for the USD account).

-

Sale

+

Any Asset except Cash, Loan/Deposit

Sell

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

#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.

#ticker#quantity#price

Distribution

+

Any Asset except Cash, Loan/Deposit

Dividend/Coupon

Payouts from existing investments, such as dividends or 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. For eg, capital contributions to funds or capital calls for PE investments.

#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

/Loan

)

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

assetswithout

assets without impacting cash.

Used for

a)

:

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

Price can be provided (for profit calculations)

, if

. If not provided, the latest available market price is used as reference.

#ticker#quantity#price/MKT

TransferFOP Out

0

Any Asset (except Cash, Loan/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

. If not provided, the latest available market price is used as reference.

#ticker#quantity#price/MKT

TransferFOP Loan Create

0

Loan

Loan transfer into account (without cash impact)

Loan transfer into account without impacting cash.

#ticker#quantity

TransferFOP Loan Repay

0

Loan

Loan transfer out of account (without cash impact)

Loan transfer out of account without impacting cash.

#ticker#quantity

TransferFOP Deposit Create

0

Deposit

Deposit transfer into account (without cash impact)

Deposit transfer into account without impacting cash.

#ticker#quantity

TransferFOP Deposit Repay

0

Deposit

Deposit transfer out of account (without cash impact)

Deposit transfer out of account without impacting cash.

#ticker#quantity

 

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.

...