Migration from UBS Quicken 2001 for Windows

[Charles Day]

On Sat, Jan 17, 2009 at 12:52 PM, David T. <sunfish62 at yahoo.com> wrote:

> It's interesting. I have read others' difficulties in importing their data
> from Quicken, but my own experience was completely simple. I exported my
> entire Quicken 2002 file as a single QIF (accounts and all), and then
> imported that into Gnucash. All my accounts (and I had a boatload, including
> stocks, mutual funds, credit cards, and a full set of categories) and
> transactions turned up just fine. I did this about two years ago. I'm not
> sure why my experience was special that way, but I did want to share that it
> doesn't always have to be hand-coded.
>

When migrating from Quicken, definitely do it as one giant import (either
via one giant QIF or loading multiple smaller QIF files). You should be
going through the importer just once for all the data. That will allow the
importer to automatically match up all the transfers between accounts, and
make much less headache and potential duplication.


> David
>

-Charles


>
> --- On Sat, 1/17/09, Roger Brooks <rsbrux at yahoo.com> wrote:
>
> > From: Roger Brooks <rsbrux at yahoo.com>
> > Subject: Re: Migration from UBS Quicken 2001 for Windows
> > To: " Sr.John R. Carter" <john at jrcarter.com>
> > Cc: gnucash-user at gnucash.org
> > Date: Saturday, January 17, 2009, 12:00 PM
> > Dear John,
> > I did wind up having to create the accounts myself during
> > the OFX import, but importing accounts doesn't seem to
> > be the source of the problem.  The problem is with the
> > transactions imports using QIF.  All of the
> > stock transactions in Quicken (SharesIn, Dividend,
> > etc.) result in debits to the brokerage account for each
> > transaction.  This results in a huge negative balance.
> > (see attached JPG).
> > After looking at this more closely, I am thinking that I
> > just don't understand the concepts well enough yet, but
> > I find it counter-intuitive for the account to have a
> > negative balance.
> > The GnuCash documentation explains in detail how to create
> > the initial stock positions in GnuCash by hand, but for this
> > to work, it seems to me that I would have to weed out the
> > corresponding transactions from the QIF file.  I also
> > don't see how to correct this behaviour for dividend
> > credits, for example.  These are (logically enough) being
> > credited to the cash (actually money market) account linked
> > with the brokerage account, but is it logical for the
> > amounts to appear also as debits to the brokerage account?
> > I realize that under double-entry bookeeping rules they must
> > be debited somewhere.
> > Thanks for responding!
> > Best Regards,
> > Roger
> >
> >
> > --- On Sat, 1/17/09, John R. Carter, Sr.
> > <john at jrcarter.com> wrote:
> >
> >
> > From: John R. Carter, Sr. <john at jrcarter.com>
> > Subject: Re: Migration from UBS Quicken 2001 for Windows
> > To: "Roger Brooks" <rsbrux at yahoo.com>
> > Cc: gnucash-user at gnucash.org
> > Date: Saturday, January 17, 2009, 4:41 PM
> >
> >
> > My best experience was to create all the appropriate
> > GnuCash accounts manually and only import the transactions
> > from Quicken with QIF, matching the Quicken accounts with
> > the GnuCash accounts manually.
> >
> > See http://www.jrcarter.com/gnucash/Quicken2gnucash.pdf
> >
> >
> > On Jan 17, 2009, at 4:35 AM, Roger Brooks wrote:
> >
> > > Hi *,
> > > I have installed GnuCash under Windows 2000 and am
> > trying to migrate my accounting from Quicken.  My initial
> > results are not encouraging.  I can reproducibly crash
> > GnuCash with any OFX file from Quicken 2001 which contains
> > transactions (bug already reported).  As a workaround, I am
> > only migrating the accounts via OFX and am using QIF files
> > for the transactions.  My main problem at present is the
> > import of securities.  It doesn't seem to work at all
> > except that the initial securities deposits in the brokerage
> > account I transferred have caused a large negative balance
> > in what Quicken calls the "linked current
> > account".  Besides that, I had to set up all of the
> > securiteis manually in GnuCash.  I have made several
> > attempts to read through the voluminous GnuCash
> > documentation.  It is at least clear to me from that how to
> > set up securites manually.  However, I don't see any
> > way to accomplish what I want, which is to import the
> > available history from
> > > Quicken.  It looks as though I would have to set up
> > all of the initial securiries buy and sell transactions in
> > GnuCash by hand and then some how figure out a way to
> > exclude these from the migrated transactions.  Presumably
> > this would require manual editing of the QIF files, which I
> > would rather avoid.
> >
> >
> >
> >
> >
> >       _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>