Grand Total in Transaction report

Sutton Hill Church shchurch at visitnz.plus.com
Fri Jul 20 16:44:55 EDT 2012


Thanks Maf

Changing the Sign Reverses --> none has done the trick.

But can you tell me now, how I can display the sum total value for each
group of envelopes?

Regards

-----Original Message-----
From: Maf. King [mailto:maf at chilwell.net] 
Sent: 20 July 2012 11:20
To: Sutton Hill Church
Cc: gnucash-user at gnucash.org
Subject: Re: Grand Total in Transaction report

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.



-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2178 / Virus Database: 2437/5142 - Release Date: 07/19/12



More information about the gnucash-user mailing list