when importing QIF i can get double or triple of the same transaction.

jbergman's Avatar

jbergman

04 Sep, 2010 03:57 AM

I grab the qif from by bank but moneydance shows each transaction twice. When I upgraded to current each is now shown three times. What is the bug in the qif sort routine.

  1. 1 Posted by Tom Freeman on 07 Sep, 2010 09:19 PM

    Tom Freeman's Avatar

    Joe,

    can you please send me a screen shot showing some of the duplicate transactions please.

    Tom

  2. 2 Posted by jbergman on 08 Sep, 2010 01:07 AM

    jbergman's Avatar

    Ok, here is the multiples. I did not show the import page. This is my register
    page.

  3. 3 Posted by Tom Freeman on 10 Sep, 2010 06:56 PM

    Tom Freeman's Avatar

    Joe,

    I noticed these transactions were all unconfirmed (the blue dot). Have you tried merging the transactions?

    From the user's guide : Merge. Moneydance has identified a direct match to a transaction which already resides in your register. This usually means there was a match on the transaction date, description and/or amount. By accepting the Merge option you will, in effect, be deleting one of the transactions so that you have only
    one entry in the register for this transaction.

    You can read through the users guide for reviewing and accepting downloaded transactions.

    Here is a link to the user's guide if you don't already have it: http://help.infinitekind.com/faqs/frequently-asked-questions-2/down...

    Tom

  4. 4 Posted by Tom Freeman on 10 Sep, 2010 08:30 PM

    Tom Freeman's Avatar

    Joe,

    Does you financial institution support OFX downloads. This is a common format and each transaction is given an individual code which automatically deletes duplicates.

    Every time you import a QIF it will bring in the same transactions and you will have to merge out the duplicates.

    Tom

  5. 5 Posted by jbergman on 10 Sep, 2010 11:00 PM

    jbergman's Avatar

    No content.

  6. 6 Posted by jbergman on 10 Sep, 2010 11:21 PM

    jbergman's Avatar

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

          "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">







    No qfx option. The first import of the qif generated the duplicates in a fresh install of moneydance. Each transaction already has a transaction ID however. The screen I sent was after a second attempt and some were more than doubled. I am wondering why MD import does not have an abandon option. If I see a bad import why not just dump the unreconciled. I'll check the merge option and the links. Thank you.
    > // Add your reply above here > ==================================================
     From: Tom Freeman > Subject: when importing QIF i can get double or triple of the same > transaction. > > Joe, > > Does you financial institution support OFX downloads.  This is a common format and each transaction is given an individual code  which automatically deletes duplicates. > > Every time you import a QIF it will bring in the same transactions and you will have to merge out the duplicates. > > Tom > > View this Discussion online: http://help.infinitekind.com/discussions/problems/1544-when-importi... - i-can-get-double- or-triple-of-the-same-transaction > -- > Reply with #ignore to stop receiving notifications for this discussion. > 

     


  7. 7 Posted by Angie Rauscher on 11 Sep, 2010 01:09 AM

    Angie Rauscher's Avatar

    Jbergman,

    While Moneydance doesn't currently have the option to "dump" undesired imported transactions, you can confirm the correct transactions, change the register view to "Unconfirmed", select all transactions by going through the "Edit" menu or using Ctrl+A, and delete the transactions. Good luck with the next attempt, and please do let us know if we can be of further assistance,

    Angie Rauscher
    Moneydance Support

  8. 8 Posted by jbergman on 11 Sep, 2010 03:40 AM

    jbergman's Avatar

    No content.

  9. 9 Posted by Ben Spencer on 11 Sep, 2010 07:08 PM

    Ben Spencer's Avatar

    You last response simply says "No Content". If you are reply by email rather than in the forum you must put your response above the line at the top of the email. If not the support system will filter out the response.

    Ben Spencer
    Moneydance Support

  10. 10 Posted by jbergman on 11 Sep, 2010 07:20 PM

    jbergman's Avatar

    I'll resend sorry.

  11. 11 Posted by Tom Freeman on 13 Sep, 2010 01:39 PM

    Tom Freeman's Avatar

    Also you should go to preferences > network and click the auto merge downloaded transactions.

    Also you may want to contact your bank about the availability of OFX downloads. Banks that do not support direct OFX connections may provide web-based downloads of transactions/statements from their web site.

    Tom

  12. 12 Posted by jbergman on 13 Sep, 2010 02:46 PM

    jbergman's Avatar

    Actually my qif download is based on their web interface. Each transaction
    has a unique memo field but the import routine does not look at that field.
    When I look at the account the the transactions are roughly grouped into
    order. So at this point it is faster to just delete the entries manually so I can
    get started. I will try the merge selection and see what happens on the next
    import later this week.
     Thanks for all your help to all who have posted on this thread.

  13. 13 Posted by Angie Rauscher on 14 Sep, 2010 06:16 PM

    Angie Rauscher's Avatar

    Jbergman,

    Yes, do let us know how the next import goes. I agree with Tom that OFX file download format is superior to the QIF format (from both a support perspective and from my experiences as a Moneydance user). Do let us know how it goes with the merge, and good luck!

    Angie Rauscher
    Moneydance Support

  14. Angie Rauscher closed this discussion on 14 Sep, 2010 06:16 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