[GNC] Bookkeeping for a club's charity account - use business features?

elvis elvis at dogonfire.com
Tue Aug 27 17:29:38 EDT 2019


>> Hi Michael,
>>
>> This is how I would do it. I'm assuming you have around 30 people to account for.
>>
>> Make up all your accounts and sub accounts and sub sub accounts and cross accounts.
>>
>> Have a transaction in each person's account with all the splits possible.
>>
>> Each dinner copy the last transaction and alter the amounts. Maybe 20 seconds each so you are looking at about 15 minutes to update the whole.
>>
>>
>> I'm assuming your primary document is some kind of piece of paper your members fill out. If you have a spreadsheet on entry you would just massage it and import it.
>>
>> By the time you much around with business features you might as well just copy transactions.
>>
>>
>> Lawrence
> Thanks, Lawrence.
>
> The difficulty this suggestion doesn’t solve is in generating a report listing Gift-Aid-eligible totals for each member - the identity of the contributing member in each income account tree is at the twig level:
>
> Income:Destination1:MemberA
> Income:Destination2:MemberA
> Income:Destination3:MemberA
> etc
> fo

You would do a joint income account that goes to separate member 
balances that can be split up as to purpose.

The Gnucash reports are very flexible, the balance sheet should do that, 
it isn't really income it is a member balance which is an asset. I do 
the same thing for my super fund and it works a treat. I have used 
Gnucash for 12 years and I don't use the business features except for 
our big invoices, maybe 5 a month. Everything else I use something else 
and just post totals. Once you have clickey clacked 30 times to enter 
every invoice you will feel like punching the screen .



> all need to be picked up and added together for each destination and each member.
>
> The Customer-based model would ease that aspect.
>
> Unfortunately, there doesn’t seem to be a way of creating regularly repeated invoices as Scheduled Transactions, but I’m currently thinking along the lines of creating an invoice for each member for the default amounts at the beginning of the year, and then duplicating these invoices, one for each member for each meeting. After each meeting, I would edit each invoice if necessary (to deal with absences and variations in contributions) then post and pay them.
>
> This way the Destination accounts don’t need children and the annual Gift Aid Report can be populated from Customer Reports.
>
> I’ll do some experiments…
>
> Michael
>
>>> Thanks,
>>>
>>> Michael
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>
>
-- 
Somewhere out there is a company that has actually figured out how to enlarge penises, and it's helpless to reach
potential customers.



More information about the gnucash-user mailing list