Moving data from Quicken on Windows to Moneydance on Mac.

Marcus Steel's Avatar

Marcus Steel

28 Jun, 2016 11:47 AM

I have used Quicken for many years, and my wife and I have quite a lot of investments. I am really struggling to transfer the data to Moneydance. Is there anyone who I can get to come and sit down with me to explain what I have to do. I have successfully moved data for individual accounts across (although the reconciliation cleared payments seem to have dropped out which is a nuisance with some accounts going back to 1997), but each time I move a new account across some figures in the existing accounts change. I'm obviously doing something wrong, but I have no idea what it is. I am on the verge of giving up. I am happy to pay someone who could come and show me where I am going wrong.

I am in Cheltenham in UK. Is there anywhere that I can get some face to face help?

  1. Support Staff 1 Posted by Jenny on 28 Jun, 2016 12:12 PM

    Jenny's Avatar

    Hi Marcus,

    I'm afraid that we don't offer phone support, but I'd be more than happy to provide assistance via this method on the support forum.

    When importing your data, if the QIF file format is available to you when exporting from Quicken, you should follow these steps. In particular make sure you specify to Import into a new account rather than an existing account. And you set the source to "From another program".
    It is highly recommended to export all Quicken data into a single QIF file, as doing so makes the import process much smoother. Please use the option in Quicken to export "all accounts" if available. The one exception to this is if you have accounts in more than one currency - if thats the case, then you can follow these steps to import multiple QIF files.

    Most customers are able to import their data without any issues. That being said, the QIF file format was never really intended for transferring all data between personal finance software and as such it may contain inherent ambiguities that will need to be manually corrected post import. How much manual correcting needs to be done is hard to predict. I'm afraid that typically investment accounts fair worse that regular accounts in this matter.

    If you can provide details of the specific issues you've encountered regarding your data (a few examples of how transactions are appearing, and how they should be appearing) then we can work to get this data imported correctly for you.

    Jenny
    Infinite Kind Support

  2. 2 Posted by Marcus Steel on 28 Jun, 2016 08:51 PM

    Marcus Steel's Avatar

    Dear Jenny,

    Thank you for that and I will see how it goes. As I mentioned, I am in UK and I’m sure you know that Quicken exited UK quite a few years ago and so the version I am using is from 2004, will this affect my ability to export data to Moneydance?

    Marcus.

  3. Support Staff 3 Posted by Jenny on 29 Jun, 2016 09:01 AM

    Jenny's Avatar

    Hi Marcus,

    You shouldn't have any issues exporting your data from older versions of Quicken, provided you're able to export in QIF format. I'd recommend following the steps in my last reply to import your data. You can let me know if you encounter any problems, and may also wish to refer to this article that details the most common issues after a QIF import and how to resolve.

    Jenny
    Infinite Kind Support

  4. 4 Posted by Marcus Steel on 01 Jul, 2016 12:27 PM

    Marcus Steel's Avatar

    Thanks very much for that, I think I have now sorted it - with your help. Two last detailed questions. I have three unwanted files, which are from past failed attempts to transfer data to Moneydance; how do I delete them as I can’t immediately see how to do that? Secondly is there a user manual that I can access, the help menu seems to take me to a general OSX help function rather than Moneydance help?

    Marcus.

  5. Support Staff 5 Posted by Jenny on 01 Jul, 2016 12:33 PM

    Jenny's Avatar

    Hi Marcus,

    Your data is stored separately from the Moneydance software so it can't be easily moved or deleted. The data set is a 'yourfilename'.moneydance file/folder. You can follow the steps in this article to delete any unwanted data sets. If you're having trouble locating the data, you can try searching your system for '.moneydance' which should locate the files.

    You can find the full Moneydance User Guide here - the first few chapters detail getting started and setting up your accounts, and the later chapters detail the full features and functions available. You may also wish to refer to the Knowledge Base articles, specifically the 'Getting Started' guides here.

    Jenny
    Infinite Kind Support

  6. 6 Posted by Marcus Steel on 05 Jul, 2016 05:22 PM

    Marcus Steel's Avatar

    Dear Jenny,

    Thank you for that useful info, and I have followed the instructions about deleting unwanted files.

    Sorry, but I have another small question. When I update share prices they come through in pence rather than pounds, whereas Moneydance is expecting pounds; is there a way round this?

    Marcus.

  7. Support Staff 7 Posted by Jenny on 06 Jul, 2016 02:56 PM

    Jenny's Avatar

    Hi Marcus,

    Are you using the Quotes and Exchange rate extension? If so, you can enter the extension window where you'll see a list of your securities. You should see a column titled 'Stock Exchange' which is likely set to default. Select this and choose either London Exchange (GBP) or London Exchange (Pence) from the list.

    If this doesn't help can you provide some more details of the issue you're encountering.

    Jenny
    Infinite Kind Support

  8. 8 Posted by Marcus Steel on 08 Jul, 2016 04:33 PM

    Marcus Steel's Avatar

    Hello, Jenny,

    I am using the Tools-Quotes & Exchange Rates command in Moneydance. I purchased Moneydance from the Mac App Store and the user instructions say that there is no need to install the Quotes and Exchange Rates extension; Have I got that wrong?

    My problem is that when I download stock prices the prices come through in pence rather than pounds; Monedance doesn’t know that and thins that the price is in pounds. I attach a screen shot which shows what I mean (although for some reason the download seems to have come up with the wrong price).

    As you can see the normal price for Associated British Foods is around £30 (currently £27.32, whereas the download shows 2095.1089, which is in pence but Moneydance thinks it is in pounds so it is valuing the stock at 100 times its true value. Is there a way that I can either download the prices in pounds rather than pence or tell Moneydande to divide the downloaded prices by 100?

    I hope you can follow all this,
    Marcus.
    PS I am very pleased with Moneydance, this is a relatively minor problem!

  9. System closed this discussion on 07 Oct, 2016 04:40 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