Your welcome David,

On the issue with having to ‘adjust rows’ for differences in categories, 
consider the option to show zero balance accounts so all accounts will display 
and run reports for both periods followed by a copy/paste to a spreadsheet.

Then if you have any zero balance accounts that are common to both periods, you 
can delete those rows easily in the spreadsheet. (if desired)

This will leave you with both periods lining up, some accounts will have 
amounts in only one period of course, but this process is much faster than 
adding and removing rows individually or moving data up and down to accommodate 
additional accounts one by one.

Regards,
Adrien

> On Sep 28, 2018, at 10:56 AM, <davidbrown.r...@photos.bozeat.biz> 
> <davidbrown.r...@photos.bozeat.biz> wrote:
> 
> Thank you for your note Adrien .... I thought that using "children" accounts 
> gave that sort of output.  It was something I had read and not know where 
> that was.  It is the auto bit I want, not CC and paste all the time.
> 
> Obviously only perhaps needed in a Profit and Loss OR the Income & 
> Expenditure to give the last year column on the LH side.
> 
> Its OK say copy and paste into an Excel Sheet, and that the categories are 
> the same otherwise it means shuffling some part rows down to accommodate a 
> new year with additional categories.
> 
> Await the new version!!  ... must say I do enjoy using the App anyway ....
> 
> Kind regards
> 
> DAvid
> 
> -----Original Message-----
> From: gnucash-user 
> <gnucash-user-bounces+davidbrown.rdps=photos.bozeat....@gnucash.org> On 
> Behalf Of Adrien Monteleone
> Sent: 27 September 2018 20:03
> To: Gnucash Users <gnucash-user@gnucash.org>
> Subject: Re: [GNC] Report ROWS
> 
> Not sure how this relates to the original post, but you have a couple of 
> options.
> 
> 1. Run a separate report for each period, copy/paste the contents of each 
> into a spreadsheet, adjust as needed.
> 2. Run a multi-column report, put each period in its own column. This however 
> will duplicate the account names, so if you don’t want that, you’ll still 
> need to copy/paste the result into a spreadsheet to adjust as desired.
> 
> Note, there will likely be a new Balance Sheet/Income Statement report in 
> version 3.3(due in October) or 3.4. This new report is supposed to properly 
> generate multiple periods in the same report.
> 
> Regards,
> Adrien
> 
>> On Sep 27, 2018, at 5:52 AM, <davidbrown.r...@photos.bozeat.biz> 
>> <davidbrown.r...@photos.bozeat.biz> wrote:
>> 
>> I have been using GNU cash now for just over a year and now into 2nd year.  
>> Have been trawling through the help files but yet to find the explanation.  
>> I want to provide the EndOfYear reports with last year figures on the LH 
>> side.  Wondering whether this works with just one type of report or with a 
>> number of them?
>> 
>> Kind regards
>> 
>> DAvid
>> 
>> _______________________________________________
>> 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.

Reply via email to