Captools/net Documentation

Transaction Codes

Transaction Codes

Previous topic Next topic  

Transaction Codes

Previous topic Next topic  

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:

 

 

Deposits / Withdrawals

 

DPF

Deposit Funds

WDF

Withdraw Funds

 

Receive / Deliver

 

RCV

Receive shares

DLV

Deliver shares

TDG

Tax-Deductible Gift

 

Buy / Sell

 

BUY

Buy (payment from cash)

BYD

Buy & Deposit

SLL

Sell (proceeds to cash)

SLW

Sell & Withdraw

 

Sell Short / Cover

 

SLS

Sell Short

BYC

Buy to Cover short position

 

Interest

 

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

 

Dividends

 

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

 

Capital Gains Distributions

 

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

 

Return of Capital

 

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

 

Bond Discounts & Premiums

 

ACR

Accretion on purchase discount

AMT

Amortization on purchase premium

 

Options/Futures/CFDs

 

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

 

Real Estate / Depreciation

 

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)

 

Management Fees

 

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)

 

Administrative and Other Fees

 

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)

 

Tax Related

 

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

 

Multi-currency

 

BFC

Buy Foreign Currency (foreign cash accounting)

SFC

Sell Foreign Currency (foreign cash accounting)

 

Fund (Portfolio as a fund)

 

FDW

Fund Distribution Withdrawal

FDR

Fund Distribution Reinvestment

XAE

Expense Accrual or Amortization

XPS

Expense Paid from Shares

 

Margin Accounting

 

CMX

Cash / Margin transfer

SAX

Sub-Account transfer

 

Other Transaction Codes

 

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