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