cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Report of Undeposited Funds that contains only the items that have not been deposited to the bank account

I need to export a report of Undeposited Funds that contains only the items that have not been deposited to the bank accounts in order begin a correction phase of clearing out duplicate entries between this account and the bank by my predecessor. 

 

However, QB only presents a report that includes every transaction that was ever entered whether it was properly moved to bank or not.

 

Is there a workaround for this? I have tried to filter out the unwanted items to no avail.  

 

Thank you for any help you can provide.  

 

(Title has been edited by moderator for clarity)

Solved
Best answer 01-02-2018

Accepted Solutions
ProAdvisor

Re: Undeposited Funds Report

In QBO, filter Reconciled Status by "Not Reconciled" selection from the Assets Register (Dashboard > Accounting > Undeposited Funds > View Register > Funnel icon at top left row > Reconciled Status > Not Reconciled > Apply). You can export to excel or print this report.

In QB desktop, from the Register for UF account, select QuickReport and filter it Cleared NO only. You can also export this to excel or print this report.

Hope this helps!

10 Comments
ProAdvisor

Re: Undeposited Funds Report

To see what is still open in undeposited funds, just go to the bank deposit screen. They will all list if they are hanging there.  I don’t think you can print that but you can screen shot it.  

Experienced Member

Re: Undeposited Funds Report

Hy Lynda.  Thanks for your reply.  Yes, that is the only way I have been able to figure out how to do this as well.  I do not know why QB does not realize printing the current list helps to correct errors.  My predeccessor had used UDF incorrectly for more than half of this year.  The whole thing is a mess!   I was hoping for a shortcut that did not involve printing everything that was ever deposited.  So sad!   

 

Thanks again for your help. Happy New Year to you.

ProAdvisor

Re: Undeposited Funds Report

In QBO, filter Reconciled Status by "Not Reconciled" selection from the Assets Register (Dashboard > Accounting > Undeposited Funds > View Register > Funnel icon at top left row > Reconciled Status > Not Reconciled > Apply). You can export to excel or print this report.

In QB desktop, from the Register for UF account, select QuickReport and filter it Cleared NO only. You can also export this to excel or print this report.

Hope this helps!

Experienced Member

Re: Undeposited Funds Report

Thank you.  I will try this at work tomorrow.

 

Happy New Year!

Experienced Member

Re: Undeposited Funds Report

Deleted

Established Member

Re: Undeposited Funds Report

Hello, I am looking to get the same report for QB Enterprise Desktop. I followed your instructions, however, when I get to the UDF register and click the "QuickReport", it will only give me a report for the highlighted line in the register. Despite my best efforts, I cannot figure how to deselect the line so that it will run the report wide open. Can anyone explain what I am doing wrong? Thank you!

Established Member

Re: Undeposited Funds Report

Hello, I too am looking for resolution to this. I am using QB Enterprise Desktop 2017 and when following your instructions to click the "QuickReport" once in the UDF register, it will only create a report for the highlighted line that is selected in the register. Despite my best efforts, I cannot figure out how deselect the line to run the report wide open. Even if I change the date range in the report and refresh, it will still only show the data from the selected line. Can anyone explain what I am doing wrong? Thank you!

QuickBooks Team

Re: Undeposited Funds Report

Hello, FixItFairy.


Thanks for responding back and sharing the results you’re getting. 


In order to get the QuickReport for the whole register, you can follow the steps below:

 

  1. Go to Accountant at the top. 
  2. Select Chart of Accounts. 
  3. Locate Undeposited Funds from the list 
  4. From the list, right-click Undeposited Funds. 
  5. Select QuickReport:Undeposited Funds. 


Then follow the next steps provided by vpcontroller above. 


Please let me know if you have other questions. I’ll be around to help. 

Established Member

Re: Undeposited Funds Report

Hi MikiD!

 

Thank you for the quick response! I think I might have found the issue, I do not have an "Accountant" feature in my menu bar. We are running Quickbooks Enterprise Solutions 17.0 Desktop and I suspect this is an older version than what you guys are using. See screenshot of the menu bar.

 

Would you happen to know how I can accomplish the same thing in this version?

 

Thank you!

QuickBooks Team

Re: Undeposited Funds Report

Thank you for your reply, FixItFairy.

 

You will see the Accountant option in the Accountant version of Quickbooks Enterprise Solutions. Though, you can still follow the steps provided MikiD by clicking the List menu and choosing Chart of Accounts.

 

I've added a sample screenshot for your reference.

 

If you have other questions or concerns, feel free to reach out to us. Have a great day!