Migration from UBS Quicken 2001 for Windows

Sun Jan 18 06:02:05 EST 2009

Charles,
The transactions shown are DivX transactions.  UBS Quicken 2001 (which Intuit customized for UBS) doesn't offer a Div transaction.
The entries seem to come from transactions exported from the linked bank account.  A typical example from the QIF file is shown below.
^
D7/6/07
U22.61
T22.61
CX
PIdearc
L[Wachovia Securities]
^

All,
In response to the other suggestions offered in response to my inquiry, UBS Quicken 2001 refuses to export everything in one QIF file. I am forced to export a separate QIF file for each account.  For one of my Quicken files (but not for another) I was able to export everything in one OFX file.  Since I had read that OFX was more complete and more reliable, I thought that this was the way to go.  I only started to use QIF because of the crash while importing transactions from OFX files described previously.  The tip about importing the separate QIF files in one pass is a good one.  I had figured this out by trial and error, but without drawing the ultimate conclusion, that I should forget about OFX entirely and do everything with one batch of QIF files.  Unfortunately, this looks like a lot of work.  I am now considering a suggestion I read on the list in response to another inquiry, to forget about importing the history and simply switch to
 GnuCash effective 1 Jan. 2009.  My main reasons for wanting to import the history were to have better reporting on 2008 when doing my tax returns and to have the stock price and currency exchange rate histories available for reporting on investments.

Many, many thanks for all of your quick and informative answers!
Any further feedback is welcome!
Best Regards,
Roger

--- On Sun, 1/18/09, Charles Day <cedayiv at gmail.com> wrote:

From: Charles Day <cedayiv at gmail.com>
Subject: Re: Migration from UBS Quicken 2001 for Windows
To: "Roger Brooks" <rsbrux at yahoo.com>
Cc: "Sr.John R. Carter" <john at jrcarter.com>, gnucash-user at gnucash.org
Date: Sunday, January 18, 2009, 6:17 AM

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.