Grand Total in Transaction report

Maf. King maf at chilwell.net
Fri Jul 20 06:20:25 EDT 2012


On Fri 20 July 12 08:49:48 Sutton Hill Church wrote:
> Dear Maf
> 
> This file is only for recording what the donors give me, as I can quickly
> generate individual reports for each donor, when it is time for me to claim
> back the tax.
> 
> I have been using Microsoft Access to do the same thing, but using the split
> transaction and auto fill facility in gnucash has made it quicker for me.
> 
> I then enter the total figure for the day into the Cash Account in the main
> Income/Expense file for the club financial reports i.e. Profit & Loss Report
> and Balance Sheet.
> 
> Regards


Hi,

Ahh, I see.  This isn't a complete financial record, but internal workings.  
that makes more sense now.

GC tries to be clever with the account types and which side of the accounting 
equation they are supposed to be on.  You are reporting on the break-down of 
the cash, the money doesen't really change type here, as you have it in 
envelopes and you have it as a total.  It isn't income (new money) becoming an 
asset (money you have).  Both sides of the transaction are assets.

the default report options swap the sign of the Income account (or possibly 
all the envelopes) to try to be most useful in the general case, but here, you 
don't have income, you have asset in one form and want it in another (broken-
down) form.  

Try changing the type of the account income to Cash (the same as the 
envelopes).  I know it seems counter-intuitive, but if the money doesn't 
change "type", nor should the accounts

The other way you can get a sensible result is to tell the transaction report 
not to change the sign (options  [Display] Sign Reverses -> None) 
(ie. GC you are being too clever. I'm human and I'm right even when you think 
I'm wrong...)

Hope that makes sense - it is more or less clear in my head, but not sure how 
well it comes across in the email!

Maf.



More information about the gnucash-user mailing list