<img src="https://ws.zoominfo.com/pixel/5BFMW73xT6Cu70sN1cUt" width="1" height="1" style="display: none;">

Get an Undeposited Funds as of Date Report

Posted by Justin Myung, Consultant on Sep 6, 2022 10:59:29 AM
Justin Myung, Consultant
Find me on:

Have you ever wondered if there was an easier way to get a detail report of Undeposited Funds for a previous Date?  If you have a lot of transactions that flow in and out of this account, it can be a daunting task if you don’t reconcile this right after month-end close or even if there happened to be back-dated transactions after you month-end bank reconciliation.   The following search will help you download a saved search report to solve that issue. 

  1. Navigate to Reports > New Search 
  2. Select Transaction search type 
  3. Click Create Saved Search Button 
  4. Add a Search Title 
  5. On the Criteria Sub-Tab (Filters) 
      1. Add Account.  Then use the Undeposited Funds account on your system 
      2. Add Subsidiary if necessary 
      3. Add Date as “On or Before” desired date 
      4. The next four fields, you will need to us the sub tables under “Applied To” and “Applying Transaction 
          1. Add Applied To Transaction : Date as “After” desired date (same date as transaction date) 
          2. Add Applying Transaction : Date as “After” desired date (same date as transaction date) 
          3. Add Applied To Transaction : Date is Empty 
          4. Add Applying Transaction : Date is Empty 
      5. Then select USE EXPRESSIONS
          1. On the Account row, use And expression 
          2. On the Subsidiary row, use And expression 
          3. On the Date row, use And expression 
          4. Add Double Opening parenthesis on the first Applied To Transaction : Date 
          5. On the Applied To Transaction : Date row, use Or expression 
          6. Add Single Closing parenthesis on the first Applying Transaction : Date 
          7. On the Applying Transaction : Date row, use Or expression 
          8. Add Single Opening parenthesis on the first Applied To Transaction : Date 
          9. On the Applied To Transaction : Date row, use And expression 
          10. Add Double Closing parenthesis on the first Applying Transaction : Date


        Graphical user interface, website

Description automatically generated

  6. On the Results Sub-Tab 
      1. Add Date 
      2. Add Type 
      3. Add Document Number 
      4. Add Name 
      5. Add Account  
      6. Add Amount 

  7. On the Results Sub-Tab select SHOW TOTALS 

    Graphical user interface, text, application, email

Description automatically generated

You can now validate this report against your Balance Sheet:

Graphical user interface, application

Description automatically generated

 

Graphical user interface, application

Description automatically generated

 

If you need any help with customizing reports and saved searches in NetSuite, feel free to contact Concentrus.  Our consultants would be happy to guide you through the process. 

 

 

About Us

 

Concentrus is a complete NetSuite solutions provider that guides organizations through how to use NetSuite to reach highly focused business goals and objectives. We provide NetSuite implementation, developer, integration, and customization services to ensure that you have a long-term solution that is tailored to fit your systems, people, and processes.

 

Read About Our Implementation Methodology

 

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos

 

 

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, Saved Search, Transactions, Undeposited Funds

Subscribe to our blog!

Recent Posts

Posts by Topic

see all