Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
Michael 4 sets of books is possibly overkill and likely confusing. At worst you would need two, one for the club operations and one for charity. Depending on the legislation of charities/non-profits in your jurisdiction if the charity is an operation of the club you may be able to get away with one set of books, just clearly separating the income, expense, assets, liabilities and equity of each operation under sub accounts of each top level account. It would require care in not mixing the club and charity operations that may be simpler The legal requirements however take precedence over convenience Whether your members issue you with a single check for their membership fees and charitable donations or provide you with separate checks for the fees and charitable donations is another factor. If you have to transfer funds from your club bank account to the charity bank account it will be a simpler operation to record in a single set of books. Alternatively, in the former case with separate books for the charity and club you could have a clearing account in your club records to record the component of checks which was donations to the charity on banking of the cheques and then the withdrawal from the club account and deposit to the charity account. If you need to track who donated what then using their name in the description field will allow you to run a transaction report on your income: fees account to produce a statement. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] crashing trying to do a simple split
On Fri, Aug 2, 2019 at 3:13 PM David Cousens wrote: > > Mark > If GnuCash can open and read the datafile it is unlikely to be a corrupted > datafile. It could be a library file for Gnome GTK used in the UI has become > corrupted if the problem occurs while trying to display a menu. A complete > reinstall should fix that. Thanks David Cousens, Maybe that was it. On the original computer where this happened, I did the following: 1. Switched from my USB keyboard back to my bluetooth keyboard because the numlock key was acting weird. 2. Ran Windows Update, which installed a cumulative update. 3. Printed a PDF of the PDF of the receipt I was looking at in Adobe Acrobat while I was trying to enter this transaction, because somehow every time I opened the original PDF it automatically opened the print dialog, and that was weird. Now it works. I bet it was #2. No more errors in the Event Viewer. Thanks? :-) -Mark ___ 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.
Re: [GNC] crashing trying to do a simple split
Mark If GnuCash can open and read the datafile it is unlikely to be a corrupted datafile. It could be a library file for Gnome GTK used in the UI has become corrupted if the problem occurs while trying to display a menu. A complete reinstall should fix that. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] crashing trying to do a simple split
Because GnuCash is built with Gnome libraries to generate the UI. Regards, Adrien > On Aug 2, 2019, at 2:57 PM, Mark Hedges via gnucash-user > wrote: > > Hello, > > I don't know what the deal is. I will test today using the same file from > a different computer. > > It's possible my filesystem in the first computer has become corrupt. It's > overdue for a disk wipe at the Microsoft store. > > Seems like it has something to do with drawing the menu of transfer > accounts. Why does it reference a gnome library in Windows 10? > > -- > Mark Hedges ___ 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
Thanks for the clarification and explanation. Posts like this are an excellent example of how useful this list is. Regards, Adrien > On Aug 2, 2019, at 2:18 PM, Mike or Penny Novack > wrote: > > On 8/2/2019 1:21 PM, Adrien Monteleone wrote: >> Yes, I understand they are different. The Business Features *could* still be >> used, just not considered in a formal way. >> >> But certainly, manual entries are possible. >> >> The tough part of pledges is they really don’t go anywhere in the account >> tree that I can see. >> >> They are not assets, not AR from a legal standpoint, not liabilities, not >> income, and since none of those, not equity either. Perhaps they should be >> tracked separately since trying to do so in GnuCash requires shoehorning >> something of the app to fit. But if one likes using shoehorns... >> >> Regards, >> Adrien > Sorry, but PLEDGES (unlike membership dues, etc.) are receivables. But only > according to the terms of the pledge. If you pledge $X (unconditionally) that > is a current receivable of $X. If you pledge $X in each of the years 2019, > 2020, and 2021 then only $X is receivable now, $X more becomes receivable > after Jan 1, 2020, etc. > > Membership dues are not receivable when billed because legally a member can > quit at any time. Rules of the organization may require notice, permission to > demit, etc. but are not enforceable unless the member later seeks to rejoin. > > HOWEVER --- charities and other non-profits rarely seek to enforce pledges > because except in the circumstances where would not cause bad publicity. Thus > if somebody (who clearly had the money) pledged 10 million to their college > endowment fund but dropped dead of a heart attack before sending it they > probably WOULD approach the executor of the estate asking for it. But might > not go to court if turned down. > > Michael D Novack > > PS: This is the reason why charities, etc. like to have you make a pledge > (and set up automatic payment) of $Y/month. Because it IS then a receivable > for them. ___ 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.
Re: [GNC] crashing trying to do a simple split
Hello, I don't know what the deal is. I will test today using the same file from a different computer. It's possible my filesystem in the first computer has become corrupt. It's overdue for a disk wipe at the Microsoft store. Seems like it has something to do with drawing the menu of transfer accounts. Why does it reference a gnome library in Windows 10? -- Mark Hedges CEO Weird Vibe Inc. -please forgive mobile typos- On Fri, Aug 2, 2019, 6:28 AM Derek Atkins wrote: > David, > > David Carlson writes: > > > Derek, Mark indicated that he was using either 3.5 or 3.6 in Windows 10. > > He did in his original message, which I didn't look at; I only looked at > his second message, which didn't quote that portion. That's why I > asked. > > Mea Culpa. > > -derek > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > ___ 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
On 8/2/2019 1:21 PM, Adrien Monteleone wrote: Yes, I understand they are different. The Business Features *could* still be used, just not considered in a formal way. But certainly, manual entries are possible. The tough part of pledges is they really don’t go anywhere in the account tree that I can see. They are not assets, not AR from a legal standpoint, not liabilities, not income, and since none of those, not equity either. Perhaps they should be tracked separately since trying to do so in GnuCash requires shoehorning something of the app to fit. But if one likes using shoehorns... Regards, Adrien Sorry, but PLEDGES (unlike membership dues, etc.) are receivables. But only according to the terms of the pledge. If you pledge $X (unconditionally) that is a current receivable of $X. If you pledge $X in each of the years 2019, 2020, and 2021 then only $X is receivable now, $X more becomes receivable after Jan 1, 2020, etc. Membership dues are not receivable when billed because legally a member can quit at any time. Rules of the organization may require notice, permission to demit, etc. but are not enforceable unless the member later seeks to rejoin. HOWEVER --- charities and other non-profits rarely seek to enforce pledges because except in the circumstances where would not cause bad publicity. Thus if somebody (who clearly had the money) pledged 10 million to their college endowment fund but dropped dead of a heart attack before sending it they probably WOULD approach the executor of the estate asking for it. But might not go to court if turned down. Michael D Novack PS: This is the reason why charities, etc. like to have you make a pledge (and set up automatic payment) of $Y/month. Because it IS then a receivable for them. ___ 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.
[GNC] Loan and Mortgage scheduler | Escrow account for Tax rounds monthly payment up
The title pretty well says it all, except I don't want it to round up, I want the exact amount I entered. I entered USD 192.68, but GNUCash rounds up to USD193.00. I can supply screen shots if necessary. Version 3.6+(2019-06-29) on Fedora 29, all patches up to date. -- 73 de Jim, KD1YV ___ 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
Yes, I understand they are different. The Business Features *could* still be used, just not considered in a formal way. But certainly, manual entries are possible. The tough part of pledges is they really don’t go anywhere in the account tree that I can see. They are not assets, not AR from a legal standpoint, not liabilities, not income, and since none of those, not equity either. Perhaps they should be tracked separately since trying to do so in GnuCash requires shoehorning something of the app to fit. But if one likes using shoehorns... Regards, Adrien > On Aug 2, 2019, at 7:09 AM, Mike or Penny Novack > wrote: > > On 8/2/2019 3:34 AM, Adrien Monteleone wrote: >> I’m not sure about keeping track of member donations in an Asset account. >> > There are difficult issues doing financials for non-profits which can require > some fiddling using gnucash (or any alternative). > > For example -- the members may want to receive "statements" (invoices) and > want these to reflect a unified statement (membership as well as pledges) BUT > membership dues are NOT a receivable for such organizations < keeping books on a cash basis, but more important, a member can withdraw at > any time, does not OWE the billed dues. They DO owe pledges, but only > according to the terms of the pledge* >> > > ONE solution is to bite the bullet and keep multiple books for different > purposes. Main books on a cash basis NOT tracking members but just the source > of the income (dues, donations, pledges, etc.) and the other used just to be > able to invoice and track which members have paid, etc. In the example > situation above where members may contribute (get credited for contributions > actually made by others) that is another level of complexity. > > Michal D Novack > > * Thus if a pledge is $5000 in the form of $1000 a year for five years they > do not owe $5000 immediately ___ 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
I’m not quite following the need to keep the members in a separate book, especially in the Club case. But since you are already doing this in spreadsheets, maybe just keep the member stuff there (with better inter-sheet links if needed) and export data relevant to the GC books. That would keep your needed books at ‘2’ —one for the club, one for the charity. Regards, Adrien > On Aug 2, 2019, at 10:33 AM, Michael Hendry wrote: > > If I understand you correctly, this would involve my keeping four sets of > books: > > Club - members > Club - business of running the club > > Charity - members > Charity - business of running the charity > >> In the example situation above where members may contribute (get credited >> for contributions actually made by others) that is another level of >> complexity. > > >> >> Michal D Novack >> >> * Thus if a pledge is $5000 in the form of $1000 a year for five years they >> do not owe $5000 immediately > > I wish I had such a problem to deal with! > > Thanks, > > 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
Don’t forget to copy the list, this came in only to me. > On Aug 2, 2019, at 3:48 AM, Michael Hendry 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
> On 2 Aug 2019, at 13:09, Mike or Penny Novack > wrote: > > On 8/2/2019 3:34 AM, Adrien Monteleone wrote: >> I’m not sure about keeping track of member donations in an Asset account. >> > There are difficult issues doing financials for non-profits which can require > some fiddling using gnucash (or any alternative). > > For example -- the members may want to receive "statements" (invoices) and > want these to reflect a unified statement (membership as well as pledges) BUT > membership dues are NOT a receivable for such organizations < keeping books on a cash basis, but more important, a member can withdraw at > any time, does not OWE the billed dues. They DO owe pledges, but only > according to the terms of the pledge* >> Fortunately, our members don’t want to receive invoices or statements of any sort, and they don’t make pledges - except perhaps in that they undertake to dine at another member’s house at some future date, and make a payment to the club’s charity account. > > ONE solution is to bite the bullet and keep multiple books for different > purposes. I have one file for the club, and one for the charity - the bank accounts must be kept separate, and I think it’s important for me to be wearing a “club” hat or a “charity” hat in dealing with the bookkeeping. > Main books on a cash basis NOT tracking members but just the source of the > income (dues, donations, pledges, etc.) and the other used just to be able to > invoice and track which members have paid, etc. If I understand you correctly, this would involve my keeping four sets of books: Club - members Club - business of running the club Charity - members Charity - business of running the charity > In the example situation above where members may contribute (get credited for > contributions actually made by others) that is another level of complexity. > > Michal D Novack > > * Thus if a pledge is $5000 in the form of $1000 a year for five years they > do not owe $5000 immediately I wish I had such a problem to deal with! Thanks, 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.
Re: [GNC] crashing trying to do a simple split
David, David Carlson writes: > Derek, Mark indicated that he was using either 3.5 or 3.6 in Windows 10. He did in his original message, which I didn't look at; I only looked at his second message, which didn't quote that portion. That's why I asked. Mea Culpa. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
On 8/2/2019 3:34 AM, Adrien Monteleone wrote: I’m not sure about keeping track of member donations in an Asset account. There are difficult issues doing financials for non-profits which can require some fiddling using gnucash (or any alternative). For example -- the members may want to receive "statements" (invoices) and want these to reflect a unified statement (membership as well as pledges) BUT membership dues are NOT a receivable for such organizations> ONE solution is to bite the bullet and keep multiple books for different purposes. Main books on a cash basis NOT tracking members but just the source of the income (dues, donations, pledges, etc.) and the other used just to be able to invoice and track which members have paid, etc. In the example situation above where members may contribute (get credited for contributions actually made by others) that is another level of complexity. Michal D Novack * Thus if a pledge is $5000 in the form of $1000 a year for five years they do not owe $5000 immediately ___ 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.
Re: [GNC] Club membership fees and charitable contributions - Business Features or Assets?
I’m not sure about keeping track of member donations in an Asset account. Sure, the donation is an asset of the club. That would go to Cash or Checking, etc. But the other side of that should be some sort of Income account I would think. With the Business Features you could set up each member as a ‘customer’ and use the Customer Report to tally their period/annual donations. This would also allow you to easily track the annual subscriptions if you ‘invoice’ them. (you don’t need to send actual invoice, just create and post them) 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. 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) 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. Regards, Adrien > On Aug 2, 2019, at 1:50 AM, Michael Hendry wrote: > > I have just become Treasurer for my Rotary Club, and my predecessor used > spreadsheets to record the club’s finances. > > Everyone is required to pay an annual subscription, but there are a number of > ways in which members may opt in to regular or occasional charitable payments > (e.g. an annual subscription to a monthly Bottle Draw or “Foundation Meals”, > where a member hosts a dinner party and the club receives donations from the > guests, destined for the Rotary Foundation charity). > > We can reclaim tax at 25% of the value of the charitable donations in the > form of Gift Aid, but it is necessary to keep track of who paid what in order > to make the necessary annual claim. Separate spreadsheets are currently used > to keep track of these payments, but they’re not linked to the other > spreadsheets - with the attendant risks of missed or duplicate entries. > > I think that the Business Features of GC are probably overkill, and am > looking at having an Assets:Members:member_name account for each member, > primed with (e.g.) the Annual Subscription at the beginning of the Rotary > year, and with optional entries at the time of opt-in to the charitable > donations. > > I’d appreciate the thoughts of the group, especially from anyone who’s tried > either (or both) the Business Features and the Assets approach. > > 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.
[GNC] Club membership fees and charitable contributions - Business Features or Assets?
I have just become Treasurer for my Rotary Club, and my predecessor used spreadsheets to record the club’s finances. Everyone is required to pay an annual subscription, but there are a number of ways in which members may opt in to regular or occasional charitable payments (e.g. an annual subscription to a monthly Bottle Draw or “Foundation Meals”, where a member hosts a dinner party and the club receives donations from the guests, destined for the Rotary Foundation charity). We can reclaim tax at 25% of the value of the charitable donations in the form of Gift Aid, but it is necessary to keep track of who paid what in order to make the necessary annual claim. Separate spreadsheets are currently used to keep track of these payments, but they’re not linked to the other spreadsheets - with the attendant risks of missed or duplicate entries. I think that the Business Features of GC are probably overkill, and am looking at having an Assets:Members:member_name account for each member, primed with (e.g.) the Annual Subscription at the beginning of the Rotary year, and with optional entries at the time of opt-in to the charitable donations. I’d appreciate the thoughts of the group, especially from anyone who’s tried either (or both) the Business Features and the Assets approach. 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.
