Re: [GNC] Import is finding no matching transactions
On Wed, 1 Jun 2022 00:00:19 + Gyle McCollam wrote: > Aaron, > 1st David is correct, you don't set up the expense account as > subaccounts of your checking account. They are Expenses and you > debit the expense account and credit the bank account. By looking at > the expense account you get the "running total" of the expense. But don't panic, the accounts in the inappropriate place can be moved, by editing the accounts from the Accounts screen. 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] Import is finding no matching transactions
Aaron, 1st David is correct, you don't set up the expense account as subaccounts of your checking account. They are Expenses and you debit the expense account and credit the bank account. By looking at the expense account you get the "running total" of the expense. 2ndly, Budgets are set up for expected expenses for you to track what you thought you were going to spend versus what you actually spent. "Budget" accounts never show you an "active" or current balance in an account, the actual expense account shows you the running total or active balance. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of davidcousen...@gmail.com Sent: Tuesday, May 31, 2022 6:27 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import is finding no matching transactions Aaron, >From your description it sounds as though you have created sub-accounts of your checking account to implement a budget process. If this is the case, it is the opposite of normal accounting proceduress. To account for expenditure in a specific category the generally accepted procedure is to create sub accounts of Expenses for specific expense categories. You can get information on the Budgeting features in the Tutorial and Concepts Guide https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_budgets.html and from the wiki https://wiki.gnucash.org/wiki/Budget_Requirements detailing a bit more of the background. David Cousens On Tue, 2022-05-31 at 15:17 +, Thepwnd via gnucash-user wrote: > Hi all, > > I wanted to circle back on this issue that I opened a couple weeks ago. I > came down with the flu, as did the rest of my family, so I haven't had a > chance to look at this again until this weekend. Also, I'm not sure if I'm > creating the response to the mailing list in the most optimal way, but I can't > find any specific instructions other than to change the subject line when > replying, so please let me know if there's something else I should be doing. > > With that out of the way, I was able to figure out what the problem > was. Apparently my importer tool wasn't able to find any matches because the > source account is locked as my "Checking Account," but when I setup my > accounts initially - and I'm not sure this was the correct way to do it - I > ended up creating a bunch of subaccounts for all of my expense categories. My > intention was to be able to see a running balance in each category, but I also > don't think I understand how to fully utilize the budget feature in > GnuCash. At any rate, I updated one of my transactions to set the source > account to the main/root checking account, rather than the subaccount, and now > the importer is able to find a match for it. > > So I guess I have a few follow-up questions: 1) Can I use the budget feature > in GnuCash to see an active balance for a given expense category, or does the > budget only tell me how much money I've spent in that category for the given > time period? 2) Is there a way to either change the source account on an > import (I'm not sure how it automatically detected the Checking Account in the > first place) or to perform a mass update to the source account on my > transactions? > > Thanks, > -Aaron > ___ > 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] Import is finding no matching transactions
Aaron, >From your description it sounds as though you have created sub-accounts of your checking account to implement a budget process. If this is the case, it is the opposite of normal accounting proceduress. To account for expenditure in a specific category the generally accepted procedure is to create sub accounts of Expenses for specific expense categories. You can get information on the Budgeting features in the Tutorial and Concepts Guide https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_budgets.html and from the wiki https://wiki.gnucash.org/wiki/Budget_Requirements detailing a bit more of the background. David Cousens On Tue, 2022-05-31 at 15:17 +, Thepwnd via gnucash-user wrote: > Hi all, > > I wanted to circle back on this issue that I opened a couple weeks ago. I > came down with the flu, as did the rest of my family, so I haven't had a > chance to look at this again until this weekend. Also, I'm not sure if I'm > creating the response to the mailing list in the most optimal way, but I can't > find any specific instructions other than to change the subject line when > replying, so please let me know if there's something else I should be doing. > > With that out of the way, I was able to figure out what the problem > was. Apparently my importer tool wasn't able to find any matches because the > source account is locked as my "Checking Account," but when I setup my > accounts initially - and I'm not sure this was the correct way to do it - I > ended up creating a bunch of subaccounts for all of my expense categories. My > intention was to be able to see a running balance in each category, but I also > don't think I understand how to fully utilize the budget feature in > GnuCash. At any rate, I updated one of my transactions to set the source > account to the main/root checking account, rather than the subaccount, and now > the importer is able to find a match for it. > > So I guess I have a few follow-up questions: 1) Can I use the budget feature > in GnuCash to see an active balance for a given expense category, or does the > budget only tell me how much money I've spent in that category for the given > time period? 2) Is there a way to either change the source account on an > import (I'm not sure how it automatically detected the Checking Account in the > first place) or to perform a mass update to the source account on my > transactions? > > Thanks, > -Aaron > ___ > 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] Import is finding no matching transactions
Hi all, I wanted to circle back on this issue that I opened a couple weeks ago. I came down with the flu, as did the rest of my family, so I haven't had a chance to look at this again until this weekend. Also, I'm not sure if I'm creating the response to the mailing list in the most optimal way, but I can't find any specific instructions other than to change the subject line when replying, so please let me know if there's something else I should be doing. With that out of the way, I was able to figure out what the problem was. Apparently my importer tool wasn't able to find any matches because the source account is locked as my "Checking Account," but when I setup my accounts initially - and I'm not sure this was the correct way to do it - I ended up creating a bunch of subaccounts for all of my expense categories. My intention was to be able to see a running balance in each category, but I also don't think I understand how to fully utilize the budget feature in GnuCash. At any rate, I updated one of my transactions to set the source account to the main/root checking account, rather than the subaccount, and now the importer is able to find a match for it. So I guess I have a few follow-up questions: 1) Can I use the budget feature in GnuCash to see an active balance for a given expense category, or does the budget only tell me how much money I've spent in that category for the given time period? 2) Is there a way to either change the source account on an import (I'm not sure how it automatically detected the Checking Account in the first place) or to perform a mass update to the source account on my transactions? Thanks, -Aaron ___ 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] Import is finding no matching transactions
Yes, if the transactions have been imported before, they will not even show in the matching dialog, in the latest version of GC. J On 5/14/2022 4:26 PM, Greg Feneis wrote: Another possibility is if you happen to be trying to import transactions that GnuCash thinks have already been imported, the matcher dialogue may appear like there are no transactions being proposed to be imported, essentially there will be nothing displayed in the matcher dialogue. Just in case this is what you're seeing. This according to how GnuCash 3.21 works. Maybe newer GnuCash still works the same? Kind regards, Greg Feneis (Pixel 3) On Sat, May 14, 2022, 14:20 Jean L wrote: Can you give us more details? Are you saying that GC does not show matching transactions, but does it at least show the imported transactions (and fails to find matches)? Note that the transaction dates have to match (the imported transactions and the ones you have in your ledger) for them to be matched (look in your preferences, the "import" tab, that's where the thresholds are adjusted for days), they don't have to match exactly depending on the "likely match day threshold" but they have to be within that. You could try to debug by lowering the "match display threshold" to see whether that helps GC find them. But in theory, if the days match and the amounts match, GC should find the transactions and show them in the reconcile dialog. On 5/14/2022 2:06 PM, Thepwnd via gnucash-user wrote: Hi all, So I am still fairly new to Gnucash (and personal finances for that matter), but I've been using it the last 2 months and change to track my family's spending. I primarily use my debit card for daily purchases, but I have begun keeping receipts for more immediate entry into the ledger and to more accurately track what categories I spend the most money in. However, there are still some purchases I make that don't give me a receipt, and in those cases, the only record I have is on my bank statement. I would like to be able to import my bank statement occasionally to catch all those transactions, but not duplicate all the ones I already entered. My understanding is that when importing transactions from a bank statement, Gnucash should be able to match any existing transactions on the ledger and mark those as "Reconcile" on the statement. I swear this was working when I first started using Gnucash, but now, when I try to import my bank statement, Gnucash isn't finding any matches on the ledger, even though the vast majority of the transactions on the statement already exist in Gnucash. I can't figure out what happened, and there don't appear to be any preferences for imports or matching, so I'm not sure what I might have changed to cause this to stop working. Does anyone here have any ideas? Thanks in advance! -Aaron Sent with [ProtonMail](https://protonmail.com/) secure email. ___ 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 seehttps:// 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 seehttps://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] Import is finding no matching transactions
Another possibility is if you happen to be trying to import transactions that GnuCash thinks have already been imported, the matcher dialogue may appear like there are no transactions being proposed to be imported, essentially there will be nothing displayed in the matcher dialogue. Just in case this is what you're seeing. This according to how GnuCash 3.21 works. Maybe newer GnuCash still works the same? Kind regards, Greg Feneis (Pixel 3) On Sat, May 14, 2022, 14:20 Jean L wrote: > Can you give us more details? Are you saying that GC does not show > matching transactions, but does it at least show the imported > transactions (and fails to find matches)? > > Note that the transaction dates have to match (the imported transactions > and the ones you have in your ledger) for them to be matched (look in > your preferences, the "import" tab, that's where the thresholds are > adjusted for days), they don't have to match exactly depending on the > "likely match day threshold" but they have to be within that. You could > try to debug by lowering the "match display threshold" to see whether > that helps GC find them. But in theory, if the days match and the > amounts match, GC should find the transactions and show them in the > reconcile dialog. > > On 5/14/2022 2:06 PM, Thepwnd via gnucash-user wrote: > > Hi all, > > > > So I am still fairly new to Gnucash (and personal finances for that > matter), but I've been using it the last 2 months and change to track my > family's spending. I primarily use my debit card for daily purchases, but I > have begun keeping receipts for more immediate entry into the ledger and to > more accurately track what categories I spend the most money in. However, > there are still some purchases I make that don't give me a receipt, and in > those cases, the only record I have is on my bank statement. > > > > I would like to be able to import my bank statement occasionally to > catch all those transactions, but not duplicate all the ones I already > entered. My understanding is that when importing transactions from a bank > statement, Gnucash should be able to match any existing transactions on the > ledger and mark those as "Reconcile" on the statement. I swear this was > working when I first started using Gnucash, but now, when I try to import > my bank statement, Gnucash isn't finding any matches on the ledger, even > though the vast majority of the transactions on the statement already exist > in Gnucash. > > > > I can't figure out what happened, and there don't appear to be any > preferences for imports or matching, so I'm not sure what I might have > changed to cause this to stop working. Does anyone here have any ideas? > > > > Thanks in advance! > > -Aaron > > > > Sent with [ProtonMail](https://protonmail.com/) secure email. > > ___ > > 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 seehttps:// > 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] Import is finding no matching transactions
Can you give us more details? Are you saying that GC does not show matching transactions, but does it at least show the imported transactions (and fails to find matches)? Note that the transaction dates have to match (the imported transactions and the ones you have in your ledger) for them to be matched (look in your preferences, the "import" tab, that's where the thresholds are adjusted for days), they don't have to match exactly depending on the "likely match day threshold" but they have to be within that. You could try to debug by lowering the "match display threshold" to see whether that helps GC find them. But in theory, if the days match and the amounts match, GC should find the transactions and show them in the reconcile dialog. On 5/14/2022 2:06 PM, Thepwnd via gnucash-user wrote: Hi all, So I am still fairly new to Gnucash (and personal finances for that matter), but I've been using it the last 2 months and change to track my family's spending. I primarily use my debit card for daily purchases, but I have begun keeping receipts for more immediate entry into the ledger and to more accurately track what categories I spend the most money in. However, there are still some purchases I make that don't give me a receipt, and in those cases, the only record I have is on my bank statement. I would like to be able to import my bank statement occasionally to catch all those transactions, but not duplicate all the ones I already entered. My understanding is that when importing transactions from a bank statement, Gnucash should be able to match any existing transactions on the ledger and mark those as "Reconcile" on the statement. I swear this was working when I first started using Gnucash, but now, when I try to import my bank statement, Gnucash isn't finding any matches on the ledger, even though the vast majority of the transactions on the statement already exist in Gnucash. I can't figure out what happened, and there don't appear to be any preferences for imports or matching, so I'm not sure what I might have changed to cause this to stop working. Does anyone here have any ideas? Thanks in advance! -Aaron Sent with [ProtonMail](https://protonmail.com/) secure email. ___ 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 seehttps://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.