Re: [GNC] Profit & Retained Earning don't match
The Transaction Report has an 'Add options summary' flag, but it sadly does not show *all* options, very few of them in fact. Regards, Adrien On 2/25/22 4:01 PM, David Carlson wrote: I can't check right now but I think there is an enhancement request to show in a printable form all the settings for a given report. ___ 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] Profit & Retained Earning don't match
Derek, Thanks for raising those legitimate points. I think a flag or trigger to reselect accounts would be helpful. I would note that, to my way of thinking, when I call up a saved report, I *am* running it from scratch, although I understand your perspective. From my corner, when I call up a custom report, I'm doing the exact same steps as when I run a system report "from scratch." I open the reports menu, and I ask to run my report. In one case, it's a new report from scratch; the other is not. That's confusing to me. David Original Message From: Derek Atkins Sent: Fri Feb 25 21:07:49 EST 2022 To: Stan Brown Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Profit & Retained Earning don't match HI, On Fri, February 25, 2022 7:07 pm, Stan Brown wrote: > On 2022-02-25 15:09, D. wrote: >> >> My recollection was that standard reports based on a class of accounts >> (assets, liabilities) will recompile the account list each time. >> >> It would seem useful to extend this functionality to saved reports as >> well... > > That's what I was trying to suggest, but you stated it much more clearly! ANY report you re-run from scratch will start with the current set of accounts. Changing the list of accounts on a Saved Report, however, could have negative consequences, especially if the user explicitly set the set of accounts. Imagine if you explicitly wanted a Cash Flow report with all but one Asset account, saved it, and then when you re-ran the report that account got added in! That would change the report results. Arguably there *could* be a flag for "using the default" which would cause the saved report to use the current default (which may be different than the default at the time the report was saved). I'm not sure how we would encode that, and it certainly would not be a backwards-compatible change. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Profit & Retained Earning don't match
HI, On Fri, February 25, 2022 7:07 pm, Stan Brown wrote: > On 2022-02-25 15:09, D. wrote: >> >> My recollection was that standard reports based on a class of accounts >> (assets, liabilities) will recompile the account list each time. >> >> It would seem useful to extend this functionality to saved reports as >> well... > > That's what I was trying to suggest, but you stated it much more clearly! ANY report you re-run from scratch will start with the current set of accounts. Changing the list of accounts on a Saved Report, however, could have negative consequences, especially if the user explicitly set the set of accounts. Imagine if you explicitly wanted a Cash Flow report with all but one Asset account, saved it, and then when you re-ran the report that account got added in! That would change the report results. Arguably there *could* be a flag for "using the default" which would cause the saved report to use the current default (which may be different than the default at the time the report was saved). I'm not sure how we would encode that, and it certainly would not be a backwards-compatible change. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Profit & Retained Earning don't match
On 2022-02-25 15:09, D. wrote: > > My recollection was that standard reports based on a class of accounts > (assets, liabilities) will recompile the account list each time. > > It would seem useful to extend this functionality to saved reports as > well... That's what I was trying to suggest, but you stated it much more clearly! -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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] Profit & Retained Earning don't match
Derek, Some of the standard reports automatically update the account selection when they are invoked. See, for example, the Advanced Portfolio report, which automatically selects new commodity accounts each time it is run. My recollection was that standard reports based on a class of accounts (assets, liabilities) will recompile the account list each time. It would seem useful to extend this functionality to saved reports as well... David T. Original Message From: Derek Atkins Sent: Fri Feb 25 16:56:36 EST 2022 To: Stan Brown Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Profit & Retained Earning don't match HI, On Fri, February 25, 2022 4:49 pm, Stan Brown wrote: > > On 2022-02-25 13:14, Derek Atkins wrote: >> For example, if you ran the report, then added an account, that new >> account would not be included by default in the report if you refresh >> it. >> You need to manually add the new account into the report. >> >> This also applies to saved reports. > > Wow -- I did not know this, but it explains why my balance sheet and > income statement sometimes miss accounts. (With the income statement in > particular, I run it only at the end of the year, so any accounts could > have been added almost a whole year ago, and I wouldn't remember when I > added them.) > > I select accounts for my saved reports in what seems like a sensible > way: all Income And Expense accounts for the income statement, and all > Assets, Liabilities, and Equities for the balance sheet. > > I don't know how hard this would be to do, but it would be nice if GC > would keep track in a saved report of how accounts were selected. If the > selection was by a hierarchy rather than individual accounts, GC could > then automatically include all accounts within that hierarchy when > running the saved report. Yeah, sorry -- that's not how it works. It honestly doesn't know anything about "accounts" per se, let along hierachies. It just knows "Object GUIDs". The good news is that it's only a few clicks to get "all accounts" added. But yeah, if you save a report, or have a report "open", it wont learn about new accounts. This has been the case since, oh... 2003? 2005? Something like that. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Profit & Retained Earning don't match
I can't check right now but I think there is an enhancement request to show in a printable form all the settings for a given report. On Fri, Feb 25, 2022, 3:57 PM Derek Atkins wrote: > HI, > > On Fri, February 25, 2022 4:49 pm, Stan Brown wrote: > > > > On 2022-02-25 13:14, Derek Atkins wrote: > >> For example, if you ran the report, then added an account, that new > >> account would not be included by default in the report if you refresh > >> it. > >> You need to manually add the new account into the report. > >> > >> This also applies to saved reports. > > > > Wow -- I did not know this, but it explains why my balance sheet and > > income statement sometimes miss accounts. (With the income statement in > > particular, I run it only at the end of the year, so any accounts could > > have been added almost a whole year ago, and I wouldn't remember when I > > added them.) > > > > I select accounts for my saved reports in what seems like a sensible > > way: all Income And Expense accounts for the income statement, and all > > Assets, Liabilities, and Equities for the balance sheet. > > > > I don't know how hard this would be to do, but it would be nice if GC > > would keep track in a saved report of how accounts were selected. If the > > selection was by a hierarchy rather than individual accounts, GC could > > then automatically include all accounts within that hierarchy when > > running the saved report. > > Yeah, sorry -- that's not how it works. It honestly doesn't know anything > about "accounts" per se, let along hierachies. It just knows "Object > GUIDs". > > The good news is that it's only a few clicks to get "all accounts" added. > > But yeah, if you save a report, or have a report "open", it wont learn > about new accounts. > > This has been the case since, oh... 2003? 2005? Something like that. > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > ___ > 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] Profit & Retained Earning don't match
HI, On Fri, February 25, 2022 4:49 pm, Stan Brown wrote: > > On 2022-02-25 13:14, Derek Atkins wrote: >> For example, if you ran the report, then added an account, that new >> account would not be included by default in the report if you refresh >> it. >> You need to manually add the new account into the report. >> >> This also applies to saved reports. > > Wow -- I did not know this, but it explains why my balance sheet and > income statement sometimes miss accounts. (With the income statement in > particular, I run it only at the end of the year, so any accounts could > have been added almost a whole year ago, and I wouldn't remember when I > added them.) > > I select accounts for my saved reports in what seems like a sensible > way: all Income And Expense accounts for the income statement, and all > Assets, Liabilities, and Equities for the balance sheet. > > I don't know how hard this would be to do, but it would be nice if GC > would keep track in a saved report of how accounts were selected. If the > selection was by a hierarchy rather than individual accounts, GC could > then automatically include all accounts within that hierarchy when > running the saved report. Yeah, sorry -- that's not how it works. It honestly doesn't know anything about "accounts" per se, let along hierachies. It just knows "Object GUIDs". The good news is that it's only a few clicks to get "all accounts" added. But yeah, if you save a report, or have a report "open", it wont learn about new accounts. This has been the case since, oh... 2003? 2005? Something like that. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Profit & Retained Earning don't match
On 2022-02-25 13:14, Derek Atkins wrote: > For example, if you ran the report, then added an account, that new > account would not be included by default in the report if you refresh it. > You need to manually add the new account into the report. > > This also applies to saved reports. Wow -- I did not know this, but it explains why my balance sheet and income statement sometimes miss accounts. (With the income statement in particular, I run it only at the end of the year, so any accounts could have been added almost a whole year ago, and I wouldn't remember when I added them.) I select accounts for my saved reports in what seems like a sensible way: all Income And Expense accounts for the income statement, and all Assets, Liabilities, and Equities for the balance sheet. I don't know how hard this would be to do, but it would be nice if GC would keep track in a saved report of how accounts were selected. If the selection was by a hierarchy rather than individual accounts, GC could then automatically include all accounts within that hierarchy when running the saved report. -- Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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] Profit & Retained Earning don't match
Is it possible that you are missing an account in one of the reports? For example, if you ran the report, then added an account, that new account would not be included by default in the report if you refresh it. You need to manually add the new account into the report. This also applies to saved reports. -derek On Tue, February 22, 2022 5:16 pm, John Wilson wrote: > When I did our church's books for January 2022 the profit from the > Profit & Loss account and retained earnings on the balance sheet do not > match by $539.95 > > The Net income in the P a/c is $193,748.66 and on the BS it has shrunk > to $193,208.71. > > I cannot see an error in the figures and $539.95 does not occur in any > transactions. > > I wonder if I have set up the new set of books wrongly. > > The attached screenshots are of my tree of accounts starting at 11-37-37 > > A fresh set of eyes would be appreciated > > John > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.