Quicken import issues

dschaller78's Avatar

dschaller78

20 Jan, 2020 01:21 AM

I have a number of investment accounts, and when I imported from Quicken 2016, I ended up with most of them having incorrect balances, and there are many "duplicate" accounts that have an "X" on the end of the same name that have balances in them. I do not see any easy way to fix this. I have attached images of one account (closed and money transferred to somewhere else) and the two accounts created in MoneyDance. I did this with the demo version, as I wanted to see how it worked before spending money. I intend to do so if this can be fixed. If I have to create every account by hand I don't know if MoneyDance is worth it.

  1. 1 Posted by dantdavis on 20 Jan, 2020 08:53 PM

    dantdavis's Avatar

    Just a user here who went through this process in the last couple of months.
    (It will be TMI, but you can read the very long "Vicissitudes of Moving..." in this forum, where I address your issues above plus many others, since I also encountered them)

    You appear to have two primary questions: cash balances are off, and "duplicate" ACCOUNTX accounts are created.

    The ACCOUNTX accounts tend to be created because Quicken allows you to create or destroy money (i.e. doesn't follow accounting methods). I mostly found these happening in accounts where I placed a transaction against its own account - i.e. basically destroying money - like depreciating a car. There are other ways you can create or destroy money in Quicken, but that should get you started. Moneydance won't let you create or destroy money - so it creates a "where does that money disappear to?" account.

    **How to fix? I think you can hide the account and also tell it not to impact your net worth. That seems to be moneydance's normal answer. [Basically instead of destroying money, Moneydance lets you hide the money.... :) ]**

    As for cash balances - that's more of a problem as there are many transactions especially for investment accounts, that don't move to Moneydance properly - though it's usually the inadequacies of the QIF file export/import process. The good news is that Moneydance does a great job imo of making sure the investment non-cash balances are correct.

    **How to fix? I think Moneydance would say "compare the cash balance in Quicken to the cash balance in Moneydance - go to the initial Moneydance balance and enter a 'corrective' entry that makes your current Moneydance balance match Quicken". (Caveat by me: your historical cash balances will forever be wonky, but going forward should work). This seems to be the standard fix.**

    I went further, by changing the Quicken issues in Quicken, then created a QIF file that Moneydance liked, but that took a bit of massaging. It all depends on how far you want to go with your historical data vs. wanting to move forward...

    Now that I'm done with my conversion, I think it was worth it, but your mileage may vary.

  2. 2 Posted by dwg on 20 Jan, 2020 09:18 PM

    dwg's Avatar

    I'm a fellow user.

    Ahh yes Quicken's amazing ability to create money out of thin air - wish I could do it.

    The most common occurrence for this is how Quicken allows you to do Opening balances in some versions, the money just appears. Moneydance is based on accounting rule however so money cannot just appear.

    It seems it got really confused in this case though and came up with a negative amount on import. The easiest solution for opening balances is to place the value in the Initial balance field. You do this by clicking on the account in question in the side bar to make its register have focus. Select menu item Account -->Edit Account and enter the opening balance in the Initial Balance field.

    Then delete the rubbish 12/12/14 transaction and finally delete the account with the X at the end of its name which should now have no transactions in it.

  3. 3 Posted by dantdavis on 20 Jan, 2020 09:27 PM

    dantdavis's Avatar

    I agree with dwg's response for your particular uploads, especially since this ACCOUNTX account appears to have only one entry. My response was more generic, covering things like the WITHDRAWX issue, which doesn't transfer properly, causing cash balance issues.

  4. 4 Posted by dschaller78 on 21 Jan, 2020 12:55 AM

    dschaller78's Avatar

    dantdavis and dwg,
    Thank you both for your assistance. The Edit Account step to access the opening balance was probably the most important piece, as I had looked around but did not see how to change the opening balance. I look forward to reading the Vicissitudes of Moving post to hopefully learn of other issues and fixes I have not encountered yet.

    Thanks again to both of you.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • MoneyDanceAllianz.PNG 31.5 KB
  • MoneyDanceAllianzX.PNG 10.8 KB
  • QuickenAllianz.PNG 25.8 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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