switching from MS Money

Jon's Avatar

Jon

22 Jan, 2016 01:36 PM

Hi we have used MS Money for years and have lots of accoutns and investments . What is the best way to import data?

  1. 1 Posted by -Kevin N. on 22 Jan, 2016 03:38 PM

    -Kevin N.'s Avatar

    Hi Jon,

    First off, allow me to make a suggestion and download the free trial version of Moneydance to see if it will suit your needs. You can do so here:
    http://infinitekind.com/download-moneydance-personal-finance-software

    Unfortunately, Microsoft does not make it very easy to export your data from MS Money. There are detailed step-by-step instructions for doing so and for importing the data into Moneydance here:
    http://help.infinitekind.com/kb/importing-data-from-banks-and-other...

    I've done this process myself. It is doable but be prepared to spend some time restoring the correct balances to accounts and re-applying stock splits. Take your time and make sure to open any closed accounts in MS Money beforehand.

    I continue to use MS Money in parallel with Moneydance. There are some clever people who have provided a few free apps which allow MS Money users to download stock quotes as well as import data directly from participating financial institutions. (mainly applies to U.S. users)

    If you run into too much trouble with the export / import procedure, and you're interested in the free apps that I mentioned, let me know and I'll provide the links to them.

    HTH -Kevin N.

  2. 2 Posted by jon Tuppen on 22 Jan, 2016 06:02 PM

    jon Tuppen's Avatar

    Thanks Kevin

     

    I have started palying and it looks like this will suit just fine.

     

    May I ask why you run both in parallel – I am pretty keen to only use one.

     

    I see imports do not import categories which is a real nuisance. Is there any quick way of at least importing the category list?

     

    Jon

  3. 3 Posted by -Kevin N. on 22 Jan, 2016 07:06 PM

    -Kevin N.'s Avatar

    Hi Jon,

    I'm running MS Money due to some of the reports IMO are better than Moneydance's. Also it serves as something of a fail-safe in that if the two programs don't balance out at the end of the day, I know that something is amok.

    I imported my data from MS Money over 5 years ago, I have to confess that I'm not sure anymore if Categories were imported or not. If I remember correctly they were. You might want to try opening one of the QIF files that were exported from MS Money to see if indeed the Category information is included in the QIF.

    I believe that when I imported my MS Money data, I did it in two steps. First I imported only the account info so as to build the account structure in Moneydance. To do so import the QIF and checkmark 'Import Account Info Only' at the bottom of the Import QIF windows. This may or may not have also brought along the Categories but I'm not 100% sure. I then performed the whole process over again, this time with the 'Import Account Info Only' option un-checked.

    HTH -Kevin N.

  4. 4 Posted by Ben Spencer on 22 Jan, 2016 07:50 PM

    Ben Spencer's Avatar

    With respect to importing categories. It is necessary on the Moneydacnce QIF import window to set the "File Source" option to "From another program". If you do not set this option when importing the QIF file categories will not import.

    Ben Spencer
    Infinite Kind Support

  5. System closed this discussion on 22 Apr, 2016 08:00 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