Re: [GNC] Balance Sheet mismatch
If I recall correctly, there is a known limitation of the current Balance Sheet with respect to multiple currencies. I also recall there is only one price option that 'works', mostly, but I don't recall which one it is. (I thought it was 'nearest' but not certain) There are older threads on this topic. Also check bugs.gnucash.org Regards, Adrien On 6/2/22 11:50 PM, Fred Tydeman wrote: I have made a test file with just two transactions: Opening Balance in GBP on 3/13/2011 xfer and convert to USD 1/1/2016 So, those two transactions put two entries in the Price database for GBP. I then added a third price between those two dates on 1/11/2013 The Balance Sheet shows a mismatch if run on 1/11/2013 or any date after that date but is OK if run on 1/10/2013 or any date earlier The value of the GBP (reported in USD) is changing in the Assets section of the report, but the Equity section is remaining constant. Should the Equity section show an Unrealized gain/loss? This looks like a bug to me. I am not sure how to report, or what is needed. The test2.gnucash file is around 5000 bytes small Now sure where the Price history is kept, nor the Report options. ___ 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 mismatch
Fred, The price database is stored in your main datafile for the set of books. You can edit it from the Tools->Price Database in the menu. David Cousens On Thu, 2022-06-02 at 21:50 -0700, Fred Tydeman wrote: > I have made a test file with just two transactions: > Opening Balance in GBP on 3/13/2011 > xfer and convert to USD 1/1/2016 > So, those two transactions put two entries in the Price database for GBP. > I then added a third price between those two dates on 1/11/2013 > The Balance Sheet shows a mismatch if run on 1/11/2013 or any date after > that date > but is OK if run on 1/10/2013 or any date earlier > The value of the GBP (reported in USD) is changing in the Assets section of > the report, > but the Equity section is remaining constant. > Should the Equity section show an Unrealized gain/loss? > This looks like a bug to me. I am not sure how to report, or what is > needed. > The test2.gnucash file is around 5000 bytes small > Now sure where the Price history is kept, nor the Report options. > > > > On Wed, Jun 1, 2022 at 7:56 AM Fred Tydeman wrote: > > > > > On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman > > wrote: > > > > > I am now trying going back in time to see when the first imbalance starts. > > > How do I get a list of transactions in a specific date range? > > > Is there a way to find stock/mutual fund prices of zero(0)? > > > > > > > First mismatch happens back in 2012. > > It appears that using Report Options / Commodities / Price Source of > > Closest to report date is a problem when the date of the report > > is between two dates of a Foreign currency exchange rate in Price Database. > > However, that is not the only problem, as now using > > Last up through report date for Commodities, I get a mismatch > > when the Balance sheet report is the same date as a Price Database entry > > of a foreign currency. > > > ___ > 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 mismatch
I have made a test file with just two transactions: Opening Balance in GBP on 3/13/2011 xfer and convert to USD 1/1/2016 So, those two transactions put two entries in the Price database for GBP. I then added a third price between those two dates on 1/11/2013 The Balance Sheet shows a mismatch if run on 1/11/2013 or any date after that date but is OK if run on 1/10/2013 or any date earlier The value of the GBP (reported in USD) is changing in the Assets section of the report, but the Equity section is remaining constant. Should the Equity section show an Unrealized gain/loss? This looks like a bug to me. I am not sure how to report, or what is needed. The test2.gnucash file is around 5000 bytes small Now sure where the Price history is kept, nor the Report options. On Wed, Jun 1, 2022 at 7:56 AM Fred Tydeman wrote: > > > On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman > wrote: > >> I am now trying going back in time to see when the first imbalance starts. >> How do I get a list of transactions in a specific date range? >> Is there a way to find stock/mutual fund prices of zero(0)? >> > > First mismatch happens back in 2012. > It appears that using Report Options / Commodities / Price Source of > Closest to report date is a problem when the date of the report > is between two dates of a Foreign currency exchange rate in Price Database. > However, that is not the only problem, as now using > Last up through report date for Commodities, I get a mismatch > when the Balance sheet report is the same date as a Price Database entry > of a foreign currency. > ___ 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 mismatch
On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman wrote: > I am now trying going back in time to see when the first imbalance starts. > How do I get a list of transactions in a specific date range? > Is there a way to find stock/mutual fund prices of zero(0)? > First mismatch happens back in 2012. It appears that using Report Options / Commodities / Price Source of Closest to report date is a problem when the date of the report is between two dates of a Foreign currency exchange rate in Price Database. However, that is not the only problem, as now using Last up through report date for Commodities, I get a mismatch when the Balance sheet report is the same date as a Price Database entry of a foreign currency. ___ 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 mismatch
Tried that. Still not in balance. Also, tried Show Hidden Accounts (I believe I have none now) => Imbalance. Also, tried Select All => Imbalance I am now trying going back in time to see when the first imbalance starts. How do I get a list of transactions in a specific date range? Is there a way to find stock/mutual fund prices of zero(0)? On Tue, May 31, 2022 at 11:31 PM Geoff wrote: > Hi Fred > > It's more likely that you have omitted one or more newly created accounts? > > Try going into the Report Options / Accounts / Select Default / Apply. > > Regards > > Geoff > = > > On 1/06/2022 3:06 pm, Fred Tydeman wrote: > > In running a Balance Sheet for today, the values in Total Assets > > and (Liabilities & Equity) do not match. Any suggestions on what > > could be wrong? Does it depend upon transactions being Reconciled? > > ___ > > 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 mismatch
On 6/1/2022 2:31 AM, Geoff wrote: Hi Fred It's more likely that you have omitted one or more newly created accounts? Try going into the Report Options / Accounts / Select Default / Apply. Regards Geoff Also (before running any report) make sure that there is nothing in Imbalance or Orphan. Michael D Novack ___ 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 mismatch
Hi Fred It's more likely that you have omitted one or more newly created accounts? Try going into the Report Options / Accounts / Select Default / Apply. Regards Geoff = On 1/06/2022 3:06 pm, Fred Tydeman wrote: In running a Balance Sheet for today, the values in Total Assets and (Liabilities & Equity) do not match. Any suggestions on what could be wrong? Does it depend upon transactions being Reconciled? ___ 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 mismatch
In running a Balance Sheet for today, the values in Total Assets and (Liabilities & Equity) do not match. Any suggestions on what could be wrong? Does it depend upon transactions being Reconciled? ___ 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.