Undeposited Funds as of Date

Hey @AnthonyC1, seeing your first post here in the Community is awesome. I’m excited to guide you in generating lists of payment transactions from an Undeposited Funds account for a specific date.

We can generate the Custom Transaction Detail Report to reflect the lists of payments that are still in the Undeposited Funds as of a certain date. Feel free to follow the steps below:

1. Go to the Reports tab and select Custom Reports. Then, pick Transaction Detail.
   
2. After that, hover your mouse to Customize Report.
3. Select the date range you want to show in the report by clicking the Dates dropdown from the Display section.
4. From the Filters section, click the FILTER column and select Account. Then, go to the search field beside and enter Undeposited Funds.
   
5. Once done, click OK to display all the customization you did.

You can also read this article to learn how you further modify a report: Customize reports in QuickBooks Desktop.

Additionally, check out this article if you want to save the customization of your report: Create, access, and modify memorized reports.

We’re thankful to have a conversation with you about generating payment lists under the Undeposited Funds account. We’ll gladly have you back here if you want to expand your knowledge or have more questions about this topic. Take care, and we wish the best for your business.

Hi, Thank you for the assistance. It does bring up a list of all the transactions for the account on that date but not which ones were still waiting to be deposited which may have been added to there on a previous day. Is there a way to narrow it down to just see what transactions had not been marked for deposit yet on that day?

I appreciate your prompt response, AnthonyC1. I'll address this issue by providing additional steps to narrow the undeposited transaction in QuickBooks Desktop (QBDT).

We'll generate the same report suggested by my colleague above and follow the steps below:

1. Go to the Reports tab and choose Custom Reports. Then, pick Transaction Detail.
2. After that, glide your mouse to Customize Report.
3. Choose the date range you want to show in the report by clicking the Dates dropdown from the Display section.
4. From the Filters section, click the FILTER column and select Account. Then, go to the search field beside and choose the For Details Account Matching bullet.
5. Choose the Undeposited Funds.
6. Once done, click OK.

Also, it is important to set the date to the specific date you require for your transaction or activity.

Let me know if you have other concerns

RE: I am trying to see what transactions make up my undeposited funds account as of a certain date.

There's no way to do that with the internal QuickBooks reporting feature. It doesn't have the ability to roll back the clock, as it were, to show what was undeposited at a point in time in the past.