[GNC] Quicken import and duplicate records

[Greg Feneis]

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.
>