Transaction Codes
The Transaction Code ("TAC") used in a transaction indicates what kind of activity is represented by the transaction record. Proper specification of the transaction codes is essential to obtaining the correct balances, cost bases and reporting results from Captools/net.
For users who download or import their data into Captools/net from a third party source, the TAC codes will be assigned during the date import process based upon the specifications contained in the import template. These assignments are based upon a translation of custodian or clearing firm codes provided in the raw data. The translations are usually correct, there may be some cases where either the translation cannot be performed or it is incorrect, requiring user intervention. Also, there may be some cases where data is not available for import, necessitating your manual entry of the data, thus requiring your familiarity with the transaction codes.
This chapter describes the meaning of each of the available TAC codes. These codes are summarized below by category, with a brief description for each TAC code. Click on the category heading to view the detailed description of the TAC codes in the category, along with brief examples of their use:
DPF |
Deposit Funds |
WDF |
Withdraw Funds |
RCV |
Receive shares |
DLV |
Deliver shares |
TDG |
Tax-Deductible Gift |
BUY |
Buy (payment from cash) |
BYD |
Buy & Deposit |
SLL |
Sell (proceeds to cash) |
SLW |
Sell & Withdraw |
SLS |
Sell Short |
BYC |
Buy to Cover short position |
IN+ |
Interest income to cash |
IN- |
Interest payment from cash |
IRI |
Interest income reinvested |
IOB |
Interest income on cash balance |
INW |
Interest income withdrawn |
MIS |
Margin Interest Sale |
DV+ |
Dividend income to cash |
DV- |
Dividend payment from cash |
DRI |
Dividend reinvested |
DVW |
Dividend income withdrawn |
NQD |
Non Qualified Dividend to cash |
NQR |
Non Qualified dividend Reinvested |
NQW |
Non Qualified dividend Withdrawn |
NQA |
Non Qualified dividend Allocation |
OIP |
Other Income Paid from custodian |
ACL |
Accrual of Dividend or Interest |
CGD |
Long term Capital Gains Distribution to cash |
CGR |
Long term Capital Gains Distribution Reinvested |
CGW |
Long term Capital Gains Distribution Withdrawn |
SGD |
Short term Capital Gains Distribution to cash |
SGR |
Short term Capital Gains Distribution Reinvested |
SGW |
Short term Capital Gains Distribution Withdrawn |
CLD |
Capital Loss Distribution |
SLD |
Short term Capital Loss Distribution |
ROC |
Return of Capital (or "Principal") to cash |
RCR |
Return of Capital Reinvested |
RCW |
Return of Capital Withdrawn |
RCS |
Return of Capital with Shares reduced |
Splits and Share Distributions
SP+ |
Split shares received |
SP- |
Split shares delivered (on short position) |
CIL |
Cash in lieu of fractional shares |
ACR |
Accretion on purchase discount |
AMT |
Amortization on purchase premium |
BOP |
Buy Option |
SOP |
Sell Option |
ROP |
Receive Stock Option |
XOP |
Exercise Stock Option |
MTM |
Mark to Market |
Partnerships / Direct Investments
DST |
Partnership distribution to cash |
DSR |
Partnership distribution reinvested |
DSW |
Partnership distribution withdrawn |
NCI XPS CCT PIC CCC |
Non-Cash Income eXpenses Paid with Shares Capital CommiT Paid In Capital Close Capital Commitment |
BRW |
Borrow of funds (to cash) |
RPY |
Repay funds (from cash) |
RNT |
Rent received (to cash) |
EXP |
Expenses paid (from cash) |
DPR |
Depreciation (reduces cost basis) |
MFE |
Management fee (paid from cash) |
MFS |
Management fee (paid from shares sold) |
MFD |
Management fee (paid from deposit) |
MFA |
Management Fee Accrual (non-cash) |
AFE |
Advisory fee (paid from cash) |
AFS |
Advisory fee (paid from shares sold) |
AFD |
Advisory fee (paid from deposit) |
PCN |
Profit ConcessioN (incentive fee from cash) |
PCS |
Profit Concession (incent fee from shares sold) |
PCA |
Profit Concession Accrual (incent fee accrued) |
FEE |
Admin. fee charged (paid from cash) |
FES |
Admin. fee (paid from shares sold) |
FED |
Admin. fee (paid from deposited funds) |
OFE |
Other fee charged (paid from cash) |
OFS |
Other fee (paid from shares sold) |
OFD |
Other fee (paid from deposited funds) |
CBA |
Cost basis adjustment |
TXW |
Tax withheld (from cash) |
TXS |
Tax withheld (paid from shares sold) |
TXD |
Tax withheld (paid from deposited funds) |
ETX |
Tax adjustment |
SCO |
Short term loss carryover |
LCO |
Long term loss carryover |
TDG |
Tax Deductible Gift |
WCF |
Wash-loss cost Carry Forward |
BFC |
Buy Foreign Currency (foreign cash accounting) |
SFC |
Sell Foreign Currency (foreign cash accounting) |
DFC Deposit Foreign Currency (foreign cash accounting)
WFC Withdraw Foreign Currency (foreign cash accounting)
FDW |
Fund Distribution Withdrawal |
FDR |
Fund Distribution Reinvestment |
XAE |
Expense Accrual or Amortization |
XPS |
Expense Paid from Shares |
CMX |
Cash / Margin transfer |
SAX |
Sub-Account transfer |
MMO |
Memo transaction |
ERR |
Error transaction |
COI |
Cost of Insurance |
Minimum software level required for following codes:
Level-3/higher: PCN, PCS, PCA, MFA, DFC, WFC, XAE
Level-4 : FDW, FDR, MTM PIC, CCT, CCC