Re: [GNC] reconcile problem?
I understand no piece of software "thinks for you" 100% (maybe you did not intend it, but that comment feels condescending to me, but I digress)though I would argue that GC does indeed do just that in many ways... I am just asking for help in dealing with this problem.problem being that the bank doesn’t differentiate between cards when posting the payment, therefore leading to GC not being able to differentiate. How does deleting them help? So you manually enter the payments transactions and also delete all the bank transactions from that bank during the import? My concern is then you have to basically go out and double check you have them manually entered so they do appear.which basically I have done... You said " when I import payments from by checking account, I allocate the payments to the correct card account." That is exactly what I am doing and where the problem arises. I do not use the import function for the credit card accounts, I enter them manually in the credit card accounts. I even use the same description as the bank does in my checking account"bankname payment". It is when I am importing my checking account info that the issue comes up..there are three choices on import on what to do with the itemand none of them seem to do the trick.one option imports the item and ends up being aduplictaeanother doesn’t import it at allthe third I cant recall what it does but it messes up..and again I assume that is because GC cannot differentiate. The SAME payment sometimes duplicates and also DIFFERENT payments to the same bank post to seemingly random accounts in GC for that bank. Was just hoping that as powerful as GC seems to be (I haven’t tapped into more than 40% of what it can do I would guess.) there was a more elegant solution so GC routes the imported payment to the right bank card account and doesn’t duplicate the same ones. -Original Message- From: Dean Gibson [mailto:gnucash.st...@mailpen.com] Sent: Friday, February 25, 2022 12:08 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] reconcile problem? Well, I have multiple multiple cards with the same bank, & it's no trouble to detect the payments during import & deal with them in an appropriate manner. I n my case, I delete them from the import. That makes the reconciliation balance to the amount that was due. Then, when I import payments from by checking account, I allocate the payments to the correct card account. GNUcash is reasonable accounting software. It just doesn't do thinking for each individual's particular situation. On 2022-02-25 08:20, David Carlson wrote: > That came up in another thread a couple of weeks ago. As far as I know, > the only solution is to be very careful in the matching step of the import. >You can help yourself when making the payments to be sure they have > different dates or amounts, or even paying out of different checking > accounts. > > On Fri, Feb 25, 2022 at 8:11 AM scum buster wrote: > >> Sidebar question --- do any of you have more than one credit card with the >> same bank? That is where I am running into issues when I import and >> "clear" (I have always called this "reconciling" but I guess there is a >> difference?) >> >> The bank just has a line item "bankname payment" , same for each card >> account. >> >> That is where I run into issues trying to manually "clear" and that throws >> my account balances in GC off >> >> -Original Message- >> From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] >> Sent: Wednesday, February 23, 2022 2:15 PM >> To:gnucash-u...@lists.gnucash.org >> Subject: Re: [GNC] reconcile problem? >> >> Transactions won't reconcile themselves, but you can clear them either >> manually or via an import. >> >> If you opened a backup by mistake, that would result in something >> showing 'unreconciled' if the backup was before the reconciliation. >> >> The only way to get the 'y' to appear in the register is through a >> reconciliation. Which means you in fact checked it off a previous time. >> >> You can re-do a reconciliation by changing all of the affected >> transactions back to 'n' or 'c', and then trying again. Be sure to >> remove any adjusting transactions you made during the last >> reconciliation. You probably don't need them. (but can always re-create >> if you do) >> >> Then proceed with this months reconciliation. >> >> In the future, if you ever notice transactions appearing 'c' or 'n' when >> you know they should be 'y' means you've edited them in a manner that >> will change the flag. (either in that register or one conn
Re: [GNC] reconcile problem?
Yeah that was probably me….I never saw a solution…..may have missed it, been dealing with health stuff…. Thanks for the reply….they do have different dates and amounts but seems like no matter how I attempt to handle them during the clearing process, something always ends up goofy….the matching step is where I am having issues. From: David Carlson [mailto:david.carlson@gmail.com] Sent: Friday, February 25, 2022 11:21 AM To: scum buster Cc: Adrien Monteleone; GnuCash List Subject: Re: [GNC] reconcile problem? That came up in another thread a couple of weeks ago. As far as I know, the only solution is to be very careful in the matching step of the import. You can help yourself when making the payments to be sure they have different dates or amounts, or even paying out of different checking accounts. On Fri, Feb 25, 2022 at 8:11 AM scum buster wrote: Sidebar question --- do any of you have more than one credit card with the same bank? That is where I am running into issues when I import and "clear" (I have always called this "reconciling" but I guess there is a difference?) The bank just has a line item "bankname payment" , same for each card account. That is where I run into issues trying to manually "clear" and that throws my account balances in GC off -Original Message- From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] Sent: Wednesday, February 23, 2022 2:15 PM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] reconcile problem? Transactions won't reconcile themselves, but you can clear them either manually or via an import. If you opened a backup by mistake, that would result in something showing 'unreconciled' if the backup was before the reconciliation. The only way to get the 'y' to appear in the register is through a reconciliation. Which means you in fact checked it off a previous time. You can re-do a reconciliation by changing all of the affected transactions back to 'n' or 'c', and then trying again. Be sure to remove any adjusting transactions you made during the last reconciliation. You probably don't need them. (but can always re-create if you do) Then proceed with this months reconciliation. In the future, if you ever notice transactions appearing 'c' or 'n' when you know they should be 'y' means you've edited them in a manner that will change the flag. (either in that register or one connected to the transaction) If you don't get warnings about this, go to Actions > Reset Warnings... and adjust as needed. When you edit a transaction and the flag changes (or you discover it later) simply re-reconcile and clear the affected transaction(s). (and if you are editing amounts, double check you didn't make an adjusting entry, because again, you might no longer need it!) Regards, Adrien On 2/23/22 9:33 AM, Paul Kinzelman wrote: > That's a good question and I think that could be an explanation > for the resurrection of the reconciled transactions which happened > quite awhile ago when I was new to GC. > > But that doesn't explain how a transaction could become > reconciled on its own like the one that happened this month, which > tipped me over the edge to post about it. -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] reconcile problem?
Sidebar question --- do any of you have more than one credit card with the same bank? That is where I am running into issues when I import and "clear" (I have always called this "reconciling" but I guess there is a difference?) The bank just has a line item "bankname payment" , same for each card account. That is where I run into issues trying to manually "clear" and that throws my account balances in GC off -Original Message- From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] Sent: Wednesday, February 23, 2022 2:15 PM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] reconcile problem? Transactions won't reconcile themselves, but you can clear them either manually or via an import. If you opened a backup by mistake, that would result in something showing 'unreconciled' if the backup was before the reconciliation. The only way to get the 'y' to appear in the register is through a reconciliation. Which means you in fact checked it off a previous time. You can re-do a reconciliation by changing all of the affected transactions back to 'n' or 'c', and then trying again. Be sure to remove any adjusting transactions you made during the last reconciliation. You probably don't need them. (but can always re-create if you do) Then proceed with this months reconciliation. In the future, if you ever notice transactions appearing 'c' or 'n' when you know they should be 'y' means you've edited them in a manner that will change the flag. (either in that register or one connected to the transaction) If you don't get warnings about this, go to Actions > Reset Warnings... and adjust as needed. When you edit a transaction and the flag changes (or you discover it later) simply re-reconcile and clear the affected transaction(s). (and if you are editing amounts, double check you didn't make an adjusting entry, because again, you might no longer need it!) Regards, Adrien On 2/23/22 9:33 AM, Paul Kinzelman wrote: > That's a good question and I think that could be an explanation > for the resurrection of the reconciled transactions which happened > quite awhile ago when I was new to GC. > > But that doesn't explain how a transaction could become > reconciled on its own like the one that happened this month, which > tipped me over the edge to post about it. -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] reconciling specific credit cards in an account
Hi Thanks for the reply. No, I don't use debit cards. The issue is that one bank services a few of my credit cards. And the downloads show them all the same --- "bankname online payment" with no differentiation of what specific credit card account that line item is for. Gnucash doesn't show any other info than that upon reconciling, probably because the bank doesn't provide it. My only other solution would be to have only one credit card per bank name...then it's a no brainer which credit card account goes with what. But that's not practical for me. -Original Message- From: John Layman [mailto:john.lay...@laymanandlayman.com] Sent: Thursday, February 17, 2022 12:56 PM To: 'scum buster'; gnucash-user@gnucash.org Subject: RE: [GNC] reconciling specific credit cards in an account Sounds like you are confusing your bank account debit card with a credit card. They may look the same, but the debit card will directly draw funds from the checking account. If you are having to enter a PIN number when you use that card, it's almost certainly a debit card. -Original Message- From: gnucash-user On Behalf Of scum buster Sent: Wednesday, February 16, 2022 8:03 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] reconciling specific credit cards in an account I have been using Gnucash for years..currently version 3.7. I very much appreciate the program.I used quicken for years til I started using Gnucash. Have never used this forum before, so I hope I don't screw this up. LOL I am not a Gnucash expertI know I do some things wrong but I get by One thing I always seem to have issues with (I am sure it is user error).is with my checking account and credit card charges that come through that account I download my checking account data as a quicken file and "import" that. I have a few credit cards with one company. The charges come through as " bankname online payment" when they hit my checking account. That would be fine if I had only one credit card with that bank. But with a few different cards, I have issues trying to get them to auto-reconcile correctly and end up having to manually add the items and manually pick the right account..and that ends up making duplicate charges somehow. What is the right way to set things up so that Gnucash knows what credit card account is being referenced when the charges hit my checking account? Thanks for your help! -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+scumbuster=comcast@gnucash.org] On Behalf Of gnucash-user-requ...@gnucash.org Sent: Wednesday, February 16, 2022 12:00 PM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 227, Issue 32 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] reconciling specific credit cards in an account
I have been using Gnucash for years..currently version 3.7. I very much appreciate the program.I used quicken for years til I started using Gnucash. Have never used this forum before, so I hope I don't screw this up. LOL I am not a Gnucash expertI know I do some things wrong but I get by One thing I always seem to have issues with (I am sure it is user error).is with my checking account and credit card charges that come through that account I download my checking account data as a quicken file and "import" that. I have a few credit cards with one company. The charges come through as " bankname online payment" when they hit my checking account. That would be fine if I had only one credit card with that bank. But with a few different cards, I have issues trying to get them to auto-reconcile correctly and end up having to manually add the items and manually pick the right account..and that ends up making duplicate charges somehow. What is the right way to set things up so that Gnucash knows what credit card account is being referenced when the charges hit my checking account? Thanks for your help! -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+scumbuster=comcast@gnucash.org] On Behalf Of gnucash-user-requ...@gnucash.org Sent: Wednesday, February 16, 2022 12:00 PM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 227, Issue 32 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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.