Importing from Quicken

[Ian Lewis]

QIF files don't specify the currency so the importer couldn't know what
currency the QIF is in unless you tell it what currency it is in. I assume
you had to specify the currency as pounds as pence isn't really a seperate
currency and isn't in the list of available currencies.

Short of making a "pence" currency that is always equal to 1/100 relative to
the pound I'm not sure what gnucash could do better in this case as the
amounts were not specified with the precision of the base currency unit and
there is nothing in a QIF that tells you what the currency is let alone
whether the amounts are in a sub-currency (if you can call it that).

Ian

2008/2/25, Richard Ullger <rullger at ntlworld.com>:
>
> 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.
> >
> _______________________________________________
> 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.
>