Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Reconcile Individual Lines Feedback

If the bank provides feedback as individual lines instead of one mail line then in most situations the description field on the bank statement will hold a payment number that is equal to the payment number that was created by Netsuite. The naming convention Netsuite uses is always following the pattern “payment batch number” / “Transaction line number”. If this information is indeed present the Bank Reconciliation will automatically match the individual lines. If the bank does not provide this feedback in the description it's recommended to contact the bank so that it can potentially be altered. Please note that on the bank account configuration the “/” should not be a part of the additional delimiter settings.

...

If the bank is not able to provide this transaction number as the feedback you could enable the matching option on the bank account configuration named “Match Closed On Exact Match Within Date Range”. In most cases, this matching option will still be able to match the lines automatically, but it is only recommended to enable this matching option if amounts are pretty unique so the system is protected in some way against incorrect matches.

If none of the above options is a potential solution for automizing the matching the user always can proceed manually by first selecting on the line the correct entity. After selecting the entity the Bank Reconciliation Suite App will show a pop-up. In this pop-up, you first select the checkbox labeled “Show Closed Transactions”. The list that is shown should hold the expected closed transaction to reconcile against.

...