I wish you folks would re-consider allowing csv imports to investment registers

markandclare's Avatar


15 Jul, 2017 08:17 PM

My companies 401k administrator only allows "screen scraping" from an html table then copy/paste into Excel. That's the only way I can "download" data. I'm perfectly capable of formatting and moving columns around to however you design the import. The investment transaction register is not unlike any other checking, savings or credit card register why not let us import to it?

BTW, yes, for the 6 years I have worked for this company I have complained about it. :)

  1. 1 Posted by dwg on 15 Jul, 2017 10:29 PM

    dwg's Avatar

    Hi Clare,

    The registers look similar but they work quite differently, The Bank and Credit card registers are strictly column based.

    The Investment register on the other hand is based on a few variable factors. firstly the Action type, this to start with determines what fields are active for the following transaction, the action types must be one of the pre-defined types, so your download would have to have a field like this that also meets the rules, the types were defined by Intuit many years ago. Depending on action type some fields become mandatory others optional, Transactions like Transfers need to have a sign to indicate which direction the transfer it in.

    I have a Managed fund that only provides CSV data and while the data is all there I would have to write a program that does some heavy duty data parsing to structure it into something that could be imported.

    If you data really does meet the rules there is an add on for excel that will create a QIF file that Moneydance can import

    FWIW this tool can be found at:


  2. System closed this discussion on 14 Oct, 2017 10:30 PM.

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

Keyboard shortcuts


? 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