Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 1

Duplicated Transactions; One deleted and In Reconciliation Discrepancy Report



For our company's Essential Quick Books account, we had multiple duplicate transactions that were reconciled. After reconciliation those duplicated were deleted from the register. And now there's a discrepancy within the reconciliation and I have all of these duplicated sitting in my Reconciliation Discrepancy Report. I need them removed so my ending balance can go back to normal, but I don't want them added back to my register. How do I remove these transactions completely so then I can move and reconcile for the next month?


Thank you for your time!



1 Comment

Duplicated Transactions; One deleted and In Reconciliation Discrepancy Report

Hello Victoria,


When you reconciled the transactions (including the duplicates), they will all be part of the Reconciliation report. Deleting one of them (regardless if this is a duplicate) will automatically reflect on the Reconciliation Discrepancy report.


There are two ways to undo the whole reconciliation. This will remove the history of the deleted duplicates.

If you choose to invite your accountant, they'll have an option to undo the reconciled period at once. You can share this article for them to know how: Undo your client’s reconciliations with QuickBooks Online Accountant.


If you want to undo the reconciled transactions yourself, you can follow Step 2 in this article for the detailed instructions: Undo and remove transactions from reconciliations in QuickBooks Online.


After undoing the reconciled transactions, you can reconcile the period again. You don't need to worry about the duplicates since you've mentioned earlier that you've already deleted them.


To know more about the reconciliation, you can browse this article: Learn the reconcile workflow in QuickBooks.


We'll be right here if you require our assistance in correcting your reconciliation. Have a great day!

Need to get in touch?

Contact us