Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?
On Sat, Sep 19, 2020 at 03:10:51PM -0400, Michael or Penny Novack wrote: > > > > The "restricted account" you are referring to is probably a "fund". Monies > > collected for a specific purpose and meant to be used for that specific > > purpose only. These are accounts that need to be kept in the Equity > > section. > > Actually, there are SEVERAL ways restricted funds may be accounted for. > > A lot will depend on the answer to two questions. > > a) Do these funds have their own bank accounts? > > b) What are the rules of your jurisdiction as to how restricted funds should > appear on the balance sheet. > > Those answers will determine what options remain for accounting for > restricted funds. > Yes, OP here, with a few more weeks of knowledge/experience gathered from here and elsewhere. Restricted funds are a can of worms! ... a complete and utter pain. There are also 'designated' funds which are not quite so restricted. Our church/PCC really only has one restricted fund, the fabric fund, so it's relatively easy to handle by having a separate bank account for it. We also tend to put funds designated for the building into the same fund, this isn't strictly correct but for the very small size of our church/PCC it makes sense. If one has a lot of separate restricted and/or designated funds it must be very difficult to keep track of them all. -- Chris Green ___ 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] Error with Advanced portfolio report
Thanks. Original Message From: John Ralls Sent: Sat Sep 19 16:46:42 EDT 2020 To: mike823 Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Error with Advanced portfolio report > On Sep 19, 2020, at 1:15 PM, mike823 wrote: > > It is a bug and it was reported at least 5 times since 4.2 was released. > Never got any attention for the dev team. It's https://bugs.gnucash.org/show_bug.cgi?id=797891 and is fixed. The fix will be released in 4.2 so the five reports after that will indeed get no attention from the dev team as none will be necessary. Regards, John Ralls ___ 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] New user - anyone else using GnuCash for PCC (church) accounts? Advice?
The group I keep books for has a policy of only accepting restricted or directed donations in the case where the donation is very large. Large in our case is over $10,000 or $20,000 Mexican pesos, $500 or $1000 US dollars. So far we have not had to deal with any. We have had a couple of donations of that size, but they were not restricted.l Will On 2020 Sep 20, at 09-20 03:41:05, Chris Green wrote: On Sat, Sep 19, 2020 at 03:10:51PM -0400, Michael or Penny Novack wrote: > > >> The "restricted account" you are referring to is probably a "fund". Monies >> collected for a specific purpose and meant to be used for that specific >> purpose only. These are accounts that need to be kept in the Equity >> section. > > Actually, there are SEVERAL ways restricted funds may be accounted for. > > A lot will depend on the answer to two questions. > > a) Do these funds have their own bank accounts? > > b) What are the rules of your jurisdiction as to how restricted funds should > appear on the balance sheet. > > Those answers will determine what options remain for accounting for > restricted funds. > Yes, OP here, with a few more weeks of knowledge/experience gathered from here and elsewhere. Restricted funds are a can of worms! ... a complete and utter pain. There are also 'designated' funds which are not quite so restricted. Our church/PCC really only has one restricted fund, the fabric fund, so it's relatively easy to handle by having a separate bank account for it. We also tend to put funds designated for the building into the same fund, this isn't strictly correct but for the very small size of our church/PCC it makes sense. If one has a lot of separate restricted and/or designated funds it must be very difficult to keep track of them all. -- Chris Green ___ 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] New user - anyone else using GnuCash for PCC (church) accounts? Advice?
If one has a lot of separate restricted and/or designated funds it must be very difficult to keep track of them all. And don't forget GRANTS. Those are very much like restricted funds if the money is received ahead of use AND are almost, if not quite as much work, even when in the form of reimbursement grants << ones where you track the eligible expenses, prepare a report of those along with matching receipts/paid invoices to submit to the entity making the grant >> With both restricted donations and grants, one of the tasks of the treasurer, besides tracking how used, may be to track funds at risk of disappearing if not used according to purpose/time. You board may need to take actions, including asking the donor or grantor to alter the restriction conditions, allow a change of purpose or more time, etc. 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] SQLite File crashes Gnucash on opening after upgrade to 4.1 on Macos
Hi, I was finally able to get back to a backup of this SQLlite file. Unfortunately trying to open a version older than the last update of Gnucash I got (19 August 2020, v4.1-4), which was working fine, Gnucash still crashes. I'll then open a bug for this. Regards, -nodje On 17/09/2020 17:58, John Ralls wrote: > >> On Sep 17, 2020, at 4:43 AM, coolnodje wrote: >> >> Just wanted to make sure this was already caught as a bug. >> >> I've had a bug like this in the past, though with another SQLite File. >> >> Everything was fine until the upgrade, hence i assume this is regression. > More likely a damaged file since there weren't any SQL backend changes > between 4.0 and 4.1. Please open a bug report and attach the crash report > from Console. > > Regards, > John Ralls > ___ 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] Can't "Save As" to sqlite, is it a compile option?
Version 2.4, not 4.2, which is not out yet. Regards, Adrien On 9/13/20 9:57 AM, Chris Green wrote: On Sun, Sep 13, 2020 at 10:40:59AM -0400, Derek Atkins wrote: The SQL backend uses libdbi and that is a compile-time option. However you need runtime libraries to enable the various SQL backends to work. Most likely you don't have the appropriate SQLite database drivers installed. Search for libdbi-dbd-sqlite and similar. Thank you Derek, spot on! I needed to install libdbd-sqlite3 and now GnuCash offers to save in sqlite3. I was confused by a web site (not GnuCash) that said:- From version 4.2, Gnucash supports PostrgreSQL, MySQL and SQLite3. ___ 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] Can't "Save As" to sqlite, is it a compile option?
See my other reply about versions and database support. I've been using SQlite3 since the 2.6.x days. The build instructions on the wiki are very good. The most time will be spent reading and making sure you have the build environment and dependencies. If you get that right, the actual build is fairly quick and painless. Regards, Adrien On 9/13/20 9:44 AM, Chris Green wrote: On Sun, Sep 13, 2020 at 03:34:10PM +0100, Chris Green wrote: I am running GnuCash 3.8 Build ID: 3.8b+(2019-12-29) on [x]ubuntu 20.04. I have started keeping a small PCC accounts with this but decided I wanted to move to storing the data in sqlite rather than the default XML. It doesn't seem to be possible, if I click on SaveAs in the File menu the only Data Format I'm offered is XML. Is this because sqlite storage is a compile time option that hasn't been included in the Ubuntu build, or is there something else I need to do? Ah! I've just seen that sqlite is only supported from version 4.2 and I'm on version 3.8, so that explains it! Does anyone have any experience of getting GnuCash >4.2 working on [x]Ubuntu? Is it easy to compile/build? (I do have a fair amount of experience, I used to build my own Linux kernels etc.) ___ 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] Need to - Mark Split as Un-reconciled - in GC 3.8
Check the Wiki, there is a section on upgrading. I'm not certain, but I seem to recall reading from Windows users that Windows will prompt to remove it. But I see no harm in removing 3.8 manually first. Your data and preferences exist outside of where the application does. Always make sure you have a back up of both in any case. Regards, Adrien On 9/17/20 6:37 PM, w...@theprescotts.com wrote: Don't know about Windows. On Mac OS, I have 2.6.1.1, 3.0.1, 3.10, 4.0, 4.1, 4.1.4 all currently installed. Don't ask why. Will On 2020 Sep 17, at 09-17 13:04:53, Fran_3 via gnucash-user wrote: Thanks Chris. Question - Do I have to remove GC 3.8 before installing 4.1 or what? (On Windows 10( Thanks for the help. FYI - I searched... site:lists.gnucash.org upgrade to 4.1 for help on this before posting. I'm sure the question has been asked before but I guess I didn't see it in the search results. ___ 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] How to upgrade from 3.8 to 4.1 on Win10?
On 9/17/20 4:36 PM, Fran_3 via gnucash-user wrote: Just now getting around to upgrading 3.4 to 4.1 on Win10. 1 - I've downloaded 4.1. Do I just run it or first uninstall 3.8? This has been answered, but for completeness, Windows will offer to uninstall 3.8 before installing 4.1. 2 - Also I see in the archives someone tried to upgrade from ver 2.x to ver 4... and the following comment (amoung others)... " Skipping versions (such as2.5 ---> 4.0 is not supported" Does this apply to going from 3.8 to 4.1? Per the Wiki, upgrading by skipping major versions is not supported. The numbering scheme changed with 3.x. 2.4.x and 2.6.x are both major versions. The next two major versions are 3.x and 4.x, so this is the list: 2.4.x 2.6.x 3.x 4.x You can't skip one. Moving from 2.4 -> 3.x is not supported in one jump. You'd have to go through 2.6.x first. (and also 3.x if your final destination is 4.x) Moving from 2.6.x -> 4.x is not supported in one jump, you have to go through a 3.x release first. Thus, 3.8 -> 4.1 is fine. After EACH upgrade between major versions, you should perform: Actions > Check & Repair > Check & Repair All. 3 - any other steps that should be performed to have things go smoothly? Always make sure you have proper backups in place, both of your data file and your preferences and saved report configurations. See the wiki for these locations on your operating system. I'm sure this is somewhere online or in the archives or Wiki but, after digging around for awhile, I just haven't stumbled across it so thanks in advance for any help. See the FAQ there. There is also a search bar at the top right of every page. "Upgrade" would find something useful. 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.
