Re: [GNC] Importing QIF results into duplicate entry
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. 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 > 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@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@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.
Re: [GNC] Importing QIF results into duplicate entry
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 ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Importing QIF results into duplicate entry
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 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@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@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.
[GNC] Importing QIF results into duplicate entry
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@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.