How to Correct Undeposited Funds Without Deleting the Incorrect Deposits in QuickBooks
If you have payments sitting in undeposited funds that you deposited manually, you need to clear them out. You can delete the deposits you made without using undeposited funds and then deposit them correctly, but this will affect your previous reconciliations. The beginning balance of your current reconciliation will change and the newly entered deposits will show up. They offset each other, so all you have to do is check them off to finish your reconciliation. However, this means you'll have a reconciliation report that doesn't match your bank statement.
So you might want to do the $0 deposit trick instead. Go to Banking > Make Deposits, select all the undeposited funds that have already been deposited, then add an additional line on the deposit with a negative amount (bringing the deposit total down to $0) using whatever account that was used on the manual deposits (most likely a revenue account). No effect on your checking account, but it’ll not only clear up undeposited funds but also the duplicate revenue you most likely created when you entered your deposits manually.
If you use deposit the $0 check to your regular checking account, you will see a $0 deposit that you should clear on the next reconcile. For this reason, I prefer creating a "clearing" bank account that I used for all my $0 transaction tricks.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA





Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
Hi Ruth,
I have two the duplicate revenue at Service Income, I do not know how to correct it. I’ll try your $0 trick on Monday.
Thanks
Lynn
Thank you so much for the “$0 deposit trick”. I have been looking for a way to clear my undeposited funds without effecting everything else. I tend to enter most of my deposits manually because I like for my check register to show who the money came from; however, this led me to having a ridiculously large amount in my undeposited funds that I had no idea how to clear until I came across your suggestion. Thank you!
Glad to help, Vickie!
You might want to take a look at the Deposit Detail report (Reports > Banking) instead. It has much better info than the register.
Ruth