Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have been struggling with this issue for so long now. Each year I wait until the last minute to reconcile the months of bank transactions in order to get the P&L done and uploaded to my tax accountant. This year I had decided I was going to keep up with monthly reconciliations and not wait until the last minute. So, I begin to reconcile January, February and March 2021. Suddenly I see this transaction from July 2020 of $117 appear as unreconciled. Naturally I go back to the July 2020 recon report and see that it had indeed been reconciled. Next I go through all the months leading up and through January 2021 and see it was not outstanding.
I undo each month from March and back through December to try to figure out what to do next. Seems there should be a log somewhere in Quickbooks Desktop Pro to see this transaction becoming unreconciled. But, nope, or at least I couldn't find it.
Good afternoon, @Pstreicher.
It's great to see you back in the Community. Let me share some light on this reconciling subject.
There are three step to help you fix issues when you're reconciling in your QuickBooks Desktop account:
Step 1: Review your opening and beginning balances
Step 2: Look for changed, deleted, or added transactions
Step 3: Look for reconciliation adjustments
You can review this guide on the particular instructions to take: Fix issues when you're reconciling in QuickBooks Desktop.
Let me know if this helps. I want to ensure that you're able to get back to running your business. Have a wonderful day!
Thanks for that but I have done all that.
Thanks for getting back to us, @Pstreicher.
I have some steps we can try. You'll want to run the Verify and Rebuild tools. The Verify tool self-identifies the most commonly known data issues within a company file and the Rebuild tool self-resolves most data integrity issues. Let me guide you how.
To run the Verify Data:
If your data has data damage, continue the steps to Rebuild Data to fix your file. Here's how:
For details check this article: Verify and Rebuild Data in QuickBooks Desktop.
After running the tools, check your reconciliation again.
Additionally, you can reach out to your accountant to review your reconciliation.
I'm also attaching this link in case you need help with bank-related tasks: Find help with bank feeds and reconciling accounts.
Let me know how it goes after trying the steps as I want to make sure this is resolved for you. Take care and have a good one.
Yep. Did that too. All was good.
I wish I really knew what happened here. Did I accidentally make the transaction unreconciled in the drop down check box? I tried deleting it but then the account is out of balance. This thing just doesn't make any sense to me and is holding me up. My thought now is to just continue reconciling each month and letting this transaction sit there as unreconciled. Maybe it will disappear one day like it appeared. I am not an accountant. I do have a cpa tax guy but I hesitate to call on him but may just send him an email, maybe ask to meet with him to show him this situation. Maybe he can make a suggestion via email.
I can't believe no one else has not came across this problem.
@ShiellaGraceA wrote:Thanks for getting back to us, @Pstreicher.
I have some steps we can try. You'll want to run the Verify and Rebuild tools. The Verify tool self-identifies the most commonly known data issues within a company file and the Rebuild tool self-resolves most data integrity issues. Let me guide you how.
To run the Verify Data:
- Go to File.
- Select Utilities.
- Click Verify Data.
If your data has data damage, continue the steps to Rebuild Data to fix your file. Here's how:
- Go to File.
- Select Utilities.
- Click Rebuild Data.
For details check this article: Verify and Rebuild Data in QuickBooks Desktop.
After running the tools, check your reconciliation again.
Additionally, you can reach out to your accountant to review your reconciliation.
I'm also attaching this link in case you need help with bank-related tasks: Find help with bank feeds and reconciling accounts.
Let me know how it goes after trying the steps as I want to make sure this is resolved for you. Take care and have a good one.
I have this problem too! Nothing fixes it
I have the same problem!
I appreciate you for bringing your concern to the Community forum, @Dreadiloks.
There are some reasons why the reconciled transactions will show up as unreconciled in the next days/years. In QuickBooks Desktop, it could be that someone undid the last reconciliation or changed/deleted the reconciled transactions.
This may also occur in these scenarios:
You'll want to run the Audit Trail report. It has all the records about the changes made to your QuickBooks company data file. Using an audit trail you can have a permanent record about who is performing changes in QuickBooks. Here's how:
To correct them, we can perform a special reconciliation. To make sure your account will remain accurate and balanced, you can consult your accountant.
For additional information, you can check this article: Learn the reconcile workflow in QuickBooks.
Stay in touch if you need anything else, Dreadiloks. Take care and stay healthy.
Thank you for this very detailed reply. I should have updated the thread to post that I did follow some advice given earlier, which I believe was similar to yours. After many attempts, nothing worked. Then, one morning I woke up with the thought of having another attempt at it. I didn't quite know what it was that I was going to try to do but somehow I managed to trick the program and complete a fix. From what I can remember basically all I had to do was to add in an offsetting transaction that I thought would negate the problem or unreconciled transaction. Note that this unreconciled and problem child transaction had been reconciled six months before. I had taken a hiatus for several months before getting back to the reconciling for the year. I will also tell everyone here that I did not have a good and solid backup/restore procedure or routine I like to call it previously. If I had backed up the file with every monthly reconciliation I would have been able to easily restored that month previous to where the problem transaction was and begin anew. I am now remembering and, in the habit, while taking my time to do this backup routine with each monthly reconciliation.
Back to where I left off though, Once I entered the opposite or negating transaction I then deleted the problem transaction from the register. If I remember correctly, all I did next was go into my current month reconciliation and check off the new negating transaction and I was able to balance. Reading this now as I typed it, it just doesn't quite seem right or how I did it. But, I believe if anyone else has this problem, just go through the steps posted by our moderator, Sarah, and I believe that you will somehow magically fix this as I did. I now believe that a monthly backup is so important that it can't be stressed enough. I still to this day wonder how this problem came about but I can only imagine it was my error and a problem error. It happens, but, you move on after the fix and hope it never happens again. I'd be interested in hearing if any of you get this problem fixed sooner than later now with all this information posted here.
Oh, I just remembered after reading over replies with help. I did do an adjusting entry to the reconciliation at first I believe. I"m a little foggy on the actual steps I took at the moment. This was the first important step now I believe that got me to thinking the next morning on how to resolve this. I think then I was about to change the unreconciled entry to reconciled, delete the negating entry along with the adjusting entry and then the next reconciliation showed balanced. Crazy, right? I hope I never have to go through this again but if I do I'll know what to do. Remember, it's just a computer program and we can sometimes logically think through a manipulation or trick to get things done right. :)
I have been using QB desktop for the past 15 years and no one has been able to solve this issue so far. It is obviously a programmer issue and they will need to find a fix for it. You will not be able to delete them. Only way to make them disappear is to click the button on the top right corner of the screen to hide the transactions after the statements end date. I still have charges showing in the reconciliation window from 2015! It is super annoying and I have not found a solution after many attempts to run diagnostics ect. ect......Good luck! I hope that Intuit will find a solution soon.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here