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

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:

• Bank transactions are duplicates, missing or wrong or bank balance not updating
• Exclude duplicates or personal expenses from downloaded bank transactions

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

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!

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.

Following this practice will remove the record of the original check and the void, does it not?  We need to preserve the record of the voided check as well as the re-isssued check.  How do we do that?

Thanks,

Geoff

Greetings, gstuart.

Helping you preserve your records in QuickBooks Online is my priority.

Deleting the transaction will remove the original and voided check permanently.

To preserve the voided and re-issued check in the system, ensure you're not deleting any of it. However, if you accidentally removed the transactions, you can always re-create them.

You can access the transaction's Audit History to see what was the original amount and items listed. You can follow the detailed steps provided by my peer above in accessing the Audit Log section.

To know more about the Audit Log report, check out this article: Use the audit log in QuickBooks Online. It provides more details on what other information you can find in this log as well as a brief video to serve as your visual reference.

Additionally, I recommend visiting this link: Account Management. These will provide links about managing your QuickBooks Online account, income, expenses, inventory, and running reports.

Leave a comment below should you have other questions regarding deleting and voiding checks in QuickBooks Online. I’ll be around to help. Keep safe.

Hi - Has anyone figured out what to do with these voided transactions that show up in the reconciliation without deleting/removing the record? 

Thanks,

Ashley 

Hi there, @AshleyC.

Currently, the option to clear the voided or deleted transaction that shows up on your reconciliation report is unavailable except for the steps given by my colleagues above. I'd recommend speaking with your accountant in case you need further assistance with these transactions. Your accountant will ensure that your books are accurate and avoid future errors.

You can check out this link to get an accountant just in case you don't have one: https://quickbooks.intuit.com/find-an-accountant/.

I've added an article that may help you with the process: Learn the reconcile workflow in QuickBooks. This contains sub-articles about fixing and adjusting reconciliation.

I'll be here if you have other questions. Feel free to let me know in the comment section. Take care. 

Hi, Richard, Thanks for that, but I am not using a online account, it is on my desktop

Hello, @Dandsigns.

Could you elaborate on what you're attempting to accomplish or address with your QuickBooks Desktop (QBDT) account? That will certainly assist us in providing an exact answer to your concern.

If you have reconciled transactions that are showing as uncleared, this usually occurs when a future date is entered in the Statement Date field of the Begin Reconciliation window.

To resolve this, reconcile the transactions using the right date after undoing the previous reconciliation. Here are the steps: 

1. Click Reconcile from the Banking menu.
2. Select the account in the Begin Reconciliation window, then click Undo Last Reconciliation.
3. Before reversing a previous reconciliation, a warning to back up the company file is displayed. Continue if you've already created a backup.
4. When the message Undo Previous Reconciliation has completed appears, click OK. It's worth noting that the last reconciled date has been reset to the previous date.
5. Make a new reconciliation of the transactions.

If you're having difficulties with another error, I recommend reading this post for additional troubleshooting tips: Resolve common issues on Previous Reconciliation report.

In case you need to void or delete a check, check this article for detailed guidance: Create, modify, and print checks.

If you mean something different, I'm always available to assist you and answer any questions you might have. Have a good day and stay safe!

We have come across this problem as well, unfortunately.  And after reading this article, I think it is safe to say that there is no fix for this problem and it's in fact a glitch with quickbooks.

Voided checks should not show up in the bank register as uncleared checks. They shouldn't show up at all, and if they do show up, we should see the void in there as well so we can clear the two against each other and wash.  And that is not the case.

I am real curious to know how everyone managed to get this out of their uncleared checks section of their bank reconciliation because I can't think of any other way, without removing it from the register.  And obviously we don't want to delete it because that's history we need to refer back to.

Thanks!

I appreciate you joining in on this thread, terab3. I'll share details to ensure you'll get the help you need.

You'll want to use the built-in Void feature to mark the voided check as cleared and avoids it from showing up in the reconciliation.

To do that:

1. In your QBDT account, open your bank register.
2. Select the check you want to void.
3. Click Edit and select Void from the Delete dropdown.

Additionally, you can perform a special reconciliation where the starting and ending balances are both equal. Then, mark off all of the 0.00 checks you don't want to see during a regular reconciliation. 

Moreover, you can check out this article to guide you in reviewing your business finances that are accurate and balanced: Understand reports. It includes multiple reports you'll need to run to rack your business needs.

You can reply in the comments below if you have other QuickBooks concern. We'd be glad to help you further. Have a great day.

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.