Reg file to import Quicken QFX files automatically into Money

Since everything in a QFX file is OFX compliant, the unique “INTU.BID” tag’s value that Quicken uses to makes a connection back to Intuit (“call home”), and verify that the financial institution has licensed (PAID for annually) the right to import that file into Intuit’s software, isn’t of any consequence to Money and can be imported directly.

If you download QFX files from your financial institution’s website (that is the default choice on Bank of America’s Mastercard website now) , you can Save and then import them directly into Money [File->Import->Downloaded Statement...], but you may have to click on type: ALL FILES to see the file. You can skip the Save step and have the file import on it’s own by following the registry addition below.


Cal Learner has developed this registry fix that you could run, so that QFX files will behave just like OFX and will import into Money automatically:

Here is a 2-step way to create that registry file:

1. Open a new Notepad file, and paste the following lines between the ===delimiter lines=== below into the file.

==================begin QFX2OFX.reg========
[HKEY_CLASSES_ROOT\.qfx]
@=”ofx.document”
“Content Type”=”text/qfx”
“@”=”ofx.document”

[HKEY_CLASSES_ROOT\.qfx\ofx.document]

[HKEY_CLASSES_ROOT\.qfx\ofx.document\ShellNew]

[HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/x-qfx]
“Extension”=”.qfx”

[HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/x-qfx]
“Extension”=”.qfx”

================end QFX2OFX.reg==========

2. Save the file as “QFX2OFX.reg” and Run.

-ameridan

12 Comments »

  1. Tia Serena said

    Thank you so much for your blog. I don’t know if Money is superior to other softwares, but I have used it for 12 years, it took a long time to setup, it works for me and I am not willing to go through the whole learning curve again, and/or risk messing up my financial record.
    That said, I tried to use the first suggestion, just importing the qfx file and telling Money to import it. It replied that the file must be corrupted.
    I am VERY AFRAID of messing with the registry. Any other suggestion?

  2. ameridan said

    Right-click on the QFX file and select “Open with” > “Choose Program” > Select “Microsoft Money Import Handler” (you may have to click Browse and find it manually in the Program Files folder Money Plus\MnyCoreFiles (normally hidden) as mnyimprt.exe) > Click on “Always use this program to open this type of file” > Click “OK” and Windows will create the Registry entry for you after your next Reboot.

    The file corrupted message is unrelated however, and you may need to manually “scrub” the file to make it compatible. Some banks produce QFX files that are not compatible, although I’ve never had any problems. See http://www.accountantforums.com/importing-qfx-files-into-money-2003-downloaded-financial-statemen-t78407.html as an example.

    • Jim Morgan said

      I’m using Windows 8.1 and when I tried to “Choose Program”, “Microsoft Money Import Handler” did not show up in the list. Even when I tried to choose another program, nothing showed up. I also could not find the file that was supposed to be downloaded. That file was “Export.qfx”. I noticed that when I used the old bank format (soon to be discontinued) that the file name was “Download.ofx”.

  3. ameridan said

    I’m still using Windows XP, so I can’t be of much help regarding Windows 8 peculiarities. Looks like I’ll be buying a Windows 8.1 device sometime later this year though…

    PHWhite’s suggestion might be a good temporary move though until someone else replies with a solution. When prompted to Run or Save, select Save and change the extension to OFX rather than QFX.

  4. Jim Morgan said

    The registration change to allow Quicken.qfx does not seem to work. However, following the information from Microsoft – ” If your financial institution provides OFX or QIF statement downloads, the Sunset versions will allow you to import those statements into your Money file.” – saving my bank data as an older version of Quicken (QIF) works beautifully. You download the file. Decided where to save it on your computer. Select “Import” in Money. Select the saved QIF file. Select the appropriate account in Money and the data is there.

    • Jim Morgan said

      I’ve found that if you select the older version of Quicken (QIF), you DON’T have to save it first. Just download while Money is open and Money will ask you which account do you want to import the data into. Select the account and the import is done automatically.

  5. ameridan said

    Jim,
    You are correct. In fact, that is the only option for PayPal and many other financial houses with the only drawbacks: (1) being careful not to overlap the date range from previous downloads or you will import duplicates of your transactions and (2) not getting other statement data like account balances – just transactions.

    I prefer QFX whenever it is available. If your PC came with Quicken preinstalled, or you’ve tried Moneydance, etc., then QFX may be linked to one of those programs rather than Money and it really is just figuring out how to correct the registry to point to Money Import Handler instead.

    By the way Jim, I notice in your February 7th comment that you state that Money Import Handler doesn’t show up in the list of programs, so I just tried it myself and found that you may have to click on the Browse button and find it manually in your Program Files folder \Money Plus\MnyCoreFiles (normally hidden) as mnyimprt.exe. I just added this clarification in the original comment above that you were using as a reference ;-)

  6. Jim Morgan said

    I’m not really interested in account balances, I can see those and make a mental note of them, but I was going bananas not being able to download transactions directly into Money, so this is a saver for me. I tried once to save and then import – I got the date and amount but the descriptions were incorrect. So the direct downloads work for me.

  7. P said

    [edited by ameridan]

    You [may] need to add this to the first line of the file [depending on which OS you are running]:

    Windows Registry Editor Version 5.00

    [ P, this may explain why I had to edit my Windows 8.1 registry manually]

  8. James Pickett said

    I’m using an old, 2003, copy of Money on an XP – I’m resisting sending more money to MS for a change in formatting – and I, too, would like to be able to download statements.
    I tried creating the .reg file but I couldn’t get it to work.
    Then I looked at the contents and noticed that there was no ‘magical’ conversion.
    So, I thought, ‘why not just change the extension, .qfx to .ofx?’
    I gave it a try, copied statement.qfx to statement.ofx and it imported perfectly into Money 2003.
    Don’t know if it was a one-time fluke or if it will do anything nasty to MS Money but I plan on just changing the extension until it causes a problem.

  9. ameridan said

    Changing the extension is fine James. The reg fix simply makes Money process qfx files the same as ofx files, so you are manually doing the same thing. By the way, if you want to upgrade Money, you need not “send more money to MS” – you can download the Sunset Plus version for free – just follow the links at the top of my blog.

  10. D Sandgren said

    I am running MS Money 2002. I just was able to download .qfx file from my bank, then open Money and import – select all, and find the .qfx file. It imported perfectly. Will try again in a few days. YEA!

RSS feed for comments on this post · TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 107 other followers

%d bloggers like this: