Alain, Here is a scenario that could produce what you are seeing. 1. Sometime in the past you entered a commodity, e.g., stock, mutual fund, something that uses units and prices. 2. On the date the balance sheet starts showing an unrealized gain or loss a different unit price for this commodity became available to gnucash. This usually happens through the price editor tool. Depending on the Commodity settings in the report, gnucash computed a current price for the commodity and compared the value computed using this price to the cost(s) at entry time(s) of the commodity. This difference is included in the unrealized gains and losses.
The next suggestion should be followed on a copy of your gnucash file in case there are unpleasant effects. If you have rarely used the price editor (as your messages seem to indicate), then it may be easy to locate the commodity and delete any recorded prices. That should fix your issue. Dale On 04/02/2018 07:52 AM, David T. via gnucash-user wrote: > > 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, cag...@free.fr<cag...@free.fr> wrote: > > > De: cag...@free.fr > À: "John Ralls" <jra...@ceridwen.us> > Cc: "gnucash-user" <gnucash-user@gnucash.org> > Envoyé: Lundi 2 Avril 2018 13:51:03 > Objet: Re: Unrealized loss > > > > > De: "John Ralls" <jra...@ceridwen.us> > À: cag...@free.fr > Cc: "gnucash-user" <gnucash-user@gnucash.org> > Envoyé: Dimanche 1 Avril 2018 15:34:43 > Objet: Re: Unrealized loss > > > > > > > On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@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 ] . > > 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@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@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@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.
