iCreateOFX Investment

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 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.

1. Investment Buys - for Stocks, Debt(bonds), Mutual Funds and Options.
2. Investment Sells - for Stocks, Debt(bonds), Mutual Funds and Options.
3. Investment Positions - for Stocks, Debt(bonds), Mutual Funds and Options.
4. Cash transactions - Deposits, Withdrawals, Journal Cash and Margin Interest.
5. Journal Securities* - for Stocks, Debt(bonds), Mutual Funds and Options.
6. Capital gains - for Stocks, Debt(bonds), Mutual Funds and Options.
7. Return of Capital - for Stocks, Debt(bonds), Mutual Funds and Options.
8. Re Investment - Dividend, Interest and Miscellaneous for Stocks, Debt and Mutual Funds.
9. Investment Expense(s) and Income - for Stocks, Debt(bonds), Mutual Funds and, with the exception of income, Options.
10. Investment Transfer(s) - for Stocks, Debt(bonds), Mutual Funds and Options.
11. Investment Split(s) - for Stocks and Mutual Funds only.

Currently supported Investment files.

Broker Name	File type(s) / description
BMO Investorline	CSV files
Charles Schwab	CSV files
Daily Access	CSV files
Dodge and Cox	CSV files
TD Ameritrade	CSV files
Fidelity International	CSV Files
PPS Inc	CSV Files
Hargreaves and Lansdown	Portfolio and transaction Summary CSV Files
Retirement Strategies Inc	CSV Files
Scottrade	CSV Files
Scottrade Advisors	CSV Files
Wells Fargo Advisor Services	CSV Files
Novia Financial	CSV Files
Vanguard	CSV Files
Generic QIF	Investment QIF Files
Generic CSV	Generic CSV Files