Re: [GNC] Balance Sheet - Currency Conversion
Hi John, The fact is the transaction in the specific date was already done. It means I already have the money in my account in my currency. Thus, right price is that registered on transaction. On Sat, Aug 3, 2019, 12:38 John Ralls wrote: > > > > On Aug 2, 2019, at 5:48 PM, Danilo Freitas da Costa > wrote: > > > > Hi, @ll! > > > > I'm facing a strange issue or misunderstanding, using different > currencies. > > > > For simplification, I have an account tree like this: > > > > Asset > > Asset : Account-1 (BRL) > > Income > > Income : Income-1 (USD) > > > > My default currency is BRL. > > > > Steps (example): > > > > 1. Add an income on 07/Jun/2019 and provide the currency quotation on > this > > date. > > 2. Generate Balance Sheet report until 30/06/2019 > > > > Until now, everything is OK. The conversion sounds good. > > > > 3. Add a new income on 05/Jul/2019 and provide the currency quotation on > > this date. > > 4. Generate Balance Sheet report until 30/06/201. > > > > Now, the report Balance Sheet uses the most recent quotation not the > > quotation on 07/jun. As well, the total of "Assets" and "Liabilities and > > Equity" doesn't match. > > > > Is there any way to use this entries and provide a balance sheet with the > > the correct value? > > Why is the price on 7 June more correct than the one on 5 July for a > report dated 30 June? > > That aside, try setting the price source to "Average Cost". If it's still > out of balance then you probably have unaccounted-for trading gains or > losses. The trial balance report, run for different days, can help track > down the dates of the transactions with the gains. > > Regards, > John Ralls > > ___ 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 - Currency Conversion
I would think the ‘Most Recent’ or ’Nearest in Time’ options would not look at the price db past the closing date of the report. And if it does look past the date, Average/Weighted Average wouldn’t work either because transactions (and prices) entered post 6/30/19 shouldn’t be part of the report. Running a Balance Sheet for a specified closing date should produce the same report no matter what day it is run on, without regards to any transactions or price data entered after 6/30/19. (assuming no historical transactions or prices were altered) I should think it a bug if this is not the case. Regards, Adrien > On Aug 3, 2019, at 3:52 AM, Christopher Lam wrote: > > Simple answer, unfortunately no. > Running balance sheet (or multicolumn balance sheet) on date 30/06/19 will > try the nearest pricedb entry by default, which is dated 05/07/19. > If you wish to run balance-sheet using prices dated 05/06/19, you will have > to duplicate the 05/06/19 prices to the new date 30/06/19. > HTH > > On Sat, 3 Aug 2019 at 08:33, Danilo Freitas da Costa > wrote: > >> Hi, @ll! >> >> I'm facing a strange issue or misunderstanding, using different currencies. >> >> For simplification, I have an account tree like this: >> >> Asset >> Asset : Account-1 (BRL) >> Income >> Income : Income-1 (USD) >> >> My default currency is BRL. >> >> Steps (example): >> >> 1. Add an income on 07/Jun/2019 and provide the currency quotation on this >> date. >> 2. Generate Balance Sheet report until 30/06/2019 >> >> Until now, everything is OK. The conversion sounds good. >> >> 3. Add a new income on 05/Jul/2019 and provide the currency quotation on >> this date. >> 4. Generate Balance Sheet report until 30/06/201. >> >> Now, the report Balance Sheet uses the most recent quotation not the >> quotation on 07/jun. As well, the total of "Assets" and "Liabilities and >> Equity" doesn't match. >> >> Is there any way to use this entries and provide a balance sheet with the >> the correct value? >> >> Regards, >> >> *Danilo* ___ 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 - Currency Conversion
> On Aug 2, 2019, at 5:48 PM, Danilo Freitas da Costa > wrote: > > Hi, @ll! > > I'm facing a strange issue or misunderstanding, using different currencies. > > For simplification, I have an account tree like this: > > Asset > Asset : Account-1 (BRL) > Income > Income : Income-1 (USD) > > My default currency is BRL. > > Steps (example): > > 1. Add an income on 07/Jun/2019 and provide the currency quotation on this > date. > 2. Generate Balance Sheet report until 30/06/2019 > > Until now, everything is OK. The conversion sounds good. > > 3. Add a new income on 05/Jul/2019 and provide the currency quotation on > this date. > 4. Generate Balance Sheet report until 30/06/201. > > Now, the report Balance Sheet uses the most recent quotation not the > quotation on 07/jun. As well, the total of "Assets" and "Liabilities and > Equity" doesn't match. > > Is there any way to use this entries and provide a balance sheet with the > the correct value? Why is the price on 7 June more correct than the one on 5 July for a report dated 30 June? That aside, try setting the price source to "Average Cost". If it's still out of balance then you probably have unaccounted-for trading gains or losses. The trial balance report, run for different days, can help track down the dates of the transactions with the gains. Regards, John Ralls ___ 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 - Currency Conversion
Simple answer, unfortunately no. Running balance sheet (or multicolumn balance sheet) on date 30/06/19 will try the nearest pricedb entry by default, which is dated 05/07/19. If you wish to run balance-sheet using prices dated 05/06/19, you will have to duplicate the 05/06/19 prices to the new date 30/06/19. HTH On Sat, 3 Aug 2019 at 08:33, Danilo Freitas da Costa wrote: > Hi, @ll! > > I'm facing a strange issue or misunderstanding, using different currencies. > > For simplification, I have an account tree like this: > > Asset > Asset : Account-1 (BRL) > Income > Income : Income-1 (USD) > > My default currency is BRL. > > Steps (example): > > 1. Add an income on 07/Jun/2019 and provide the currency quotation on this > date. > 2. Generate Balance Sheet report until 30/06/2019 > > Until now, everything is OK. The conversion sounds good. > > 3. Add a new income on 05/Jul/2019 and provide the currency quotation on > this date. > 4. Generate Balance Sheet report until 30/06/201. > > Now, the report Balance Sheet uses the most recent quotation not the > quotation on 07/jun. As well, the total of "Assets" and "Liabilities and > Equity" doesn't match. > > Is there any way to use this entries and provide a balance sheet with the > the correct value? > > Regards, > > *Danilo* > ___ > 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.