Filtering Imported Bank Data and Account Transactions
On the Match Bank Data page, you can filter the Imported Bank Data and Account Transactions grids. You can filter by date range and transaction type, or you can use the Search field to locate specific text or number values. You can also filter content by sorting by columns.
To filter imported bank data and account transactions:
-
If you have not already, do the following:
-
Go to Transactions > Bank > Match Bank Data.
-
From the Account list, select the bank or credit card account.
In the Imported Bank Data and Account Transactions grids, NetSuite displays the imported bank lines and corresponding account transactions that require manual matching.
-
-
From the To Be Matched subtab, you can do the following:
-
To set the date range for transactions in the lists, enter or select the dates in the From and To fields at the top of the panes.
-
To filter by transaction type, from the Select Type list, select a transaction type.
-
To filter using the search functionality, in the Search field, start typing the text or number value on which to search. As you type, NetSuite narrows the search results in the list.
When entering a date, use a date format consistent with the displayed format in 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 sort by column, click the column header.
-
To reorder a column, drag it to a new location
-
If the number of items in the grids exceeds the page limit, click the arrows to see the next or previous page of results.
-
If the number of items in the bottom section exceeds the page limit, click the arrows to see the next or previous page of results. The Number of Rows In List Segments preference determines how many rows the bottom section can display per page. Each page can display a maximum of 500 rows at a time.
-
Related Topics
- Matching Bank Data
- Updating Imported Bank Data
- Viewing Details of Account Transactions
- Viewing Transactions To Be Submitted
- Viewing Unmatched Transactions
- Undoing Matched Transactions
- Excluding Imported Bank Lines From the Matching Process
- Restoring Excluded Imported Bank Lines
- Adding Account Transactions During the Matching Process
- Marking Transactions as Cleared
- Undoing the Cleared Status of Transactions