cancel
Showing results for 
Search instead for 
Did you mean: 
AK2487
Level 1

Uncleared transactions

I have checks that were written in the last 2 previous years that have never cleared.  They continue to show up as uncleared transactions on my reconciliation reports.  What is the best way to remove them from the system since the checks are no longer valid?

5 Comments 5
DebSheenD
QuickBooks Team

Uncleared transactions

Hello, AK2487.

 

Thank you for reaching out to us here in the Community. I'm here to provide some information about the uncleared transaction on your reconciliation report. 

 

Ensure these transactions are relevant yet uncleared, you'll have to wait until it'll get cleared from the bank. However, if it's a duplicate, you can delete it in the bank register. Here's how:
 

  1. Go to the Banking menu.
  2. Choose Bank Feeds and then Bank Feeds Center.
  3. In the Items Reviewed section, hit the account with the transactions you want to remove.
  4. Click items to Delete.
  5. Tap the transactions you want to delete.
  6. Click Delete.


In addition, I've added this article that you can check about how to import web connect in QuickBooks Desktop.

 

I'm all ears if you have other questions about bank transactions in QuickBooks. Take care!

lexylu
Level 2

Uncleared transactions

H have the same issue but my client ha over 5000 uncleared transactions. They are marked with an "R" on the register. How do I clean this up quickly?

LeizylM
QuickBooks Team

Uncleared transactions

Hi there, lexylu. 

 

I'd be glad to help you clean up uncleared transactions in QuickBooks Desktop (QBDT).

 

But before doing so, let's make sure to secure a backup copy of your company file. This way, you'll be able to restore it anytime you want to undo the process.

 

To start, simply open the transaction and select the Delete option. Alternatively, you can use the keyboard shortcut CTRL + D to automatically delete an entry.

 

Another option is to have the Admin or External Accountant user log in and delete the transactions in bulk.

 

Here's how:

 

  1. From the File menu, select Switch to Single-user mode. If you see Switch to Multi-user mode, don't select it.
  2. Go to the Accountant menu and select Batch Delete/Void Transactions.
  3. Choose the transactions you want to delete or void from the Available Transactions list.
  4. Click on Review & Delete (or Review & Void).
  5. Select Back Up & Delete or Back Up & Void. You can also skip the backup and select Delete only or Void only from the dropdowns.User-added image
  6. Click Yes to confirm you want to delete or void the transactions.


Lastly, you can visit the Desktop Apps website and find a suitable deleter application. Simply enter the keyword "deleter" in the search field provided.

 

If you have any additional questions about un-cleared transactions, I'm always here to help. You are welcome to reply below or post again. Have a good one!

lexylu
Level 2

Uncleared transactions

My apologies. I am using quickbooks online - qbo

DebSheenD
QuickBooks Team

Uncleared transactions

Thanks for getting back to us, @lexylu.

 

Let me help you remove these uncleared transactions in QuickBooks Online (QBO).

 

If the transactions are automatically downloaded from the bank, you can proceed with the steps I previously mentioned. However, if you manually entered the transactions into QuickBooks, you'll have to delete them manually as well.

 

Here's how:
 

  1. Click the Banking menu.
  2. Select the correct bank account.
  3. Go to the  Reviewed tab and mark the items you want to delete.
  4. Click the Batch actions button.
  5. Choose Exclude Selected.
  6. Once done, go to the Excluded tab.
  7. Mark the transactions. Then, click the Batch actions button.
  8. Click Delete.

 

To learn more about this process, read this article: Exclude expenses from downloaded bank transactions.

 

Lastly, I recommend visiting this Community article: Reconcile Workflow. It contains in-depth details about starting, fixing any differences, and completing the reconciliation process. 

 

Please let me know how it goes or if you have other concerns. I'll be around to help some more. Take care.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us