Skip to main content
R
RebeccaHatcher
December 30, 2017
Solved

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

  • December 30, 2017
  • 3 replies
  • 0 views

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)

      Best answer by vpcontroller

      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!

      3 replies

      lynda11_2
      lynda11_2
      December 31, 2017

      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.  

        R
        RebeccaHatcherAuthor
        December 31, 2017

        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
        vpcontrollerAnswer
        January 2, 2018

        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!

          R
          RebeccaHatcherAuthor
          January 5, 2018

          Thank you.  I will try this at work tomorrow.

           

          Happy New Year!

          H
          hootster1417
          April 17, 2020

          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.

          M
          Mel1001
          October 8, 2020

          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!

          R
          rvrfrf
          October 8, 2020

          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!

          Terms & ConditionsAccessibility statement