Re: [GNC] Bookkeeping for a club's charity account - use business features?
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@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. ___ 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] Bookkeeping for a club's charity account - use business features?
> On 27 Aug 2019, at 16:10, Adrien Monteleone > 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 >> 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@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. ___ 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] Scrolling problem
Jonathan, Apparently you do not want to make additional effort to address your problem to make Gnucash usable. We cannot help you if you do not do your part in the debugging process. You have not mentioned whether this problem is in only one account view or every account view, whether it is also in the General Ledger view, or whether you have tried Colin's or Adrien's suggestions. If you open a register view and click View > Filter by.., exactly which button is marked on the Date tab, and is the Save box checked? Also, while you are there, under the Status tab, are all the boxes checked? Did you, or are you willing to try uninstalling and re-installing GnuCash. That is easy to do, but it may or may not help. Last, reply to group so we all can see your progress. David Carlson On Tue, Aug 27, 2019 at 7:02 AM Colin Law wrote: > Forwarding to the list as you accidentally replied to me instead of the > list. > You do not seem to have replied to the previous email from Adrien. > > Colin > > On Tue, 27 Aug 2019 at 12:36, Jonathan Silvey > wrote: > > > > I'm sorry if no one can solve this problem. I will probably have to > abandon Gnucash completely. Thanks for your help previously. > > Jonathan > > > > > > > > On Tue, 20 Aug 2019 at 22:56, Jonathan Silvey > wrote: > >> > >> Hi, > >> > >> Sorry about not replying to all. > >> > >> Click on a transaction and scroll up using the Up arrow and it shows > just one more transaction. > >> > >> It's been happening for several months now and if I changed anything > that might have triggered it, I can't remember doing so. > >> > >> > >> > >> Jonathan > >> > >> > >> > >> On Tue, 20 Aug 2019 at 21:13, Colin Law wrote: > >>> > >>> On Tue, 20 Aug 2019 at 20:53, Jonathan Silvey < > jonathan.sil...@gmail.com> wrote: > >>> > > >>> > Hi, > >>> > I have checked and all were already checked. > >>> > >>> You sent this to me and not to the list, you have to select Reply All > >>> or Reply List on this email list. I am forwarding it to the list > >>> here. > >>> What happens if you click on a transaction and then use the up arrow > >>> to scroll to the top and keep going? > >>> > >>> Has this just started happening? If so did anything happen that might > >>> have triggered it? > >>> > >>> Colin > >>> > >>> > > >>> > Jonathan > >>> > > >>> > > >>> > > >>> > On Tue, 20 Aug 2019 at 15:48, Colin Law wrote: > >>> >> > >>> >> Check in View > Filter By that in the Date tab that Show All is > >>> >> selected, and in the Status tab that all boxes are checked. > >>> >> > >>> >> Colin > >>> >> > >>> >> On Tue, 20 Aug 2019 at 15:18, Jonathan Silvey < > jonathan.sil...@gmail.com> wrote: > >>> >> > > >>> >> > I cannot scroll to transactions at an earlier date than what's at > the top > >>> >> > of the current screen. THis happens for any account. However, in > >>> >> > Reconciliation, the scrollbar moves correctly. The totals in > Accounts are > >>> >> > also correct. > >>> >> > > >>> >> > I use Windows10 and Gnucash Version: 3.5, Build ID: > 3.5+(2019-03-30). > >>> >> > > >>> >> > Can anyonne help, please? > >>> >> > Jonathan > >>> >> > ___ > >>> >> > 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. > ___ > 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. > -- David Carlson ___ 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] Bookkeeping for a club's charity account - use business features?
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 > 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@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] Bookkeeping for a club's charity account - use business features?
> \On Aug 27, 2019 w35d239, at 7:36 AM, Michael Hendry > wrote: > > > I was thinking Mike meant that there was something intrinsically incompatible > with cash-based accounting which happened when Business Features were added. > But you’re saying that it’s only if there are posted and unpaid invoices > outstanding at year-end that this is a problem. Even more precisely, it is only a problem if you include the affected accounts in your reports. Having posted and outstanding invoices is fine because there will be a separate mechanism to ‘realize’ income on a cash basis. (and a separate account for that which *will* get included in reports) Here’s a little detail: Invoice Posted -- Dr. A/R $50 Cr. Income:Pledges $50 Accrual method, ‘Income’ = $50 Cash method, ‘Income’ = 0 This is because in accrual accounting, you ‘realize’ income when it is ‘earned’. Posting an invoice, means you’ve already ‘earned’ it. If you were to include all income accounts in the income statement, it would show you an income of $50, which is incorrect on a cash basis. Creating a separate cash-basis income account solves this. Invoice Paid Dr. Cash$50 Cr. A/R $50 Dr. Income:Pledges $50 Cr. Income:Receipts $50 Accrual method, ‘Income’ = 0 Cash method, ‘Income’ = $50 (note, you have to do the second part of the above manually or via SX, the first Dr./Cr. pair is done with the ‘process payment’ business feature.) Now, you’ve moved the ‘accrued’ income to a ‘cash’ income account, when you run the Income Statement report, *only* include the cash account - all will be well even if the ‘accrued’ account is not zero yet - that is, has outstanding invoices. This is also why you don’t have to ‘clear up’ outstanding invoices at year end. (unless unpaid pledges reset to ‘zero’ at that time.) Your Income Statement would show an income of $50 which *is* correct now, because you’ve received the money. Since you are only reporting on the Income:Receipts account, it doesn’t matter that the Income:Pledges account might reflect some unpaid invoices - it won’t factor into the report. > > I presume that an unposted invoice can be deleted, so it would be possible to > prepare invoices when (for example) a member opted in to the Foundation > Dinners, and to review unposted invoices periodically - especially in the > closing weeks of the year. You wouldn’t necessarily have unposted invoices. But regardless of posted or unposted, you can’t delete them. You can however assign them to a ‘placeholder’ customer, and/or zero out all the info. The usual recommendation is to change the invoice number to something like “use next” so you can spot it easy in an invoice ‘find’, edit the invoice, and re-use it later. Regards, Adrien ___ 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] No Suitable backend was found
Op dinsdag 27 augustus 2019 15:08:49 CEST schreef Human: > I had a backup and got back to that which opened fine in v3.6. I am not sure > why that file got corrupted. > > Thanks for all the help. I got upgraded as a result. I'm glad to hear that :) Geert ___ 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] Bookkeeping for a club's charity account - use business features?
> On 27 Aug 2019, at 13:24, Mike or Penny Novack > wrote: > > On 8/27/2019 2:40 AM, Michael Hendry wrote: > >> I had understood from a recent response from Mike Novack that using an >> accrual-basis system for cash-basis organisation would be wrong. > "Wrong" is the wrong term. I did not say that. I said that adjustments might > have to be made (the books kept on accrual basis but the reports had to > reflect cash basis). That calls for more than a little bookkeeping experience > to do correctly. Apologies for misquoting you. I’ve extracted part of the exchange (between asterisks): *** > On 25 Aug 2019, at 15:55, Mike or Penny Novack > wrote: > > On 8/25/2019 3:25 AM, Michael Hendry wrote: > > First (and an important question) > Is your organization om the cash or accrual basis? You should always state > that. Cash. > The business features of gnucash only work for accrual. *** …which I mistakenly took to mean I could only use the business features if I were accounting on an accrual basis. > > Back to the suggestion of not posting invoices immediately, that would be > correct for memberships/dues (which are not legally receivable) but you could > post pledges (which are --once a pledge is made the person owes that amount > to the organization). Not that I only know this true for the US. > > The other thing mentioned, RESTRICTED donations (the donor has earmarked for > a set purpose) introduces the need for more record keeping. The treasurer has > to track when the organization has "earned" that donation << the restriction > removed because that amount has been spent for the designated purpose >> Yes, we’d already discussed this a couple of years ago in another context, and you had suggested using a Liabilities account to keep track of such restricted funds. The accountant who examined those accounts prior to their submission to OSCR advised that this wasn’t the proper way to handle restricted funds in a UK context, and that the administrator would have to keep an eye on (e.g.) bursaries awarded through donations restricted for this purpose. > > Michael D Novack 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] No Suitable backend was found
I had a backup and got back to that which opened fine in v3.6. I am not sure why that file got corrupted. Thanks for all the help. I got upgraded as a result. On 27 Aug 2019, 4:13 PM, at 4:13 PM, Geert Janssens wrote: >Hmm, if you kept backup files, you could go back through previous >versions to >determine where it went wrong. >And then compare the good backup with your bad file. > >It may also be useful to doublecheck the file you try to open really is >an xml >file (though probably compressed). > >To do so, first check whether your copy of gnucash is configured to >compress >xml files via >Edit -> Preferences -> General -> Compress files >If that's not set, try opening the failing gnucash file with a plain >text >editor like Wordpad, Notepad+, BBEdit,... (Not with an office suite >though). > >If it is compressed you first have to decompress it with something like >7zip. >You may have to change the extension before 7zip will decompress it. >For >example name your file something.gnucash.gz and then open it with 7zip. > >Once decompressed you can again check whether the decompressed version >looks >like proper xml. And you could even check if gnucash will open the >uncompressed xml file afterwards. There have been compression problems >in the >past and since you last used gnucash 2.6.7 you may be experiencing >that. > >Regards, > >Geert > >Op dinsdag 27 augustus 2019 10:50:23 CEST schreef Human: >> Hi I am using GnuCash 2.6.7 and file format is xml. I need to recover >this >> file, is there anyway to do so? >> >> Thanks! >> >> On Tue, Aug 27, 2019 at 1:47 PM Geert Janssens > >> >> wrote: >> > Op maandag 26 augustus 2019 14:37:58 CEST schreef Human: >> > > Please see attached. >> > >> > Unfortunately there isn't much data in the trace file. >> > >> > The first line is common when you haven't installed Finance::Quote >for >> > online >> > price retrieval. You can ignore that. >> > >> > The two subsequent lines on the other hand suggest write permission >issues >> > in >> > C:\Users\Maulik\.gnucash >> > Gnucash can't access expressions-2.0 and can't write a stylesheets >file in >> > there. >> > But no hints as to why your file can't be read. >> > >> > I'll note that location is only used by gnucash 2.x and older. What >> > version of >> > gnucash are you running ? And what's the file format you have >chosen (xml, >> > sqlite) ? >> > >> > Regards, >> > >> > Geert ___ 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] [MAINT] Unplanned reboot of code.gnucash.org this morning
Hi, TL;DR: Code.gnucash.org stopped responding so I had to force-reboot it this morning; it appears that everything is back online. Long version: This morning @fell noticed that gncbot was missing from #gnucash and pinged me about it. I tried to login to code but couldn't -- the login wouldn't complete. I tried to access the shell and login would not complete, there, either. After several attempts to access code directly and indirectly failed, the only remaining approach to regain access was to forcibly reboot. I did that this morning around 6:48am US/EDT. At that time, gncbot returned, mail started flowing again, and web access returned. I have not spent any time log-hunting to figure out what might have happened, but whatever wedged the server happened sometime around 4am (according to the logs for when gncbot left #gnucash). More information if/when I get it. If you have any questions, please feel free to ask. Thanks! -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] Bookkeeping for a club's charity account - use business features?
> On 27 Aug 2019, at 09:41, Adrien Monteleone > wrote: > > > >> On Aug 27, 2019 w35d239, at 1:40 AM, Michael Hendry >> wrote: >> >> >> OK, so provided I’m careful to clean up any outstanding invoices before the >> end of the financial year, I can use the Business Features for a cash-basis >> organisation. > > Not necessary to clean up any outstanding invoices. Since you aren’t > including the ‘Income:Pledges’ account in the Income Statement, any that > aren’t paid in full won’t affect your Income. Only actual receipts will - aka > - Cash Basis. But my OCD tendencies would force me to do so… > > Also, you wouldn’t include A/R in your Balance Sheet report since technically > it isn’t supposed to exist in a Cash system. > > >> >> I had understood from a recent response from Mike Novack that using an >> accrual-basis system for cash-basis organisation would be wrong. > > That is true. What you are doing is using the invoice system (which is > accrual based) to track some stuff you need for special purposes, but you > aren’t reporting on those affected accounts. You’re using cash-basis accounts > containing only cash-basis transactions for your formal reports. I was thinking Mike meant that there was something intrinsically incompatible with cash-based accounting which happened when Business Features were added. But you’re saying that it’s only if there are posted and unpaid invoices outstanding at year-end that this is a problem. > >> >>> >>> > > But you can easily have a second set of books to keep and report on "by > member" stuff, and if using the business features, can invoice. That’s a method I hadn’t thought of, and will look into. There’s the obvious risk of these two sets of books getting out of step. >> >> Working this way would avoid creating the Income:Pledges and Income:Receipts >> workaround suggested above. >> >> All income received from members could then be simultaneously invoiced and >> paid, with Accounts Receivable persistently zero. > > You can do that, and it would be the standard advice on how to use GnuCash > for a cash-basis book, but then lose the ability to see who hasn’t ‘paid up’. > > (at least not without lots of individual member accounts, or a separate > spreadsheet to keep track) > > I’m also not sure how yet how that would affect your ability to track the > gift amount per member. I presume that an unposted invoice can be deleted, so it would be possible to prepare invoices when (for example) a member opted in to the Foundation Dinners, and to review unposted invoices periodically - especially in the closing weeks of the year. >>> 1) Do you need to know how much each member donated for each destination? >>> >>> or >>> >>> 2) >>> >>> For the Club: >>> >>> Do you just want to track how much was received (in aggregate for all >>> members) for each destination >> >> Yes > > Then you shouldn’t need individual member sub-accounts for each destination. Exactly. >> >>> >>> and >>> >>> For the Members: >>> >>> How much (in aggregate for all destinations) each member donated? (for >>> Gift Aid purposes) >> >> Yes, but some destinations aren’t Gift-Aid-eligible > > Here’s where I’m investigating using ‘expense vouchers’ for those > destinations that are eligible. I didn’t get a chance to do a trial with it > yet. Hopefully later today. > > Another option might be the upcoming ‘owner report’ that might get included > in the 3.7 release. It will allow you to match up payments to invoices > easily. This might also allow you to run a report of gift amounts for only > those invoices that match the eligible destinations. Sounds useful! Regards, Michael > > Regards, > Adrien > ___ > 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. ___ 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] Bookkeeping for a club's charity account - use business features?
On 8/27/2019 2:40 AM, Michael Hendry wrote: I had understood from a recent response from Mike Novack that using an accrual-basis system for cash-basis organisation would be wrong. "Wrong" is the wrong term. I did not say that. I said that adjustments might have to be made (the books kept on accrual basis but the reports had to reflect cash basis). That calls for more than a little bookkeeping experience to do correctly. Back to the suggestion of not posting invoices immediately, that would be correct for memberships/dues (which are not legally receivable) but you could post pledges (which are --once a pledge is made the person owes that amount to the organization). Not that I only know this true for the US. The other thing mentioned, RESTRICTED donations (the donor has earmarked for a set purpose) introduces the need for more record keeping. The treasurer has to track when the organization has "earned" that donation << the restriction removed because that amount has been spent for the designated purpose >> Michael D Novack ___ 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] Bookkeeping for a club's charity account - use business features?
If #1 one, that is quite messy, yes, and you’ll need lots of manual transactions and some sort of searchable/filterable tag system as I described previously. (to avoid hundreds or thousands of accounts and sub-accounts) But if #2, then the business features can handle that easily with invoice line items posted to Income accounts for each destination and assigning those invoices to individual customer accounts. No need for the individual member account(s) in the Income tree at all. GnuCash will track each customer's pledged (invoiced) amounts as well as payments. The gift portion *might* be a little trickier, but I think it can be achieved by the expense vouchers feature. (since they operate as sort of a ‘chargeback’) I’ll have to investigate. Regards, Adrien 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, 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. -- The harder I work the luckier I get. ___ 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] Scrolling problem
Forwarding to the list as you accidentally replied to me instead of the list. You do not seem to have replied to the previous email from Adrien. Colin On Tue, 27 Aug 2019 at 12:36, Jonathan Silvey wrote: > > I'm sorry if no one can solve this problem. I will probably have to abandon > Gnucash completely. Thanks for your help previously. > Jonathan > > > > On Tue, 20 Aug 2019 at 22:56, Jonathan Silvey > wrote: >> >> Hi, >> >> Sorry about not replying to all. >> >> Click on a transaction and scroll up using the Up arrow and it shows just >> one more transaction. >> >> It's been happening for several months now and if I changed anything that >> might have triggered it, I can't remember doing so. >> >> >> >> Jonathan >> >> >> >> On Tue, 20 Aug 2019 at 21:13, Colin Law wrote: >>> >>> On Tue, 20 Aug 2019 at 20:53, Jonathan Silvey >>> wrote: >>> > >>> > Hi, >>> > I have checked and all were already checked. >>> >>> You sent this to me and not to the list, you have to select Reply All >>> or Reply List on this email list. I am forwarding it to the list >>> here. >>> What happens if you click on a transaction and then use the up arrow >>> to scroll to the top and keep going? >>> >>> Has this just started happening? If so did anything happen that might >>> have triggered it? >>> >>> Colin >>> >>> > >>> > Jonathan >>> > >>> > >>> > >>> > On Tue, 20 Aug 2019 at 15:48, Colin Law wrote: >>> >> >>> >> Check in View > Filter By that in the Date tab that Show All is >>> >> selected, and in the Status tab that all boxes are checked. >>> >> >>> >> Colin >>> >> >>> >> On Tue, 20 Aug 2019 at 15:18, Jonathan Silvey >>> >> wrote: >>> >> > >>> >> > I cannot scroll to transactions at an earlier date than what's at the >>> >> > top >>> >> > of the current screen. THis happens for any account. However, in >>> >> > Reconciliation, the scrollbar moves correctly. The totals in Accounts >>> >> > are >>> >> > also correct. >>> >> > >>> >> > I use Windows10 and Gnucash Version: 3.5, Build ID: 3.5+(2019-03-30). >>> >> > >>> >> > Can anyonne help, please? >>> >> > Jonathan >>> >> > ___ >>> >> > 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. ___ 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] No Suitable backend was found
Op maandag 26 augustus 2019 14:37:58 CEST schreef Human: > Please see attached. Unfortunately there isn't much data in the trace file. The first line is common when you haven't installed Finance::Quote for online price retrieval. You can ignore that. The two subsequent lines on the other hand suggest write permission issues in C:\Users\Maulik\.gnucash Gnucash can't access expressions-2.0 and can't write a stylesheets file in there. But no hints as to why your file can't be read. I'll note that location is only used by gnucash 2.x and older. What version of gnucash are you running ? And what's the file format you have chosen (xml, sqlite) ? Regards, Geert ___ 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] No Suitable backend was found
Hi I am using GnuCash 2.6.7 and file format is xml. I need to recover this file, is there anyway to do so? Thanks! On Tue, Aug 27, 2019 at 1:47 PM Geert Janssens wrote: > Op maandag 26 augustus 2019 14:37:58 CEST schreef Human: > > Please see attached. > > Unfortunately there isn't much data in the trace file. > > The first line is common when you haven't installed Finance::Quote for > online > price retrieval. You can ignore that. > > The two subsequent lines on the other hand suggest write permission issues > in > C:\Users\Maulik\.gnucash > Gnucash can't access expressions-2.0 and can't write a stylesheets file in > there. > But no hints as to why your file can't be read. > > I'll note that location is only used by gnucash 2.x and older. What > version of > gnucash are you running ? And what's the file format you have chosen (xml, > sqlite) ? > > Regards, > > Geert > > > ___ 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] Bookkeeping for a club's charity account - use business features?
> On 27 Aug 2019, at 08:20, elvis wrote: > > >>> If #1 one, that is quite messy, yes, and you’ll need lots of manual >>> transactions and some sort of searchable/filterable tag system as I >>> described previously. (to avoid hundreds or thousands of accounts and >>> sub-accounts) >>> >>> But if #2, then the business features can handle that easily with invoice >>> line items posted to Income accounts for each destination and assigning >>> those invoices to individual customer accounts. No need for the individual >>> member account(s) in the Income tree at all. GnuCash will track each >>> customer's pledged (invoiced) amounts as well as payments. The gift portion >>> *might* be a little trickier, but I think it can be achieved by the expense >>> vouchers feature. (since they operate as sort of a ‘chargeback’) I’ll have >>> to investigate. >>> >>> Regards, >>> Adrien >>> > 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 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@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. ___ 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] Bookkeeping for a club's charity account - use business features?
> On Aug 27, 2019 w35d239, at 1:40 AM, Michael Hendry > wrote: > > > OK, so provided I’m careful to clean up any outstanding invoices before the > end of the financial year, I can use the Business Features for a cash-basis > organisation. Not necessary to clean up any outstanding invoices. Since you aren’t including the ‘Income:Pledges’ account in the Income Statement, any that aren’t paid in full won’t affect your Income. Only actual receipts will - aka - Cash Basis. Also, you wouldn’t include A/R in your Balance Sheet report since technically it isn’t supposed to exist in a Cash system. > > I had understood from a recent response from Mike Novack that using an > accrual-basis system for cash-basis organisation would be wrong. That is true. What you are doing is using the invoice system (which is accrual based) to track some stuff you need for special purposes, but you aren’t reporting on those affected accounts. You’re using cash-basis accounts containing only cash-basis transactions for your formal reports. > >> >> >>> But you can easily have a second set of books to keep and report on "by member" stuff, and if using the business features, can invoice. >>> >>> That’s a method I hadn’t thought of, and will look into. There’s the >>> obvious risk of these two sets of books getting out of step. > > Working this way would avoid creating the Income:Pledges and Income:Receipts > workaround suggested above. > > All income received from members could then be simultaneously invoiced and > paid, with Accounts Receivable persistently zero. You can do that, and it would be the standard advice on how to use GnuCash for a cash-basis book, but then lose the ability to see who hasn’t ‘paid up’. (at least not without lots of individual member accounts, or a separate spreadsheet to keep track) I’m also not sure how yet how that would affect your ability to track the gift amount per member. >> 1) Do you need to know how much each member donated for each destination? >> >> or >> >> 2) >> >> For the Club: >> >> Do you just want to track how much was received (in aggregate for all >> members) for each destination > > Yes Then you shouldn’t need individual member sub-accounts for each destination. > >> >> and >> >> For the Members: >> >> How much (in aggregate for all destinations) each member donated? (for >> Gift Aid purposes) > > Yes, but some destinations aren’t Gift-Aid-eligible Here’s where I’m investigating using ‘expense vouchers’ for those destinations that are eligible. I didn’t get a chance to do a trial with it yet. Hopefully later today. Another option might be the upcoming ‘owner report’ that might get included in the 3.7 release. It will allow you to match up payments to invoices easily. This might also allow you to run a report of gift amounts for only those invoices that match the eligible destinations. Regards, Adrien ___ 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] No Suitable backend was found
Hmm, if you kept backup files, you could go back through previous versions to determine where it went wrong. And then compare the good backup with your bad file. It may also be useful to doublecheck the file you try to open really is an xml file (though probably compressed). To do so, first check whether your copy of gnucash is configured to compress xml files via Edit -> Preferences -> General -> Compress files If that's not set, try opening the failing gnucash file with a plain text editor like Wordpad, Notepad+, BBEdit,... (Not with an office suite though). If it is compressed you first have to decompress it with something like 7zip. You may have to change the extension before 7zip will decompress it. For example name your file something.gnucash.gz and then open it with 7zip. Once decompressed you can again check whether the decompressed version looks like proper xml. And you could even check if gnucash will open the uncompressed xml file afterwards. There have been compression problems in the past and since you last used gnucash 2.6.7 you may be experiencing that. Regards, Geert Op dinsdag 27 augustus 2019 10:50:23 CEST schreef Human: > Hi I am using GnuCash 2.6.7 and file format is xml. I need to recover this > file, is there anyway to do so? > > Thanks! > > On Tue, Aug 27, 2019 at 1:47 PM Geert Janssens > > wrote: > > Op maandag 26 augustus 2019 14:37:58 CEST schreef Human: > > > Please see attached. > > > > Unfortunately there isn't much data in the trace file. > > > > The first line is common when you haven't installed Finance::Quote for > > online > > price retrieval. You can ignore that. > > > > The two subsequent lines on the other hand suggest write permission issues > > in > > C:\Users\Maulik\.gnucash > > Gnucash can't access expressions-2.0 and can't write a stylesheets file in > > there. > > But no hints as to why your file can't be read. > > > > I'll note that location is only used by gnucash 2.x and older. What > > version of > > gnucash are you running ? And what's the file format you have chosen (xml, > > sqlite) ? > > > > Regards, > > > > Geert ___ 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.