[GNC] Non-profit loan/grant tracking
Howdy! We use GnuCash for the bookkeeping for our non-profit, and I love the simplicity and straightforward implementation of double-entry. I'm really grateful for how much GnuCash has helped us as we grow. We're now in a situation I can't figure the best practices around. We have a single bank account. This year we received a cash loan and a grant. Both of them require us to track what expenses the funds specifically went to pay for. I'm unclear of how to best set this up in GnuCash. For grants that don't require tracking, we just co-mingle the funds in our bank account general funds, but this grant's funds will be actually in our bank account but expenses using those specific funds needs to be tracked. For loans that don't require tracking, I know to create a liability account for the loan and begin it with a transaction between the loan and the bank account. But it feels like I need some other account to track the remaining balance on the funds from the loan/grant. I can do a subaccount on our bank account, but the ledger balance for the bank account won't match what the bank says without doing math every time. I imagine there may be a better way. So yeah - any advice? Thanks so much in advance! -jag Joshua Ginsberg Vice-President & Treasurer https://seekhealing.org/ ___ 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 remove or hide certain bills from appearing in the Due Bills Reminder?
Thanks Adrien. As always very helpful! BTW, I attempted to setup a second AP account under Liabilities named "AP Temporary Suspended " - But, when posting it GC won't let me post to that account. - It will however allow creating a new account that shows up on the same level as Assets & Liabilities... So, I've decided to un-post the bills in question and re=post them with a date way out... as GC will not allow posting a bill without a due date. Thanks again for the help !!! On Tuesday, July 21, 2020, 1:55:13 AM EDT, Adrien Monteleone wrote: #2 - I forgot to make clear that, no, unchecking the Active box does not hide the bill from the Due reminder. You'll have to also unpost it for that effect. You can of course re-post later with the original due date if you like. The Active checkbox, I think, will only hide the invoice from a Find operation. Regards, Adrien On 7/20/20 6:50 PM, Fran_3 via gnucash-user wrote: > 1 - So to force a posted bill down the list we will have to un-post it, >change the due date, and then re-post it... right? > 2 - And, on a posted bill... what is the "Active" Check box? > Thanks for the help. ___ 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] Difficulty with online price retrieval (John Ralls)
Thank you for your response, John, and I am sorry for the long delay but I have had an avalanche of work to do. My problem is that when I go to post an invoice the "fetch rate" button is greyed out so I cannot use the online currency rate retrieval that I used to be able to before I upgraded my hardware. After installing the current version of gnucash on my new PC, I clicked on "Install Online Price Retrieval" from the Gnucash list in my start menu and I have entered the Alfa Vantage API key in my gnucash preferences. I have checked for the presence of the perl software using the Troubleshooting method you directed me to and received the response that I should install the Finance::Quote. The only way I have done this in the past is by clicking on "Install Online Price Retrieval" from the Gnucash list in my start menu and this is what I have done several times now. So I have done this again and after a run of code in the cmd window the final lines are: "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump SBECK/Date-Manip-6.82.tar.gz C:\STRAWB~1\c\bin\gmake.exe - -OK When I look in the Windows list of apps installed it says I have installed Strawberry Perl on 3rd July (when I first tried installing it on my new PC). I am running the latest version of Gnucash and I find that in the help window it says "Version: 4.0 Build ID: 4.0+(2020-06-27) Finance::Quote: -" Please let me know what other information you need in order to be able to help me. I am stepping way out of my comfort zone when I enter the cmd window but willing to give it a go. Best regards Samantha On 16 July 2020 18:14 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Have you tried price retrieval from the command line as explained in [2]https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Does that work? You haven't actually told us exactly what doesn't work. Please elaborate. Note that trading accounts has nothing to do with it, nor do previously created prices. Note that while rates used for transactions are recorded in the pricedb to ensure that there's an entry to make reports work properly, each foreign currency split has its own exchange rate, the ratio between the amount in the foreign currency and the value in the home currency, so the only thing you'd affect by clearing the pricedb is reports on past dates, especially time series reports. You may also enter prices manually as a temporary measure until you get online quotes working properly. Regards, John Ralls On Jul 16, 2020, at 5:08 AM, Samantha Payn < [3]saman...@boorertranslations.com> wrote: Thanks for your comments John and Eric. I have again reviewed the gnucash help documentation and cannot see where I am going wrong. In addition to having installed Online Price Retrieval and entered my API key, I have now also double checked that the "use trading accounts" option is checked which it is. In the price database window the currencies I use are listed. There is an option to delete all previous prices but I presume I don't want to do that as they record the currency exchange rates used for each of my past transactions. I am beginning to think I must take a backward step and use manual price entry ... where am I going wrong, when I used to be able to use the automatic option and all seems to be set up as before? All help gratefully received. References 1. mailto:jra...@ceridwen.us 2. https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting 3. mailto:saman...@boorertranslations.com ___ 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] Adjusted Trial Balance
Trying to figure out what the best practice is for Adjustment Entries and Adjusted Trial Balance is in GnuCash. My main requirement is to be able to easily produce a (Non-Adjusted) Trial Balance and a Adjusted Trial Balance report. I was thinking of creating a temporary Adjustment Account to hold changes and I could restore/delete this account to generate the above report. Seeking help on best practice for this. ___ 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] Non-profit loan/grant tracking
You can see the transactions from an account along with the subaccounts. >From the accounts list, select the upper level account, right click, and choose open subaccounts. If you make a subaccount for the grant or loan transfers and pay from the subaccount as appropriate you will have an itemized list of the transactions for the grant or loan. If that doesn't work for you, you could also transfer funds as needed from the loan or grant account into the bank account. Each transfer should contain details of what expenses are being covered by the transfer. Basically this is a reimbursement model. This might be rather cumbersome if there are a lot of transactions. Dale On Tue, Jul 21, 2020 at 8:22 AM Joshua Ginsberg wrote: > Howdy! > > We use GnuCash for the bookkeeping for our non-profit, and I love the > simplicity and straightforward implementation of double-entry. I'm really > grateful for how much GnuCash has helped us as we grow. > > We're now in a situation I can't figure the best practices around. > > We have a single bank account. This year we received a cash loan and a > grant. Both of them require us to track what expenses the funds > specifically went to pay for. I'm unclear of how to best set this up in > GnuCash. > > For grants that don't require tracking, we just co-mingle the funds in our > bank account general funds, but this grant's funds will be actually in our > bank account but expenses using those specific funds needs to be tracked. > For loans that don't require tracking, I know to create a liability account > for the loan and begin it with a transaction between the loan and the bank > account. > > But it feels like I need some other account to track the remaining balance > on the funds from the loan/grant. I can do a subaccount on our bank > account, but the ledger balance for the bank account won't match what the > bank says without doing math every time. I imagine there may be a better > way. > > So yeah - any advice? Thanks so much in advance! > > -jag > > > Joshua Ginsberg > Vice-President & Treasurer > https://seekhealing.org/ > ___ > 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] Non-profit loan/grant tracking
On 7/21/2020 9:18 AM, Joshua Ginsberg wrote: We have a single bank account. This year we received a cash loan and a grant. Both of them require us to track what expenses the funds specifically went to pay for. I'm unclear of how to best set this up in GnuCash. For grants that don't require tracking, we just co-mingle the funds in our bank account general funds, but this grant's funds will be actually in our bank account but expenses using those specific funds needs to be tracked. For loans that don't require tracking, I know to create a liability account for the loan and begin it with a transaction between the loan and the bank account. But it feels like I need some other account to track the remaining balance on the funds from the loan/grant. I can tell you how I did this (bookkeeping for non-profits) Let's take the grant first. You create a liability for this and an income account "grant income". This latter is used when the money becomes yours (has been used for an expense authorized by the terms of the grant). When you get the grant, debit the bank account and credit the liability. That grant money is not yours yet even though in your bank account. The organizations hasn't "earned" it yet. The transactions recording qualified expenses now become more complicated. You debit the expense AND the liability (cancelling that much) and you credit the bank account (check used for that expense) AND "grant income" (that much now "earned") For me to tell you how to handle the loan you'll need to supply more details. But if this is a loan where the amounts used for the specified purpose are forgiven (one of the possibilities) it's just like that grant. Otherwise you need to explain in what sense the loan is associated to specific expenses. 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] Adjusted Trial Balance
The various options in the Trial Balance are very ill-defined. This report was created in 2004 [1], with an addition of merchandising businesses [2], but not actually documented anywhere. They have received minor maintenance fixes only otherwise. So, it would be nice to open a dialogue on what these mean exactly. Otherwise it will continue to be undocumented, misunderstood, and perhaps best retired completely. [1] https://github.com/Gnucash/gnucash/commit/a107a9af2 [2] https://github.com/Gnucash/gnucash/commit/259e01d5c On Tue, 21 Jul 2020 at 14:13, Ron Gill wrote: > Trying to figure out what the best practice is for Adjustment Entries and > Adjusted Trial Balance is in GnuCash. > > My main requirement is to be able to easily produce a (Non-Adjusted) Trial > Balance and a Adjusted Trial Balance report. > > I was thinking of creating a temporary Adjustment Account to hold changes > and I could restore/delete this account to generate the above report. > > Seeking help on best practice for this. > ___ > 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] How to remove or hide certain bills from appearing in the Due Bills Reminder?
You should be able to use other AP accounts, but make sure they are of generic type Liability, not the special type 'Accounts Payable'. There can be only one account with that special type. (Same for AR) It can even be a child of AP/AR. Glad you found a usable work around. Regards, Adrien On 7/21/20 8:57 AM, Fran_3 via gnucash-user wrote: Thanks Adrien. As always very helpful! BTW, I attempted to setup a second AP account under Liabilities named "AP Temporary Suspended " - But, when posting it GC won't let me post to that account. - It will however allow creating a new account that shows up on the same level as Assets & Liabilities... So, I've decided to un-post the bills in question and re=post them with a date way out... as GC will not allow posting a bill without a due date. ___ 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] Importfunktion geändert? Herkunftskonto
Hallo, ich habe ein Problem beim Import von CSV-Buchungen. Ich war es gewohnt über "Datei->Importieren->Buchungen importieren aus CSV..." und der Angabe des Formats (Datu, Beschreibung, Buchungstext, Einzahlung, Buchungswährung,Konto) und klick auf Weiter für jede Buchung das Gegenkonto manuell auswählen zu können. Nun verlangt der Importassistent zwingend ein Herkunftskonto in der CSV? "Weiter" ist ausgegraut, "- Bitte wählen Sie eine Herkunftskonto-Spalte oder entfernen Sie die anderen Spalten." Habe zum Test als Herkunftskonto ein Ausgleichskonto gewählt, beim Import-Schritt "Buchungen zuordnen" später, kann ich aber nicht, wie früher gewohnt, das Gegenkonto zu wählen.. Mache ich etwas falsch? Oder ist die Änderung so tatsächlich gewollt? Ich habe das Problem nach einer Neuinstallation von gnuCash 3.7. Zuvor war, wenn ich mich nicht täusche 3.0 im Einsatz. Vielen Dank für Tipps/Hinweise Paul Neuwirth ___ 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] Importfunktion geändert? Herkunftskonto
courtesy of Google Translate: Entschuldigung, ich kann beim CSV-Problem nicht helfen. Google Translate sagt mir, dass dies Deutsch ist, und obwohl es hier auf dieser Liste einige deutschsprachige Benutzer gibt (vielleicht kann einer von ihnen helfen), gibt es eine spezielle GnuCash-Liste für deutsche Benutzer. Siehe hier: https://wiki.gnucash.org/wiki/Mailing_Lists -- Sorry, I can't help with the CSV problem. Google Translate tells me this is German, and while there are some German speaking users here on this list, (maybe one of them can help out) there is a dedicated GnuCash list for German users. See here: https://wiki.gnucash.org/wiki/Mailing_Lists Regards, Adrien On 7/21/20 8:17 AM, Paul Neuwirth via gnucash-user wrote: Hallo, ich habe ein Problem beim Import von CSV-Buchungen. Ich war es gewohnt über "Datei->Importieren->Buchungen importieren aus CSV..." und der Angabe des Formats (Datu, Beschreibung, Buchungstext, Einzahlung, Buchungswährung,Konto) und klick auf Weiter für jede Buchung das Gegenkonto manuell auswählen zu können. Nun verlangt der Importassistent zwingend ein Herkunftskonto in der CSV? "Weiter" ist ausgegraut, "- Bitte wählen Sie eine Herkunftskonto-Spalte oder entfernen Sie die anderen Spalten." Habe zum Test als Herkunftskonto ein Ausgleichskonto gewählt, beim Import-Schritt "Buchungen zuordnen" später, kann ich aber nicht, wie früher gewohnt, das Gegenkonto zu wählen.. Mache ich etwas falsch? Oder ist die Änderung so tatsächlich gewollt? Ich habe das Problem nach einer Neuinstallation von gnuCash 3.7. Zuvor war, wenn ich mich nicht täusche 3.0 im Einsatz. Vielen Dank für Tipps/Hinweise ___ 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] Importfunktion geändert? Herkunftskonto
Paul, Sie können das Ursprungskonto entweder in der CSV-Datei selbst oder im Importdialog angeben. In der oberen rechten Ecke befindet sich ein Kombinationsfeld Konto, wenn alle Transaktionen dasselbe Ursprungskonto haben und es nicht in der Datei angegeben ist. Wenn Sie die Kopfzeilen den CSV-Spalten zuweisen, gibt es ein Kopfkonto für das Ursprungskonto und ein Kopfübertragungskonto für das Zählerkonto. Wenn Sie das Ursprungskonto im Kombinationsfeld des Dialogfelds angeben, weisen Sie den Kontokopf nicht einer CSV-Spalte zu, sondern nur den Kopf des Kontos übertragen. Wenn dies der erste Import ist, ordnet GNuCash die Kontonamen in dieser Spalte den internen Konten zu.Sie können das Ursprungskonto angeben. Ich hoffe, ich habe Ihr Problem richtig verstanden. Prost, David Cousens You can specifiy the origin account either within the CSV file itself or in the import dialog there is a combo box Account in the top right hand corner if all transactions have the same origin account and it is not specififed in the file. WHen you assign the headers to the CSV columns there is a header Account for the origin account and a header Transfer Account for the counter account. If you specify the origin account in the dialog combo box, then you do not assign the Account header to a CSV column only the Transfer Account header. If this is the first import GNuCash will map the account names in this column onto the internal accounts. On Tue, 2020-07-21 at 15:17 +0200, Paul Neuwirth via gnucash-user wrote: > Hallo, > > ich habe ein Problem beim Import von CSV-Buchungen. > > Ich war es gewohnt über "Datei->Importieren->Buchungen importieren aus > CSV..." und der Angabe des Formats (Datu, Beschreibung, Buchungstext, > Einzahlung, Buchungswährung,Konto) und klick auf Weiter für jede Buchung > das Gegenkonto manuell auswählen zu können. > > Nun verlangt der Importassistent zwingend ein Herkunftskonto in der CSV? > "Weiter" ist ausgegraut, "- Bitte wählen Sie eine Herkunftskonto-Spalte > oder entfernen Sie die anderen Spalten." > > Habe zum Test als Herkunftskonto ein Ausgleichskonto gewählt, beim > Import-Schritt "Buchungen zuordnen" später, kann ich aber nicht, wie > früher gewohnt, das Gegenkonto zu wählen.. > > Mache ich etwas falsch? Oder ist die Änderung so tatsächlich gewollt? > Ich habe das Problem nach einer Neuinstallation von gnuCash 3.7. Zuvor > war, wenn ich mich nicht täusche 3.0 im Einsatz. > > > Vielen Dank für Tipps/Hinweise > > > Paul Neuwirth > ___ > 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. -- Dr David R Cousens B.Sc, M.Prof. Acc., Ph.D., G.C.Ed ___ 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] Adjusted Trial Balance
Please keep replies public. Answer: No idea. On Wed, 22 Jul 2020, 12:27 am Ron Gill, wrote: > Maybe creating an Adjustment Account is not such a bad idea in that case - > is there a quick way to temporarily remove and restore a single account? > Exporting and deleting Adjustment account is quick, but the Import looks > not so good. Am I missing any tricks here? > > On Tue, Jul 21, 2020, 7:43 AM Christopher Lam > wrote: > >> The various options in the Trial Balance are very ill-defined. This >> report was created in 2004 [1], with an addition of merchandising >> businesses [2], but not actually documented anywhere. They have received >> minor maintenance fixes only otherwise. So, it would be nice to open a >> dialogue on what these mean exactly. Otherwise it will continue to be >> undocumented, misunderstood, and perhaps best retired completely. >> >> [1] https://github.com/Gnucash/gnucash/commit/a107a9af2 >> [2] https://github.com/Gnucash/gnucash/commit/259e01d5c >> >> >> On Tue, 21 Jul 2020 at 14:13, Ron Gill wrote: >> >>> Trying to figure out what the best practice is for Adjustment Entries and >>> Adjusted Trial Balance is in GnuCash. >>> >>> My main requirement is to be able to easily produce a (Non-Adjusted) >>> Trial >>> Balance and a Adjusted Trial Balance report. >>> >>> I was thinking of creating a temporary Adjustment Account to hold changes >>> and I could restore/delete this account to generate the above report. >>> >>> Seeking help on best practice for this. >>> ___ >>> 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.