Resolving Unmatched Bank Transactions
When you import an online bank statement into your NetSuite account, most statement transactions match with transactions entered in NetSuite. The Online Banking Statement page displays a date or transaction number in the Matched Transactions column for matched transactions. Unmatched transactions display a link in the Type column of the page.
To resolve any unmatched transactions, you can:
- Manually match transactions
- Enter new transactions to match the bank transactions
Manually Matching Transactions
In some cases, transactions exist in your ledgers but Auto Match cannot successfully match them to the online bank statement information. This can occur if the item is already marked as cleared in the register or if the bank item is a total of several transactions in NetSuite. You can manually match these items on the Find Matching Transactions page.
To manually match transactions to an imported statement:
- Go to Transactions > Bank > Online Banking Statement.
- Click the Find Deposit or Find Charge link in the Type column for an unmatched transaction. The Find Matching Transactions page appears.
Note
NetSuite processes new charges as checks and new deposits as deposit records.
- On the Find Match subtab, identify transactions that match the item. Select the box in the Clearcolumn to match to an existing transaction. If needed, you can check more than one box.
Note
Previously cleared transactions from a held bank reconciliation remain Cleared on the Find Matching Transactions page even if the held bank reconciliation is deleted.
- To narrow your search, check the Show Only Matching Transactions box at the top of the page to display only those transactions that have the same amount as the transaction you are trying to match.
- When you match the transaction and the amount in the Difference field at the top of the page is zero, click Save.
- The Online Banking Statement page opens with the matched transaction. Continue and match other transactions on the statement.
- Click Save.
Entering Transactions While Matching a Bank Statement
Some bank transactions such as bank fees and interest earned may not have matching transactions in the NetSuite ledgers. For these transactions, you can enter a new transaction in your NetSuite account from the Find Matching Transactions page.
To enter new transactions while matching your online bank statement:
- Go to Transactions > Bank > Online Banking Statement.
- Click the Find Deposit or Find Charge link in the Type column for an unmatched transaction.
- On the Find Matching Transaction page, select the New Charges or New Deposits subtab.
- On the New Charges subtab, enter information to record a new matching charge and then click Add.
Enter a new charge of 0.00 to resolve any open zeros on the Find Matching Transactions page.
- On the New Deposits subtab, enter information to record a new matching credit and then click Add.
- On the New Charges subtab, enter information to record a new matching charge and then click Add.
- When you finish entering new transactions and the amount in the Difference field at the top of the page is zero, click Save.
After you enter new transactions or find matching transactions your online bank statement transactions clear. Cleared transactions show on the Online Bank Statement page with transaction numbers or dates in the Matched Transaction column.
Note
When transactions match to an online bank statement they display as Cleared. You must, however, still reconcile transactions on the Reconcile Bank Statement or Reconcile Credit Card Statement pages.