Unrealized loss

David T. sunfish62 at yahoo.com
Wed Apr 4 23:28:24 EDT 2018


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.  


More information about the gnucash-user mailing list