Loading transactions from Quicken QIF files into Moneydance

Joss Kent's Avatar

Joss Kent

11 Jan, 2017 05:41 PM

i have followed all the online support guidelines to download transactions from my HSBC account into Moneydance. HSBC only allows you to download transactions in Quicken QFX or QIF format. i have therefore downloaded the transaction using the "From Another Program" option. The first download works fine. but with new transactions coming in, i then try to download again. instead of looking for similar transactions and either offering the Merge Option buttons or simply automatically cancelling out mathcing transactions it downloads entire matching set of transactions. so in effect i cannot use the system as entries and balances always wrong. have reverted back to Quicken until i sort this out. can anyone help?....please!!

  1. 1 Posted by -Kevin N. on 11 Jan, 2017 06:12 PM

    -Kevin N.'s Avatar

    Hi Joss,

    You should NOT be using 'From Another Program'. That option would be used for importing data from Quicken or Microsoft Money or some other PFM software program.

    Use the option 'From a Downloaded File.

    Make sure that the option 'Import Account Info Only' is NOT check-marked.

    Alternately, and actually preferably, if HSBC does offer the QFX file format then you should opt to use that format over the QIF file format. The QFX file format contains unique identifiers that help Moneydance to prevent duplicate transactions.

    HTH -Kevin N.

  2. 2 Posted by Joss Kent on 11 Jan, 2017 06:43 PM

    Joss Kent's Avatar
    Ok thanks Kevin. I will try the QFX file tomorrow. I had also tried the From A Download File (QIF) and that had same duplication issue. Had avoided QFX as online help said to stick to QIF! Thanks

    Joss


     

    Joss Kent | CEO | &BEYOND | [email blocked] | T UK +44 1730 815 176 | D SA +27 11 809 4300| F +27 11 809 4589 | South Africa | www.andBeyond.com

     

     

    &Beyond’s Benguerra Island, Phinda Private Game Reserve and Grumeti Serengeti Tented Camp have been listed in the Top 20 Africa Resorts of the US Condé Nast Traveler 2016 Readers Choice Awards.

  3. 3 Posted by Joss Kent on 12 Jan, 2017 04:29 PM

    Joss Kent's Avatar

    The QIF download is now working, except it continues to download the same transactions and asking me to manually merge them every time i do a new download. How do I set settings so that only new transactions are downloaded or transactions are auto merged?

  4. 4 Posted by -Kevin N. on 12 Jan, 2017 05:10 PM

    -Kevin N.'s Avatar

    Hi Joss,

    The QIF file format does NOT contain unique identifiers to help with preventing duplicate txns hence you will likely continue to experience duplicates.

    Have you tried the QFX file format?

    Keep in mind that even though the QFX file format uses unique identifiers, you may experience duplicates on the initial download using QFX. Going forward the unique identifiers should prevent duplicates.

    HTH -Kevin N.

  5. 5 Posted by -Kevin N. on 12 Jan, 2017 05:13 PM

    -Kevin N.'s Avatar

    Hi Joss,

    File > Preferences > Network tab.
    There is a setting there to 'Automatically Merge Downloaded Transactions'.

    HTH -Kevin N.

  6. 6 Posted by Joss Kent on 12 Jan, 2017 05:15 PM

    Joss Kent's Avatar

    I am using QFX file format. I downloaded once. Then downloaded again with new transactions and it did downloaded all duplicates and asked me to go through manual merge. I have seen there is a Preference tick box asking of you want to Automatically Merge Downloaded Transactions. Would that fix this?

    Joss Kent | CEO | &BEYOND | [email blocked] | T UK +44 1730 815 176 | D SA +27 11 809 4300 | F +27 11 809 4589 | South Africa | www.andBeyond.com<http://www.andBeyond.com>

    [cid:blog_d956edad-7067-406f-a5b2-872745e5051e.png]<http://blog.andbeyond.com/>[cid:Facebook_6638f43d-8c37-41cd-b865-9d8da3364a2f.png]<https://www.facebook.com/andBeyondTravel>[cid:Twitter_edaffd15-dacd-4160-b64c-b89baadc2c9c.png]<https://twitter.com/andBeyondTravel><https://www.facebook.com/andBeyondSafaris><http://www.youtube.com/andbeyondafrica><http://instagram.com/andbeyondsafari>[cid:instagram_logo_7eea4c79-589b-4b03-8d08-c724bace9209.png]<http://www.instagram.com/andbeyondtravel>[cid:Youtube_82bab38c-4b22-4a69-9405-43cf9d8ca2e6.png]<http://www.youtube.com/andbeyondafrica><http://instagram.com/andbeyondrangers>[cid:rhino_3f7b8825-4553-43f9-8fb5-52209a76495e.png]<http://www.rhinoswithoutborders.com>

    &Beyond’s Benguerra Island<http://www.andbeyond.com/benguerra-island>, Phinda Private Game Reserve<http://www.andbeyond.com/south-africa/places-to-go/phinda-private-game-reserve.htm> and Grumeti Serengeti Tented Camp<http://www.andbeyond.com/grumeti-serengeti-tented-camp> have been listed in the Top 20 Africa Resorts of the US Condé Nast Traveler 2016 Readers Choice Awards.<http://www.andbeyond.com/pressroom/latest-news-article/beyond-features-in-2016-conde-nast-traveler-readers-a-choice-awards.htm>

    Yes, paper does grow on trees! Please pause before you hit the print button.

    Read our disclaimer at &Beyond Terms and Conditions<http://www.andbeyond.com/legal-notices/user-terms>

  7. 7 Posted by -Kevin N. on 12 Jan, 2017 05:25 PM

    -Kevin N.'s Avatar

    HI Joss,

    Yes check-marking the setting should help make the match / merge process easier.

    If you continue to experience duplicate txns when using QFX files, then HSBC may not be properly following OFX protocols in which QFX files are modeled. I'm not a member of the MD support staff so I can not confirm or deny this but perhaps they [MD support] can do so.

    -Kevin N.

  8. 8 Posted by Joss Kent on 12 Jan, 2017 05:29 PM

    Joss Kent's Avatar

    Ok thanks Kevin

    Joss Kent | CEO | &BEYOND | [email blocked] | T UK +44 1730 815 176 | D SA +27 11 809 4300 | F +27 11 809 4589 | South Africa | www.andBeyond.com<http://www.andBeyond.com>

    [cid:blog_d956edad-7067-406f-a5b2-872745e5051e.png]<http://blog.andbeyond.com/>[cid:Facebook_6638f43d-8c37-41cd-b865-9d8da3364a2f.png]<https://www.facebook.com/andBeyondTravel>[cid:Twitter_edaffd15-dacd-4160-b64c-b89baadc2c9c.png]<https://twitter.com/andBeyondTravel><https://www.facebook.com/andBeyondSafaris><http://www.youtube.com/andbeyondafrica><http://instagram.com/andbeyondsafari>[cid:instagram_logo_7eea4c79-589b-4b03-8d08-c724bace9209.png]<http://www.instagram.com/andbeyondtravel>[cid:Youtube_82bab38c-4b22-4a69-9405-43cf9d8ca2e6.png]<http://www.youtube.com/andbeyondafrica><http://instagram.com/andbeyondrangers>[cid:rhino_3f7b8825-4553-43f9-8fb5-52209a76495e.png]<http://www.rhinoswithoutborders.com>

    &Beyond’s Benguerra Island<http://www.andbeyond.com/benguerra-island>, Phinda Private Game Reserve<http://www.andbeyond.com/south-africa/places-to-go/phinda-private-game-reserve.htm> and Grumeti Serengeti Tented Camp<http://www.andbeyond.com/grumeti-serengeti-tented-camp> have been listed in the Top 20 Africa Resorts of the US Condé Nast Traveler 2016 Readers Choice Awards.<http://www.andbeyond.com/pressroom/latest-news-article/beyond-features-in-2016-conde-nast-traveler-readers-a-choice-awards.htm>

    Yes, paper does grow on trees! Please pause before you hit the print button.

    Read our disclaimer at &Beyond Terms and Conditions<http://www.andbeyond.com/legal-notices/user-terms>

  9. 9 Posted by -Kevin N. on 12 Jan, 2017 09:01 PM

    -Kevin N.'s Avatar

    Hi Joss,

    Here is a link to another thread on the Moneydance forums that seems to affirm the suspicion that the issue of duplicates is due to HSBC's formatting of their OFX/QFX files.
    http://help.infinitekind.com/discussions/online-banking/4055-downlo...
    Post #13 is a reply from HSBC to a client's complaint:
    http://help.infinitekind.com/discussions/online-banking/4055-downlo...

    -Kevin N.

  10. 10 Posted by Joss Kent on 13 Jan, 2017 12:12 PM

    Joss Kent's Avatar

    Thanks..looks like I need to wait for HSBC to fix this there end! You have been very helpful.

    Joss Kent | CEO | &BEYOND | [email blocked] | T UK +44 1730 815 176 | D SA +27 11 809 4300 | F +27 11 809 4589 | South Africa | www.andBeyond.com<http://www.andBeyond.com>

    [cid:blog_d956edad-7067-406f-a5b2-872745e5051e.png]<http://blog.andbeyond.com/>[cid:Facebook_6638f43d-8c37-41cd-b865-9d8da3364a2f.png]<https://www.facebook.com/andBeyondTravel>[cid:Twitter_edaffd15-dacd-4160-b64c-b89baadc2c9c.png]<https://twitter.com/andBeyondTravel><https://www.facebook.com/andBeyondSafaris><http://www.youtube.com/andbeyondafrica><http://instagram.com/andbeyondsafari>[cid:instagram_logo_7eea4c79-589b-4b03-8d08-c724bace9209.png]<http://www.instagram.com/andbeyondtravel>[cid:Youtube_82bab38c-4b22-4a69-9405-43cf9d8ca2e6.png]<http://www.youtube.com/andbeyondafrica><http://instagram.com/andbeyondrangers>[cid:rhino_3f7b8825-4553-43f9-8fb5-52209a76495e.png]<http://www.rhinoswithoutborders.com>

    &Beyond’s Benguerra Island<http://www.andbeyond.com/benguerra-island>, Phinda Private Game Reserve<http://www.andbeyond.com/south-africa/places-to-go/phinda-private-game-reserve.htm> and Grumeti Serengeti Tented Camp<http://www.andbeyond.com/grumeti-serengeti-tented-camp> have been listed in the Top 20 Africa Resorts of the US Condé Nast Traveler 2016 Readers Choice Awards.<http://www.andbeyond.com/pressroom/latest-news-article/beyond-features-in-2016-conde-nast-traveler-readers-a-choice-awards.htm>

    Yes, paper does grow on trees! Please pause before you hit the print button.

    Read our disclaimer at &Beyond Terms and Conditions<http://www.andbeyond.com/legal-notices/user-terms>

  11. System closed this discussion on 14 Apr, 2017 12:20 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