Hi David, Thanks for your suggestion! I exported each of my account into a separate QIF file and then started importing them one by one. That worked well, although bit tedious. I had to go through duplicate detection, but that was reasonably okay as gnucash had already made a very good guess.
Thanks On Sun, Jan 20, 2019 at 12:03 PM David T. <[email protected]> wrote: > Hi, > > Welcome to GnuCash. > > Getting your data into GnuCash always seems to be a challenge; many > threads on the lists over the years attest to it. > > Given your particular problem—that is, your exported data is producing > overlaps in the results—you might be advised to revisit the export piece > and separate the accounts into different QIF files. Beginning with the > account with the most transactions, perform an import into GnuCash. Then, > **in separate passes**, import the other files, and be sure to use the > assignment window to link your incoming transactions to those that already > exist in the file. In this way, you can tell GnuCash to connect the > transactions together in the final file. > > Cheers, > David T. > > > On Jan 20, 2019, at 10:16 PM, Chitresh Bhushan <[email protected]> > wrote: > > > > Hi all, > > > > I am trying to switch to gnucash. I have exported all my data in QIF > format > > from the old software I was using, moneyguru ( > > https://github.com/hsoft/moneyguru). However, when I import the exported > > QIF file in gnucash, I see a lot of duplicate entries in gnucash, > resulting > > to incorrect balances. Moneyguru also uses double-entry accounting, so I > > was hoping this transition would be easy. > > > > To reproduce the behavior, I have linked below a sample (tiny) QIF file > > exported from moneyguru. Can someone take a look and check if the file > > format is correct? Or am I doing something wrong during the import? I am > > new to gnucash and using gnucash 2.6.19 on Ubuntu. > > > > The sample file generates duplicates in checking and credit-card accounts > > (for $980 entry) on importing. My actual data has more than 8 yrs of > > entries.. so its quite big with a lot of duplicates. > > > > Sample QIF file exported from moneyguru: > > https://peep.updog.co/shared/tiny_export.qif (381 bytes) > > > > Any help is highly appreciated! > > > > Thanks, > > CB > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
