Transaction Types are a way of classifying transactions in Canopy.
Hash Tags allows the system to recognize what to do with each line item. They are appended to the narration given in the bank statement. A ‘#’ will separate the narration from the classification as well as each additional item of information where required.
...
| 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 | External Cash inflow into the accountIncoming cash transfers. This could be salary items or transfer of assets between accounts. | - | ||||
Money Out | - | Cash | Outflow | External Cash outflow from the accountOutgoing cash transfers. This could be discretionary spending or transfer of assets between accounts accounts. | - | ||||
MiscIncome | + | Cash | Income | Investment related income into the account. This could be current account interest or refund of expenses. | Funds received as a result of investment activity. For eg, Interest on Current Account or refund of expenses. | {Optional} | |||
MiscExpense | - | Cash | Expense | Investment related expenses. This could be fees (adminstrativeExpenses as a result of investment activity. For eg, Fees (administrative, custodial, management or other) or taxes. | {Optional} | ||||
Interest | |||||||||
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 | Sale of any type of security or investment | #ticker#quantity#price | |||||
| - | 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} | |||||
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. | - | ||||
Sale | + | Any Asset except Cash, Loan/Deposit | Sell | Sale of any type of security or investment | #ticker#quantity#price | ||||
Purchase | - | Any Asset except Cash, Loan/Deposit | Buy | Purchase 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 | 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 | 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 | #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} | ||||
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 | ||||
Reinvestment | |||||||||
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} | |||||
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 out of account (without cash impact) | This is used when a deposit is transferred out of account without impacting cash. | #ticker#quantity | |||||
TransferFOP Loan Create | Loan | Loan 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. | #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 Create | 0 | Deposit | Deposit transfer into account (without cash impact) | This is used when a loan deposit is transferred 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 deposit is transferred out of account without impacting cash. | #ticker#quantity | ||||
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. | -TransferFOP Loan Create | 0 | Loan | Loan transfer into account (without cash impact) | This is used when a loan is transferred into account without impacting cash. | #ticker#quantity |
TransferFOP Loan Repay | 0 | Loan | Loan transfer out of account (without cash impact) | This is used when a loan is transferred 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.
...
Example: Management Fee#MiscExpense
...
Interest
This is meant for security or asset purchases. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identical.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used, before any fees or expenses; for Bonds, the clean price used.
Effect: reduces cash, increases unit holdings per security, sets the reference for performance or NAV for this security.
Example: Purchase of 1000 Starhub Shares @ 3.5#Purchase#STH_SP#1000#3.5
Sale
This is meant for security or asset sales. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identical.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used, before any fees or expenses; for Bonds, the clean price used.
Effect: increases cash, reduces unit holdings per security
Example: Sale of 1000 Starhub Shares @ 3.5#Sale#STH_SP#-1000#3.5
*note that the quantity here should be a negative number
Distribution
This is meant for pay-outs from existing investments, like coupons or dividends. Canopy allows distribution to be received in a different currency account from the security’s reference currency.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
Effect: increases cash, no change in unit holdings per security, impacts performance and NAV
Example: Coupon payment for Starhub 3.08 2022 bonds#Distribution#SG6W34985252
Contribution
This is meant for pay-outs to existing investments, like capital calls for private equity investmentsis meant for interest payments on deposits or current accounts. The contract reference itself is not required. The user is able to provide additional hash tag information with the ticker of the relevant deposit for the purpose of identifying the exact deposit for which the amount was relevant in case such tracking is desired.
Effect: increases cash, no impact on outstanding Deposit notional per deposit contract, impacts performance and NAV
Example: Interest on Deposit Ref: 12345#Deposit Interest#DepositRef_demoacct_usd01_12345
SpotFX In
This is meant for money flows that are attributable to FX transactions. Funds are coming in from another account which can be in the same banking relationship. This will actually be treated like a ‘Money In’ transaction, the tag provides more clarity in breaking down the transactions.
Effect: increases cash assets, does not impact performance and NAV.
Example (for the SGD account): BUY 10’000 SGD vs USD#SpotFX In
SpotFX Out
This is meant for money flows that are attributable to FX transactions. Funds are going out to another account which can be in the same banking relationship. This will actually be treated like a ‘Money Out’ transaction, the tag provides more clarity in breaking down the transactions.
Effect: reduces cash assets, does not impact performance and NAV.
Example (for the USD account): BUY 10’000 SGD vs USD#SpotFX Out
Sale
This is meant for security or asset sales. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identical.
This category requires additional information, specifically:
-
...
the ticker
...
as per Canopy which can be found with the search functionality on
...
the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used, before any fees or expenses; for Bonds, the clean price used.
Effect:
...
increases cash,
...
reduces unit holdings per security
...
Example:
...
...
Sale of 1000 Starhub Shares @ 3.5#Sale#STH_SP#-1000#3.5
*note that the quantity here should be a negative number
Purchase
This is meant for situations where the bank or the asset manager provides for automatic reinvestment of dividend or other pay-outs. This item is usually not found in the cash statement and actually a combination of a) Distribution and b) Purchasesecurity or asset purchases. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identical.
This category requires additional information, specifically:
...
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used, before any fees or expenses; for Bonds, the clean price used.
Effect: no impact on reduces cash, increases unit holdings per security, impacts performance and NAV
Example: Dividend Reinvestment for Global Equity Cumulative Class#Reinvestment#GL_EQ_CUM#50
TransferFOP In
This is meant for security or asset transfers from another bank, account or custodian where no cash payment is being made. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identicalsets the reference for performance or NAV for this security.
Example: Purchase of 1000 Starhub Shares @ 3.5#Purchase#STH_SP#1000#3.5
Distribution
This is meant for pay-outs from existing investments, like coupons or dividends. Canopy allows distribution to be received in a different currency account from the security’s reference currency.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds andspecifically:
- the purchase price used: can be MKT for current market price or the original purchase price if available; for Bonds the clean price used.Effect: no impact on cash, increases ticker as per Canopy which can be found with the search functionality on the site,
Effect: increases cash, no change in unit holdings per security, sets the reference for performance or NAV for this security.impacts performance and NAV
Example: Custodial Transfer 500 Starhub Shares#TransferFOP In# STH_SP#500#MKTCoupon payment for Starhub 3.08 2022 bonds#Distribution#SG6W34985252
...
Contribution
This is meant for security or asset transfers to another bank, account or custodian where no cash payment is being made. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identicalpay-outs to existing investments, like capital calls for private equity investments.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used: can be MKT for current market price or the original purchase price if available; for Bonds the clean price used.
Effect: no impact on cash, reduces unit holdings per security
Example: Custodial Transfer 500 Starhub Shares#TransferFOP Out# STH_SP#-500#MKT
*note that the quantity here should be a negative number
...
which can be found with the search functionality on the site,
Effect: reduces cash, no change in unit holdings per security, impacts performance and NAV
Example: Capital Call for Private Equity Fund#Contribution#PE_FUND_CAYMAN_CLASSA_2012
Loan Create
This is meant for new depositsloans. Canopy is tracking outstanding deposit loan balances and interest payments.
...
- the ticker as per Canopy which can be found with the search functionality on the site or newly provided.
Effect: reduces increases cash, increases outstanding notional per deposit loan contract
Example: New Term Deposit Loan USD Ref: 12345#Deposit Create#DepositRef6789#Loan Create#LoanRef_demoacct_usd01_123456789
...
Loan Repay
This is meant for redemption of depositsloans. Canopy is tracking outstanding deposit loan balances and interest payments.
...
- the ticker as per Canopy which can be found with the search functionality on the site or newly provided.
Effect: increases reduces cash, reduces outstanding notional per deposit loan contract
Example: Redemption Deposit Term Loan USD Ref: 12345#Deposit Repay#DepositRef6789#Loan Repay#LoanRef_demoacct_usd01_123456789
...
Loan Cost
This is meant for interest payments on deposits loans or current accountsaccount. The contract reference itself is not required. The user is able to provide additional hash tag information with the ticker of the relevant deposit loan for the purpose of identifying the exact deposit loan for which the amount was relevant in case such tracking is desired.
Effect: increases reduces cash, no impact on outstanding Deposit loan notional per deposit loan contract, impacts performance and NAV
Example: Interest on Deposit Ref: 12345#Deposit Interest#DepositRefLoan Ref: 6789#Loan Cost#LoanRef_demoacct_usd01_123456789
...
Deposit Create
This is meant for new loansdeposits. Canopy is tracking outstanding loan deposit balances and interest payments.
...
This category requires additional information, specifically:
- the the ticker as as per Canopy which can be found with the search functionality on the site or newly provided.
Effect: increases reduces cash, increases outstanding notional per loan deposit contract
Example: New Term Loan Deposit USD Ref: 6789#Loan Create#LoanRef12345#Deposit Create#DepositRef_demoacct_usd01_678912345
...
Deposit Repay
This is meant for redemption of loansdeposits. Canopy is tracking outstanding loan deposit balances and interest payments.
...
This category requires additional information, specifically:
- the the ticker as as per Canopy which can be found with the search functionality on the site or newly provided.
Effect: reduces increases cash, reduces outstanding notional per loan deposit contract
Example: Redemption Term Loan USD Deposit Ref: 6789#Loan Repay#LoanRef12345#Deposit Repay#DepositRef_demoacct_usd01_678912345
...
Reinvestment
This is meant for interest payments on loans or current account. The contract reference itself is not required. The user is able to provide additional hash tag information with the ticker of the relevant loan for the purpose of identifying the exact loan for which the amount was relevant in case such tracking is desired.Effect: reduces cash, no impact on outstanding loan notional per loan contractsituations where the bank or the asset manager provides for automatic reinvestment of dividend or other pay-outs. This item is usually not found in the cash statement and actually a combination of a) Distribution and b) Purchase.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
Effect: no impact on cash, increases unit holdings per security, impacts performance and NAV
Example: Interest on Loan Ref: 6789#Loan Cost#LoanRef_demoacct_usd01_6789
TransferFOP Deposit Create
This is used when a deposit is transferred into account without impacting cashDividend Reinvestment for Global Equity Cumulative Class#Reinvestment#GL_EQ_CUM#50
TransferFOP In
This is meant for security or asset transfers from another bank, account or custodian where no cash payment is being made. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identical.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site or newly providedthe ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used: can be MKT for current market price or the original purchase price if available; for Bonds the clean price used.
Effect: no impact on cash, but increases outstanding notional per deposit contractExample: Transfer of New Term Deposit USD Ref: 54321#TransferFOP Deposit Create#DepositRef_demoacct_usd01_54321unit holdings per security, sets the reference for performance or NAV for this security.
Example: Custodial Transfer 500 Starhub Shares#TransferFOP In# STH_SP#500#MKT
TransferFOP
...
Out
This is used when a deposit is transferred out of account without impacting cash.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the sitemeant for security or asset transfers to another bank, account or custodian where no cash payment is being made. The security will be identified by the Canopy ticker. There is no limitation on the type of assets here; listed or unlisted assets will be treated identical.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site,
- the quantity of purchase expressed in units or in nominal amount for bonds and
- the purchase price used: can be MKT for current market price or the original purchase price if available; for Bonds the clean price used.
Effect: no impact on cash, but reduces outstanding notional per deposit contractunit holdings per security
Example: Deposit Repayment Transfer USD Ref: 54321#TransferFOP Deposit Repay#DepositRef_demoacct_usd01_54321Custodial Transfer 500 Starhub Shares#TransferFOP Out# STH_SP#-500#MKT
*note that the quantity here should be a negative number
TransferFOP Loan Create
This is used when a loan is transferred into account without impacting cash.
...
Example: Term Loan Repayment Transfer USD Ref: 9876#Loan Repay#LoanRef_demoacct_usd01_9876
SpotFX In
This is meant for money flows that are attributable to FX transactions. Funds are coming in from another account which can be in the same banking relationship. This will actually be treated like a ‘Money In’ transaction, the tag provides more clarity in breaking down the transactions.
Effect: increases cash assets, does not impact performance and NAV.
Example (for the SGD account): BUY 10’000 SGD vs USD#SpotFX In
SpotFX Out
This is meant for money flows that are attributable to FX transactions. Funds are going out to another account which can be in the same banking relationship. This will actually be treated like a ‘Money Out’ transaction, the tag provides more clarity in breaking down the transactions.
Effect: reduces cash assets, does not impact performance and NAV.
Example (for the USD account): BUY 10’000 SGD vs USD#SpotFX Out
...
TransferFOP Deposit Create
This is used when a deposit is transferred into account without impacting cash.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site or newly provided.
Effect: no impact on cash, but increases outstanding notional per deposit contract
Example: Transfer of New Term Deposit USD Ref: 54321#TransferFOP Deposit Create#DepositRef_demoacct_usd01_54321
TransferFOP Deposit Repay
This is used when a deposit is transferred out of account without impacting cash.
This category requires additional information, specifically:
- the ticker as per Canopy which can be found with the search functionality on the site.
Effect: no impact on cash, but reduces outstanding notional per deposit contract
Example: Deposit Repayment Transfer USD Ref: 54321#TransferFOP Deposit Repay#DepositRef_demoacct_usd01_54321