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

Viewing Submitted Transactions

On the Reconcile Account Statement page, you can view the following transactions:

If you undo a match or cleared status, NetSuite moves the transaction (and corresponding imported bank line) back to the To Be Matched subtab.

Important:

NetSuite removes the cleared or matched status from a transaction—and others in 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 that haven't been submitted yet, see Viewing Transactions To Be Submitted.

To view submitted transactions:

  1. Go to Transactions > Bank > Reconcile Account Statement.

  2. From the Account list, select the bank or credit card account.

    Note:

    As of NetSuite 2021.1, all newly-created accounts automatically appear in the Account list. If your account doesn't appear, see Editing Accounts to Use the Match Bank Data and Reconcile Account Statement Pages.

    In the Statement End Date and Ending Statement Balance fields, NetSuite displays the end date and closing balance from the most recent account statement containing a statement date.

    Note:

    If no account statements contain a statement date, the Statement End Date field is populated with the current date. The Ending Statement Balance field is populated with the closing balance from the last reconciliation statement.

  3. Click the Review subtab.

    NetSuite shows the list of submitted transactions that were matched or cleared.

  4. To filter the transactions list by date, enter or select the dates in the From and To fields above the pane.

  5. To search, start typing in the Search field. NetSuite narrows the results as you type.

    When entering a date, use the format shown on the page. For long formats (May 1, 2018), type May for May dates. Use four digits for years. For short formats, use two digits for month or day (05/01/2018).

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

    The Matched Transaction popup window displays the bank lines and account transactions in the match group. Details include date, type, transaction number, name, and amount.

    If there are too many items, use the arrows to see more. The Number of Rows In List Segments preference sets the per-page display (up to 1000). This limit is for all grids in the To Be Matched and Review subtabs.

    To undo a match, click Undo Match. NetSuite moves the transactions back to the To Be Matched subtab on the Match Bank Data page. To access the Match Bank Data page, you can click the Match Bank Data link (upper right).

    To undo multiple matches at the same time, select them and then click the Undo Selected button at the top or bottom of the grid. For more details, see Undoing Submitted Transaction Matches.

  7. To view a submitted transaction that was marked as cleared instead of matched, click Cleared in the View Details column.

    The Cleared Transaction popup window displays details, including the transaction date, type, transaction number, name, and amount.

    To undo the cleared status, click Undo Clear. NetSuite moves the transaction back to the To Be Matched subtab on the Match Bank Data page.

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

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

Related Topics

General Notices