Importing from Quicken

[Richard Ullger]

No probIem charles,

I'll do that when I get home tonight, I'm on my way in to work at the moment.

Richard.

________________ Reply Header ________________
Subject:	Re: Importing from Quicken
Author:	"Charles Day" <cedayiv at gmail.com>
Date:		24th February 2008 7:34:28 pm

On Sun, Feb 24, 2008 at 6:06 PM, Richard Ullger <rullger at ntlworld.com>
wrote:

> Hi,
>
> When I imported my stock accounts from Quicken, the price per share was
> 100 times too big. The price is held in pence in quicken, 852p, but in
> gnucash it is held in pounds, £8.52. Consequently the total cost of
> shares of each stock purchase or sale was 100 times too big.
>

Richard, could you post a sample transaction from your QIF file that uses
pence rather than pounds?

Thanks,
Charles


> This was from Quicken 98 to gnucash 2.2.3.
>
> Regards,
>
> Richard.
>
>
> Charles Day wrote:
> > On Sun, Feb 24, 2008 at 9:39 AM, <zephod at cfl.rr.com> wrote:
> >
> >> I am a new GnuCash user having recently moved from Quicken since they
> are
> >> doing their extortion trick of forcing you to upgrade or lose the
> ability to
> >> download stock prices which really come from Yahoo. Grrrr.
> >>
> >> <Deep breath>Anyway, I have about 15yrs of data that I imported in GC
> and
> >> I had 2 main problems during the import.
> >>
> >> 1) I got messages that some transactions were deleted because they were
> >> not supported in GC. These all turned out to be stock shorts and their
> >> corresponding covers. Is shorting stock really not supported and if the
> >> answer is yes, then how do I go about reconciling the brokerage account
> that
> >> contains these transactions?
> >>
> >
> > Shorts and covers aren't supported by the current QIF importer, but if
> you
> > can provide a sample QIF file, or at least a few sample transactions,
> I'd be
> > happy to take a look at it. And by all means, if you find anything else
> in
> > your QIF that doesn't import correctly, let us know.
> >
> > 2) After the import was finished, I reorganized my accounts so that they
> are
> >> all subaccounts of the 4 main accounts: assets, liabilities, income or
> >> expenses. There was no equity account so I just created one. How can I
> get
> >> this equity account to show my net worth assuming that I am correct in
> >> thinking that is what this account is for?
> >>
> >
> > The equity accounts don't show your net worth. They are used to add or
> > remove money from an accounting period. Since you're coming from
> Quicken,
> > you're probably not using accounting periods, so your period is
> "forever".
> > So what you'll see in your Equity accounts is value added or removed
> from
> > GnuCash, such as opening balances and any shares you've added/removed
> > without doing a buy/sell (ShrsIn and ShrsOut in your .QIF).
> >
> > You don't say which version of GnuCash you are using, but there were
> quite a
> > few QIF importer fixes included in 2.2.3, particularly for investments,
> and
> > quite a few more to be included with 2.2.4 (soon to be released).
> >
> > Cheers,
> > Charles
> >
> > TIA
> >> Steve
> >> _______________________________________________
> >> 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.
> >
> _______________________________________________
> 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.
>