[GNC] Questions

Stephen C. Camidge scamidge at fastmail.fm
Wed May 8 07:13:05 EDT 2019


Thank you to both of you. I have not figured out how to export to a spreadsheet - I tried but only could export to html, added a sum of the column, but the sum gave a total of $0.


-- 
Stephen C. Camidge             scamidge at fastmail.fm   (519) 363-3912

On Tue, May 7, 2019, at 11:44 PM, Christopher Lam wrote:
> Thanks Adrien.
> I've realised that unless the multicolumn report is merged into mainstream,
> it will never gain enough exposure for bug reports. So perhaps it'll be
> better to merge for 3.6 into an 'experimental' submenu within reports.
> C
> 
> 
> On Wed, 8 May 2019 at 13:24, Adrien Monteleone <
> adrien.monteleone at lusfiber.net> wrote:
> 
> > Stephen,
> >
> > Comparative-period P&L is not yet implemented in GnuCash. (but as Chris
> > Lamm noted, he has a testing version of the report that *might* fit your
> > needs - if you can try it, please do so)
> >
> > You *can* run a multi-column report with each period in its own column,
> > but it will get messy with each column having its own row headers, as
> > you’ve likely discovered. (you could set all columns to use all accounts,
> > show zero balance accounts, and then copy/paste or export to spreadsheet
> > and then manipulate from there)
> >
> > Probably an easier route is to maintain a spreadsheet of your P&L’s and
> > paste in each column every period. Be sure to include all account including
> > zero balance accounts so everything lines up on the proper rows in the
> > spreadsheet. (I use this method along with percentage and variance columns
> > that I add)
> >
> > Regards,
> > Adrien
> >
> > > On May 6, 2019, at 8:35 AM, Stephen C. Camidge <scamidge at fastmail.fm>
> > wrote:
> > >
> > > 2) Yes, I can get multi column reports with the Transaction Report, show
> > totals monthly by account, but it will not display monthly totals and it
> > will not display Revenue separately from Expenses with totals for Revenue
> > and for Expenses.
> >
> >
> > _______________________________________________
> > 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