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

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.  

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.

Thank you.  I will try this at work tomorrow.

Happy New Year!

Deleted

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!

I had to trick quickbooks by selecting all of the receipts for deposit and then printed the deposit summary.  Since it records the deposit when printing, I then had to delete the deposit from the account they were deposited to.

Hello - I am trying to run a report that gives me the uncleared transactions as of the last fiscal yr end (for the auditors).  But when I try to use the instructions in this thread, I get a report with no transactions because all of the UF have cleared as of today.  I set the as of date back to 12-31-2019 but the report still shows no transactions even though there was a balance in UF on the balance sheet at yr end.

     Any insight into what step I might be missing is much appreciated!

Thanks for reaching out to the Community about this, Mel1001.
 

If you're using QuickBooks Online, you can run a bank report sort it by cleared status. 
 

Here's how:
1. Go to Accounting, then Chart of Accounts.2. Locate the bank account you want to run a report for.
3. In your Action column, use the ▼ drop-down and choose Run report.4. Enter a date range in the Report period area.5. Use your Sort ▼ menu, pick Clr in the Sort by drop-down, then tick Descending order.

Now checks which haven't cleared will display at the top of your report. There's another method for generating reports that show uncleared transactions, but it's only available for subscribers who use our Essentials, Plus, or Advanced plans. You'll be able to find more details in our Run a report of uncleared checks article.
 

In the event you're using QuickBooks Desktop, detailed steps for how to produce reports that show uncleared records were provided in vpcontroller's post.
 

If there's any other questions, I'm just a post away. Have a great day!

Thank you ZachE - I have Accountants Desktop Enterprise.  I did follow vpcontroller's post and set the as of date to 12-31-2019...and I still get a report with no transactions because all of the UF have cleared as of today 10-08-2020.  But what I really need are those that were uncleared at 12-31-2019.

Any thoughts as to what step I might be missing or how to get uncleared as of 12-31-2019.  Thank you!

Hi there Mel1001. 

I'm happy to help, so similar to what my colleague mentioned above you'll want to run a Bank report by cleared transactions. in QuickBooks Desktop. Here's how:

1. From the Lists menu, select Chart of Accounts.
2. Right-click Undeposited Funds and select QuickReport: Undeposited Funds.
3. From the Dates drop-down menu, select All.
4. Select Customize Report.
5. Select to the Filters tab. Scroll down the Filter list and select Cleared.
6. In the Cleared section, select No. Then select OK.
   
   

You can find these steps as well as much more at the following link: Deposit payments into the Undeposited Funds account in QuickBooks Desktop. 

If you have any other questions, feel free to post below at anytime. Thank you and have a nice afternoon. 

I need a report that I can save under customised reports.  One of my clients has an office lady that is not experienced enough to call up the report via the Chart of Accounts method described above.  

I have set up a number of reports for her to check daily.  Due to the number of incorrectly allocated payments received, a report for Undeposited Funds is important for her daily checks.

Can we please have this set up so we can save it for daily use.

Good day, MandydeMoet.

We can use the Undeposited Funds' quick report and save it so it'll be listed on the Custom reports tab. You can follow these steps:

1. Go to the Accounting menu and select Chart of Accounts.
2. Search the Undeposited Funds account. From the drop-down under the Action column, select Run report.
3. Customize it, then click the Save customization button.

In this report, if the payment has been deposited already, you'll see an offsetting deposit transaction. If not, you need to deposit it by going to the +New button and select Bank deposit. Refer to the sample screenshot below:

Post again if you need more help with this. Take care!

Thanks for the reply, but that does not work.  The list includes ALL transactions.  I only want the transactions that have not been deposited yet. 

Hi there, MandydeMoet.

For now, we're unable to run or filter the report for Undeposited Funds to only show transactions that are not yet deposited in your bank. By default, it will list all transactions that used the Undeposited Funds account.

You'll want to inform your client's employee to take note that amounts with a negative sign are already deposited. 

More details about the Undeposited Fund account and customizing reports are discussed in these articles:

• How To Use The Undeposited Funds Account To Receive Payments In QuickBooks Online
• Customize Reports In QuickBooks Online
• Common Custom Reports In QuickBooks Online

Don't hesitate to reply again you need more help with QuickBooks. 

BRAVO!  This is exactly the report I needed-Many Thanks!