report writer needed: cash available

[Tom Yates]

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

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?

> 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?


-- 

   Tom Yates
   Cambridge, UK.