Viewing Transactions To Be Submitted

When you open the Match Bank Data page, the page displays the To Be Matched subtab. This subtab lets you view transactions that need to be matched or marked as cleared. When transactions are matched or marked as cleared, they move to the Review subtab.

The Review subtab displays all transactions pending submission, which can include the following:

When you submit a transaction, the system clears it and you can do reconciliation. You can then view and reconcile the transaction on the Reconcile Account Statement page.

Important:

NetSuite removes the cleared or matched status from a transaction (and any other transactions from its match group) if you do any of the following:

  • Edit the transaction amount.

  • Void the transaction without a reversing journal entry. If you void the transaction with a reversing journal entry, the transaction remains matched or user-cleared.

  • Delete the transaction.

To view transactions to be submitted:

  1. Go to Transactions > Bank > Match Bank Data.

  2. 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.

  3. Click the Review subtab.

    NetSuite displays all transactions pending submission.

    Matched and user-cleared transactions are indicated by the Matched and Cleared label in the View Details column.

    Note:

    Transactions that are automatically created and matched by an auto-create rule are indicated by the label, To Be Generated. These transactions are generated in your general ledger account when you click Submit.

  4. To filter the transactions grid by date or to use the search functionality, see Filtering Imported Bank Data and Account Transactions.

  5. To view all the transactions in a match, click Matched (previously called View) in the View Details column (previously called Match Details).

    The Matched Transaction popup window (previously called Match Details) displays the individual transactions in the match group. Details include date, type, transaction number, name, and amount. If the number of transactions exceeds the page limit, click the arrows to see the next or previous page of results.

    If you want to undo the match, you can click Undo Match. NetSuite moves the transactions back to the To Be Matched subtab.

  6. To view a transaction that has been marked as cleared pending submission, click Cleared in the View Details column.

    The Cleared Transaction popup window appears. Details include the transaction date, type, transaction number, name, and amount.

    If you want to undo the cleared status of the transaction, you can click Undo Clear. NetSuite moves the transaction back to the To Be Matched subtab.

  7. To close the Matched Transaction or Cleared Transaction popup window, click Cancel.

  8. To go back to transactions that have not been matched or marked as cleared, click the To Be Matched subtab.

To reconcile all the pending transactions, you must submit them and then reconcile the statement. For details, see Submitting Matched or User-Cleared Transactions and Reconciling Transactions.

To see a summary of cleared and outstanding transactions for the account, go to Reports > Banking/Budgeting > Reconciliation. From the Account and Statement Date dropdown lists, select an account and statement date, and then click Refresh. For more information, see Reconciliation Summary Report.

Related Topics

General Notices