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.
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 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
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:
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.
发布评论
评论（6）
fixofx 是 Wesabe 开源的。它将各种类型的财务文件（包括 OFX 1.0 和 QIF 文件）转换为 OFX 2.0，OFX 2.0 是一种基于 XML 的格式，因此很容易解析。
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.
我编写了一个Python脚本ofx2csv.py，如果有人需要的话，它可以将OFX/QFX文件转换为CSV以编程方式执行此操作。
I wrote a Python script ofx2csv.py that converts OFX/QFX files to CSV, if anyone needs to do this programmatically.
我找到了解决这个问题的办法。
Bank2CSV Pro 将各种银行、信用卡和投资文件（QIF、OFX、QFX、QBO、OFC）转换为 CSV 格式（该文件将成为一个像常规电子表格一样的表格，其中行作为交易。它支持命令行模式：
bank2csv_pro.exe input.ofx output.csv
请参阅 http://www.propersoft.net/
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 运行良好，但免费版本只能转换 10 笔交易，完整版本售价 50 美元。我找到了一个免费的在线工具，可以将 CSV 转换为 OFX 和 QIF：
http://csvconverter.gginternational.net/
只需上传您的 csv，选择要映射的字段并繁荣 - 您就可以获得 QIF 或 OFX 文件。当我尝试将银行文件上传到 QBO 时，效果非常好
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
ofx2csv.py 脚本几乎可以工作。对于 csv 不包含“备注”字段而 qfx 包含的花旗银行下载，我需要将备注字段添加到输出：
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:
不确定您是否正在寻找实现此目的的代码或在桌面上执行此操作的实用程序。如果是后者，请尝试 iCreateOFX Basic，它可以读取 OFX 和 QIF 文件以及 CSV 文件成一个网格。
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.