1. Accounting
  2. Banking
  3. Bank Data Matching and Reconciliation
  4. Reconciling Bank and Credit Card Statements
  5. Matching Bank Data
  6. Viewing Transactions To Be Submitted

Viewing Transactions To Be Submitted

When you open the Match Bank Data page, it displays the To Be Matched subtab. Here, you’ll see transactions to match or mark as cleared. When you do, 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 so you can reconcile. You can see and reconcile it 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 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 submit them.

  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 displays the transactions in the match group, including date, type, transaction number, name, and amount. If there are too many, use the arrows to see more.

    To undo the cleared status, click Undo Clear. NetSuite moves the transaction back to the To Be Matched subtab.

    To undo several matches at the same time, select them and click Undo Selected. For more details, see Undoing Matched Transactions.

  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 displays transaction details, including transaction date, type, transaction number, name, and amount.

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

    To undo multiple cleared transactions at the same time, select them and then click Undo Selected. For more details, see Undoing the Cleared Status of Transactions.

  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 report, 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