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

Adrien Monteleone adrien.monteleone at lusfiber.net
Tue Aug 27 11:10:59 EDT 2019


You can also import invoices. So if you find the duplication-post workflow tedious, you could set up a spreadsheet with the invoice data ready to import. Then each dinner, edit the amounts, export from spreadsheet to CSV, import the CSV into GnuCash. For the next dinner, bring up the spreadsheet again, edit the amounts, rinse-repeat.

If the amount(s) that need to be edited are the same for each member, you could either have a master sheet where you chance just those numbers and they get pulled to the ‘invoice’ sheet, or else just do a Find/Replace if it is that simple.

Regards,
Adrien

> On Aug 27, 2019 w35d239, at 5:30 AM, Michael Hendry <hendry.michael at gmail.com> wrote:
> 
> 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



More information about the gnucash-user mailing list