[GNC] Importing QIF results into duplicate entry

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Importing QIF results into duplicate entry

Chitresh Bhushan
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Importing QIF results into duplicate entry

GnuCash - User mailing list
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 <[hidden email]> 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Importing QIF results into duplicate entry

David Cousens
In reply to this post by Chitresh Bhushan
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
[hidden email]
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.
David Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Importing QIF results into duplicate entry

Chitresh Bhushan
In reply to this post by GnuCash - User mailing list
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. <[hidden email]> 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 <[hidden email]>
> 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
> > [hidden email]
> > 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
[hidden email]
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.