Matching Bank Data

When you import bank data into NetSuite, depending on your reconciliation rules, the Intelligent Transaction Matching feature attempts to do the following:

Automatically match the imported bank lines with the existing account transactions in NetSuite.
Automatically create and match account transactions with imported bank lines.

For details, see Intelligent Transaction Matching for Bank Data.

For any remaining unmatched transactions, filter the grids and manually select one or more transactions from each grid to match. If your account transactions do not have matching imported bank lines, you can mark them as cleared, pending submission.

Note:

Before you match your bank data on the Match Bank Data page, you should first use the Automated Cash Application feature to generate customer payments from imported bank lines and match them. For more information, see Automated Cash Application.

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 match and reconcile custom transactions, go to Accounting Preferences and then check the Show All Transaction Types In Reconciliation box. See General Accounting Preferences.

To match imported bank lines with account transactions:

If you have not already done so, import your bank data (see Bank Data Import).
Go to Transactions > Bank > Match Bank Data.
From the Account list, select the bank or credit card account for which you want to perform matching, if not already selected.

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

The following fields are populated:
- Subsidiary (if applicable).
- Bank Balance, if your most recent account statement contains an account balance and statement date.
- Balance As Of, if the statement contains a statement date.
If you select an account for which NetSuite failed to import data during the latest import, a popup message displays the most recent import error. For more error details, go to Transactions > Bank > Banking Import History.

If NetSuite successfully imported data to the selected account, the Imported Bank Data and Account Transactions grids are populated. NetSuite displays the imported bank lines and corresponding account transactions that require manual matching for the selected account.

Note:
Any bank lines that were processed from the Automated Cash Application page no longer appear on the Match Bank Data page. The corresponding customer payments are automatically cleared in the system and ready for reconciliation.
In the Account Transactions grid, identify in-transit payments by looking for the icon in the row. One or more in-transit payments must be matched with only one imported bank line. For more information about in-transit payments, see In-Transit Payments. To enable the In-Transit Payments feature, see Enabling the In-Transit Payments Feature.
Note:
The system uses a built-in rule to automatically match an imported bank line with an in-transit payment if the following criteria are met:
- The transaction numbers exactly match.
- The dollar amounts exactly match.
- The imported bank line is a Payment type.
To filter the grids, see Filtering Imported Bank Data and Account Transactions.
If you require more information about the account transactions, click the links in the Account Transactions grid. See Viewing Details of Account Transactions.
On the To Be Matched subtab, match transaction items:

Note:
Dimmed bank lines are still processing. You cannot check the box next to a dimmed bank line until processing is complete. To see if processing is complete, refresh the Imported Bank Data grid.
1. Check the box for one or multiple transactions from the Imported Bank Data grid, and then select one or multiple transactions from the Account Transactions grid. To check or clear all the boxes for transactions visible on the current page of the Account Transactions grid, use the box in the grid header.
  
  Note:
  The Imported Bank Data grid header also includes a similar box to select or clear all visible transactions on the current page. However, you should only select this box if you want to match all visible transactions in a single group or exclude all imported transactions at the same time.
  
  Tip:
  To avoid performance degradation or timeouts, if you have a high number of transactions, you should make smaller match groups rather than match all transactions at the same time.
  
  For details about the type of matches you can perform, see Bank Transaction Matching Types.
  
  As you select transactions, NetSuite displays the transactions in the bottom section and updates the amount difference in the Difference field.
  
  If the number of items in the bottom section exceeds the page limit, click the arrows to see the next or previous page of results. The Number of Rows In List Segments preference determines how many rows the bottom section can display per page. Each page can display a maximum of 500 rows at a time.
  
  Tip:
  If a corresponding account transaction is missing, you can quickly add and match it from this page. See Manual Creation of Account Transactions During the Matching Process.
2. When the difference between the selected imported bank line items and account transactions is zero (in the Difference field), click Match.
  
  If the Make Auto-Create Rule from Selected Transactions box is active, the system creates an auto-create rule. The next time reconciliation rules are run, NetSuite automatically creates corresponding transactions from imported bank lines that fulfill certain conditions and matches them. See Automatic Creation of Account Transactions.
  
  NetSuite removes the matched transactions from the To Be Matched grid.
If you have account transactions with no matching imported bank lines, you can mark them as cleared, pending submission. See Marking Transactions as Cleared.
To exclude imported bank line items from the matching process, see Excluding Imported Bank Lines From the Matching Process.
To complete matching later, you can go to another page.

NetSuite automatically saves the work for the account as you go.
When you finish matching transactions and marking transactions as cleared, submit them. See Submitting Matched or User-Cleared Transactions.
(Optional) To view transactions pending submission, click the Review subtab. See Viewing Transactions To Be Submitted.

To match imported bank lines with account transactions:

Related Topics