I upgraded from Desktop Premier 2016 to 2019 in March 2019. After the upgrade, transactions that were previously deleted or reconciled are reappearing. Some are from years ago and I know they had been either deleted or removed previously.

RHOMES1 · ‎March 04, 2020

I do not download from the bank feed or do any kind of electronic downloads. I have gone in and cleaned up the previously reconciled transactions and they reappear the next month. What is causing this and what can I do to stop it? I have read other threads on here and tried the suggestions but nothing seems to work.

RCV · ‎March 04, 2020

Let's investigate what's causing the deleted transactions to reappear in your QuickBooks, RHOMES.

When upgrading QuickBooks, it uses the default folder location of your company file. Let's make sure we select the correct file to avoid downloading the company with the deleted and reconciled transactions.

You can also restore it in your new QuickBooks version if you created a backup file (QBB).

If you can't find it, just open the Windows Start menu and choose File Explorer. Then, look for your company file by name or the .qbw file extension.

You can check out this article for more details about displaying hidden files: Display hidden files and folders or search for files using Windows.

To learn more about upgrading QuickBooks and company files, please refer to these articles:

I have a link here where you can find articles about getting started with QuickBooks: https://quickbooks.intuit.com/learn-support/en-us/get-started/07?product=QuickBooks%20Desktop.

I'm just one reply away if you need a hand with account reconciliation or any QuickBooks related. I'll be here to help.

RHOMES1 · ‎March 11, 2020

I think you are misunderstanding me. We updated Quickbooks in March 2019 from the 2016 Premier Nonprofit edition to the 2019 Premier Nonprofit edition. We never had any trouble prior to the upgrade.

I am the bookkeeper, but I do not reconcile the accounts, we try to keep duties separate so another employee does the reconciliations. It was brought to my attention by the other employee in Jan. 2020, that she was having trouble reconciling because old transactions had come back to the reconciliation screen. We know that she can hide them, but we did not know why they were appearing at all. When I looked at her screen I also saw the transactions that were previously reconciled are now back and showing as un-reconciled. No one manually entered them.

In another reconciliation screen for a different account, my coworker enters the interest on the first screen of the reconciliation, where it should go. After she has completed the reconciliation, the interest then shows as an un-reconciled deposit. No one has entered it as a deposit, goes there by itself after the reconciliation. We have no idea why this is happening or how to fix it. I already went in once, located all of the duplicate entries, saved my work, logged out and when I returned to the program a few days later, all the duplicate interest transactions I deleted were back, plus some additional ones in the future.

A third issue occurred yesterday, my coworker reconciled another different account (we have about 16 different bank accounts each month to reconcile), she noted on the reconciliation the transactions that were still appearing even though they were previously reconciled. I logged in on my own computer, saw them as well, investigated them to find they had been voided, did not hit save at any time, just closed the window, asked my coworker to log back in to see how they showed in her reconciliation window and they were gone. No changes had been made in any way to the transactions.

I cannot keep wasting time and energy fixing duplicate entries just to have them return, especially when they are not being manually entered.

RHOMES1 · ‎March 11, 2020

I think you are misunderstanding me. We updated Quickbooks in March 2019 from the 2016 Premier Nonprofit edition to the 2019 Premier Nonprofit edition. We never had any trouble prior to the upgrade.

I am the bookkeeper, but I do not reconcile the accounts, we try to keep duties separate so another employee does the reconciliations. It was brought to my attention by the other employee in Jan. 2020, that she was having trouble reconciling because old transactions had come back to the reconciliation screen. We know that she can hide them, but we did not know why they were appearing at all. When I looked at her screen I also saw the transactions that were previously reconciled are now back and showing as unreconciled. No one manually entered them.

In another reconciliation screen for a different account, my coworker enters the interest on the first screen of the reconciliation, where it should go. After she has completed the reconciliation, the interest then shows as an unreconciled deposit. No one has entered it as a deposit, goes there by itself after the reconciliation. We have no idea why this is happening or how to fix it. I already went in once, located all of the duplicate entries, saved my work, logged out and when I returned to the program a few days later, all the duplicate interest transactions I deleted were back, plus some additional ones in the future.

A third issue occurred yesterday, my coworker reconciled another different account (we have about 16 different bank accounts each month to reconcile), she noted on the reconciliation the transactions that were still appearing even though they were previously reconciled. I logged in on my own computer, saw them as well, investigated them to find they had been voided, did not hit save at any time, just closed the window, asked my coworker to log back in to see how they showed in her reconciliation window and they were gone. No changes had been made in any way to the transactions.

I cannot keep wasting time and energy fixing duplicate entries just to have them return, especially when they are not being manually entered.

MirriamM · ‎March 11, 2020

Hello again, RHOMES1. I appreciate you providing additional details.

There are reasons why transactions already reconciled show up as unreconciled in QuickBooks Desktop (QBDT). These are due to the following:

Someone undid the last reconciliation.
Someone changed or deleted the reconciled transactions.
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) (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.

To fix the issue, I recommend you to download and run the Verify and Rebuild tool. This helps detect any issues in your company file and corrects them.

To do this, check below steps:

From the File menu.
Click on Utilities.
Select Rebuild Data/ Verify Data.

Once done, perform a mini reconciliation to resolve the problem. You can check this article for your detailed guidance: Reconcile previously deleted and re-entered checking or credit card transactions.

If you have any other follow up questions, let me know by commenting below. I'm always here to answer it for you. Have a great day!

RHOMES1 · ‎March 11, 2020

I have tried what you suggested with 2 of the entities we have that we are having issues with. The results were the same for both.

I ran the Verify Tool - I received the same message for both - "Quickbooks detected no problems with your data."

I ran the Rebuild Tool - I received the same message for both again - "Issues found 1, Errors we fixed - Error 179 See Online Article Warning: Verify Master: totTrans wrong. Is 8576 Should be 8673.

I tried the mini reconciliation, however if I check off the transactions I am fixing fixing, the difference field is not $0.00 so I did not hit Reconcile Now.

I have not tried this with the other 2 entities that we have because they have more duplicated entries then the first two.

RHOMES1 · ‎March 11, 2020

I have tried what you suggested with 2 of our 4 entities that we are having issues with. This is what happened:

I ran the Verify Tool - I received the same response for both - "Quickbooks detected no problems with your data."

I ran the Rebuild Tool - I received the same response for both - Issues found 1 - Errors we fixed Error 179 Warning: Verify Master: totTrans wrong. Is 8576 Should be 8673.

I tried to run a mini reconciliation however when I get to step 5: In reconcile window, check off the transactions you are fixing and re-reconciling, when I check the items off, the difference field no longer shows $0.00 so I did not hit the reconcile now button.

The other 2 entities have a lot more duplicate transactions that no one manually entered, so I do not want to try a fix with them until I know it works, which this did not.

Ashley H · ‎March 11, 2020

Allow me to chime in for a moment and help make sure that this is taken care of, @RHOMES1.

First of all, I appreciate your taking your time to follow all the troubleshooting steps provided by my colleagues on this thread. Since the issue persists, I suggest contacting our Desktop Support. 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. Here's how to get in touch:

Open QuickBooks.
Go to Help, then QuickBooks Desktop Help.
Choose Contact Us.
Give a brief description of your issue, then hit Continue.
Pick how you want to get contacted.

Let me know how the conversation goes. I'm always here for further assistance. Best wishes!

sherrylfacteau · ‎June 23, 2020

Hi -

I reconciled the credit card last month. All good. This month when I went to reconcile - a charge

from last month has reappeared. I do not know how or why the charge is there but I need to

know how to correct. This is QB DT Version 2018 Premier Manufacturing and Wholesale.

Thank you.

Sherry

[email address removed]

MaulikH · ‎June 23, 2020

Hi there, sherrylfacteau.

Thanks for joining the QuickBooks Community. I found a great article that would help with noticing the charge causing the issue and resolving it.

Fix issues when you're reconciling, is a great resource that you can use at any time. I'm also available, simply reply below to contact me at any time. Have a great day!

Topics

Training

Community

Resources

I upgraded from Desktop Premier 2016 to 2019 in March 2019. After the upgrade, transactions that were previously deleted or reconciled are reappearing. Some are from years ago and I know they had been either deleted or removed previously.