(.OFX/.QFX/.QIF/.QBO/.OFC) file converter [closed]

C

6

9

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

Cordwain answered 22/7, 2011 at 13:55 Comment(2)

IS this any help? #6790555 Simon – Fraenum 22/7, 2011 at 15:47

Hi Simon. Not really mate. Saw that earlier. Thank you anyway – Cordwain 22/7, 2011 at 15:49

C

1

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/

Cordwain answered 23/7, 2011 at 7:28 Comment(0)

P

5

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.

Prat answered 29/9, 2011 at 22:11 Comment(0)

S

4

I wrote a Python script ofx2csv.py that converts OFX/QFX files to CSV, if anyone needs to do this programmatically.

Stanwinn answered 19/4, 2015 at 23:36 Comment(0)

C

1

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/

Cordwain answered 23/7, 2011 at 7:28 Comment(0)

M

1

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

Minny answered 12/3, 2015 at 11:25 Comment(2)

CSV2QIF at propersoft.net/csv2qif and CSV2OFX at propersoft.net/csv2ofx are converters covering CSV to QIF and CSV to OFX conversion. – Eugenaeugene 16/10, 2016 at 16:14

Don't know anything about that site in particular, but I'd think carefully before uploading your bank transactions ANYWHERE! – Viticulture 18/10, 2016 at 12:2

C

1

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
    }

Chinoiserie answered 27/9, 2015 at 20:20 Comment(0)

C

0

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.

Cutpurse answered 22/7, 2011 at 17:57 Comment(2)

It does not really cover the entire spectrum of files I need to convert. But thank you for taking the time to post an answer – Cordwain 22/7, 2011 at 18:14

Actually reads OFX variants including QFX files using the OFX file script, plus CSV and QIF files. It will also write to QIF, OFX and CSV files. – Fifine 31/3, 2015 at 22:1

Recommended topics

Hot tags