TransType Table

Overview

The TransType table documents the transaction types used by Portfolio Slicer.

This is internal table, that you should never edit.

TransType explanations

Although you will never need to edit this table, it is helpful to understand supported TransType values that are used in transactions table TransType column.

Here are supported TransType values and short explanation of each transaction type.

  • BankFee - Fee charged by Bank. Symbol should be * Cash, Qty should be 1. Price value is bank fee amount in the currency of the account.
  • Buy - Symbol “Buy” transaction. Qty should be number of shares bought. Price should be an amount you paid for each share. Fee should be amount the investment institution charges for this transaction.
  • BuyTA - Symbol “Buy Total Amount” transaction. Qty should be number of shares bought. Price should be total amount for all shares. Fee should be amount the investment institution charges for this transaction.
  • Deposit - Cash deposit into the account. Symbol should be * Cash, Qty should be 1. Price value is amount deposited in the currency of the account.
  • Div - Dividends received. Qty should be number of shares that paid dividends. Price should be amount of dividends received per share.
  • DivTA - Dividends Total Amount received. Qty should be number of shares that paid dividends. Price should be total dividends amount received in this account from this holding.
  • DRIP - Not implemented, do not use.
  • INT - Interest paid into the account. Symbol should be * Cash, Qty should be 1. Price value is bank fee amount in the currency of the account.
  • NotionalDistrib - special type of dividends that are reinvested. Qty should be number of shares, Price is the value of total dividends. This dividend does not change cash value in the account, but they increase holdings cost basis. This type of dividends is paid (rarely) by some ETFs or mutual funds.
  • ReturnOfCapital - special type of dividends that are “Return of Capital”. Qty should be number of shares, Price is the value of total dividends. This type of dividends reduce holding cost basis.
  • Sell - Symbol “Sell” transaction. Qty should be number of shares sold. Price should be an amount you received per each share sold. Fee should be amount the investment institution charges for this transaction.
  • SellTA - Symbol “Sell Total Amount” transaction. Qty should be number of shares sold. Price should be an amount you received for all shares sold. Fee should be amount the investment institution charges for this transaction.
  • Split - Symbol split transaction. Symbol should be an investment, that announced quantity split. Price, Fee should be empty. Qty should be +x or -x, where x represents number of shared received or lost during the split.
    For example, You hold 300 shares of symbol VOO. If the split rules are: “For each 3 shares you will receive 1 share”, the Qty value should be -200 (You had 300 shares and after split you will have just 100 shares).
    Another example, if for the same hold split rules are “For each Share you will receive 2 shares, then Qty values should be +300 (You had 300 shares and after split you will have 600 shares).
  • SymbolTransferIn - Symbol transfer into the account. Qty should be the number of shares transfered in. Price should be symbol quote at the day (or day before) of the transfer. The price should be equal of SymbolTransferOut transaction adjusted for currency coversion (if any).
    For this type of transaction it is important to specify value in CostBasisOverride column - what value Portfolio Slicer should assign to Cost Basis of this symbol.
  • SymbolTransferOut - Symbol transfer out of the account. Qty should be the number of shares transfered out. Price should be symbol quote at the day (or day before) of the transfer. This transaction type will not trigger “Sale” of the symbol.
  • SymbolTransferOutAsSale - Symbol transfer out of the account that triggers a sale. Qty should be number of shares transfered out. Price should be symbol quote at the day (or day before) of the transfer. This transaction type will trigger “Sale” of the symbol and this transfer will appear as “Sale” in the sales reports. You would use this type of transaction when the transfer out is considered a sale, for example when transfering out of “Cash” account into “RRSP” or “401K” account.
  • WHTX - Withholding tax on dividends received. Symbol should be investment that paid dividends. Qty value can be ignored. Price value is the amount that was withheld.
  • Withdraw - Cash withdrawn from the account. Symbol should be * Cash, Qty should be 1. Price value is amount withdrawn in the currency of the account.
  • DripTA - not implemented, do not use.