[GNC] Calculation of Unrealized Losses

[Bill Dika]

My default currency is Canadian dollars. I have some US dollar
accounts in my balance sheet.

I have an unrealized loss in the equity section of my balance sheet at
July 31 2021 of $12.68 and cannot figure out how it was calculated. I
also have US dollar accounts expressed in Canadian dollars that I am
unable to determine how the translation from US dollars to Canadian
dollars occurs.

For example I have a US dollar account of $353.75 for Tesla (see
us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22
in Canadian dollars at July 31 2021 (see
us-dollar-accts-july-31-2021.png). This is an exchange rate of
1.28966. I am unable to figure out how Gnucash arrives at that rate
(see us-dollar-rates-price-database.png). It is not the rate at July
31 2021. It is not the average rate for all rates I have up to July 31
2021 and it is not the average rate for all rates I have in the price
database.

Also the $12.68 loss arises from only one change in the US dollar
accounts from June 30 2021 to July 31 2021. That is a $524.80 US
dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see
change-in-us-dollar-acct-july-2021.png).

Attached are images of the following:
equity-jun-30-2021.png = showing the equity section almost balanced
(.01 unrealized gain) (in Canadian dollars)
equity-july-31-2021.png = showing the $12.68 unrealized loss (in
Canadian dollars)
us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts
(in US dollars)
us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian dollars)
us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet
accounts (in US dollars)
us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian dollars)
change-in-us-dollar-acct-july-2021.png = shows the only change in the
US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US
dollars)
us-dollar-rates-price-database.png = all the US to Canadian exchange
rates in my database

I am a Canadian CPA and feel quite confident about the accounting in
the gnucash file. I have reviewed the journal entries for the period
and they all balance. The only thing I can ascertain is that the
unrealized loss arises from the US dollar accounts but I cannot figure
out how gnucash is calculating it nor can I figure out how gnucash
translates US dollars to Canadian dollars for those accounts.

I have searched the list but cannot find anything that helps me in my
calculation.

I am on Arch linux using Gnucash 4.9.

Any help would be much appreciated.

Thank you.

Bill Dika
-------------- next part --------------
A non-text attachment was scrubbed...
Name: equity-july-31-2021.png
Type: image/png
Size: 11848 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: change-in-us-dollar-acct-july-2021.png
Type: image/png
Size: 28825 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: us-dollar-accts-in-us-dollars-july-31-2021.png
Type: image/png
Size: 28502 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: equity-jun-30-2021.png
Type: image/png
Size: 11061 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: us-dollar-accts-in-us-dollars-jun-30-2021.png
Type: image/png
Size: 27889 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: us-dollar-accts-jun-30-2021.png
Type: image/png
Size: 26719 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: us-dollar-rates-price-database.png
Type: image/png
Size: 181414 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0014.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: us-dollar-accts-july-31-2021.png
Type: image/png
Size: 26870 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220427/746dc47e/attachment-0015.png>