cancel
Showing results for 
Search instead for 
Did you mean: 
RebeccaHatcher
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
vpcontroller
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

20 Comments 20
lynda
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.  

RebeccaHatcher
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.

vpcontroller
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!

RebeccaHatcher
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!

MarieWalton
Level 1

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

Deleted

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!

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!

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. 

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!

RenjolynC
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!

 

hootster1417
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.

Mel1001
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!

ZackE
Moderator

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!

Mel1001
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!

Nick_M
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. 

MandydeMoet
Level 2

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

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.

AlexV
QuickBooks Team

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

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:Capture.PNG

 

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

MandydeMoet
Level 2

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

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

JenoP
Moderator

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

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:

 

 

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

 

TMORRIS2
Level 1

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

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

Need to get in touch?

Contact us