Skip to main content
C
casa3
September 2, 2020
Question

Reconciliation reports show voided checks under "uncleared deposits". Why is this and how can I address this inaccuracy?

  • September 2, 2020
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

N
Nick_M
September 2, 2020

Hi there, casa3.

 

I'm here to walk you through on clearing our duplicate transaction so you don't have the uncleared deposit in your reconciliation.

 

If these transactions are added from the Banking page, you can undo and exclude them afterward. I'll show you how.

 

Here’s how:

  1. Log in to QuickBooks Online. 
  2. From the left menu, click Banking.
  3. Select the bank where the transaction is coming from. 
  4. Click the Reviewed or Categorized tab. 
  5. Select the transaction that has duplicates. 
  6. Click the Undo button. 

 

The transactions are now moved back to the For Review tab in which you can exclude them. If these are manually entered transactions, you can go to the customer or vendor’s list of transactions and delete each from there. 

 

To undo a monthly bank reconciliation, the accountant who has QuickBooks Online accountant can undo a reconciliation at once.

 

You can read through these articles to learn more about managing your bank transactions:

 

If you have any other questions, feel free to post down below. Thank you for your time and have a nice afternoon. 

C
casa3Author
September 2, 2020

Hello Nick, and I appreciate your quick response. Excluding duplicates from the bank feed is being done already, and presents no problem. The issue, rather, is the position of voided checks that appear on the reconciliation report under the "uncleared DEPOSITS" section. Thee checks that are listed under this section are checks that were never presented for payment because they were erroneously generated (messed up by the printer); they never showed up in the bank feed. Accordingly, a new check was created and the erroneous one voided.  What puzzles me is that these voided checks even show up at all in the recon report, and furthermore under "uncleared deposits" when they are in fact expenditures. So I guess my question is this: why do these voided checks appear in the recon report as "uncleared deposits" when they were never issued and are not deposits?  Any insight is much appreciated, thank you!

RenjolynC
RenjolynC
September 2, 2020

Thanks for getting back here, casa3.

 

I have some idea why you see the voided checks on the reconcile page. When voiding a check, this only changes the amount of the transaction to zero. However, QuickBooks still keeps a record of the transaction to show that it was canceled.

 

Since the checks never cleared the bank, you have the option to delete the transaction. Please note that deleting removes the transaction entirely.

 

Here's how:

 

  1. Go to Expenses > Vendors.
  2. Select the vendor's name and open the voided check.
  3. Click More located at the bottom, and choose Delete.
  4. Select Yes to confirm the deletion.

If you wish to see the record of the deleted check, you can run the Audit Log report by following these steps:

 

  1. Go to the Gear > Audit Log.
  2. Click Filter, and select the User, Date, and choose Transactions from the Events section.
  3. Select Apply. 
  4. Under the Event column, you will see a description of Deleted Check.
  5. Click the View link under History to see the check details.

I've got this sample screenshot for a visual guide:

 

 

Once done, you can start reconciling the account again. I'm adding this article for the instructions: Reconcile an account in QuickBooks Online.

 

To check for other guides and articles, please feel free to browse for a topic in our general support page.

 

Please feel free to add a comment below if you have any additional questions or other concerns. Take care and stay safe.

W
WJohns-UK
May 31, 2023

I think I have found the answer!

I am using Quickbooks Online.  I have run the bank reconcilation for my client's year end and I have pages of 0 value transactions that my client has voided.

Reading a previous reply I decided to run the reconcilation again using the same bank statement amount and date. I was going to then manually select all 0 value transactions but I decided to filter the transactions using the word Voided.

It brought up all the transactions I needed and the difference as 0. I selected them all, clicked done and viewed the new reconcilation report and all the voided transactions were now in the cleared section rather than the uncleared.

I started a new reconcilation just to see if the still appeared and they have now gone and my report is 6 pages shorter.

I really hope this is what you need and if not that it helps someone else.

    Terms & ConditionsAccessibility statement