|
With the recent decision by Captools® Investment Software to no longer support their programs for the individual investor, Investment Account Manager v2.0 now includes 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 v2.0.
Detailed instructions for the Captools import feature is provided in the Investment Account Manager help topic system. You’ll find these instructions by selecting the Help Menu | Contents | IAM Online Manual | Chapter 9: Importing Captools Data.
Please contact Investment Account Manager support if you have specific questions or errors regarding the Captools import function.
Captools Transaction Import Codes and Limitations
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 Captools import function currently does not handle the following transactions at this time. These types of transactions, if any, will be listed on the 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).
- Other Transaction Codes: MMO (Memo Transaction), ERR (Error Transaction), SAX (Sub-account Transfer), CMX (Cash / Margin Transfer), ROP (Receive Options), NCI (Non-Cash Income).
|
