Whenever I've wanted something that reporting couldn't do (GNUCash and many others), I've generally created a report that had all of the data (columns, rows) and dumped them to a spreadsheet. This many have done.
After that, I chop out the rows of dross and make sure it looks right and then paste it into another workbook which I've previously created and which has a second sheet that uses formulas to place the wanted data into a formatted report that I can then print from the spreadsheet. Sometimes I've gone to the length to create lookup tables (for translations and such) and even 'macro' sheets (VBS type usually) and a button on the target sheet called something like 'Generate'. This is only useful if the report is needed frequently/regularly but it does generate a nice looking report and, after getting it set up, it works pretty well without much intervention. I've even given a few of these to staff to use to simplify their reporting (taxes, etc). Now that I've retired I no longer need anything so intricate so I simply generate a basic report and type in the few numbers into a 'source' sheet and then print the destination sheet that has the requisite formatting. Good luck & Blessings all, -g -----Original Message----- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte....@gnucash.org] On Behalf Of flywire Sent: Tuesday, January 21, 2025 3:09 PM To: Gnucash Users Subject: [GNC] Simple report(s) wanted Nice question for a basic and most common need. > You need two reports and the standard report versions will likely do what you require: Balance Sheet, Income Statement > You might be able to get both [current/previous period] Balance Sheet on one page with the multi report section. I have not tried that. Elsewhere Balance Sheet reports normally report previous/current periods. Has anyone successfully generated this in GnuCash rather than a spreadsheet hack? My take on OP's request is an Itemised Profit and Loss report. (Let's ignore the inconsistencies in report menus, names and headings.) This is something GnuCash can't do because the Transaction Report has a very different engine to the Balance Sheet and Profit and Loss Reports. The Transaction Report generally has more capability, things like filters, which are not available in other reports. iirc the last time I raised using a consistent report engine the developer response was the effort would be better spent completely replacing the reporting module. Open source offerings are limited. I worked through LibreOffice Base with a sqlite connection but unlike the other modules it is very undeveloped and buggy without any development resources. A nice python framework was developed but development stopped as it got to the Base module. Straight SQL might be best. Any thoughts? Alternate user-focused reporting using SQL could be developed without impacting anything currently done by GnuCash developers. Regards _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- 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 ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
