How to make a "custom" expense report [was Re: Report customization nightmare]

Geert Janssens janssens-geert at telenet.be
Fri Jul 2 09:36:52 EDT 2010


People,

I would really like to close this discussion. I believe everything there is to 
say has been said.

Summary:
1. In general: the term custom report is confusing.
- It is used to indicate a report written in scheme that was not distributed 
as part of the GnuCash project and has to be installed separately.
- It is also used to refer to a standard GnuCash report which has its options 
set differently from the standard configuration. Such a custom report can be 
generated from within GnuCash itself and be saved under Reports -> Custom for 
later reuse.
- And lastly it is sometimes also used to refer to standard GnuCash report, 
but with a custom layout (a modified stylesheet).

2. The reports distributed with GnuCash by default cover a large part of what 
one wants to be reported. Many customization questions are the result of a 
lack of documentation on how the reports can be customized to fit a particular 
need.

3. There are certainly corner cases that aren't covered by the standard 
reports. Here are some options to deal with this:
- You can find a report that can be configured to come close and live with the 
imperfections; optionally post-process the report in another tool.
- You can also learn scheme and write the report you need. You are also 
cordially invited to share your work with other GnuCash users, either by 
having the report included in GnuCash by default, or by publishing it 
somewhere and explain how it can be installed.
- If coding isn't your thing, you can find someone willing to do it for you. 
This will require some form of negotiation for a price or for willingness to 
spend time (yes, even free work has to be negotiated in the form of how do you 
get the other party interested in doing it).

4. Changing the layout of reports is currently very limited. There are gradual 
improvements coming up in the future 2.4 release. Depending on how much you 
wish to change the layout, this may require knowledge of html and css.

5. Particularly regarding the request for an expense summary.
a. The current Income Statement report comes very close to the goal of 
displaying only expenses, but not 100%. With proper option configuration, you 
will only still have the superfluous profit/loss line at the bottom.
b. There is an alternative way to get to the goal using the transaction 
report, removing all display options, except for Totals.
c. The Income Statement was never written with this specific goal in mind, so 
for developers it's a case of "works as designed"
d. From a user's perspective, it would be great if the report could be 
slightly tweaked to achieve the goal anyway, so essentially there is an 
enhancement request on behalf of the users.

For your information, I have written this enhancement request. You can read it 
and comment on it here:
https://bugzilla.gnome.org/show_bug.cgi?id=623381
Please continue any discussion on this particular issue there.

I hope we can now focus on other discussions.

Geert


More information about the gnucash-user mailing list