Unrealized loss

Thu Apr 5 11:03:21 EDT 2018

Apologies David,

Somehow after reading over his posts several times, I still missed that. And seeing that now, makes my questions moot or answered.

So I’m more confidant to say, “Not a bug.”

The gain/loss calculation is being done on the various prices from whatever account he is using to buy/sell shares in. I’d suspect if he deletes the prices from the db, the report is still going to pull the relevant price(s) based on the commodity setting from the math in the transaction. If he bought shares at a lower price than he did previously, I would expect a sane response by GnuCash would be to report an unrealized loss.

This *might* be related to what we discovered in Feb while looking at the Trial Balance report.

Regards,
Adrien

> On Apr 5, 2018, at 6:24 AM, David T. <sunfish62 at yahoo.com> wrote:
> 
> I surmise from the OP that there ARE buy/sell transactions, based on the comment, "I do not enter share values into GC until the day I sell them," which was made early in the thread. 
> 
> I agree that details are lacking, and I apologize for the miscommunication regarding bugs. As I don't fully understand what a True Accountant believes is supposed to happen in those situations, I'm at a loss to determine whether gnucash is getting it right or wrong. 
> 
> David T 
> 
> 
> 
> On Thu, Apr 5, 2018 at 10:28, Adrien Monteleone
> <adrien.monteleone at gmail.com> wrote:
> I certainly didn’t advocate filing a bug on this. I think more sleuthing and answers are needed.
> 
> Yes, I understand the db gets an entry on a buy/sell transaction, but if you don’t have buy or sell transactions?...
> 
> And to be clear, those aren’t ‘automatically downloaded.’ They are the result of the transaction math.(perhaps the OP wasn’t expecting them to appear, but they really have to if the account is to be kept correct and reports work out properly, as you noted) We’re not talking about GC downloading new prices each day/month/week without being told to do so.
> 
> I’m at a loss with this thread because the OP hasn’t made clear that there aren’t any buy/sell transactions of anything. They claim they don’t use any currency other than EUR and don’t track stocks. The trading accounts could still be enabled, and a commodity added to the assets. And if this occurred on more than one date, well, then certainly, there will be more than one price in the db.(each one generated by GC as a result of the transaction)
> 
> But the OP has been silent on these questions, so it’s probably best to wait till he chimes back in to continue the guessing any further.
> 
> What we don’t know is:
> 
> Is he seeing this unrealized gain/loss without ANY prices AT ALL in the db? And without ANY other currencies other than the default book currency in play?(EUR) And without ANY assets denominated in ANYTHING but EUR? And without ANY stocks, funds, et cetera?
> 
> Until all of those answers are ‘yes’ I don’t think there’s a bug at all, but rather, either a transaction that is hard to find, or a user misunderstanding.
> 
> Regards,
> Adrien
> 
> > On Apr 4, 2018, at 10:28 PM, David T. <sunfish62 at yahoo.com> wrote:
> > 
> > Adrien, 
> > 
> > Gnucash places an entry in the price db when you create a buy or sell transaction.  This ensures that certain reports behave, I recall. 
> > 
> > As this issue has been discussed previously and at length, I would hesitate to file a bug until the experts weigh in on the esoteric aspects of unrealized gains in gnucash.  Currently, those experts are putting out bigger fires. 
> > 
> > David
> > 
> > 
> > On Thu, Apr 5, 2018 at 5:35, 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.
> 
> _______________________________________________
> 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.