Re: [GNC] Simple reporting help
I am trying it, it looks like a great trick. It defaulted to 2020 and I picked my own bank a/c, but when I tried to change the dates in the options I got nothing. FWIW, Version 4.2 on Windows 10, Barry On 27/10/2020 14:08, Christopher Lam wrote: The experimental multicolumn reports have a "show report options" or something in the general tab, which will assist troubleshooting. On Tue, 27 Oct 2020, 8:26 pm Michelle, wrote: I did try. Had to get the flatpak version 4.2 as Mint is too far behind that I couldn't easily "make" it, but it still gave nothing. Michelle. On Tue, 2020-10-27 at 09:00 +1100, Geoff wrote: Wow, that's a much better solution, it shows sub-totals for sub-accounts, and even handles financial years not just calendar years. Thanks for the tip Gal! Michelle - it might be worth upgrading for this feature, see attached screenshot. Geoff = On 27/10/2020 3:49 am, Gal wrote: Another way to achieve what you're looking for is to select Reports --> Experimental --> Income Statement (Multicolumn) Then select the relevant account in the Accounts Tab, and select "Year" in the Period duration dropdown list in the General tab. -- 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. ___ 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] Simple reporting help
The experimental multicolumn reports have a "show report options" or something in the general tab, which will assist troubleshooting. On Tue, 27 Oct 2020, 8:26 pm Michelle, wrote: > I did try. Had to get the flatpak version 4.2 as Mint is too far behind > that I couldn't easily "make" it, but it still gave nothing. > > Michelle. > > On Tue, 2020-10-27 at 09:00 +1100, Geoff wrote: > > Wow, that's a much better solution, it shows sub-totals for > > sub-accounts, and even handles financial years not just calendar > > years. > > > > Thanks for the tip Gal! > > > > Michelle - it might be worth upgrading for this feature, see > > attached > > screenshot. > > > > Geoff > > = > > > > On 27/10/2020 3:49 am, Gal wrote: > > > Another way to achieve what you're looking for is to select Reports > > > --> > > > Experimental --> Income Statement (Multicolumn) > > > > > > Then select the relevant account in the Accounts Tab, and select > > > "Year" in > > > the Period duration dropdown list in the General tab. > > > > > > > > > > > > -- > > > 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. > ___ 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] Simple reporting help
Yes. By default, it selected all accounts, and I even tried deselecting all and selecting indicidual accounts, but no change. This is version 4.2 flatpak build. On Tue, 2020-10-27 at 07:50 -0500, Gal wrote: > Michelle, did you make any account selection in the report options? > > > > -- > 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] Simple reporting help
Michelle, did you make any account selection in the report options? -- 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] Simple reporting help
I did try. Had to get the flatpak version 4.2 as Mint is too far behind that I couldn't easily "make" it, but it still gave nothing. Michelle. On Tue, 2020-10-27 at 09:00 +1100, Geoff wrote: > Wow, that's a much better solution, it shows sub-totals for > sub-accounts, and even handles financial years not just calendar > years. > > Thanks for the tip Gal! > > Michelle - it might be worth upgrading for this feature, see > attached > screenshot. > > Geoff > = > > On 27/10/2020 3:49 am, Gal wrote: > > Another way to achieve what you're looking for is to select Reports > > --> > > Experimental --> Income Statement (Multicolumn) > > > > Then select the relevant account in the Accounts Tab, and select > > "Year" in > > the Period duration dropdown list in the General tab. > > > > > > > > -- > > 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] Simple reporting help
I guess that report is still experimental in the Linux version :-) The Mint repos still have a build from 2019-12-29. V3.8 Thanks for making me aware of it though. I'll keep an eye on it. On Mon, 2020-10-26 at 11:49 -0500, Gal wrote: > Another way to achieve what you're looking for is to select Reports > --> > Experimental --> Income Statement (Multicolumn) > > Then select the relevant account in the Accounts Tab, and select > "Year" in > the Period duration dropdown list in the General tab. > > > > -- > 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] Simple reporting help
Another way to achieve what you're looking for is to select Reports --> Experimental --> Income Statement (Multicolumn) Then select the relevant account in the Accounts Tab, and select "Year" in the Period duration dropdown list in the General tab. -- 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] Simple reporting help
Hi Geoff, That did the trick. Many thanks. I do wish that on the General tab, Start date drop down, that they had an option for, "Since the beginning of time." :-) But that's given me exactly what I need. Many thanks for your help, Michelle. On Mon, 2020-10-26 at 22:24 +1100, Geoff wrote: > Hi Michelle > > One way to achieve this is to use the Transaction Report. > > After selecting the relevant Account(s), stay in Options and tick > "Subtotal Table" on the Display tab, then select "Date" as the > Primary > Key and "Yearly" as the Primary Subtotal on the Sorting tab. > > You should get the subtotals at the start of the report, followed by > all > the transactions. > > See attached screenshot. > > Hope this helps. > > Regards > > Geoff > = > > On 26/10/2020 8:39 pm, Michelle wrote: > > Apologies for a newbie question. I've been using GnuCash for many > > years > > but I do little reporting with it. > > > > What I'm trying to do is look at annual expenditure for a specific > > account/catagory. > > > > eg. I have - -cat:Car:Fuel ... and I want to know how much I've > > spent > > on fuel each year, over the last ten years. > > > > I've tried a number of report options, but I'm not hitting the > > right > > report. > > > > Could someone kindly help please. > > > > ___ > > 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] Simple reporting help
Hi Michelle One way to achieve this is to use the Transaction Report. After selecting the relevant Account(s), stay in Options and tick "Subtotal Table" on the Display tab, then select "Date" as the Primary Key and "Yearly" as the Primary Subtotal on the Sorting tab. You should get the subtotals at the start of the report, followed by all the transactions. See attached screenshot. Hope this helps. Regards Geoff = On 26/10/2020 8:39 pm, Michelle wrote: Apologies for a newbie question. I've been using GnuCash for many years but I do little reporting with it. What I'm trying to do is look at annual expenditure for a specific account/catagory. eg. I have - -cat:Car:Fuel ... and I want to know how much I've spent on fuel each year, over the last ten years. I've tried a number of report options, but I'm not hitting the right report. Could someone kindly help please. ___ 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.