[GNC] Custom Report

Adrien Monteleone adrien.monteleone at lusfiber.net
Thu May 9 20:28:04 EDT 2019



> On May 9, 2019, at 6:58 PM, Jimmy R via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> Te easiest way is export account summery BUT html is only available, you can
> drag the html in excel and easily copy and paste. Not as easy with the P/L
> The problem with that account summery report you cannot select a month, date
> range, etc in options.

Excel might be a problem, but LibreOffice has no issues either opening saved GnuCash reports, or importing them as plain text. (copy/paste also works) The only issue with doing comparative P&L’s in a spreadsheet is that each period needs to have all accounts visible so things line up easily, otherwise you’ll have lots of formatting to do.

And how would an account summary be the easiest way to accomplish a P&L? (you’d have to run one for each and every account) There’s already a P&L report and you can set whatever date range you like.

> 
> I find it troubling that there is no monthly report for the year. You can
> use a budget but you have to enter budget numbers for account totals to
> show.

I don’t think so. You have to create a budget, but I’m pretty sure you don’t have to populate it to get actuals to be visible. I tried this not long ago.

> 
> It would be nice to alter the budget report just to show the monthly totals
> fro the accounts and export it

Perhaps I’m thinking of something different, but I can run a budget report using just parent accounts and get monthly amounts. Could you provide an example of what you are looking for?

Regards,
Adrien


More information about the gnucash-user mailing list