Report Problem Since Updating Gnucash
Matthew Lybanon
lybanon at earthlink.net
Wed Sep 9 16:20:21 EDT 2015
Begin forwarded message:
> From: Matthew Lybanon <lybanon at earthlink.net>
> Subject: Re: Report Problem Since Updating Gnucash
> Date: September 4, 2015 at 10:05:33 AM CDT
> To: Derek Atkins <warlord at MIT.EDU>
> Cc: gnucash-user at gnucash.org
>
>
>
> Begin forwarded message:
>
>> From: Derek Atkins <warlord at MIT.EDU <mailto:warlord at MIT.EDU>>
>> Subject: Re: Report Problem Since Updating Gnucash
>> Date: September 4, 2015 at 8:57:28 AM CDT
>> To: Matthew Lybanon <lybanon at earthlink.net <mailto:lybanon at earthlink.net>>
>> Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>>
>> Hi Matthew,
>>
>> Matthew Lybanon <lybanon at earthlink.net <mailto:lybanon at earthlink.net>> writes:
>>
>>> I’d appreciating some help in tailoring a Gnucash report—or choosing
>>> the correct report. Sorry about the length of this post.
>>>
>>> A club I belong to has an annual show that’s big enough to have its
>>> own account, and I’m the “show treasurer.” All I need to do is
>>> balance a checkbook—just income and expenditures, no salaries, taxes,
>>> investments, etc. For years I’ve used Gnucash very happily. The
>>> software is capable of a lot more than I use it for, and it does what
>>> I need very well.
>>>
>>> For a long time I stuck with an old version (2.4.13) of Gnucash. I
>>> recently upgraded to version 2.6.7, and everything is fine—except for
>>> one report. (I run Gnucash on a Mac under OS X 10.5.5, but I don’t
>>> think that has anything to do with the issue.)
>>>
>>> The report in question shows all the transactions (+ and -) for a
>>> month, in chronological order, with a running balance. Here is the
>>> beginning of a report generated by Gnucash 2.4.13 (I saved the html
>>> file on my hard drive), column headings and the first transaction:
>>> Date
>>> Description
>>> Transfer
>>> Deposit
>>> Withdrawal
>>> Balance
>>> 07/06/2015
>>> Check 1302 (details omitted)
>>> Expenses:Check
>>>
>>> $118.23 <gnc-register:split-guid=d372c061e18e55b63e9516bdeab75633%23>
>>> $13,536.49 <gnc-register:split-guid=d372c061e18e55b63e9516bdeab75633%23>
>>>
>>> (I apologize if the columns don’t line up.) The amount in the
>>> rightmost column is the checkbook balance after the transaction. And
>>> here is the beginning of the same report (for a later month) generated
>>> by Gnucash 2.6.7:
>>>
>>> Date
>>> Description
>>> Transfer
>>> Deposit
>>> Withdrawal
>>> Balance
>>> 08/06/2015
>>> Check 1303 (details omitted)
>>> Expenses:Check
>>>
>>> $4,036.00 <gnc-register:split-guid=1fcf319a36c92431d5e149e36bd67fbc%23>
>>> -$4,036.00 <gnc-register:split-guid=1fcf319a36c92431d5e149e36bd67fbc%23>
>>> While the earlier report shows the checkbook balance after the
>>> transaction in the rightmost column, the later report doesn’t. It
>>> shows the result of applying the transaction to a zero initial
>>> balance. (What’s more, I still have the old report in a tab in
>>> Gnucash. Instead of showing the checkbook balance after the
>>> transaction, as it did before, now the rightmost column of the old
>>> report shows the result of applying the transaction to a zero balance.
>>> I understand that Gnucash re-generates reports each time it starts
>>> up—which means now old reports have the same problem as new ones.)
>>>
>>> I’m obviously not a “power user” of Gnucash, but I’ll describe how I
>>> created the report. In the Gnucash tab that shows, in effect, the
>>> checkbook register (Assets:Current Assets:MyAccount), I choose Filter
>>> By… in the View menu. On the Date tab I choose Select Range/Choose
>>> Date, and enter the beginning and ending dates for the period I want.
>>> Then I choose Account Report from the Reports menu. I eliminate two
>>> columns I’m not interested in (Num and Memo), and there’s the report,
>>> showing the transactions for the selected period.
>>>
>>> As well as I can remember, that’s how I did it when I was running
>>> Gnucash 2.4.13. Can someone tell me what I need to do to have the
>>> “Balance” column show the running balance from the checkbook register,
>>> rather than what it shows now?
>>
>> Is this ia Custom Report (that you wrote?) or is this one of the GnuCash
>> reports? If the latter, which report?
>>
>> Thanks,
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>> --
>> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>> Member, MIT Student Information Processing Board (SIPB)
>> URL: http://web.mit.edu/warlord/ <http://web.mit.edu/warlord/> PP-ASEL-IA N1NWH
>> warlord at MIT.EDU <mailto:warlord at MIT.EDU> PGP key available
>
>
> Not a custom report. It’s one of the built-in GnuCash reports. Reports Menu: Account Report, after selecting the date range for which I want to see transactions.
>
I haven’t seen any further replies for several days. I hope my answer didn’t get lost. The report I’m having trouble with is one of the built-in Gnucash reports, not a custom report.
More information about the gnucash-user
mailing list