That would be an ideal report and there have been many requests for it on this list over the years. (I was one of those) I think something like this is in the works and might even be available for further testing in the next release. (If I remember the thread correctly)
For now, you can use the Budget Report and simply not show the budget amounts, just show the actuals. You can even get your YTD column as the ’Totals’ column if you like. You can then export this to a spreadsheet for further manipulation and formatting as desired. Alternatively, you can run each period separately and export to a spreadsheet and then combine them. If you choose to always show all accounts, even those with a zero balance so that the rows match, you can pull in the individual periods and have the ‘master report’ on its own sheet tab that simply is a set of references to the individual period reports that are in their own sheets. It would of course take some time to set up but then would be a fairly quick process after that. (you can also set up a single period on your master report with the cell references, then ‘fill’ across to the next 11 columns. Some spreadsheet apps are smart enough to update the relative references. Others, you simply select each column at a time and do a Find/Replace on the referenced sheet name.) Regards, Adrien > On Jun 17, 2019, at 10:32 AM, Jimmy R via gnucash-user > <gnucash-user@gnucash.org> wrote: > > Sorry for posting her, I tried Dev but never showed up > > A yearly report selectable by year or range of the year > 13 columns 1 for accounts and 12 for Jan thru Dec > > Be able to export to csv > > I know there is a basic layout is in budgets but we don't need the budget > amounts > > No graphics needed we can use Libreoffice or Excell if we need it > > No grand totals needed can be done in Libreoffice or Excell > > Thank You _______________________________________________ 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.
