The reporting mechanism is a bit ‘obtuse’ to put it mildly with respect to custom reports. Eventually, when GnuCash is a proper database application, this will change. In the meantime, you also have an option, if you are using one of the database backends, to use something like PieCash which can parse the data and allow you to write your own reports using more friendly tools than the default reporting system. Do a web search or specifically a search here on the list for threads about it with links.
Regards, Adrien > On Jun 3, 2018, at 2:01 AM, John Robins <j...@newzpoint.com> wrote: > > Got it! Thank you. > > One quick follow up question. Would it be possible for a gnucash developer to > add this report into the software, could I commission a developer to add this > report in (or would it be too expensive), or is it not the type of report > that could be added in? > All the best, John > > ------------------------------------------- > John Robins > > USA: +1 (863) 397-3646 > UK: +44 (783) 788-8246 > UAE: +97 (150) 651-6381 > Skype: john_robins > Web: www.newzpoint.com > > On 6/3/18 07:51, David T. via gnucash-user wrote: >> Indeed. And once your data are in a spreadsheet, you can run all sorts of >> sophisticated functions on it. ;) >> >> David >> >> >>> On Jun 3, 2018, at 10:07 AM, Adrien Monteleone >>> <adrien.montele...@lusfiber.net> >>> wrote: >>> >>> John, >>> >>> I’ll have to interpret a bit, but my guess is you want a report that shows >>> multiple months worth of P&L data, consolidated with each month in it’s own >>> column. (and maybe even a YTD or QTD column at the end) >>> >>> There is no such report. >>> >>> You can run a multi-column report and put each column as a different >>> month’s P&L, but that will repeat the account name header column. >>> >>> More than likely, you’ll need to either export and import, or copy/paste >>> individual months into a spreadsheet and work from there. (a simple >>> select-all, copy/paste is usually sufficient) >>> >>> Regards, >>> Adrien >>> >>> >>>> On Jun 2, 2018, at 10:51 AM, John <j...@newzpoint.com> >>>> wrote: >>>> >>>> Hi. >>>> >>>> I have been looking through the report options and help files and I am >>>> unable to work out how to create a month by month profit and loss >>>> spreadsheet. Is this possible? and if so, do I need to download and >>>> install a plugin of some kind. >>>> >>>> Many thanks, John >>>> >>>> ------------------------------------------- >>>> John Robins >>>> >>>> >>>> <https://www.newzpoint.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. >>>> >>>> >>> >>> _______________________________________________ >>> 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.
