Importing from Quicken

Richard Ullger rullger at ntlworld.com
Sun Feb 24 21:06:44 EST 2008


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.

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


More information about the gnucash-user mailing list