I have not found the solution to my issue. I have a customer payment from 3 years ago (prior to my time) that was applied to their invoice. The payment was then in Undeposited Funds. The funds were applied to a deposit and that deposit reflects the payment. Bank account has been reconciled but the payment is still in Undeposited Funds. How do I get this payment out of "pending" in Undeposited Funds?
I can think of two ways to take out the pending funds, Cholletr.
The first is to run the Verify/Rebuild tool. This will help us know if this is caused by data damage since the funds are already added to the bank account. Here's how:
Go to Utilities, then choose Verify Data.
If QuickBooks detected no problems, there's no further action needed. If you receive a message, "Your data has lost integrity", the file is damaged. Just continue to Rebuild Data to correct the problem.
When you Rebuild Data, you'll receive a message to back up your company file, just click OK. The utility starts as soon as the back up is finished.
Click OK when you get the message "Rebuild has completed".
Run Verify Data again to check for remaining data damage.
If there are no issues after running the tool, the next thing to do is to delete the duplicate payments. Here's how:
Press Ctrl + F on your keyboard.
In the Find window, go to the Advanced tab.
Under FILTER, select Transaction Type.
Under Transaction Type, select Payment.
Open the duplicate payments, then press Ctrl + D on your keyboard.
Thanks for keeping in touch with us here in the Community, @cholletr.
Let me share with you some information on how you'll be able to clear these pending deposited payments in QuickBooks Desktop.
Since the bank account associated with these deposited payments has been already reconciled, the only way to remove them is to create a Bank deposit and look for an account using a negative value to offset it. However, you'll have to consult your accountant for the best advice. This way, you won't mess up your valuable transactions.
Meanwhile, I'll guide you on how to create a bank deposit in QuickBooks Desktop:
Go to the Banking menu then choose the Make Deposits option.
Select the payments that you want to deposit then click OK.
Pick a bankaccount with a negative value to which todeposit the money.
Specify the deposit date.
You can add a memo description if you want to.
Choose the Cashback amount.
Hit Save and Close if you wanted to exit or Save and New if you wish to exit to this page and create another deposit once done.