Settlement Discrepancies in NetSuite Order Management

Settlement discrepancies are issues that occur during the reconciliation process in NetSuite, particularly visible in the Settlement and Fee Report where records may show Retry for deposit entries. This indicates that NetSuite couldn't locate a matching payment in its records for a bank settlement.

To resolve these discrepancies, navigate to NetSuite Pay > Daily Settlement Batch > Settlement and Fee Report. By selecting Retry, you initiate an automated process aimed at finding the missing payment within NetSuite. However, if the Retry process fails to find a match, the system notes this, and you will need to manually address the issue or contact NetSuite support if it recurs.

Common Causes of Settlement Discrepancies

• A settlement discrepancy often arises when a failed transaction has been moved from Undeposited Funds to another general ledger (GL) account. Transactions not present in Undeposited Funds cannot be reconciled effectively.
• To remedy this, move the pertinent transactions back into Undeposited Funds before retrying the reconciliation process.

Tips for Effective Resolution

• Always check if the transactions are still in Undeposited Funds.
• Review your GL mappings for accuracy to prevent future discrepancies.

By understanding and applying these practices, you can optimize the reconciliation process in NetSuite and reduce the likelihood of encountering settlement discrepancies.

Key Points:

• Settlement discrepancies occur when payments cannot be matched during reconciliation.
• Use the Retry function to locate missing payments in NetSuite.
• Manually intervene when automated processes fail, or seek support for recurring issues.

Source: This article is based on Oracle's official NetSuite documentation.