(.OFX / .QFX / .QIF / .QBO / .OFC) file converter

Question

We create an application that reads files (.OFX / .QFX / .QIF / .QBO / .OFC) and puts the data read into a file in the grid.

Does anyone know a utility or a third-party tool for converting file types (.OFX / .QFX / .QIF / .QBO / .OFC) to something more traditional, like XML or CSV. Any help would be greatly appreciated!

We use C # / ASP.NET to develop a web application. The application is hosted on a Windows server if it has any meaning ...

Answer 1

I found a solution to this problem.

Bank2CSV Pro converts various bank, credit cards and investment files (QIF, OFX, QFX, QBO, OFC) into CSV format (the file will become a table, like a regular spreadsheet with rows like transactions). It supports command line mode:

bank2csv_pro.exe input.ofx output.csv

See http://www.propersoft.net/

Answer 2

fixofx was open source 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 therefore easy to parse.

Answer 3

I wrote a Python script ofx2csv.py that will convert OFX / QFX files to CSV if someone needs to do this programmatically.

Answer 4

Bank2CSV Pro works well, but the free version only converts 10 transactions, and the full version costs $ 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 display and boom - you will get your QIF or OFX file. Worked very well for me when I tried to upload my bank files to QBO

Answer 5

Not sure if you are using code to execute this or for a utility that does this on the desktop. If this is the last one, try iCreateOFX Basic , which reads OFX and QIF files, as well as CSV files in the grid.

Answer 6

Works from x2csv.py script. To load citibank, where csv does not include the memo and qfx fields, I needed to add a memo field to output:

line = { 'date': transaction.date.strftime(DATE_FORMAT), 'payee': transaction.payee, 'memo':transaction.memo, 'debit': debit, 'credit': credit, 'balance': balance }