Re: [GNC] rookie question Imbalance-USD
Thanks; my apologies to you as well. On Jun 21, 2022, 09:46, at 09:46, Gyle McCollam wrote: >Liz, >Even though your email was not directed at me, I too want to apologize >for my part in the exchange. My apology is not only to you, but to the >user base and to David T. as well. > > >Thank You, >Gyle McCollam > >Gyle McCollam > >609.680.2326 Mobile > >gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > >From: gnucash-user >on behalf of Liz >Sent: Tuesday, June 21, 2022 12:55 AM >To: David T. via gnucash-user >Subject: Re: [GNC] rookie question Imbalance-USD > >On Sun, 19 Jun 2022 10:57:19 -0400 >"David T. via gnucash-user" wrote: > >> I made my comment from that perspective; your snarky comment just >> underscores for me the kind of person YOU are. Go stuff yourself. >> >> David T. > > >David, >As the moderator, I don't want to see such words in the archives. >You put in lots of good information, please refrain from those sorts of >comments. > >Liz >___ >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. ___ 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] rookie question Imbalance-USD
Liz, Even though your email was not directed at me, I too want to apologize for my part in the exchange. My apology is not only to you, but to the user base and to David T. as well. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Liz Sent: Tuesday, June 21, 2022 12:55 AM To: David T. via gnucash-user Subject: Re: [GNC] rookie question Imbalance-USD On Sun, 19 Jun 2022 10:57:19 -0400 "David T. via gnucash-user" wrote: > I made my comment from that perspective; your snarky comment just > underscores for me the kind of person YOU are. Go stuff yourself. > > David T. David, As the moderator, I don't want to see such words in the archives. You put in lots of good information, please refrain from those sorts of comments. Liz ___ 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] rookie question Imbalance-USD
I agree. I apologize for responding as I did. On June 21, 2022 12:55:15 AM EDT, Liz wrote: >On Sun, 19 Jun 2022 10:57:19 -0400 >"David T. via gnucash-user" wrote: > >> I made my comment from that perspective; your snarky comment just >> underscores for me the kind of person YOU are. Go stuff yourself. >> >> David T. > > >David, >As the moderator, I don't want to see such words in the archives. >You put in lots of good information, please refrain from those sorts of >comments. > >Liz >___ >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] rookie question Imbalance-USD
On Sun, 19 Jun 2022 10:57:19 -0400 "David T. via gnucash-user" wrote: > I made my comment from that perspective; your snarky comment just > underscores for me the kind of person YOU are. Go stuff yourself. > > David T. David, As the moderator, I don't want to see such words in the archives. You put in lots of good information, please refrain from those sorts of comments. Liz ___ 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] rookie question Imbalance-USD
Kevin, We cannot really tell whether it is correct to remove the transactions to the Imbalance account or not. You can really only determine that by examining the register of the account to which you think you should perhaps change the split to the imbalance account. Before actually changing it check in that register for that account and check if it would duplicate a transaction already present. If so then it would likely be safe to delete. If not and you are reasonably sure it is the right account you would change it and assign the Imbalance account entry to it. Any transactions to Equity:Opening Balance accounts should be at or near the date you first created the books and there should be an entry in Equity:Opening Balances for each Asset or Liability account which existed at that date. Ultimately your check on all of this will be when you run a reconciliations of the credit card account(s) and your bank accounts against the statements provided by the bank. This should detect if you have incorrectly assigned one end of a transaction to an asset or liability account. It is generally not possible to reconcile Equity ,Income and Expense accounts as there are no external statements to reconcile them against. David Cousens On Mon, 2022-06-20 at 22:30 +, Kevin T via gnucash-user wrote: > Sorry to have created such a row. > Yes, clicking the split does indeed show me more information and is helpful to > a point. > I have made many blunders during this process that I am likely to pay for in > time. I paid little attention to the import account as I figured I would > properly assign them at a later time. Yes, I had used quicken many years ago, > sorry. > I appreciate the information all of you have provided. > I have read some more about double entry accounting. Again thanks. > That said, I have 3 cases in the Imbalance account. All are discussed with > the split line showing. I hope that you can see the screen shots included. > a) ones which are truly involving only one account. > these I am assuming they are safe to remove as no other accounts are effected. > > ..b) one in which the transaction is showing two accounts and one of them > is the imbalance account and one other 'proper' account. > > The above is a credit card transaction. In the double entry world, and if > this were a a perfect world, the imbalance would be a different asset > account. In the real world, the asset account, not shown, does cover this > transaction but is done in a single transfer of funds to the source CC > account. > I have reconciled all the CC card accounts. If done properly, should the > imbalance account be the source CC account? > If I look at the CC accounts that I have made all the corrections, or imported > more correctly, the transactions contain appropriate double entries, as below. > > I think that these types of entries are also left over from imports not used > or repeated. They are almost all involving CC imports. It would seem that > these are also OK to remove. They are double, and at times tripling, the > expense account entries and values...c) this one involves opening > balances. > > what should a opening balance be offset with ? To me, this is a magical > entry, and its source, whether credit or debit, is of no importance. There > is only one Opening balance account in the equity group. In am starting in > the middle of the year and the accounts have existed for a while there are > opening balances for all Equities, Liabilities, and Assets. Should there be > others ?. > My background is engineering, the transfer of electrons is well understood. > Accounting, and its nuances, are not. > Again, thanks for all of your insight. > Kevin > > On Saturday, June 18, 2022, 05:29:56 PM CDT, David T. > wrote: > > The confusion arises when you use "entry" for both splits and transactions in > the same paragraph, as you did here. > > On June 18, 2022 4:57:57 PM EDT, Gyle McCollam wrote: > When I say entry, I refer to the entire transaction, but I get your point. > > > Sent from Samsung Galaxy smartphone. > > > Original message From: "David T." Date: > 6/18/22 4:24 PM (GMT-05:00) To: gnucash-user@gnucash.org, Gyle McCollam < > gmccol...@live.com>, David Carlson , Kevin T < > neviki...@yahoo.com>Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie > question Imbalance-USD > Gyle, > > Whether you delete the imbalance account or not once it is empty is a user > preference. Some dislike seeing the imbalance account in their books, and > delete it if it is empty. Others (like myself and you) leave that account in > place. I leave it because it just reappears again later anyways when you miss > a
Re: [GNC] rookie question Imbalance-USD
You're welcome. You seem to have sent it with a mysterious subtext that is impossible to decipher. For the record, improperly-used terminology on this list has resulted in epic misunderstandings that confuse newcomers when they attempt to understand the complexities of both gnucash AND double entry bookkeeping. The terminology in this specific case is a prime example of this. If you were to go back and look at the list archives, you'd see involved discussions about the use and meaning of the terms "transaction" "split" and "entry". I made my comment from that perspective; your snarky comment just underscores for me the kind of person YOU are. Go stuff yourself. David T. On June 19, 2022 9:59:23 AM EDT, Gyle McCollam wrote: >Thank you for going back over my post with such a fine-tooth comb. I don't >know how I could have made such an egregious error. I will attempt to do >better in the future, but when I make an error like this again in the future, >and I'm sure I will, please bring it to my attention. My sincerest apologies. > I do hope you forgive me. > >Thank you. > > >Thank You, >Gyle McCollam > >Gyle McCollam > > >gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > >From: David T. >Sent: Saturday, June 18, 2022 6:32 PM >To: Gyle McCollam ; gnucash-user@gnucash.org >; David Carlson ; Kevin >T >Subject: RE: [GNC] rookie question Imbalance-USD > >The confusion arises when you use "entry" for both splits and transactions in >the same paragraph, as you did here. > >On June 18, 2022 4:57:57 PM EDT, Gyle McCollam wrote: >When I say entry, I refer to the entire transaction, but I get your point. > > > >Sent from Samsung Galaxy smartphone. > > > > Original message >From: "David T." >Date: 6/18/22 4:24 PM (GMT-05:00) >To: gnucash-user@gnucash.org, Gyle McCollam , David >Carlson , Kevin T >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] rookie question Imbalance-USD > >Gyle, > >Whether you delete the imbalance account or not once it is empty is a user >preference. Some dislike seeing the imbalance account in their books, and >delete it if it is empty. Others (like myself and you) leave that account in >place. I leave it because it just reappears again later anyways when you miss >an entry. > >Also, I'll note that you made a misleading statement late in the first >paragraph when you said that "If he deletes the entry, he will delete it from >the other accounts as well." In this instance, I think you meant to say "If he >deletes the **transaction,** he will delete it from the other accounts as >well." It's a minor, yet significant, difference in terminology. An entry (as >I understand) is the single line within a transaction, synonymous with the >Gnucash term "split." The Transaction is made up of two or more splits/entries. > >Best, >David T. > >On June 18, 2022 2:57:01 PM EDT, Gyle McCollam wrote: > >I agree that the matching step is critical when importing and the proper >account should be assigned during import. I also agree that the OP needs to >understand Double Entry accounting better, However, if he has "empty" >transactions in the imbalance account, my bet is that if he clicks on the >split icon in the toolbar, he will see his debit and credit accounts, plus the >empty imbalance account. When correcting the imbalance entry, he needs to >open the split and click on the imbalance entry and change that to the proper >account. I think he added the proper account, entered the amount, then >removed the amount from the imbalance account. Doing it this way you can't >delete the imbalance account, unless you "jump" to one of the other accounts >and delete it from there. If he deletes the entry, he will delete it from the >other accounts as well, which he doesn't want to do. > You state that "Once all funds are re-allocated there should be no entries > remaining and you can safely delete that account." You don't delete the > account, once there are no entries the account it is irrelevant and if you > have it set to not display unused accounts you won't see it unless in the > future there is another entry in there, > > >Thank You, >Gyle McCollam > >Gyle McCollam > >609.680.2326 Mobile > >gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > >From: gnucash-user on >behalf of David Carlson >Sent: Saturday, June 18, 2022 1:59 PM >To: Kevin T >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] r
Re: [GNC] rookie question Imbalance-USD
Sorry, tht first para was to be cross out. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Gyle McCollam Sent: Sunday, June 19, 2022 9:59 AM To: David T. ; gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD Thank you for going back over my post with such a fine-tooth comb. I don't know how I could have made such an egregious error. I will attempt to do better in the future, but when I make an error like this again in the future, and I'm sure I will, please bring it to my attention. My sincerest apologies. I do hope you forgive me. Thank you. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: David T. Sent: Saturday, June 18, 2022 6:32 PM To: Gyle McCollam ; gnucash-user@gnucash.org ; David Carlson ; Kevin T Subject: RE: [GNC] rookie question Imbalance-USD The confusion arises when you use "entry" for both splits and transactions in the same paragraph, as you did here. On June 18, 2022 4:57:57 PM EDT, Gyle McCollam wrote: When I say entry, I refer to the entire transaction, but I get your point. Sent from Samsung Galaxy smartphone. Original message From: "David T." Date: 6/18/22 4:24 PM (GMT-05:00) To: gnucash-user@gnucash.org, Gyle McCollam , David Carlson , Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD Gyle, Whether you delete the imbalance account or not once it is empty is a user preference. Some dislike seeing the imbalance account in their books, and delete it if it is empty. Others (like myself and you) leave that account in place. I leave it because it just reappears again later anyways when you miss an entry. Also, I'll note that you made a misleading statement late in the first paragraph when you said that "If he deletes the entry, he will delete it from the other accounts as well." In this instance, I think you meant to say "If he deletes the **transaction,** he will delete it from the other accounts as well." It's a minor, yet significant, difference in terminology. An entry (as I understand) is the single line within a transaction, synonymous with the Gnucash term "split." The Transaction is made up of two or more splits/entries. Best, David T. On June 18, 2022 2:57:01 PM EDT, Gyle McCollam wrote: I agree that the matching step is critical when importing and the proper account should be assigned during import. I also agree that the OP needs to understand Double Entry accounting better, However, if he has "empty" transactions in the imbalance account, my bet is that if he clicks on the split icon in the toolbar, he will see his debit and credit accounts, plus the empty imbalance account. When correcting the imbalance entry, he needs to open the split and click on the imbalance entry and change that to the proper account. I think he added the proper account, entered the amount, then removed the amount from the imbalance account. Doing it this way you can't delete the imbalance account, unless you "jump" to one of the other accounts and delete it from there. If he deletes the entry, he will delete it from the other accounts as well, which he doesn't want to do. You state that "Once all funds are re-allocated there should be no entries remaining and you can safely delete that account." You don't delete the account, once there are no entries the account it is irrelevant and if you have it set to not display unused accounts you won't see it unless in the future there is another entry in there, Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of David Carlson Sent: Saturday, June 18, 2022 1:59 PM To: Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD First, Imbalance-USD is not an expense account but a top level account, and it is intended to be used only when an automated function is unable to form a fully balanced transaction. You are correct that you can look under that account name to find unbalanced transactions if and when they exist. You might find it useful to re-read about double entry bookkeeping in the various help resources. The F1 key should work while in GnuCash. We never use the term "Category" to refer to anything in GnuCash, not even "Expense" Accounts. The fact that you are finding "empty" transactions there indicates that you are not always deleting references to that account after re-allocating funds to the desired account. Onc
Re: [GNC] rookie question Imbalance-USD
Thank you for going back over my post with such a fine-tooth comb. I don't know how I could have made such an egregious error. I will attempt to do better in the future, but when I make an error like this again in the future, and I'm sure I will, please bring it to my attention. My sincerest apologies. I do hope you forgive me. Thank you. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: David T. Sent: Saturday, June 18, 2022 6:32 PM To: Gyle McCollam ; gnucash-user@gnucash.org ; David Carlson ; Kevin T Subject: RE: [GNC] rookie question Imbalance-USD The confusion arises when you use "entry" for both splits and transactions in the same paragraph, as you did here. On June 18, 2022 4:57:57 PM EDT, Gyle McCollam wrote: When I say entry, I refer to the entire transaction, but I get your point. Sent from Samsung Galaxy smartphone. Original message From: "David T." Date: 6/18/22 4:24 PM (GMT-05:00) To: gnucash-user@gnucash.org, Gyle McCollam , David Carlson , Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD Gyle, Whether you delete the imbalance account or not once it is empty is a user preference. Some dislike seeing the imbalance account in their books, and delete it if it is empty. Others (like myself and you) leave that account in place. I leave it because it just reappears again later anyways when you miss an entry. Also, I'll note that you made a misleading statement late in the first paragraph when you said that "If he deletes the entry, he will delete it from the other accounts as well." In this instance, I think you meant to say "If he deletes the **transaction,** he will delete it from the other accounts as well." It's a minor, yet significant, difference in terminology. An entry (as I understand) is the single line within a transaction, synonymous with the Gnucash term "split." The Transaction is made up of two or more splits/entries. Best, David T. On June 18, 2022 2:57:01 PM EDT, Gyle McCollam wrote: I agree that the matching step is critical when importing and the proper account should be assigned during import. I also agree that the OP needs to understand Double Entry accounting better, However, if he has "empty" transactions in the imbalance account, my bet is that if he clicks on the split icon in the toolbar, he will see his debit and credit accounts, plus the empty imbalance account. When correcting the imbalance entry, he needs to open the split and click on the imbalance entry and change that to the proper account. I think he added the proper account, entered the amount, then removed the amount from the imbalance account. Doing it this way you can't delete the imbalance account, unless you "jump" to one of the other accounts and delete it from there. If he deletes the entry, he will delete it from the other accounts as well, which he doesn't want to do. You state that "Once all funds are re-allocated there should be no entries remaining and you can safely delete that account." You don't delete the account, once there are no entries the account it is irrelevant and if you have it set to not display unused accounts you won't see it unless in the future there is another entry in there, Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of David Carlson Sent: Saturday, June 18, 2022 1:59 PM To: Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD First, Imbalance-USD is not an expense account but a top level account, and it is intended to be used only when an automated function is unable to form a fully balanced transaction. You are correct that you can look under that account name to find unbalanced transactions if and when they exist. You might find it useful to re-read about double entry bookkeeping in the various help resources. The F1 key should work while in GnuCash. We never use the term "Category" to refer to anything in GnuCash, not even "Expense" Accounts. The fact that you are finding "empty" transactions there indicates that you are not always deleting references to that account after re-allocating funds to the desired account. Once all funds are re-allocated there should be no entries remaining and you can safely delete that account. It will be re-created if new transactions appear. As you noticed, double-clicking is nearly useless in GnuCash. It does work to change the sort order of columns in some windows. When using an import function, GnuCash is trying to learn what Account transactions have been applied to in the past so it can
Re: [GNC] rookie question Imbalance-USD
The confusion arises when you use "entry" for both splits and transactions in the same paragraph, as you did here. On June 18, 2022 4:57:57 PM EDT, Gyle McCollam wrote: >When I say entry, I refer to the entire transaction, but I get your point. > > > >Sent from Samsung Galaxy smartphone. > > > > Original message >From: "David T." >Date: 6/18/22 4:24 PM (GMT-05:00) >To: gnucash-user@gnucash.org, Gyle McCollam , David >Carlson , Kevin T >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] rookie question Imbalance-USD > >Gyle, > >Whether you delete the imbalance account or not once it is empty is a user >preference. Some dislike seeing the imbalance account in their books, and >delete it if it is empty. Others (like myself and you) leave that account in >place. I leave it because it just reappears again later anyways when you miss >an entry. > >Also, I'll note that you made a misleading statement late in the first >paragraph when you said that "If he deletes the entry, he will delete it from >the other accounts as well." In this instance, I think you meant to say "If he >deletes the **transaction,** he will delete it from the other accounts as >well." It's a minor, yet significant, difference in terminology. An entry (as >I understand) is the single line within a transaction, synonymous with the >Gnucash term "split." The Transaction is made up of two or more splits/entries. > >Best, >David T. > >On June 18, 2022 2:57:01 PM EDT, Gyle McCollam wrote: > >I agree that the matching step is critical when importing and the proper >account should be assigned during import. I also agree that the OP needs to >understand Double Entry accounting better, However, if he has "empty" >transactions in the imbalance account, my bet is that if he clicks on the >split icon in the toolbar, he will see his debit and credit accounts, plus the >empty imbalance account. When correcting the imbalance entry, he needs to >open the split and click on the imbalance entry and change that to the proper >account. I think he added the proper account, entered the amount, then >removed the amount from the imbalance account. Doing it this way you can't >delete the imbalance account, unless you "jump" to one of the other accounts >and delete it from there. If he deletes the entry, he will delete it from the >other accounts as well, which he doesn't want to do. > You state that "Once all funds are re-allocated there should be no entries > remaining and you can safely delete that account." You don't delete the > account, once there are no entries the account it is irrelevant and if you > have it set to not display unused accounts you won't see it unless in the > future there is another entry in there, > > >Thank You, >Gyle McCollam > >Gyle McCollam > >609.680.2326 Mobile > >gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > >From: gnucash-user on >behalf of David Carlson >Sent: Saturday, June 18, 2022 1:59 PM >To: Kevin T >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] rookie question Imbalance-USD > >First, Imbalance-USD is not an expense account but a top level account, and >it is intended to be used only when an automated function is unable to form >a fully balanced transaction. You are correct that you can look under that >account name to find unbalanced transactions if and when they exist. > >You might find it useful to re-read about double entry bookkeeping in the >various help resources. The F1 key should work while in GnuCash. > >We never use the term "Category" to refer to anything in GnuCash, not even >"Expense" Accounts. > >The fact that you are finding "empty" transactions there indicates that you >are not always deleting references to that account after re-allocating >funds to the desired account. Once all funds are re-allocated there should >be no entries remaining and you can safely delete that account. It will be >re-created if new transactions appear. > >As you noticed, double-clicking is nearly useless in GnuCash. It does work >to change the sort order of columns in some windows. > >When using an import function, GnuCash is trying to learn what Account >transactions have been applied to in the past so it can try to use the same >account with similar transactions. That is why it is important to use the >"Matching" step to correct account assignments before the import process is >closed. > >Lastly, text files in Windows OS always use CR-LF, but other OS's mostly >use C
Re: [GNC] rookie question Imbalance-USD
When I say entry, I refer to the entire transaction, but I get your point. Sent from Samsung Galaxy smartphone. Original message From: "David T." Date: 6/18/22 4:24 PM (GMT-05:00) To: gnucash-user@gnucash.org, Gyle McCollam , David Carlson , Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD Gyle, Whether you delete the imbalance account or not once it is empty is a user preference. Some dislike seeing the imbalance account in their books, and delete it if it is empty. Others (like myself and you) leave that account in place. I leave it because it just reappears again later anyways when you miss an entry. Also, I'll note that you made a misleading statement late in the first paragraph when you said that "If he deletes the entry, he will delete it from the other accounts as well." In this instance, I think you meant to say "If he deletes the **transaction,** he will delete it from the other accounts as well." It's a minor, yet significant, difference in terminology. An entry (as I understand) is the single line within a transaction, synonymous with the Gnucash term "split." The Transaction is made up of two or more splits/entries. Best, David T. On June 18, 2022 2:57:01 PM EDT, Gyle McCollam wrote: I agree that the matching step is critical when importing and the proper account should be assigned during import. I also agree that the OP needs to understand Double Entry accounting better, However, if he has "empty" transactions in the imbalance account, my bet is that if he clicks on the split icon in the toolbar, he will see his debit and credit accounts, plus the empty imbalance account. When correcting the imbalance entry, he needs to open the split and click on the imbalance entry and change that to the proper account. I think he added the proper account, entered the amount, then removed the amount from the imbalance account. Doing it this way you can't delete the imbalance account, unless you "jump" to one of the other accounts and delete it from there. If he deletes the entry, he will delete it from the other accounts as well, which he doesn't want to do. You state that "Once all funds are re-allocated there should be no entries remaining and you can safely delete that account." You don't delete the account, once there are no entries the account it is irrelevant and if you have it set to not display unused accounts you won't see it unless in the future there is another entry in there, Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of David Carlson Sent: Saturday, June 18, 2022 1:59 PM To: Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD First, Imbalance-USD is not an expense account but a top level account, and it is intended to be used only when an automated function is unable to form a fully balanced transaction. You are correct that you can look under that account name to find unbalanced transactions if and when they exist. You might find it useful to re-read about double entry bookkeeping in the various help resources. The F1 key should work while in GnuCash. We never use the term "Category" to refer to anything in GnuCash, not even "Expense" Accounts. The fact that you are finding "empty" transactions there indicates that you are not always deleting references to that account after re-allocating funds to the desired account. Once all funds are re-allocated there should be no entries remaining and you can safely delete that account. It will be re-created if new transactions appear. As you noticed, double-clicking is nearly useless in GnuCash. It does work to change the sort order of columns in some windows. When using an import function, GnuCash is trying to learn what Account transactions have been applied to in the past so it can try to use the same account with similar transactions. That is why it is important to use the "Matching" step to correct account assignments before the import process is closed. Lastly, text files in Windows OS always use CR-LF, but other OS's mostly use CR. This creates confusion when viewing text files in other OS's. On Sat, Jun 18, 2022 at 11:54 AM Kevin T via gnucash-user < gnucash-user@gnucash.org> wrote: I have been populating my accounts with CSV. During the import, the tool doesn't have any existing transactions to match, so most of them get assigned the expense category 'Imbalance-USD'. I am to the point of making sure that accounts are reconciled and transactions don't have left over or bad account assignments. Since Imbalance is one of those expense categories I thought that would be a good place to ma
Re: [GNC] rookie question Imbalance-USD
Gyle, Whether you delete the imbalance account or not once it is empty is a user preference. Some dislike seeing the imbalance account in their books, and delete it if it is empty. Others (like myself and you) leave that account in place. I leave it because it just reappears again later anyways when you miss an entry. Also, I'll note that you made a misleading statement late in the first paragraph when you said that "If he deletes the entry, he will delete it from the other accounts as well." In this instance, I think you meant to say "If he deletes the **transaction,** he will delete it from the other accounts as well." It's a minor, yet significant, difference in terminology. An entry (as I understand) is the single line within a transaction, synonymous with the Gnucash term "split." The Transaction is made up of two or more splits/entries. Best, David T. On June 18, 2022 2:57:01 PM EDT, Gyle McCollam wrote: >I agree that the matching step is critical when importing and the proper >account should be assigned during import. I also agree that the OP needs to >understand Double Entry accounting better, However, if he has "empty" >transactions in the imbalance account, my bet is that if he clicks on the >split icon in the toolbar, he will see his debit and credit accounts, plus the >empty imbalance account. When correcting the imbalance entry, he needs to >open the split and click on the imbalance entry and change that to the proper >account. I think he added the proper account, entered the amount, then >removed the amount from the imbalance account. Doing it this way you can't >delete the imbalance account, unless you "jump" to one of the other accounts >and delete it from there. If he deletes the entry, he will delete it from the >other accounts as well, which he doesn't want to do. > You state that "Once all funds are re-allocated there should be no entries > remaining and you can safely delete that account." You don't delete the > account, once there are no entries the account it is irrelevant and if you > have it set to not display unused accounts you won't see it unless in the > future there is another entry in there, > > >Thank You, >Gyle McCollam > >Gyle McCollam > >609.680.2326 Mobile > >gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > >____ >From: gnucash-user on >behalf of David Carlson >Sent: Saturday, June 18, 2022 1:59 PM >To: Kevin T >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] rookie question Imbalance-USD > >First, Imbalance-USD is not an expense account but a top level account, and >it is intended to be used only when an automated function is unable to form >a fully balanced transaction. You are correct that you can look under that >account name to find unbalanced transactions if and when they exist. > >You might find it useful to re-read about double entry bookkeeping in the >various help resources. The F1 key should work while in GnuCash. > >We never use the term "Category" to refer to anything in GnuCash, not even >"Expense" Accounts. > >The fact that you are finding "empty" transactions there indicates that you >are not always deleting references to that account after re-allocating >funds to the desired account. Once all funds are re-allocated there should >be no entries remaining and you can safely delete that account. It will be >re-created if new transactions appear. > >As you noticed, double-clicking is nearly useless in GnuCash. It does work >to change the sort order of columns in some windows. > >When using an import function, GnuCash is trying to learn what Account >transactions have been applied to in the past so it can try to use the same >account with similar transactions. That is why it is important to use the >"Matching" step to correct account assignments before the import process is >closed. > >Lastly, text files in Windows OS always use CR-LF, but other OS's mostly >use CR. This creates confusion when viewing text files in other OS's. > > >On Sat, Jun 18, 2022 at 11:54 AM Kevin T via gnucash-user < >gnucash-user@gnucash.org> wrote: > >> I have been populating my accounts with CSV. During the import, the tool >> doesn't have any existing transactions to match, so most of them get >> assigned the expense category 'Imbalance-USD'. >> I am to the point of making sure that accounts are reconciled and >> transactions don't have left over or bad account assignments. Since >> Imbalance is one of those expense categories I thought that would be a good >> place to make sure things are clean. >>
Re: [GNC] rookie question Imbalance-USD
I agree that the matching step is critical when importing and the proper account should be assigned during import. I also agree that the OP needs to understand Double Entry accounting better, However, if he has "empty" transactions in the imbalance account, my bet is that if he clicks on the split icon in the toolbar, he will see his debit and credit accounts, plus the empty imbalance account. When correcting the imbalance entry, he needs to open the split and click on the imbalance entry and change that to the proper account. I think he added the proper account, entered the amount, then removed the amount from the imbalance account. Doing it this way you can't delete the imbalance account, unless you "jump" to one of the other accounts and delete it from there. If he deletes the entry, he will delete it from the other accounts as well, which he doesn't want to do. You state that "Once all funds are re-allocated there should be no entries remaining and you can safely delete that account." You don't delete the account, once there are no entries the account it is irrelevant and if you have it set to not display unused accounts you won't see it unless in the future there is another entry in there, Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of David Carlson Sent: Saturday, June 18, 2022 1:59 PM To: Kevin T Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie question Imbalance-USD First, Imbalance-USD is not an expense account but a top level account, and it is intended to be used only when an automated function is unable to form a fully balanced transaction. You are correct that you can look under that account name to find unbalanced transactions if and when they exist. You might find it useful to re-read about double entry bookkeeping in the various help resources. The F1 key should work while in GnuCash. We never use the term "Category" to refer to anything in GnuCash, not even "Expense" Accounts. The fact that you are finding "empty" transactions there indicates that you are not always deleting references to that account after re-allocating funds to the desired account. Once all funds are re-allocated there should be no entries remaining and you can safely delete that account. It will be re-created if new transactions appear. As you noticed, double-clicking is nearly useless in GnuCash. It does work to change the sort order of columns in some windows. When using an import function, GnuCash is trying to learn what Account transactions have been applied to in the past so it can try to use the same account with similar transactions. That is why it is important to use the "Matching" step to correct account assignments before the import process is closed. Lastly, text files in Windows OS always use CR-LF, but other OS's mostly use CR. This creates confusion when viewing text files in other OS's. On Sat, Jun 18, 2022 at 11:54 AM Kevin T via gnucash-user < gnucash-user@gnucash.org> wrote: > I have been populating my accounts with CSV. During the import, the tool > doesn't have any existing transactions to match, so most of them get > assigned the expense category 'Imbalance-USD'. > I am to the point of making sure that accounts are reconciled and > transactions don't have left over or bad account assignments. Since > Imbalance is one of those expense categories I thought that would be a good > place to make sure things are clean. > I double click that expense category and the tab populates.Most of these > entries have no value in either the deposit or withdrawal columns.Some > do.Some even have a transfer account defined and values. > Sooo.. the stupid questions.. > If they have a transfer account and values already specified, why is this > transaction in this expense category?How do I find out from which account > these transactions were originally created? double clicking does > nothing.If they contain no values, is it safe to delete them? > I did import a number of times, trying figuring out the import behavior, > into temp or no longer existing accounts. Are these left over after > deleting these accounts? > version 4.1 windows. > I have noticed that my original emails contain a ? for every CRLF that > occurs, when the mailing list distributes this. I am using yahoo mail to > send this. Is there a way to stop this ? mark 'feature'?? > > Kevin > ___ > 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 > htt
Re: [GNC] rookie question Imbalance-USD
First, Imbalance-USD is not an expense account but a top level account, and it is intended to be used only when an automated function is unable to form a fully balanced transaction. You are correct that you can look under that account name to find unbalanced transactions if and when they exist. You might find it useful to re-read about double entry bookkeeping in the various help resources. The F1 key should work while in GnuCash. We never use the term "Category" to refer to anything in GnuCash, not even "Expense" Accounts. The fact that you are finding "empty" transactions there indicates that you are not always deleting references to that account after re-allocating funds to the desired account. Once all funds are re-allocated there should be no entries remaining and you can safely delete that account. It will be re-created if new transactions appear. As you noticed, double-clicking is nearly useless in GnuCash. It does work to change the sort order of columns in some windows. When using an import function, GnuCash is trying to learn what Account transactions have been applied to in the past so it can try to use the same account with similar transactions. That is why it is important to use the "Matching" step to correct account assignments before the import process is closed. Lastly, text files in Windows OS always use CR-LF, but other OS's mostly use CR. This creates confusion when viewing text files in other OS's. On Sat, Jun 18, 2022 at 11:54 AM Kevin T via gnucash-user < gnucash-user@gnucash.org> wrote: > I have been populating my accounts with CSV. During the import, the tool > doesn't have any existing transactions to match, so most of them get > assigned the expense category 'Imbalance-USD'. > I am to the point of making sure that accounts are reconciled and > transactions don't have left over or bad account assignments. Since > Imbalance is one of those expense categories I thought that would be a good > place to make sure things are clean. > I double click that expense category and the tab populates.Most of these > entries have no value in either the deposit or withdrawal columns.Some > do.Some even have a transfer account defined and values. > Sooo.. the stupid questions.. > If they have a transfer account and values already specified, why is this > transaction in this expense category?How do I find out from which account > these transactions were originally created? double clicking does > nothing.If they contain no values, is it safe to delete them? > I did import a number of times, trying figuring out the import behavior, > into temp or no longer existing accounts. Are these left over after > deleting these accounts? > version 4.1 windows. > I have noticed that my original emails contain a ? for every CRLF that > occurs, when the mailing list distributes this. I am using yahoo mail to > send this. Is there a way to stop this ? mark 'feature'?? > > Kevin > ___ > 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.
[GNC] rookie question Imbalance-USD
I have been populating my accounts with CSV. During the import, the tool doesn't have any existing transactions to match, so most of them get assigned the expense category 'Imbalance-USD'. I am to the point of making sure that accounts are reconciled and transactions don't have left over or bad account assignments. Since Imbalance is one of those expense categories I thought that would be a good place to make sure things are clean. I double click that expense category and the tab populates.Most of these entries have no value in either the deposit or withdrawal columns.Some do.Some even have a transfer account defined and values. Sooo.. the stupid questions.. If they have a transfer account and values already specified, why is this transaction in this expense category?How do I find out from which account these transactions were originally created? double clicking does nothing.If they contain no values, is it safe to delete them? I did import a number of times, trying figuring out the import behavior, into temp or no longer existing accounts. Are these left over after deleting these accounts? version 4.1 windows. I have noticed that my original emails contain a ? for every CRLF that occurs, when the mailing list distributes this. I am using yahoo mail to send this. Is there a way to stop this ? mark 'feature'?? Kevin ___ 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.
