Report Generation Question

[Matthew Lybanon]

Thanks for your suggestions.  The Account Report on a filtered (to choose the date range) account register gives me what I want except for the starting and ending balances on separate lines.  I had already thought of using a word processor to do some post-processing, but a spreadsheet is even better.  And I'll follow your suggestion to create an enhancement request.


Begin forwarded message:

> From: Geert Janssens <janssens-geert at telenet.be>
> Subject: Re: Report Generation Question
> Date: November 18, 2013 11:41:02 AM CST
> To: gnucash-user at gnucash.org
> Cc: Matthew Lybanon <lybanon at earthlink.net>
> 
> Hi Matthew,
>  
> I didn't see a reply to your question so far, so here's my stab at it.
>  
> The report as you ask *exactly* doesn't exist in GnuCash as far as I know. There is no transaction report that will show a starting balance at the beginning of the report. This looks like a useful improvement to me. Can you create an enhancement request in our Bugzilla for this ? (More info on Bugzilla: http://wiki.gnucash.org/wiki/Bugzilla)
>  
> Another report that will get you close is GnuCash' own version of the "Register report". You can get this by opening an account register and then select "Reports"->"Account Report". It still won't show a starting balance though. To only report on a limited set of transactions you can apply a filter or search on your account register and then call "Account Report" on the filtered register/search result register.
>  
> Other than that what you could do is generate the report in GnuCash and then copy the generated report into LibreOffice Calc/Microsoft Excel and do some post processing.
>  
> Geert
>  
> On Wednesday 13 November 2013 16:29:05 Matthew Lybanon wrote:
> > I would like to produce a report from GnuCash that shows transactions
> > from one account in the following format:
> > 
> > ----------
> > Title
> > 
> > From <date 1> to <date 2>
> > 
> > Starting balance:     $—
> > 
> > transaction 1
> > transaction 2
> >      …
> > 
> > Ending balance:     $—
> > ----------
> > 
> > The treasurer (a former accountant) in a club I belong to generates
> > reports like this (using different software), and calls each a
> > "register report."
> > 
> > I can't figure out how to do this using GnuCash's built-in reports,
> > and I'm probably not competent to design a custom report.  I can get
> > almost what I want from a General Ledger report or a Transaction
> > Report that shows a running balance.  The biggest problem is showing
> > the starting balance.  If any of the built-in reports can show that,
> > I would appreciate some details.
> > 
> > I could probably accomplish what I want by entering dummy transactions
> > of $0.00 at the beginning and end of the reporting period (even that
> > wouldn't give me starting and ending balances on lines separate from
> > the list of transactions), but I would like to find out a cleaner
> > way.
> > 
> > I'm new to the list, and I realize this question may already have been
> > answered.  I would appreciate any help.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > 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.
>