Unconventional QIF formats for investment accounts in Moneydance?

Jeff Rice's Avatar

Jeff Rice

13 Aug, 2009 05:40 PM

It seems like the way Moneydance handles securities, etc in investment accounts is a bit unconventional. I exported my Moneydance data into a QIF file and imported it into another program, since a friend was a big fan and I don't think it's a bad thing to see what's available from time to time. When I imported the data, every holding I had in my investment accounts showed up as individual accounts themselves. Has anyone else seen this? It seems very strange... I like Moneydance and I felt secure with it, partly because I didn't think I was getting locked into a particular proprietary file format. But I'm wondering if the latter assumption was untrue, if the exported QIF files aren't actually well supported by other programs.

  1. 1 Posted by Jeff Rice on 13 Aug, 2009 07:20 PM

    Jeff Rice's Avatar

    As a side question, why doesn't Moneydance support export to OFX? For a cross-platform program, it seems odd not to support an open format.

  2. 2 Posted by msumick on 14 Aug, 2009 08:16 AM

    msumick's Avatar

    I have run into this issue as well. There is no easy fix that I have seen other than manually editing the QIF file. I have a lot of data, so this was not feasible. It owuld be nice if this were fiexed.

    I have also run into problems when expriting split transactions to QIF, this is alos not standard.

  3. 3 Posted by Ben Spencer on 16 Sep, 2009 03:26 PM

    Ben Spencer's Avatar

    Hi All

    Currently Moneydacne does not fully support exporting investment accounts to QIF files. You are correct in that investment accounts get exported as bank accounts. We are aware that this is a serious problem and we hope to get a fix written after MD2010 is released.

    With regard to exporting to OFX files. The OFX file format does not have categories/tags/etc and is really only intended for downloaded transactions. So I do not believe this would not be a useful replacement to QIF.However we do have a suggestion ticket in track for OFX export. Here is the link:

    http://moneydance.com/trac/ticket/1887

    If you register and log into trac you can vote on suggestions. We use the number of votes to help us determine what to wok on next.

    I am sorry for the trouble this investment qif export issue is causing you.

    Sincerely

    Ben Spencer

  4. 4 Posted by Jeff Rice on 16 Sep, 2009 06:27 PM

    Jeff Rice's Avatar

    Ben,
    Well thankfully, problems in Moneydance are much easier to solve than in
    other programs, if one has a little programming ability. Thanks to the
    plugin python console, I was able to get all my investment data into a
    standard QIF format that I could test out in Wesabe, etc.

    I can't think of another program that this sort of solution would have
    been possible in.

    Jeff

  5. 5 Posted by Ben Spencer on 16 Sep, 2009 06:42 PM

    Ben Spencer's Avatar

    Hey jeff

    If you would like to make your python script public I am sure other users would benefit from it.

    If you attach it to this discussion I will turn it into a knowledge base article for other users.

    Sincerely

    Ben Spencer

  6. 6 Posted by Jeff Rice on 16 Sep, 2009 06:57 PM

    Jeff Rice's Avatar

    Well, hmm. I'm sure it could be useful, but it is a little rough. It's
    nothing polished like a plugin, and the script itself has to be edited
    to export the correct account. And then the output has to be cut and
    pasted from the python console into a text file to save it.

    I don't mind offering it up, I just don't want to get hate mail if
    someone runs into a problem! I will work on cleaning it up and documenting it, and then put it up. Actually, with a few minor changes it could be used to export individual accounts from Moneydance as well.

  7. 7 Posted by Jeff Rice on 16 Sep, 2009 07:19 PM

    Jeff Rice's Avatar

    OK, here is the script I've cobbled together. You need the python interface plugin to use it, and you'll need to edit the first line to reflect the name of the account you are exporting. The output appears in the python interface window, and you'll need to copy it into a text document and save it with the extension 'qif'.

    I know this is ugly and not very elegant. But it works for my accounts, which was my goal. It might not work for yours, or for all the transaction types you have. I only tried to make it work for the transaction types that appear in my accounts. With a small amount of python, you can rewrite it to handle any type... or ask for help.

    Finally, there might be a few other small problems to work out once you import your data into a new program. For example, Schwab labeled a number of my tranactions as 'reinvestment of X', and it was interpreted as a new fund. SInce I only had two or three transactions like that, I edited them by hand later.

    Also, this same trick could be used fairly easily to export a single account from a Moneydance file. I haven't done that - since editing the QIF file itself is simple - but it is possible.

    Anyway, use at your own risk. It's ugly but, at least for my needs, functional.

  8. 8 Posted by Jessica Little on 16 Sep, 2009 09:20 PM

    Jessica Little's Avatar

    Thanks Jeff! I'm sure this will be helpful for others in the future.

    Jessica Little
    Moneydance Support

  9. Angie Rauscher closed this discussion on 13 May, 2010 05:46 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac