A Reconciled Transaction from 2020 Suddenly Appears in 2021 as Unreconciled, How to fix this?

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:

1. Go to File.
2. Select Utilities.
3. Click Verify Data. 

If your data has data damage, continue the steps to Rebuild Data to fix your file. Here's how:

1. Go to File.
2. Select Utilities.
3. 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.

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:

 

1. Go to File.
2. Select Utilities.
3. Click Verify Data. 

 

If your data has data damage, continue the steps to Rebuild Data to fix your file. Here's how:

 

1. Go to File.
2. Select Utilities.
3. 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:

• Cleared transactions were unchecked (uncleared) in the account register.
• Funds were transferred from a previously reconciled bank account to a sub-account.
• Company file conversions can cause issues (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) (the US only).
• The transactions were never reconciled in the company file. This might be because the file was restored from a backup, which can overwrite data and reconciliations.

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:

1. Click Reports at the top menu bar and choose Account & Taxes.
2. Select Audit Trail. On the report screen, click Customize Report.
3. Filter the dates. Then, click OK. You can use this article to customize it: Customize a report.

To correct them, we can perform a special reconciliation. To make sure your account will remain accurate and balanced, you can consult your accountant.

1. Go to the Banking menu and select Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
5. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
6. Make sure the Difference field shows $0.00.
7. Once done, select Reconcile Now.

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.