report writer needed: cash available

[Derek Atkins]

Okay, the Transaction Report CAN display the memo fields, but it
cannot create subtotals based on the memo fields.  So do this from
the Chart of Accounts page:

  [main menu] -> Reports -> Transaction Report

- Then click [Options]
- Then click on the [Accounts] tab and then select the accounts you want
  to display.  In this case you might want to just limit it to the
  particular income or expense account.
- Then click on the [Display] tab and make sure [Memo] is checked (it should
  be on by default).
- Then click on the [Sorting] tab and select how you want it sorted.
- Then click on the [General] tab and select the reporting dates.

Then click [Ok] and the report should load for you.   Hopefully this
is what you wanted.

-derek

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



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