Re: [GNC] balance sheet and account equation for Business Accounts
On 07/25/2018 09:13 AM, nor via gnucash-user wrote: > I have separate income accounts for USD and Euro transactions. When the need > arises than only funds from Euro is converted to default USD account held at > the bank at the prevailing exchange rate. > > balance sheet report is with exchange rates at balance sheet report date. > May be these exchange rate variations are not automatically accounts as > gain/loss in B/L report. > > nor > You need to enable trading accounts and follow the setup described at https://wiki.gnucash.org/wiki/Trading_Accounts Please read the two articles it mentions at the top. Essentially foreign exchange rate changes act like stock price fluctuations. --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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.
Re: [GNC] balance sheet and account equation for Business Accounts
Thanks. Shall do by this weekend. In Ver 3.2 standard report seems to be located at user/.gnucash/book nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] balance sheet and account equation for Business Accounts
I have separate income accounts for USD and Euro transactions. When the need arises than only funds from Euro is converted to default USD account held at the bank at the prevailing exchange rate. balance sheet report is with exchange rates at balance sheet report date. May be these exchange rate variations are not automatically accounts as gain/loss in B/L report. nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] balance sheet and account equation for Business Accounts
As well as the internal funds transfer from Euro to USD in your Asset:bank account are you also converting the corresponding income account in Euro to an Income account in USD at the same exchange rate? If not this is a possible spurce of any imbalance in the accounting equation. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] balance sheet and account equation for Business Accounts
Don't need to be a programmer. Just save the link into the standard-reports folder - on windows it's somewhere in c:\program files (x86)\gnucash On Mon, 23 Jul 2018, 02:20 nor via gnucash-user wrote: > That will be great. Link viewed. However, I am not comfortable with > programmingnor > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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.
Re: [GNC] balance sheet and account equation for Business Accounts
That will be great. Link viewed. However, I am not comfortable with programmingnor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] balance sheet and account equation for Business Accounts
Unfortunately the current balance sheet will compulsorily convert all amounts to a target currency. If you're willing to help beta test, a new balsheet is in development at https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm - this one will, by default, not choose a target currency so that your EUR and USD are counted separately. C On 22 July 2018 at 19:18, nor via gnucash-user wrote: > I use USD as default and Euro other currency. Separate accounts are created > for each currency to avoid exchange variations. i.e. all Euro transactions > are dealt with corresponding account in Euro. > > For inter account fund transfer, prevailing exchange rate is considered > when > I transfer funds from my USD to Euro account. > > For Balance Sheet Report, variables are, > > Price Source: Most Recent > Currency: Default i.e USD > > Accounting equation does not hold as per the dates of balance sheet report. > This is due to the gain/loss w.r.t. exchange rates at various dates. > > Need guidance how to take care. This was discussed earlier but w.r.t. stock > trading in difference currency. > > Only inter currency transaction in my case is internal fund transfer within > my own bank accounts. > > nor > > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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.
[GNC] balance sheet and account equation for Business Accounts
I use USD as default and Euro other currency. Separate accounts are created for each currency to avoid exchange variations. i.e. all Euro transactions are dealt with corresponding account in Euro. For inter account fund transfer, prevailing exchange rate is considered when I transfer funds from my USD to Euro account. For Balance Sheet Report, variables are, Price Source: Most Recent Currency: Default i.e USD Accounting equation does not hold as per the dates of balance sheet report. This is due to the gain/loss w.r.t. exchange rates at various dates. Need guidance how to take care. This was discussed earlier but w.r.t. stock trading in difference currency. Only inter currency transaction in my case is internal fund transfer within my own bank accounts. nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
