CoolComputing Logo
Coupons/Deals  ·  New Promo Codes/Coupons  · October 19, 2018

American Express & Bank of America Export to OFX for Microsoft Money/MS Office Accounting

Posted on Thursday, January 8, 2015 @ 08:24:27 PM CST by David Yee [] [read 11336 times]

Tips: Windows-world
It is the start of the year, and tax season is here, so I was wanting to download transactions from various financial institutions such as credit card companies into my accounting software. I still use the now-defunct Microsoft Office Accounting software, which requires import to be of in OFX format. That is the same format that Microsoft Money (which has also been axed by MS) uses. The card companies I use mostly still allow the export of transaction data into OFX, but when I logged into American Express today, I did not readily see such an option.

Last year I remember that I was able to import American Express transactions by downloading into Quicken/Quickbooks format of QFX, and then renaming the file extension to OFX. This time, however, I see that there is a new option called Sync with Quickbooks, and when I went to the Download Transactions option, it only showed 3 options:
  • Adobe PDF
  • MS Excel
  • CSV

I tried some of the CSV to OFX converters out there, but nothing really worked for me, so I went back to and played around some more there. Apparently, if you:

  1. Go to Statements & Activity

  2. Click the download transactions icon

  3. Instead of clicking "Select Transactions", pick "Card Activity"

  4. You will be brought the the same old export to Quicken option from last year

  5. Pick your statements- I just go ahead and select all of them from the past 12
  6. months, then click the Download button at the bottom
  7. Save the QFX file (which interestingly is called ofx.qfx by default), then rename the extension to QFX OFX (thanks to JB for pointing out the typo), so that it ends up named ofx.ofx and you are good to go again.

Hope this helps anyone still using MS Money or Office Accounting Professional and are upset at AMEX for removing the feature. The capability is still there, thankfully. You just have to pick the right options and then rename.

Addendum November 2017

I recently opened a business credit card account (Business Advantage Cash Rewards) with Bank of America, and encountered a similar issue. But thankfully the solution is very similar. You would:

  1. Go to to Activity tab
  2. Click the Download link (to the left of Print)
  3. Pick your Transaction period range. Nice thing here is that you can download a year's worth instead of just 3 month at a time like some other banks (cough cough American Express & Capital One)
  4. For File type, pick WEB Connect for Quicken 2015 and above, not Quickbooks
  5. Rename the extension of the stmt.qfx file to ofx (e.g. so that it ends up to be stmt.ofx). Import, and you're good to go!

See the screenshot below:

Right now there are 1 comments/reviews for American Express & Bank of America Export to OFX for Microsoft Money/MS Office Accounting.
Please rate this article or post a brief review of American Express & Bank of America Export to OFX for Microsoft Money/MS Office Accounting or comment on benchmark/performance, features, availability, price or anything else regarding American Express & Bank of America Export to OFX for Microsoft Money/MS Office Accounting. Thanks!

American Express & Bank Of America Export To OFX For Microsoft Money/MS Office Accounting Rating: 3.3/5 (46 votes cast) 1 comment(s) by users total.

Your Name:
I have read and agreed to the Review Posting Agreement.
Review Title:

Posted by JB (2 years ago)

Excellent (but small typo)

In step 6 you wrote "rename the extension to QFX", but you really mean to rename it to OFX. Otherwise this works like a charm, and keeps Money on hobbling along on life support for another little while. Thanks!

Was this review helpful for you?


Toggle Comment Form

1 person said 'YES'