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

Michael Hendry hendry.michael at gmail.com
Tue Aug 27 13:08:55 EDT 2019


> On 27 Aug 2019, at 16:10, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> 
> 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.

Having a quick look at this option, exported some invoices, edited them (to change Customer’s name, which had appeared in the Description column) and tried to import, but nothing came up in the Preview apart from the headers.

I think this may be something to do with the UTF-8 problem I’ve recently come across with imports of names with acute accents in them. This time it’s the pound sign (“£”) that is the cause of trouble - if I change it to a dollar-sign the preview comes up OK but the import still fails, on the basis that there is no such customer.

Documentation on the export/import procedure for invoices is scant and hard to find.

Nonetheless, his sounds like a promising approach to what would be a tedious process if done by hand.

Thanks, Adrien, you’ve been a great help!

Michael

> 
> 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
> 
> _______________________________________________
> 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.





More information about the gnucash-user mailing list