Scenario:
On the Match Bank Data page (Transactions > Bank > Match Bank Data), the user noticed that there are Bank and NetSuite transactions that we're missing
Bank Transaction missing:
NetSuite Transaction missing:
Solution:
Here's what you can check.
(1) For the Bank Transaction, check if it was marked as excluded; this means the transaction was "excluded" from the matching process.
To undo that:
- Go to Transactions > Bank > Match Bank Data
- In the Imported Bank Data and Account Transactions grids, NetSuite displays the imported bank lines and corresponding account transactions that require manual matching.
- Click the Excluded subtab.
- The items you selected move back to the To Be Matched subtab.
(2) For the NetSuite transaction, check if it was marked as cleared; this means the transaction did not need to be match to a bank transaction to be included on the reconciliation process.
To undo that:
- Go to Transactions > Bank > Match Bank Data.
- In the Imported Bank Data and Account Transactions grids, NetSuite displays the imported bank lines and corresponding account transactions that require manual matching.
- NetSuite displays the list of pending transactions that you can submit.
- The Cleared Transaction popup window appears.
- NetSuite moves the transaction back to the To Be Matched subtab.
After doing that, the Bank and NetSuite transactions will not be available on the Match Bank Data page:
Hope this helped!