Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
December 11, 2018
Solved

How do I reverse a deposit that was made into a bank account from Undeposited Funds?

I recently took over booking keeping for a company and am cleaning up years of transactions that were applied to "Undeposited Funds" but never deposited.  Unfortunately, I've had to go back into each transaction and edit them one at a time individually.  Today I accidently deposited all of the remaining transactions to one of the bank accounts.  How do I reverse the deposit so that all of those transactions are back in "Undeposited Funds" so I can continue editing them?
NOT MY USER ID
Level 5
December 11, 2018
Open the deposit, CTRL+D to delete it.  The payments will go back into the Undeposited Funds account.

22 replies

Level 7
December 11, 2018
What is the purpose of "undeposited funds"
NOT MY USER ID
Level 5
December 11, 2018
It enables you to match the deposits in QB with the deposits on your bank statement more easily.  I think of it as an envelope in my desk drawer.  As I receive cash/checks, I put them in the envelope.  When I'm ready to make a deposit, I move them from the envelope to the deposit window.  When I reconcile my bank statement, the amounts match (rather than, e.g., 12 entries in QB that equal 1 deposit on the bank statement).
qbteachmt
Level 11
December 11, 2018
It provides for a Date difference between when you got the funds and when you did the banking, as well. Here is how I teach it: If the customers' due date is the 15th, and you get mail from the 12th to the 15th, but don't do the banking deposit until the 17th, you want to show the customers have paid on time, so that separation of steps provides that separation for date of each activity: Payment is separate from Deposit of that/those payments. Also, I like to Organize my deposits into personal checks and  Bank-issued checks, because I have had occasion where the Bank issued checks were bundled in an envelope (and held up at the processing service), making the customers' payments late, and they have had to take it up with their banks.
NOT MY USER ID
Level 5
December 11, 2018
Open the deposit, CTRL+D to delete it.  The payments will go back into the Undeposited Funds account.
January 26, 2019

I don't see the deposit.  How do I find it

 

Level 5
February 28, 2019

I am having a similar problem. I need to delete a deposit that consisted of 3 items. The items seem to be sitting in undeposited funds. When I try to delete the items in the items from Chart of Accounts --> Undeposited Funds --> Account History I get the message "This transaction has been deposited. If you want to change or delete it, you must edit the deposit it appears on and remove it first.". Sounds logical, but when I go to Accounting --> [My Bank Account] --> Account History I can't see the 3 items nor a single item that is the total of the 3 for that date.  What am I doing wrong?


Hi there, @CV5.

 

Thanks for joining this thread. Allow me to jump in and provide some additional information about deleting deposit payment in QuickBooks.

 

The reason why you're getting this error is when the payment transaction that you're trying to delete is still linked to a bank deposit (Deposited to main account). What you need to do is delete the bank deposit first before we can delete the payment. 

 

Here's how:

  1. In the Chart of Accounts, open the deposit transaction.
  2. Press Ctrl + D on your keyboard to delete.
  3. Once done, you can go back to your Undeposited Fund, and from there you can now delete the payment. 

If you need further assistance with the steps from our live support, I recommend contacting our QuickBooks Desktop Support Team. They have the tools to pull up your account and do a remote session. 

 

Here's how you can contact our live support:

  1. Follow the Official Intuit Contact link.
  2. Select your QuickBooks product.
  3. Select an issue type from the menu below, you need only to select two options for the contact information to appear.
  4. Click Start a message at the bottom.

This will get you on the right track. Feel me in if you have any other questions. Have a good one. 

qbteachmt
Level 11
December 11, 2018

There should never be a JE for Undeposited Funds. That can corrupt this account. And a JE is an extra transaction; you should not need it if you already have this data in the file.

June 12, 2019

Hi its interesting you said this.  I'm trying to clean my undeposited funds account from 2017. I have a restaurant and our past bookkeeper posted daily sales as a single journal entry with the cash going to undeposited funds. She also used JE and Transfers to record when we replenished our petty cash account and made deposits to the bank account. Now my undeposited funds register has loads of negative transactions in addition to all of the JE cash income sitting in it. I'm not sure how I should go about correcting this. Can you help me please?

MaryLandT
Level 10
June 13, 2019

Thank you for the details about how the deposits were recorded, @freestylin.

 

I'm here to help clear the negative balance in the Undeposited Funds account.

 

If payments were already deposited to the right bank account, you can delete the duplicate entries from this account.

 

Before making any changes since the process can't be reversed, I recommend backing up your company file.

 

To delete the journal entries:

  1. Go to your Banking menu.
  2. Select Use Register.
  3. Select Undeposited Funds, then click OK.
  4. Double-click the JE to bring up the transaction, one at a time.
  5. Press CTRL + D on your keyboard to delete it.

You can then deposit the payments. Here's how:

  1. Go to your Banking menu, then select Make Deposits.
  2. Select the payment in the Payments to Deposit window.
  3. Select the bank from the Deposit to box where you want to post the funds.
  4. Click Save and close.

You can read through this article for additional information with the solution above: Understand how the Undeposited Funds account works.

 

Upon sharing this, I still suggest consulting with your accountant. He/she might have specific instructions on how to handle the deposits sitting in the Undeposited funds account. These are very old transactions and you may be working in a closed period of your books.

 

Feel free to leave a comment below if there's anything else you need with clearing up the Undeposited Funds account. I'd be glad to help you further.

September 2, 2020

My transaction is over a year old and needs to be done in a general journal entry.  How do I do that for an undeposited funds account?