Filtering Imported Bank Lines

On the Automated Cash Application page, you can filter imported bank lines.

Go to Transactions > Bank > Automated Cash Application.
From the Account list, select the appropriate bank or credit card account.

NetSuite displays a list of all bank lines for which NetSuite was unable to find matching payments.

If the number of bank lines in the list exceeds the page limit, click the arrows to see the next or previous page of results.
Filter your data:
- To switch from a list of all bank lines to only the bank lines excluded from payment generation, click Show Excluded Only.
  
  Note:
  Show Excluded Only is only applicable if the box is checked for one or more bank lines.
- To search for specific text or numbers on the page, in the Search field, start typing the text or number value. As you type, NetSuite narrows the results in the list.
  
  When entering a date, use a date format consistent with the displayed format on the page (as set in the User Preferences). For example, if you use a long date format (May 1, 2018), enter May to search for a date in May. When entering a year, use four digits (for example, 2018). If you use a short date format, always use two digits for the month or day (for example, 05/01/2018).
- To modify the date range for bank lines in the list, enter or select the dates in the From and To fields.