Migration from UBS Quicken 2001 for Windows

[Roger Brooks]

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.





      
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GnuCashBrokerageAccount.jpg
Type: image/pjpeg
Size: 228099 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20090117/4c0c4ecd/attachment-0001.bin