[GNC] Profit and Loss Spreadsheet

David T. sunfish62 at yahoo.com
Sun Jun 3 02:51:26 EDT 2018


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.monteleone at 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 <john at 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 at 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 at 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.



More information about the gnucash-user mailing list