As mentioned by our colleague, running the Verify and Rebuild tool helps to isolate and fix the issue. Please try to click on the File menu, Utilities, select Verify.
Then, follow the instructions to resolve the error message. Try to go to the reconciliation page again.
Let us know if you need anything else. Thanks!
Same here, ive just gone to reconcile December and items that where previously reconciled in November have popped up.I thought it was meant to be ''quickbooks''?Not takes you five hours books!
Hello there, @Jo b.
Allow me to help share some information about the issue of previously reconciled transactions appearing back in the register as unreconciled.
Reconciled transactions show as unreconciled due to the following reasons:
- Undo Last Reconciliation was clicked.
- The reconciled transactions were changed or deleted.
- The cleared transactions were unchecked (uncleared) in the account register.
- Funds were transferred from a previously reconciled bank account to its sub account.
- The company file has been converted between QuickBooks for Mac and Windows or between QuickBooks Online and desktop (applies to US only).
- The transactions were never reconciled in the company file (perhaps a backup was restored and overrode the file where the reconciled transactions existed).
Whatever the reason/cause of the issue, you must re-reconcile the transactions. A special or mini reconciliation should help you complete this task with ease. There are two methods available to complete the process.
- Method 1, this uses an "off-cycle" reconciliation date and require that you know the ending balance from the most recent reconciliation.
- Method 2, this method uses a date other than the most recent reconciliation and does not require that you know the ending balance from the previous reconciliation.
For the detailed process and steps, you may check this article: Reconcile previously deleted and re-entered checking or credit card transactions.
Stay in touch if you have any other reconciliation concerns. Have a good one!
I have this same problem, and have for some time. The utilities do not help AT ALL, so when you recommend them you are just increasing people's frustration.
This bug crops up every once in a while and wastes my time. I hope Intuit will allocate the money to fix it one day. It's a known bug.
I'm having the same issue in QuickBooks Online. Recently transferred from QB Desktop to Online. Connected the bank accounts today and there are numerous checks that are showing up as "For Review" that were already cleared on a previous bank reconciliation.
How do I correct this?
Hi there, @lucedalelivestoc.
Thanks for reaching back out here in the Community. I'd be pleased to assist you with removing the bank transactions that are showing up on the For Review tab in QuickBooks Online.
You can exclude the bank transactions that are showing up on the For Review tab. Doing this removes the transactions downloaded from your bank institution.
To do that:
From the left menu, select Banking.
On the Banking page, select the For Review tab.
- Select the check-boxes of the transactions to exclude.
- From the Batch actions drop-down, choose Exclude Selected.
Excluded transactions are listed on the Excluded tab for reference or review, but are not tracked or reported as part of your business finances and don't appear in any associated account registers or reports.
To learn more about excluding transactions in QuickBooks, please refer to this article: How to exclude from downloaded bank transactions.
That should do it!
Please let me know if I can be of additional assistance. I'm always here to lend a helping hand. Wishing you and your business continued success.
Hello! I am having this issue as well. When I tried to reconcile for March 2019, a deposit from November of 2017 showed up!! After 4 days of reading (and attempting) almost every fix in this thread, nothing has worked. The only option I have not tried was the "exclude" transaction as I cannot seem to locate this option in Quickbooks Desktop. I was able to track down the date this 'magically reappeared' in my Reconciliation Screen. It was the day after I successfully completed January 2019's Reconciliation. If I restore the back-up from that day, it's all is good. But, if I restore the back-up from the following day, 02/15/19, it's wrong. I've spent too much time on this already, I cannot recreate every transaction since 02/14/19. There has to be another solution, please help!!
Hello! I am having this issue as well. When I tried to reconcile for March 2019, a deposit from November of 2017 showed up!! After 4 days of reading (and attempting) almost every fix in this thread, nothing has worked. The only option I have not tried was the "exclude" transaction, as I cannot seem to locate this option in Quickbooks Desktop. I was able to track down the date this 'magically reappeared' in my Reconciliation Screen. It was the day after I successfully completed January Reconciliation. If I restore the back-up from that day, it's all is good. But, if I restore the back-up from the following day (02/15/19) it's wrong. I've spent so much time on this already, I simply cannot recreate every transaction since 02/14/19. Please help!!
Thank you for joining the thread, @SpartanOffroad.
I'm here to help make sure that the reconciled transactions for March showed in the transaction list by filtering the date.
Let's review the date range of the transaction to make sure that the information is accurate. Here's how:
- Go to the Banking menu.
- Select Bank Feeds, then choose Bank Feeds Center.
- Choose the appropriate bank account.
- Click Transaction List.
- On the page, check the date range of the transaction and change it if not accurate.
Once done, your reconciled bank transaction will show on the page.
I've attached a screenshot below for your reference.
That should provide you with information about your concern. Feel free to post a comment below if you have other questions aside from this. I'll be around if you need me.
Hi there, @SpartanOffroad,
I appreciate you following the steps to resolve the transactions appearing back as unreconciled in your register.
This can happen when previously reconciled transactions have been modified, deleted, or added in the register.
You need to open the Reconciliation Discrepancy report so you can see transactions that were changed since the last reconciliation.
Here's how to pull up the report:
- Go to Reports.
- Select Banking, then Reconciliation Discrepancy.
- Select the appropriate account, then click OK.
- Then, review the report to identify any discrepancies.
- Once the discrepancy is identified, please make the necessary corrections.
You can also go through this article for additional information: Fix Reconciliation Discrepancies.
Please stay in touch with me on what the results are. I'm here anytime you need help.
@MaryLandT while I sincerely appreciate your suggestion, that was one of the first things I tried.
Trust me when I say that I have read & attempted EVERY suggested fix in this thread. I'll attach the image from the report showing no discrepancy.
I can also assure you that I would have no reason to go back to 2017 transactions to adjust anything. This happened all by itself.
Thanks for getting back to us in the Community and providing a screenshot, @SpartanOffroad.
Allow me to chime in for a moment and help make sure that this is taken care of.
First of all, I appreciate you taking your time following all the troubleshooting steps provided by my colleagues and on this thread. If you already tried performing the rebuild and verify data utilities and the issue still persists, I suggest contacting our Phone Support team. They have tools such as screen-sharing (remote access) that can check your company file and investigate this further. They can also perform other troubleshooting steps and fix this for you.
For the detailed steps on how to reach them, please refer to this article: Contact the QuickBooks Desktop Customer Support Team.
After contacting them, I'm confident that you'll be able to get rid of this issue.
Please comment below to let me know how it goes or if you have any follow-up questions. I'm always here for further assistance. Take care always!
Hello there, hyltonhundtsalo.
I appreciate you for joining this thread. I want this reconciliation issue to be taken care of.
Running the Verify and Rebuild tool helps to isolate and fix the issue with reconciliation.
However, if this doesn't work, you'll need to get in touch with our QuickBooks Care Team so they can take a closer look and conduct a deeper investigation about this reconciliation issue.
You can reach them through the contact details found in this link: Contact the QuickBooks Desktop Customer Support Team.
Keep me posted and don't hesitate to get back to me if there's anything else I can hep you with.
I've experienced the same problem - the dates on my recs appear to have jumped forward into 2019 and it's also pulling transactions from 2017 in to the reconciliation. I've used the Undo function to get back to where the issue seems to stem (October 2018) but the opening balance is now completely wrong. I ran the Verify and Rebuild functions - no issues. The discrepancy report is zero. I have no duplicates. I really don't want to have to go back to the beginning of time and re-run the recs, particularly if as I've read here, the problem re-occurs. I use QB Desktop Pro 2017. Can anyone advise what to do?
Hello there, Tuam.
I can see that you've already run the Verify/Rebuild utility tool to resolve your concern. However, we won't stop there, and I want to make sure you get more support to resolve this. I'd suggest reaching out to our technical support to check this further.
Here's how to get in touch with them:
- Click Help inside QuickBooks.
- Go to QuickBooks Desktop Help.
- In the Have a Question? window, click Contact Us.
- Enter a brief description of your issue, then click Continue.
- Choose either Message an Agent or Talk to a Specialist.
Of course, you can visit us if you have other concerns. We're just here to help you.
Definitely a bug! I just tried to reconcile previous month and found more than a year's worth of reconciliation gone! I do not download from bank. Always manual. Have used QuickBooks for almost 17 years, and have never experienced anything like this. I am using the Desktop Pro 2017 version, and I think the last update must have messed something up. I have read all the entries on this topic, and quite frankly, I am afraid to try any of the fixes lest something else go wrong. Ugh.
Thanks for joining us here in the Community, @MAG-M.
It's my priority that you'll be able to bring back your reconciled transactions.
Here are some resources that you can check out in case you encounter some issues upon reconciling the transactions:
If you need additional assistance with the procedure, you can feel free to get in touch with our Customer Care Team.
Please know that I'm just a post away should you need anything else about this concern. I'll be around to help you out. Have a good one!
Thank you for your reply, Betty Jane. I have at least three recent backups, but I don't want to restore without knowing if one of them solves the problem. I will be even more upset than I already am if I start losing transactions needlessly. Is there a way to open a backup that doesn't overwrite the existing data?
Thanks for keeping me updated about this, @MAG-M.
It's good to hear that you're now up and running. Let me provide some more details about restoring a company file in QuickBooks Desktop.
If you wish to open a backup that doesn't overwrite your existing data, all you have to do is to restore the backup and save it on your desktop. Additionally, if you encounter any issues while restoring the backup copy, you may refer to the articles below for some troubleshooting steps:
This should get you moving today.
Feel free to reach back out to me if you have any other questions concerning QuickBooks. I'll be happy to lend a hand. Wishing you and your business continued success!