[GNC] Gnu Cash / UNrealised Losses in Trial balance

[Eid Eid]

Thank you.
I have tried “scoping’’ the trial balance report on various accounts and date ranges, and found out :
= The ‘unrealised losses’ figure is showing significant jumps on the days where the EUR/USD pricing is being changed significantly (as we know EUR/USD rate has been quite variable in the last period.
= When restricting the trial balance report to only the “EUR Bank Account”, it is showing Unrealised losses with almost the same figure as for the entire Trial Balance.

So I am concluding thisis simply the losses I am incurring because of the EUR devaluation with respect to the USD.
And that should the EUR/USD rate increase back again to say 1.2 these losses would disappear (if I keep the Euros in Euros and not trade them for USD, of course).

Would the above make any sense?

Thanks for all the help, really appreciated


From: David Carlson <david.carlson.417 at gmail.com>
Sent: Friday, November 4, 2022 3:40 PM
To: Eid Eid <eideid at ideko-lb.com>
Cc: Derek Atkins <derek at ihtfp.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Gnu Cash / UNrealised Losses in Trial balance

You are on the right track.  The unrealized losses probably came from some transaction involving another currency exchange with your primary currency or, as Derek hinted, two or more transactions involving a security or other commodity.  You can adjust the date range of the report to narrow down the group of transactions to search for the source of the issue.  To eliminate the loss you would need to add a transaction to convert the unrealized loss to a realized loss.  Others here can give specific advice once you have found the offending transactions.

On Fri, Nov 4, 2022 at 8:26 AM Eid Eid <eideid at ideko-lb.com<mailto:eideid at ideko-lb.com>> wrote:
Thank you,

In my case, this seems to be related to the EUR/USD rate.
When I print a trial Balance, and I change which rate to use "Nearest in time, Last recorded price, etc.." this figure (UNrealised losses) is changing. I do not have inventory.

So I feel this is "Difference of Exchange" . Is my understanding correct?

Thanks,

EE


-----Original Message-----
From: Derek Atkins <derek at ihtfp.com<mailto:derek at ihtfp.com>>
Sent: Tuesday, November 1, 2022 8:16 PM
To: Eid Eid <eideid at ideko-lb.com<mailto:eideid at ideko-lb.com>>
Cc: Gnucash Users <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: Re: [GNC] Gnu Cash / UNrealised Losses in Trial balance

Hi,

On Tue, November 1, 2022 1:53 pm, Eid Eid wrote:
> HI to all.
> I am getting an amount as Unrealized losses in my trial balance, and
> this is popping up while enot being related to a given
> registry/account. It seems to be generated by the system, and by
> playing around, I am convinced it is related to Difference of Exchange.
> Can someone explain to me what this is, and how to get rid of it?
>
> Thank you,

You buy 10 widgets at $10 each.
You sell 5 widgets at $15 each.

You need to account for that (realized) gain.

Now the widget price increases to $20 each.  That would be unrealized gain..

>
> Eid E. Eid

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

--
       Derek Atkins                 617-623-3745
       derek at ihtfp.com<mailto:derek at ihtfp.com>             www.ihtfp.com<http://www.ihtfp.com>
       Computer and Internet Security Consultant

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
To update your subscription preferences or to unsubscribe:
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.


--
David Carlson