CyberNotes: Import QIF Files into Quicken 2008. Now go to File - Export - QIF File, and select the account that you want to deal with from the Quicken Account to Export from. This should be the account that you created/used in Step 1. It’s crucial that you check the Account List box.
We are building an application that reads files (.OFX/.QFX/.QIF/.QBO/.OFC) and place the data read in the file in a grid.
Does anyone know of a utility or 3rd party tool to convert the file types (.OFX/.QFX/.QIF/.QBO/.OFC) to something more conventional like XML or CSV. Any help will be greatly appreciated!
We are using c#/ASP.NET for developing out web application. The app is hosted on a Windows server if it makes any difference...
fixofx was open sourced from wesabe. It converts various types of financial files including ofx 1.0 and qif files to qfx 2.0, which is an xml-based format and so is easily parsed.
I wrote a Python script ofx2csv.py that converts OFX/QFX files to CSV, if anyone needs to do this programmatically.
I found a solution to this problem.
Bank2CSV Pro converts various bank, credit card and investment files (QIF, OFX, QFX, QBO, OFC) into CSV format (the file will become a table like a regular spreadsheet with rows as transactions. It supports command line mode:
bank2csv_pro.exe input.ofx output.csv
See http://www.propersoft.net/
Bank2CSV Pro works well but the free version converts only 10 transactions and the full version costs USD 50. I found a free online tool that converts CSV to OFX and QIF:
Just upload your csv, select the fields to map and boom - you get your QIF or OFX file. Worked really well for me when I tried to upload my bank files to QBO
Not sure if you are loking for code to accomplish this or for a utility that does it on the desktop. If it i the latter, then try iCreateOFX Basic which reads OFX and QIF files as well as CSV files into a grid.
The ofx2csv.py script almost works. For the citibank downloads where the csv does not include the 'memo' field and qfx does, I needed to add the memo field to output: