[Fwd: Re: Importing from Quicken]

Charles Day cedayiv at gmail.com
Mon Feb 25 15:49:51 EST 2008 

On Mon, Feb 25, 2008 at 12:27 PM, Richard Ullger <rullger at ntlworld.com>
wrote:

> When this transaction is imported into gnucash, I ended up with a total
> amount of 1700 pounds.
>
> D5/4/05
> NBuy
> YHSBC Holdings
> I850
> Q2
> CR
> U17.00
> T17.00
>

So it is as Ian suspected. There is no indication of what currency is being
used in the transactions. And even if you tell the importer to assume that
the currency is pounds, how is the QIF importer to know that some figures
are in whole units of currency and others in hundredths?


> Derek Atkins mentioned in another thread that, when entering a stock
> purchase into a gnucash stock account, the stock price is not stored but
> is calculated. So when importing the above transaction, could gnucash
> not calculate the share price from the quantity and total price. In this
> case it wouldn't matter whether the price per share was held in pounds
> or pence.
>

Agreed. That would take care of this mix of pounds and pence. As luck would
have it, I recently changed the QIF importer so that it calculates the price
this way. That change is included in GnuCash 2.2.4, which should be released
in about a week if I recall correctly.

Cheers,
Charles

Regards,
>
> Richard.
>
>
>
>
> Charles,
>
> Below are two example transactions from a QIF file exported from a
> Quicken 98 investment account. The account can contain monetary
> transactions such as a dividend or charges as well stock.
>
> The dividend transaction is recorded in pounds. The stock purchase has a
> price per share in pence (850) with the transaction total in pounds (17.00
> ).
>
> Regards,
>
> Richard.
>
> !Type:Invst
> D5/4/05
> NDiv
> YHSBC Holdings
> CR
> U14.68
> T14.68
> MDividend from UKSOP Partnership shares
> ^
> D5/4/05
> NBuy
> YHSBC Holdings
> I850
> Q2
> CR
> U17.00
> T17.00
> ^
>
>
>
> Charles Day wrote:
> > On Sun, Feb 24, 2008 at 6:06 PM, Richard Ullger <rullger at ntlworld.com
> > <mailto: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
> >     <mailto: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 <mailto: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 <mailto: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 <mailto: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.
>

More information about the gnucash-user mailing list