Troubleshooting Unreconciled Transactions in NetSuite

A previously reconciled transaction becomes unreconciled in NetSuite.

The following reasons could explain why previously reconciled transactions become unreconciled:

  • Transaction Editing:
  • Warning Notification: When a reconciled transaction is edited, NetSuite issues a soft warning: “Editing this transaction will unreconcile the transaction.”
  • Action: Ensure that users are aware of this warning and avoid editing reconciled transactions unless absolutely necessary.
  • Deleted Reconciliation:
  • Reconciled Statements Page: If the reconciliation was deleted from the Reconciled Statements page, the transactions within that reconciliation will become unreconciled.
  • Action: Verify if the reconciliation was deleted by navigating to:
  • Transactions > Bank > Reconcile Account Statement > List.
  • Review the list to check if the specific reconciliation was deleted.

Steps to Verify and Correct Unreconciled Transactions:

  • Check Transaction Status:
  • Navigate to Transactions > Bank > Reconcile Account Statement.
  • Select the relevant account.
  • Review the list of reconciled transactions to identify any discrepancies.
  • Review Reconciliation History:
  • Navigate to Transactions > Bank > Reconcile Account Statement > List.
  • Look for any deleted reconciliations or changes made to previously reconciled transactions.
  • Prevent Future Issues:
  • Educate users about the impact of editing reconciled transactions.
  • Implement controls or restrictions to prevent unauthorized editing of reconciled transactions.

By understanding these potential causes and following the outlined steps, users can manage and resolve issues with unreconciled transactions effectively, ensuring the accuracy and integrity of their financial records in NetSuite.

Leave a comment

Your email address will not be published. Required fields are marked *