Migration from UBS Quicken 2001 for Windows

[Charles Day]

On Sat, Jan 17, 2009 at 12:00 PM, Roger Brooks <rsbrux at yahoo.com> wrote:

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

In the attached image, are those dividend transactions? Could you show the
QIF lines for one of them? For a "Div" action, I believe the two accounts
involved should be a dividend income account and the brokerage account. On
the other hand, a "DivX" action should pair the dividend income account with
whatever account the cash was transferred to in Quicken (your money market
account, I presume.)

If you can provide the QIF lines, I can try it here and see whether it works
for me.

Cheers,
Charles


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