Don’t forget to copy the list, this came in only to me. > On Aug 2, 2019, at 3:48 AM, Michael Hendry <hendry.mich...@gmail.com> wrote: > >> >> You can easily duplicate invoices to reduce typing. You can also do some >> quick duplication in a spreadsheet, then import this data as ‘invoices’ into >> GnuCash, reducing even more work. > > Presumably I could create ordinary GC transactions in a spreadsheet too?
Sure, and you can use the importer which will also eventually learn your transactions and the import process will speed up over time since you won’t have to manually assign stuff during the process. > >> >> From a manual perspective, you’d have to create either another level of >> tracking, perhaps using manual AR entries against donation income. >> >> Work reduction could be accomplished with scheduled transactions, though >> you’d still need one for each member. There is also the ‘duplicate >> transaction’ function that might come in handy. >> >> As for reporting with manual transactions, you could utilize the Transaction >> Report and its filters to tailor the report to your needs. >> >> Finally, on the spreadsheet end, you could reduce data entry duplication and >> opportunity for errors using sheet/cell references to a master >> sheet/workbook. The master would get updated either upon opening or manually >> using an ‘update links’ function. (exists in Libreoffice Calc, I’m sure >> Excel has something similar) > > I’ve already come up against a problem with this with the files my > predecessor has passed on - the links refer to the directory structure on his > computer, not on mine. Yes, you’d have to update those links. You *should* be able to do this with the Find/Replace tool quite quickly though once you get straight what the current links should point to, you can update them for your own case. The simplest method would be to have one consolidated book with multiple sheets. Then you eliminate the directory structure issue. (the separation would be done in different GnuCash books, the spreadsheet is just for the dirty work) The next easiest approach is to put all of the workbooks in the same folder and keep them together. Then you only need the file name reference. Regards, Adrien > >> >> There are some people using GnuCash for non-profits on this list, hopefully >> they’ll see this and chime in with tips and pitfalls to watch out for. > > I’m confident there will be pitfalls! > > I’m planning to run the existing spreadsheets and GC files in parallel for > the first year, and see how they turn out. > > Regards, > > Michael > > _______________________________________________ gnucash-user mailing list gnucash-user@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.
