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...
On
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.
On
I wrote a Python script ofx2csv.py that converts OFX/QFX files to CSV, if anyone needs to do this programmatically.
On
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:
http://csvconverter.gginternational.net/
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
On
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:
line = {
'date': transaction.date.strftime(DATE_FORMAT),
'payee': transaction.payee,
'memo':transaction.memo,
'debit': debit,
'credit': credit,
'balance': balance
}
fixofx was open sourced from Wesabe. It converts various types of financial files including OFX 1.0 and QIF files to OFX 2.0, which is an XML-based format and so is easily parsed.
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/