Unrealized loss

[David Carlson]

If there was some way to search for or display transactions that contained
a non-zero exchange rate in one or more of it's split lines it might be
possible to track this down.

If the OP had made a typo years ago and corrected it but GnuCash left some
garbage it would not be easy to find.  I suppose that he could try Check
and Repair All to see if it makes a difference.

The fact that " setting the calculation mode to "average" or "nearest in
time" " makes a difference suggests that there may be more than one
transaction with a non-zero exchange rate and on different dates.

One other place to look is in the chart of accounts choose View > Filter by
> Other and check Show Hidden Accounts.  Then make sure the Commodity
column is shown and click on it two or three times to see if any account
has a currency other than his base currency.  If so, that would be the
place to look.

David C

On Wed, Apr 4, 2018 at 7:34 PM, Adrien Monteleone <
adrien.monteleone at gmail.com> wrote:

> But the OP specifically said he doesn’t deal with stocks or any other
> investments. So there should be no such added prices. (and technically,
> those would be manual inputs via the transaction, just not via the Price
> Editor) As far as I’m aware, GnuCash doesn’t just grab prices from online
> without being told to in some fashion.
>
> Regards,
> Adrien
>
> > On Apr 4, 2018, at 3:55 PM, nvsoar <nvsoar at charter.net> wrote:
> >
> > Hmmmmm.  Seems to me that a price is added to the system any time a
> stock is purchased or sold, or when a dividend is reinvested.
> > nvsoar
> >
> > On 04/04/18 09:32, Adrien Monteleone wrote:
> >> The value will usually change based on that setting. Sometimes ‘latest’
> and ’nearest in time’ will be the same, but that depends on running the
> report ON an actual day (not FOR an actual day) that is on or after a price
> update and before the next price update.
> >>
> >> First, you say you deleted all rates updated automatically by GC
> without you noticing. (does not happen, you have to open the price editor
> and tell it to ‘get quotes’) This leaves the presumption that there are
> other prices in the db that you either entered manually or intentionally
> updated with the ‘get quotes’ button.
> >>
> >> Then you say there are NO rates in the system.
> >>
> >> Which is it?
> >>
> >> If you open the Price Database is there anything at all listed in the
> window? (this includes a Currencies tree)
> >>
> >> Do you have ANY transactions where you purchased or entered an opening
> balance for a commodity or any currency other than the default book
> currency? (EUR)
> >>
> >> If you go to File > Properties, is ‘Use Trading Accounts’ checked?
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Apr 4, 2018, at 11:10 AM, cageda at free.fr wrote:
> >>>
> >>> I suspect there is a bug that should be reported:
> >>>
> >>> As I do NOT manage currencies other than EUR and no traders accounts
> taking into account share values, I have deleted all exchanges rates that
> had been updated automatically by GC without my noticing.
> >>> BUT my Unrealized loss on a given day varies according to my setting
> the calculation mode to "average" or "nearest in time" for instance. It
> doesn's seem to make sense since there are NO exchange rates in my system.
> >>>
> >>> Ideas?
> >>> TIA
> >>> Alain
> >>>
> >>>
> >>>
> >>>
> >>> De: "sunfish62" <sunfish62 at yahoo.com>
> >>> À: cageda at free.fr, "John Ralls" <jralls at ceridwen.us>
> >>> Cc: "gnucash-user" <gnucash-user at gnucash.org>
> >>> Envoyé: Lundi 2 Avril 2018 14:52:46
> >>> Objet: Re: Unrealized loss
> >>>
> >>> Alain,
> >>>
> >>> Your new transaction is balanced, and won't affect the imbalance in
> another transaction.
> >>>
> >>> I personally find the unrealized gains issue to be exceedingly
> difficult to understand. Since you say you don't care about this, just
> ignore it.
> >>>
> >>> David T
> >>>
> >>>
> >>>
> >>>
> >>> On Mon, Apr 2, 2018 at 17:02, cageda at free.fr
> >>> <cageda at free.fr> wrote:
> >>>
> >>>
> >>>
> >>> De: [ mailto:cageda at free.fr | cageda at free.fr ]
> >>> À: "John Ralls" < [ mailto:jralls at ceridwen.us | jralls at ceridwen.us ] >
> >>> Cc: "gnucash-user" < [ mailto:gnucash-user at gnucash.org |
> gnucash-user at gnucash.org ] >
> >>> Envoyé: Lundi 2 Avril 2018 13:51:03
> >>> Objet: Re: Unrealized loss
> >>>
> >>>
> >>>
> >>>
> >>> De: "John Ralls" < [ mailto:jralls at ceridwen.us | jralls at ceridwen.us ]
> >
> >>> À: [ mailto:cageda at free.fr | cageda at free.fr ]
> >>> Cc: "gnucash-user" < [ mailto:gnucash-user at gnucash.org |
> gnucash-user at gnucash.org ] >
> >>> Envoyé: Dimanche 1 Avril 2018 15:34:43
> >>> Objet: Re: Unrealized loss
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cageda at free.fr |
> cageda at free.fr ] | [ mailto:cageda at free.fr | cageda at free.fr ] ] wrote:
> >>>
> >>>
> >>> Hello.
> >>>
> >>> I have have had an "unrealized loss" showing on my balance sheet for
> years. I haven't bothered too much as the amount is extremely small.
> (€7.70).
> >>>
> >>> I had kind advice on this forum as to identify the date on which the
> loss showed up and the procedure to cancel it. I did find the date but
> stangely not the transaction. So I'm not going to keep trying to cancel the
> loss any longer.
> >>>
> >>> I read that, without actually "cancelling" the loss, it is possible to
> prevent it from showing. I know that this is not legal for a company, but
> my book keeping is fully personal so I'd like to know the procedure.
> >>>
> >>>
> >>>
> >>>
> >>> “Cancelling” isn’t really the right term. You need to record the loss
> as either expense or negative income depending on how you handle capital
> gains. There’s an explanation of how to do this in [ [
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html |
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] |
> [ https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html |
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] .
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
> >>>
> >>>
> >>> I have identified the day on which the unrealized lossed first
> appeared. I have drawn a transaction report for that day (and the day
> before). There is no transaction that can remotely explain the loss.
> >>> I do not handle foreign currencies. Regarding shares I do not use
> trader accounts or split transactions including profits or losses. I do not
> enter share values into GC until the day I sell them. There is no way in
> the meantime GC can take into account a difference in value.
> >>>
> >>> Something might help identify where the problem comes from: I had
> another instance with an unrealized loss as big as my total yearly income.
> It went away a few weeks (or months I'm not sure) after it showed up. There
> is no way a single transaction (or even a few ) on a particular day
> triggered an unrealized loss as big as my yearly income.
> >>>
> >>> What I would like at this stage is simply set GC NOT to SHOW
> unrealized losses/gains. No legal problem as I'm only managing my personal
> familyaccounts.
> >>>
> >>> TIA for you help
> >>> Regards
> >>> Alain
> >>>
> >>>
> >>> I tried the following:
> >>> C an equity account "Unrealized loss" : EUR 7.70
> >>> D an income account "Realized loss" : EUR 7.70
> >>> The total Equity remained the same - 7.70
> >>> I changed the signs and the total equity remained at - 7.70
> >>> I don't get it.
> >>>
> >>> TIA
> >>> Alain
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>