cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

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 January 02, 2018

Best Answers
Highlighted
Level 11

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

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!

View solution in original post

15 Comments
Highlighted
Community Champion

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.  

Highlighted
Level 2

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

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.

Highlighted
Level 11

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

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!

View solution in original post

Highlighted
Level 2

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

Thank you.  I will try this at work tomorrow.

 

Happy New Year!

Highlighted
Level 1

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

Deleted

Highlighted
Anonymous
Not applicable

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

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!

Highlighted
Anonymous
Not applicable

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

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!

Highlighted
Anonymous
Not applicable

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

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. 

Highlighted
Anonymous
Not applicable

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

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!

Highlighted
QuickBooks Team

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

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!

 

Highlighted
Level 1

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

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.

Highlighted
Level 1

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

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!

Highlighted
QuickBooks Team

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

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!

Highlighted
Level 1

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

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!

Highlighted
QuickBooks Team

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

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. 

Need to get in touch?

Contact us