...
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 accountsDeposits 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 currency account in the Account is debited and another currency account is credited.Use this tag of the account that is being credited. 'Incoming Cash FX Spot. Eg. Buy 10,000 SGD vs USD (for the SGD account) | - | |
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. 'Outgoing Cash FX Spot. 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 | Payments made as compensation Payouts from existing investments. This could be Dividends, Coupons , 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. This is usually used for 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, 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 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 | 0 | 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 | |
TransferFOP Deposit Loan Create | 0 | DepositLoan | Deposit Loan transfer into account (without cash impact) | This is used when a deposit is transferred Loan transfer into account without impacting cash. | #ticker#quantity | |
TransferFOP Deposit Loan Repay | 0 | DepositLoan | Deposit Loan transfer out of account (without cash impact) | This is used when a deposit is transferred Loan transfer out of account without impacting cash. | #ticker#quantity | |
TransferFOP | Loan Deposit Create | 0 | LoanDeposit | Loan Deposit transfer into account (without cash impact) | This is used when a loan is transferred Deposit transfer into account without impacting cash. | #ticker#quantity |
TransferFOP | Loan Deposit Repay | 0 | LoanDeposit | Loan Deposit transfer out of account (without cash impact) | This is used when a loan is transferred 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.
...