Convert Investment / brokerage CSV & QIF files to OFX.
iCreateOFX Investment is an investment CSV to OFX converter for converting your brokerage CSV files to OFX. At launch, iCreateOFX Investment supports Ameritrade, Fidelity, Scottrade and Charles Schwab CSV
file conversion to OFX. In addition, the program ships with a Generic CSV script for converting CSV files with a
layout described in the user guide. Support for other brokerage houses is only subject to submitting the CSV file
header / layout.
Supported transactions types.
The program supports all investment / brokerage transactions that are supported by the OFX specification. Investment transaction actions are preceded by the investment type, e.g for a stock buy the action is
Stock - Buy and for a mutual fund buy Mutual Fund - Buy. QIF files do not have support for options transactions.
Currently supported Investment CSV files.
- Investment Buys - for Stocks, Debt(bonds), Mutual Funds and Options.
- Investment Sells - for Stocks, Debt(bonds), Mutual Funds and Options.
- Investment Positions - for Stocks, Debt(bonds), Mutual Funds and Options.
- Cash transactions - Deposits, Withdrawals, Journal Cash and Margin Interest.
- Journal Securities* - for Stocks, Debt(bonds), Mutual Funds and Options.
- Capital gains - for Stocks, Debt(bonds), Mutual Funds and Options.
- Return of Capital - for Stocks, Debt(bonds), Mutual Funds and Options.
- Re Investment - Dividend, Interest and Miscellaneous for Stocks, Debt and Mutual Funds.
- Investment Expense(s) and Income - for Stocks, Debt(bonds), Mutual Funds and, with the exception of income, Options.
- Investment Transfer(s) - for Stocks, Debt(bonds), Mutual Funds and Options.
- Investment Split(s) - for Stocks and Mutual Funds only.
The table below lists the currently supported files. Use the Generic script if your brokerage is not listed, and be sure to read the the layout expected by the script. To get a script written for your
brokerage, send a sample file inclusing as many transaction types as possible to: support[@]icreateofx[.]co[.]uk
Dodge And Cox
Foreign and Colonial
Hargreaves And Lansdown
Pension Plan Services
Stock Market Eye