Importing from Quicken

Richard Ullger rullger at ntlworld.com
Mon Feb 25 14:58:11 EST 2008


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


More information about the gnucash-user mailing list