Viewing Transactions Pending Submission in NetSuite

When you open the Match Bank Data page, you'll access the To Be Matched subtab, which displays transactions that need to be matched or marked as cleared. Successfully matching transactions allows them to progress to the Review subtab and ultimately assists in reconciling your accounts.

How to View Transactions Pending Submission

To effectively view and process transactions pending submission, follow these steps:

1. Navigate to Match Bank Data: Go to Transactions > Bank > Match Bank Data.
2. Select Account: From the Account dropdown, choose the specific bank or credit card account. NetSuite will show the grid with imported bank data that requires manual matching.
3. Review Subtab: Click the Review subtab to see all pending transactions that need action.
   • Transactions that are matched or marked as cleared will display labels such as Matched or Cleared in the View Details column.
   • Transactions generated by an auto-create rule are tagged with To Be Generated or specific transaction types such as Deposit to Be Created.
4. Optional Filters: If needed, apply filters to the transactions grid by date range or transaction type. For searching specific transactions, utilize the Search functionality.
5. Inspect Matched Transactions: To view details of a matched transaction, select Matched in the View Details column. The details will include date, type, transaction number, name, memo, and amount.
6. Cleared Transactions: Click Cleared in the View Details column to access the Cleared Transaction popup, showing pertinent details similarly to matched transactions. Undo clearing by selecting Undo Clear to revert the transaction back to the To Be Matched subtab.
7. Closing Popups: Close the Matched or Cleared Transaction popup by clicking Cancel.
8. Return to Unmatched Transactions: To go back to transactions that haven't been matched or cleared, simply click the To Be Matched subtab.

Important Notes

• Submitting transactions clears them, enabling reconciliation right from the Reconcile Account Statement page.
• Be cautious: editing a transaction amount, voiding it without a reversing entry, or deletion will unmatch and remove the cleared status from that transaction and its match group.

For reconciliation, ensure to submit all pending transactions as detailed in the guides about Submitting Matched or User-Cleared Transactions and Reconciling Transactions.

A summary report of your reconciliations can also be generated via Reports > Banking/Budgeting > Reconciliation.

Key Takeaways

• Access transactions pending submission through the Match Bank Data page.
• Use filtering and search features to manage transaction data efficiently.
• Understanding matched and cleared transaction statuses simplifies the reconciliation process.

Source: This article is based on Oracle's official NetSuite documentation.