Importing

David Sarvadi's Avatar

David Sarvadi

28 May, 2017 09:12 PM

I've discovered that when I try to import my Quicken file, a lot of the problems with getting the balances right are transfers that did not get assigned to the correct account. When I moved the ones from the checking account that were not marked reconciled or cleared, the checking account balance was corrected. I suspect it's because the accounts were not created at the time the import was finalized.

I realize the instructions are to do a two step process, but that has NOT worked for me in the past. I'll try again, but I think the Category listing should differentiate between transfers and categories of spending, visually. Right now, they look the same.

Thanks. Hopefully I can get moneydance working now!

  1. Support Staff 1 Posted by Ethan on 29 May, 2017 12:34 AM

    Ethan's Avatar

    Hello,

    Yes, what you describe is a likely result of not creating the accounts before importing the data itself. Importing the account information first, and then the data second, is important for successfully importing a QIF file from Quicken. Let us know if this process still doesn't work for you after trying again, and if there is any consistency in the transactions that don't seem to be coming through correctly.

    Ethan
    Moneydance Support

  2. 2 Posted by David Sarvadi on 29 May, 2017 12:53 PM

    David Sarvadi's Avatar

    So I tried what you suggested, and this is what showed up in the main
    checking account. None of these transactions should be there. In fact,
    my interpretation of the initial import is that no transactions should
    be imported. Below is the screen shot of what I set up for the import.
    I believe that is set up correctly. I'm trying now to just import the
    transactions after importing the accounts. Will let you know what happens.

    David Sarvadi
    5791 Coachview Court
    Haymarket, VA 20169
    703-753-9978
    703-906-1177 (C)
    [email blocked]

  3. 3 Posted by David Sarvadi on 29 May, 2017 01:04 PM

    David Sarvadi's Avatar

    And, exactly as I expected, the transactions created when the accounts
    were created distorted the balances. Here's that screen shot. All of
    the transactions shown are duplicates that should have been in the
    respective accounts. It looks like only transfers to/from investment,
    loan, and asset accounts where incorrectly imported.

    David Sarvadi
    5791 Coachview Court
    Haymarket, VA 20169
    703-753-9978
    703-906-1177 (C)
    [email blocked]

  4. 4 Posted by David Sarvadi on 30 May, 2017 02:25 AM

    David Sarvadi's Avatar

    I've tried the two alternatives, and the import is not handling the
    transfers between accounts correctly. Are the transfer transactions
    being posted in both accounts so that duplicate transactions are in each
    account? Such as, the record in a of a transfer a to b produces entries
    in a and b, and the record in b produces the same transaction in each
    account?

    David Sarvadi
    5791 Coachview Court
    Haymarket, VA 20169
    703-753-9978
    703-906-1177 (C)
    [email blocked]

  5. 5 Posted by David Sarvadi on 30 May, 2017 02:29 AM

    David Sarvadi's Avatar

    Here's a screen shot of one of the transfer files. Note there are two
    entries for many dates, with offsetting entries of increase and decrease.

    David Sarvadi
    5791 Coachview Court
    Haymarket, VA 20169
    703-753-9978
    703-906-1177 (C)
    [email blocked]

  6. System closed this discussion on 29 Aug, 2017 02:30 AM.

  7. David Sarvadi re-opened this discussion on 13 Aug, 2019 10:52 PM

  8. 6 Posted by David Sarvadi on 13 Aug, 2019 10:52 PM

    David Sarvadi's Avatar

    This comment was split into a new private discussion: Importing

    I bought Moneydance in 2015, and tried to use the code when I updated to
    2019.  It didn't work.  ?

    David Sarvadi
    5791 Coachview Court
    Haymarket, VA 20169
    703-753-9978
    703-906-1177 (C)
    [email blocked]

  9. 7 Posted by dwg on 13 Aug, 2019 11:31 PM

    dwg's Avatar

    I'm a fellow user.

    When you purchase Moneydance the license you receive is valid for that version and the next major release, so a license purchased for Moneydance 2015 will be valid for the 2015 and 2017 versions.

    To upgrade past this you can purchase an upgrade license at a 50% discount.

  10. Maddy closed this discussion on 14 Aug, 2019 11:37 AM.

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