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