cancel
Showing results for 
Search instead for 
Did you mean: 
GolfNut72
Level 4

Clearing undeposited funds account in Quickbooks Desktop Pro

I have been working on a client's books that were several years behind.  I have updated most of the information to current but still, have some issues with the Undeposited Funds account.  There are several entries from 2010 and 2014 that need to be dealt with and I can't find where they were deposited in a bank account, AND the bank accounts have been reconciled through April 2020.

 

I reviewed a suggestion that was for Quickbooks Online but can't figure out the best way to remove the extra amounts that are in the Undeposited Funds account.

 

I would appreciate any suggestion on how I can handle it so I would have a zero-sum deposit and the deposited fund account would be cleared.

 

Thanks

EJ

 

1 Comment 1
Rea_M
Moderator

Clearing undeposited funds account in Quickbooks Desktop Pro

Hello there, GolfNut72. 

 

I'm here to ensure you're able to find which bank account were several entries from 2010 and 2014 deposited. This way, you can keep your client's account updated and remove the extra amounts that are in the Undeposited Funds account. 

 

To find where the entries are deposited, you can either pull up the Audit Trail report or make use of the Find option. Let me guide you how. 

 

Pull up the Audit Trail report from the Reports menu. Here's how: 

  1. Go to the Reports menu. 
  2. Select Accountant & Taxes
  3. Choose Audit Trail
  4. Click the Customize Report button. 
  5. Go to the Filters tab. 
  6. In the Search Filters field, type in Transaction and select Transaction Type below. 
  7. Select Deposit from the Transaction Type field.
  8. Click OK

 

To use the Find feature, here's how: 

  1. Go to the Edit menu. 
  2. Select Find
  3. Choose the Advanced tab. 
  4. Select Transaction Type on the Filter option. 
  5. Choose Deposit in the Transaction Type field.
  6. Click Find

 

Once done, you can create a journal entry and offset the value of the extra amounts in the Undeposited Funds account. Just go to the Banking menu and make a deposit. Then, select the entry and the journal you created. 

 

After that, you'll have to do a mini reconciliation to correct the previous years (2010 and 2014) reconciled accounts. 

 

Please let me know if you have other concerns. I'm just around to help.

Need to get in touch?

Contact us