[GNC] Importing QIF results into duplicate entry

[David Cousens]

Hi Chitresh,

Had a quick look at the QIF format in your attached file. It seems to be OK.
The QIF format is not all that well defined. Compare the w3c
definition(https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm) and that
in Wikipedia (https://en.wikipedia.org/wiki/Quicken_Interchange_Format) for
example. There are several difference which could cause problems with an
import parser. The QIF files I have imported (mainly from paypal) looked
more like the Wikipedia format description than the w3c.

Have you matched your account structure in GnuCash as closely as you can to
the Quicken categories? If accounts matching the categories don't exist, the
new account button in the account matching dialog will allow you to create
appropriate accounts on the fly. You can rearrange and rename accounts after
importing data but having a roughly matching heirarchy will make it easier.

Importing one account at a time (preferrably in small blocks until you have
the process working well) as David T suggested is a good process. 

Understanding the matcher operation and the meaning of the A, U and R flags
is also important. Sometimes the matcher will match to a transaction that is
not the same transaction and will reject import. This can happen with
frequent recurring transactions and you have to manually uncheck the R flag
in that case.

There are a number of threads in the archives like the following
https://lists.gnucash.org/pipermail/gnucash-user/2010-April/034615.html
where the operation of the matcher is discussed. Searching the archives with
Google for "site:lists.gnucash.org import match" will bring up appropriate
threads.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html