[GNC] Quicken import and duplicate records

[Priit Lilleleht]

Hi David!

Well, I just made a full export from Quicken and then fed the big file to
GnuCash. Everything was done automatically and I had no control of the
sequence of import. Maybe I'll try the import by smaller chunks.

Best Regards,
Priit

Kontakt D via gnucash-user (<gnucash-user at gnucash.org>) kirjutas kuupäeval
L, 27. aprill 2019 kell 19:59:

> Priit,
>
> I suspect you imported the transactions for Swedbank, and then imported
> ones from LHV, correct?
>
> When you do this, you must ensure that you take the time in the second
> import to ensure that the transaction from Swedbank to LHV is matched to
> the transaction from the first import. They are two sides of the same
> transaction, and Gnucash is not necessarily going to know that. So, you
> teach the matcher by demonstration.
>
> That will eliminate the duplicate entries. Of course, you can delete one
> of them after the fact, but it is better to get the matching right.
>
> (Note: if I have the sequence wrong, the concept nevertheless holds)
>
> David
>
> On April 27, 2019, at 7:43 PM, Greg Feneis <mfeneis at gmail.com> wrote:
>
> Hi,
>
> I get duplicate transactions sometimes too.  I tend to download data from
> financial institutions and import it to GnuCash on a quarterly basis and
> catch things up.  The matcher does a pretty good job of assigning accounts
> and so forth, but it's not perfect.  I find I still have to survey its work
> and make minor corrections.  Still amazing free software and the matcher
> does 90% of the work.
>
> Sometimes, I'll import a credit card's account data, which will include
> payments I make from my checking account to pay the credit card, so payment
> transactions also appear in my checking account as a result of importing my
> credit card data.  Then, if I import my checking account data, and if the
> matcher and I don't see that the credit card payment transaction is already
> in my checking account register, the matcher will import this payment
> transaction and assign it to the credit card account, essentially causing a
> duplicate transaction to appear.
>
>
>
>
> Kind regards,
>
> Greg Feneis
>
>
>
>
> On Sat, Apr 27, 2019 at 6:47 AM Priit Lilleleht <Priit.Lilleleht at eesti.ee>
> wrote:
>
> > Greetings, dear GnuCash gurus! :)
> >
> > I wonder if there is an answer to my problem with Quicken data import? I
> > have used Quicken 2000 Home & Business since year 2000 but recently I
> > discovered GnuCash as a cute and at the same time much more serious
> > alternative to this old Quicken ("serious" meaning more close to the
> > professional bookkeeping). So I tried to import all my Quicken history to
> > Gnucash and it was generally a success except for the duplicate entries
> > which are created when there is a transfer from one account to another in
> > Quicken. Instead on one transaction there are 2 created in GnuCash and
> they
> > both are changing the balance. Here is one example:
> >
> > https://drive.google.com/file/d/1ID-DxZTcPN8sy9QADt9sSG4PCRquBd5T/view
> >
> > I suspect that when Quicken recorded this transfer then one record has
> flag
> > (Num) TXFR and the other has not, and GnuCash import treats them as
> > different transactions and creates a matching record for both of them.
> Also
> > Quicken has a possibility that when a transfer record is created then
> > afterwards you can add memo to the record of one account and this is
> > probably also treated as 2 different transactions in GnuCash when the
> memo
> > fields do not match. I have also many of those kind of records and they
> all
> > are imported as duplicates.
> >
> > Maybe this is only the problem with old Quicken versions and the newer
> ones
> > do keep the transfer records matching. GnuCash is version 3.4.
> >
> > Has anyone seen this kind of trouble before and are there any solutions?
> >
> > Thank You in Advance,
> > Priit Lilleleht
> >
> >
> >
> >
> >
> >
> > Manuste ala
> > _______________________________________________
> > 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.
> >
> _______________________________________________
> 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.
> _______________________________________________
> 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.
>