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 haven’t 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 account transactions that still need 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 search, start typing in the Search field. As you type, NetSuite narrows down the results.
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 there are too many items in the grids, use the arrows to see more results.
-
If there are too many items in the bottom section, use the arrows to see more. The Number of Rows In List Segments setting controls how many rows per page (up to 500 max).
-
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