...
Each transaction will be tagged directly to a Currency Account. The currency of the transaction is therefore included in the account for which it is transacted. For asset transactions, the currency of the underlying needs to match with the currency of the account used.
On this page, we'll cover explain and provide examples for each Hash Tag and explain when to use them.
| Table of Contents |
|---|
Hash Tag | Type of Underlying | What's happening to the Underlying | Additional Information to be included (appended) |
Money In | Cash | Inflow | - |
Money Out | Cash | Outflow | - |
MiscIncome | Cash | Income | {Optional} |
MiscExpense | Cash | Expense | {Optional} |
Purchase | Any Asset except Cash, Loan/Deposit | Buy | #ticker#quantity#price |
Sale | Any Asset except Cash, Loan/Deposit | Sell | #ticker#quantity#price |
Distribution | Any Asset except Cash, Loan/Deposit | Dividend / Coupon | #ticker |
Contribution | Any Asset except Cash, Loan/Deposit | Reversal dividend/ Reversal coupon/ Capital Call | #ticker |
Reinvestment | Any Asset except Cash | Dividend/Coupon Reinvestment | #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 |
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 | {Optional:#ticker} |
Loan 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) | #ticker#quantity |
HashTag | What type of Underlying is this | What is happening to the Underlying | Additional Information to be included (appended) |
TransferFOP Deposit Repay | Deposit | Deposit transfer out of account (without cash impact) | #ticker#quantity |
TransferFOP Loan Create | Loan | Loan transfer into account (without cash impact) | #ticker#quantity |
TransferFOP Loan Repay | Loan | Loan transfer out of account (without cash impact) | #ticker#quantity |
SpotFX In | FX Spot | FX Buy | - |
SpotFX Out | FX Spot | FX Sell | - |
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: Wire Transfer from other Bank#Money Bank#Money In
Money Out
This is meant for money flows that are not part of the portfolio returns. Funds are flowing out and not into investments or fees and will not be included in the loss calculation.
...
Example: Wire Transfer to other Bank#Money Bank#Money Out
MiscIncome
This is meant for money flows that are part of the portfolio returns. While the funds are a result of the investment activity they may not always be directly attributed to a specific investment. This will be included in the profit calculation. This category can also be used for revisions of expenses.
...
Effect: increases cash assets, impacts performance and NAV.
Example: Security lending#MiscIncomelending#MiscIncome; Refund of Custody Fee#MiscIncomeFee#MiscIncome
MiscExpense
This is meant for money flows that are part of the portfolio returns. While the funds are a result of the investment activity they may not always be directly attributed to a specific investment. This will be included in the profit calculation.
...
Effect: reduces cash assets, impacts performance and NAV.
Example: Management Fee#MiscExpenseFee#MiscExpense
Purchase
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.
...
Example: Purchase of 1000 Starhub Shares @ 3.5#Purchase#STH5#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.
...
Example: Sale of 1000 Starhub Shares @ 3.5#Sale#STH5#Sale#STH_SP#-1000#3.5
*note that the quantity here should be a negative number
...
Example: Coupon payment for Starhub 3.08 2022 bonds#Distribution#SG6W34985252bonds#Distribution#SG6W34985252
Contribution
This is meant for pay-outs to existing investments, like capital calls for private equity investments.
...
Example: Capital Call for Private Equity Fund#Contribution#PEFund#Contribution#PE_FUND_CAYMAN_CLASSA_2012
Reinvestment
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) Purchase.
...
Example: Dividend Reinvestment for Global Equity Cumulative Class#Reinvestment#GLClass#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.
...
Example: Custodial Transfer 500 Starhub Shares#TransferFOP Shares#TransferFOP In# STH_SP#500#MKT
TransferFOP Out
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 identical.
...
Example: Custodial Transfer 500 Starhub Shares#TransferFOP Shares#TransferFOP Out# STH_SP#-500#MKT
*note that the quantity here should be a negative number
...
Example: New Term Deposit USD Ref: 12345#Deposit 12345#Deposit Create#DepositRef_demoacct_usd01_12345
Deposit Repay
This is meant for redemption of deposits. Canopy is tracking outstanding deposit balances and interest payments.
...
Example: Redemption Deposit Ref: 12345#Deposit 12345#Deposit Repay#DepositRef_demoacct_usd01_12345
Interest
This is 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.
...
Example: Interest on Deposit Ref: 12345#Deposit Interest#DepositRef12345#Deposit Interest#DepositRef_demoacct_usd01_12345
Loan Create
This is meant for new loans. Canopy is tracking outstanding loan balances and interest payments.
...
Example: New Term Loan USD Ref: 6789#Loan 6789#Loan Create#LoanRef_demoacct_usd01_6789
Loan Repay
This is meant for redemption of loans. Canopy is tracking outstanding loan balances and interest payments.
...
Example: Redemption Term Loan USD Ref: 6789#Loan 6789#Loan Repay#LoanRef_demoacct_usd01_6789
Loan Cost
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.
...
Example: Interest on Loan Ref: 6789#Loan 6789#Loan Cost#LoanRef_demoacct_usd01_6789
TransferFOP Deposit Create
...
Example: Transfer of New Term Deposit USD Ref: 54321#TransferFOP 54321#TransferFOP Deposit Create#DepositRef_demoacct_usd01_54321
TransferFOP Deposit Repay
...
Example: Deposit Repayment Transfer USD Ref: 54321#TransferFOP 54321#TransferFOP Deposit Repay#DepositRef_demoacct_usd01_54321
TransferFOP Loan Create
This is used when a loan is transferred into account without impacting cash.
...
Example: Transfer of New Term Loan USD Ref: 9876#TransferFOP 9876#TransferFOP Loan Create#LoanRef_demoacct_usd01_9876
TransferFOP Loan Repay
This is used when a loan is transferred out of account without impacting cash.
...
Example: Term Loan Repayment Transfer USD Ref: 9876#Loan 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.
...
Example (for the SGD account): BUY 10’000 SGD vs USD#SpotFX 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.
...
Example (for the USD account): BUY 10’000 SGD vs USD#SpotFX USD#SpotFX Out