It is 2015, 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:
I tried some of the CSV to OFX converters out there, but nothing really worked for me, so I went back to AmericanExpress.com and played around some more there. Apparently, if you:
- Go to Statements & Activity
- Click the download transactions icon
- Instead of clicking "Select Transactions", pick "Card Activity"
- You will be brought the the same old export to Quicken option from last year
- Pick your statements- I just go ahead and select all of them from the past 12 months, then click the Download button at the bottom
- Save the QFX file (which interestingly is called ofx.qfx by default), then rename the extension to QFX, 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.