cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
FMW
Level 3

Previous cleared amounts in bank suddenly reappearing

Good morning,

 The bank register/account is showing amounts of previously cleared and reconciled amounts.  The current bank statement balance and my QB balance are in order/reconcile. 

Why/how are these previously cleared transactions appearing (see attached)--even going back to early 2020?

How do I clear these without effecting the bank account and QB account, as I said, both these accounts are reconciled correctly. 

 

Thank you very much,

QBDT Premier 2019

 

 

Solved
Best answer October 21, 2021

Best Answers
jamespaul
Moderator

Previous cleared amounts in bank suddenly reappearing

Hello, FMW. 

 

I appreciate the screenshot. I have a couple of things you can do to help you remove those old 2020 transactions. 

 

Since your statement matches with QuickBooks' balances, then this can be caused by a data damage. You can fix this by using the Verify/Rebuild Utility. Here's how: 

 

  1. Go to File.
  2. Hover on Utilities, and select Verify Data.
  3. Follow the prompts and wait for the process to complete.
  4. After the Verify process, go back to the File and Utilities menu again.
  5. Select Rebuild.
  6. Follow the pop-up prompts to start the rebuild process. 

 

After running the utility, go back to your bank register and the Reconciliation page and check those 2020 transactions. 

 

While you mentioned that the statement and balances are correct, I would still suggest double-checking the Discrepancy report. This ensures that those 2020 transactions aren't duplicated or manually unreconciled from the bank register. 

 

Here's how: 

 

  1. Go to the Banking menu, then select Reconcile.
  2. Click the Locate Discrepancies button.
  3. Select Discrepancy Report

 

You can also use the Previous Reports button to check for previously cleared or reconciled transactions.

 

If those 2020 transactions are duplicated or have been unreconciled, then you'll want to delete them or do a mini-reconciliation. This will affect the bank account, so I would suggest reaching out to an accountant.  

 

If you need help with the mini-reconciliation, you can also check this article: Reconcile previously deleted and re-entered checking or credit card transactions.

 

Do you need help recording your sales and expenses for the next period? I would suggest browsing for an article from these topics if you need a guide or two: 

 

 

I'm always down to answer any other concerns you might have regarding the reconciliation or your transactions in QuickBooks. If you're looking to finish other tasks, please let me know and I'll lend a hand again. 

View solution in original post

1 Comment 1
jamespaul
Moderator

Previous cleared amounts in bank suddenly reappearing

Hello, FMW. 

 

I appreciate the screenshot. I have a couple of things you can do to help you remove those old 2020 transactions. 

 

Since your statement matches with QuickBooks' balances, then this can be caused by a data damage. You can fix this by using the Verify/Rebuild Utility. Here's how: 

 

  1. Go to File.
  2. Hover on Utilities, and select Verify Data.
  3. Follow the prompts and wait for the process to complete.
  4. After the Verify process, go back to the File and Utilities menu again.
  5. Select Rebuild.
  6. Follow the pop-up prompts to start the rebuild process. 

 

After running the utility, go back to your bank register and the Reconciliation page and check those 2020 transactions. 

 

While you mentioned that the statement and balances are correct, I would still suggest double-checking the Discrepancy report. This ensures that those 2020 transactions aren't duplicated or manually unreconciled from the bank register. 

 

Here's how: 

 

  1. Go to the Banking menu, then select Reconcile.
  2. Click the Locate Discrepancies button.
  3. Select Discrepancy Report

 

You can also use the Previous Reports button to check for previously cleared or reconciled transactions.

 

If those 2020 transactions are duplicated or have been unreconciled, then you'll want to delete them or do a mini-reconciliation. This will affect the bank account, so I would suggest reaching out to an accountant.  

 

If you need help with the mini-reconciliation, you can also check this article: Reconcile previously deleted and re-entered checking or credit card transactions.

 

Do you need help recording your sales and expenses for the next period? I would suggest browsing for an article from these topics if you need a guide or two: 

 

 

I'm always down to answer any other concerns you might have regarding the reconciliation or your transactions in QuickBooks. If you're looking to finish other tasks, please let me know and I'll lend a hand again. 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us