With the recent decision by Captools® Investment Software to no longer support their programs for the individual investor, the developers of Investment Account Manager have included in IAM an import feature for Captools investment data. This import feature allows the conversion of the most common investment transactions from Captools Investment Software into Investment Account Manager.
Download a PDF of the Investment Account Manager / Captools import process.
Investment Account Manager will convert the following Captools transaction types:
DPF: Deposit Funds (to cash)
RCV: Receive Shares (non-cash transaction)
DLV: Deliver Shares (non-cash transaction). Use to indicate shares delivered out of the portfolio.
BUY: Buy (payment from cash)
BYD: Buy and Deposit (zero net cash change)
CBA: Cost Basis Adjustment (non-cash transaction). This code is used to adjust the cost basis of a security.
IN+: Interest Income (to cash)
IN-: Interest Payment (from cash)
IRI: Interest Income Reinvested (zero net cash change)
IOB: Interest Income on Cash Balance
DV+: Dividend Income (to cash)
DRI: Dividend Reinvested (zero net cash change)
DVW: Dividend Income Withdrawn (zero net cash change)
SGD: Short Term Gains Distribution (zero net cash change)
SGR: Short Term Gains Distribution Reinvested (zero net cash change)
SGW: Short Term Gains Distribution Withdrawn (zero net cash change)
CGD: Long Term Gains Distribution (zero net cash change)
CGR: Long Term Gains Distribution Reinvested (zero net cash change)
CGW: Long Term Gains Distribution Withdrawn (zero net cash change)
WDF: Withdraw Funds (from cash)
SLL: Sell (Proceeds to Cash)
SLW: Sell & Withdraw (zero net cash change)
CIL: Cash in Lieu (of fractional shares, proceeds to cash)
ROC: Return of Capital (to cash)
RCR: Return of Capital Reinvested (zero net cash change)
RCW: Return of Capital Withdrawn (zero net cash change)
EXP: Expenses (paid from cash)
MFE: Management Fee (paid from cash)
FEE: Administrative Fee (paid from cash)
OFE: Other Fee ((paid from cash)
MFS: Management Fee (paid from shares sold, zero net cash change)
FES: Administrative Fee (paid from shares sold, zero net cash change)
MFD: Management Fee (paid from deposited funds, zero net cash change)
FED: Administrative Fee (paid from deposited funds, zero net cash change)
OFS: Other Fee (paid from shares sold, zero net cash change)
OFD: Other Fee (paid from deposited funds, zero net cash change)
SLS: Sell Short (proceeds to cash).
BYC: Buy to Cover Short Position (payment from cash).
XOP: Exercised Option (non-cash transaction). If an XOP is for a Put exercised, it will be followed by a SLL transaction for underlying security
XOP: Exercised Option (non-cash transaction). If an XOP is for a Call exercised, it will be followed by a BUY transaction for the underlying security.
SP+: Split Shares Received (non-cash transaction). If negative number shares in SP+ transaction, represents a reverse split.
TXW: Tax Withheld (from cash).
TXD: Tax Withheld (zero net cash change).
The IAM / Captools import function does not currently handle the following transactions at this time. These types of transactions, if any, will be listed on the IAM / Captools Import Exceptions Report.
DV-: Dividend payment (on short position)
SP-: Split shares delivered (on short position)
Capital Gain Distributions: CLD (Capital Loss Distribution), SLD (Short Term Capital Loss Distribution), Undistributed Capital Gains
Bond Discounts / Premiums: ACR (Accretion on Purchase Discount), AMT (Amortization on Purchase Premium),
Partnerships / Direct Investments: DST (Partnership Distribution), DSR (Partnership Distribution Reinvested), DSW (Partnership Distribution Withdrawn).
Real Estate / Depreciation: BRW (Borrow of Funds), RPY (Repay Funds), RNT (Rent Received), DPR (Depreciation)
Tax Related: ETX (Estimated Tax Adjustment), SCO (Short Term Carryover), LCO (Long Term Carryover), TDG (Tax Deductible Gift).
