Importing from Quicken

Charles Day cedayiv at gmail.com
Sun Feb 24 22:39:03 EST 2008


On Sun, Feb 24, 2008 at 7:14 PM, Ian Lewis <ianmlewis at gmail.com> wrote:

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

I believe some UK versions of Quicken put pound symbols in the QIF file (see
bug 141003 <http://bugzilla.gnome.org/show_bug.cgi?id=141003>). So maybe his
QIF has a "p" for pence in it... I don't know. I've asked him to provide a
sample.  Of course, if the pound symbol or "p" is there then I'm surprised
it imported at all!

-Charles


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