Migration from UBS Quicken 2001 for Windows

David T. sunfish62 at yahoo.com
Sat Jan 17 15:52:59 EST 2009


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.

David

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


      


More information about the gnucash-user mailing list