NetSuite Admin Tip: Tips on How to Eliminate Old Imported Bank Transactions

Old imported bank transactions may show up in the Match Bank Data page due to any of the following:

1. Transactions were not submitted for matching,
2. Transactions were duplicates,
3. Previously reconciled transactions were unreconciled
4. Transactions were erroneously imported

There are 2 options to eliminate old imported bank transactions. To illustrate, let's use the example below. There are transactions from 2020 that are still showing in the Match Bank Data page. 

OPTION 1: Excluding the Transactions

1.     Select the transactions under the Imported Bank Data section.

2.     Click on the Exclude button.

3.    These transactions will not be deleted but will be moved to the Excluded tab. 

Take note that the reason why Delete Function is not yet available in the Match Bank Data page is to provide the users the ability to still be able to restore the transactions in cases where it was accidentally excluded by someone or incorrectly excluded by the system.