report writer needed: cash available

[Derek Atkins]

Hi,

Quoting Tom Yates <madlists at teaparty.net>:

> On Sun, 24 Sep 2006, Derek Atkins wrote:
>
>> Just so I understand what you're asking -- you want to take a look
>> at a particular expense account and you want to get totals of that
>> particular expense based on the Transaction Description?
>
> derek:
>
> thanks for the response!
>
> the church's weekly banking run, in the current account, appears as a 
> giant split transaction - usually 30-40 small credits, each of which 
> balances with another account (usually an income account, but not 
> always).
>
> what i want is a report i can run against an income account, which 
> will summarise the income by the memo field appearing in the split 
> transaction in the current account.
>
> let me see if a short example helps:
>
> suppose i have a weekly banking run transaction, made on 13/1/06, for 
> a total credit of 300.00 (description field: weekly banking).  this 
> is a split transaction, breaking down:
>
> AMOUNT	BALANCING ACCOUNT		MEMO FIELD
> 150.00	childrens home			collecting box
> 85.00	new building fund		liz brown
> 65.00	new building fund		steve bloggs
>
> i see that my new building fund account is now showing a total income 
> of 150.00, but in the account view, all i see is
>
> 85.00	weekly banking
> 65.00	weekly banking

There's an open RFE that asks for an option to display the Split Memo
instead of the Transaction Description in this spot of a Split Transaction.

> what i want is a report i can run on the building fund account which 
> will print out:
>
> 13/1/06	85.00	liz brown
> 13/1/06	65.00	steve bloggs
>
> if, in addition, it could either sort by that MEMO field (the donor's 
> name), that would be even better.
>
> is that any clearer?

So you just want to see the Split Memos with the itemized listings?
Or do you want subtotals based on that too?

>> The transaction report can ALMOST do this -- there's an option to 
>> "sort" by a secondary key (e.g. the Description), and there appears 
>> to be an option to make subtotals Secondary Subtotals (subtotals 
>> based on the secondary key), but that option seems to be greyed out. 
>>  If it weren't greyed out, it might do what you want.
>
> i've had a cursory look and can't find it.  is that in 1.8.12, or is 
> it a gnucash-2 feature?

I don't know.  I don't have 1.8 handy, I only looked at 2.0.  Did
you look in the Sorting page of the Report Options of the Transaction
Report?

-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/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available