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

16 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]

    • Scott Burns said

      That was the fix. Thanks

  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!

  11. Thanks to Cal Learner for the registry fix – a big benefit
    I am using Windows 8.1 and for some reason I could not get the automatic registry update to work but was able to manually insert the right elements into the registry. For simplicity, here are the manual instruction equivalents of his edits (note that things that look like directories and sub-directories in the registry I am calling as such for ease of understanding though I recognize this is probably incorrect terminology):

    1. Run regedit

    1a. Backup your registry so you can revert if needed:
    File/Export and then set export range to ‘All’

    2. Ensure there is a directory hierarchy HKEY_CLASSES_ROOT\.qfx\ofx.document\ShellNew
    Subdirectories can be created using Edit/New/Key

    3. Under HKEY_CLASSES_ROOT\.qfx ensure there are two records:
    (Default) REG_SZ ofx.Document
    Content Type REG_SZ text/qfx
    Records like this can be created using Edit/New/String Value

    4. Under both HKEY_CLASSES_ROOT\.qfx\ofx.document and
    HKEY_CLASSES_ROOT\.qfx\ofx.document\ShellNew I have the record:
    (Default) REG_SZ (value not set)
    I imagine these do nothing but include them for completeness

    5. Ensure there is a directory hierarchy
    HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/x-qfx
    Note that \ indicates directory hierarchy whereas / is just part of the directory name.

    6. In this directory ensure there are two records:
    (Default) REG_SZ (value not set)
    Extension REG_SZ .qfx
    Records like this can be created using Edit/New/String Value

    Save your work and then reboot to apply
    Good luck!

  12. PHWhite said

    I am also running Windows 8.1 but am currently renaming .qfx files to use an .ofx suffix to get them to import into Microsoft Money. I looked at doing the manual registry edits shown by James Pelham Burn and am wondering if there is a simpler way to do this. I looked at my .ofx registry entry, and all it has is two records:

    HKEY_CLASSES_ROOT\.ofx
    (Default) REG_SZ ofx.Document
    Content Type REG_SZ text/ofx

    When I open an .ofx file it gets automatically imported into Microsoft Money, so that is working with this minimal registry information. There is currently no .qfx registry entry, probably because I have never directly opened a .qfx file.

    I don’t understand the registry entries for this but wonder why for .qfx files I need more than the minimal entries that I have for .ofx files. Can anyone explain how this works or point me at something that explains this?

  13. ameridan said

    There are other entries in the registry for ofx files that link them to Money’s Import Handler. All of the entries shown merely have your PC treat qfx files as ofx files rather than start from scratch.

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 112 other followers

%d bloggers like this: