[GNC] Importing QIF results into duplicate entry

[Chitresh Bhushan]

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. <sunfish62 at yahoo.com> 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 <chitresh4u at gmail.com>
> 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
> > gnucash-user at gnucash.org
> > 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.
>
>