Can anyone help me with this? Do I have to supply more/different information?
I have been using gnucash personally for a couple of years now and would like to develop more confidence in the program. Thank you in advance for your help. Bill Dika On Wed, Apr 27, 2022 at 1:42 PM Bill Dika <billd...@gmail.com> wrote: > 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 > _______________________________________________ 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.
