[GNC] Importing QIF results into duplicate entry

[David T.]

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.