Troubleshooting Reconciliation Issues

If you modify, void, or delete a reconciled transaction, NetSuite may do the following:

Make the transaction unreconciled.
Unmatch the transaction.
Remove the cleared status from the transaction.

The following table outlines what happens in these scenarios and the action required to resolve any issues that arise.

Note:

These scenarios also apply to matched or cleared transactions that have yet to be reconciled.

Scenario	Result	Action Required
A reconciled transaction has its amount modified.	If the transaction was matched, it becomes unmatched and unreconciled (including others in the group). If it was only cleared (not matched), it becomes unreconciled and the cleared status is removed. Note: Unmatched transactions, or those with cleared status removed, move to the Transactions to Match subtab.	If the transaction was matched before, create a new match group using Match and Submit, and then reconcile. To create a match group, do one of the following: Match an existing general ledger transaction or transactions to the imported bank transaction associated with the transaction that had its amount modified. Create a new general ledger transaction or transactions and match to the imported bank transaction associated with the transaction that had its amount modified. If it was cleared, select Clear and Submit, and then reconcile it.
A reconciled transaction is voided with a reversing journal entry.	The transaction stays reconciled and matched or cleared. The reversing journal entry appears on the Transactions to Match subtab.	If there's a matching imported bank transaction, select Match and Submit. Otherwise, select Clear and Submit for the reversing entry. Then reconcile it.
A reconciled transaction is voided without a reversing journal entry.	NetSuite sets the transaction's amount to zero. If it was matched, it becomes unmatched and unreconciled (with any in the group). If it was cleared, it becomes unreconciled and loses cleared status. Note: Unmatched or cleared transactions removed move to the Transactions to Match subtab.	On the Transactions to Match subtab, select Clear and Submit for the voided transaction, and then reconcile it. Warning: Do not match the voided transaction. If the voided transaction has a matching imported bank transaction, select Match and Submit for a valid general ledger transaction, and then reconcile it. To create a match group, do one of the following: Match an existing general ledger transaction or transactions to the corresponding imported bank transaction associated with the voided transaction. Create a new general ledger transaction or transactions and match to the imported bank transaction associated with the voided transaction.
A reconciled transaction is deleted.	If the transaction was matched, the transaction becomes unmatched and unreconciled (along with any transactions in the match group). If the transaction was marked as cleared, the transaction becomes unreconciled and has its cleared status removed. The deleted transaction is no longer visible anywhere in NetSuite. Any transactions belonging to the same match group move to the Transactions to Match subtab.	Use Match and Submit for any unmatched transactions that belonged to the same group as the deleted transaction, if needed. Then reconcile the transactions. Note: If it was marked as cleared before, you don't need to do anything.

Scenario

Result

Action Required

A reconciled transaction has its amount modified.

If the transaction was matched, it becomes unmatched and unreconciled (including others in the group).

If it was only cleared (not matched), it becomes unreconciled and the cleared status is removed.

Note:

Unmatched transactions, or those with cleared status removed, move to the Transactions to Match subtab.

If the transaction was matched before, create a new match group using Match and Submit, and then reconcile.

To create a match group, do one of the following:

Match an existing general ledger transaction or transactions to the imported bank transaction associated with the transaction that had its amount modified.
Create a new general ledger transaction or transactions and match to the imported bank transaction associated with the transaction that had its amount modified.

If it was cleared, select Clear and Submit, and then reconcile it.

A reconciled transaction is voided with a reversing journal entry.

The transaction stays reconciled and matched or cleared.

The reversing journal entry appears on the Transactions to Match subtab.

If there's a matching imported bank transaction, select Match and Submit. Otherwise, select Clear and Submit for the reversing entry. Then reconcile it.

A reconciled transaction is voided without a reversing journal entry.

NetSuite sets the transaction's amount to zero.

If it was matched, it becomes unmatched and unreconciled (with any in the group).

If it was cleared, it becomes unreconciled and loses cleared status.

Note:

Unmatched or cleared transactions removed move to the Transactions to Match subtab.

On the Transactions to Match subtab, select Clear and Submit for the voided transaction, and then reconcile it.

Warning:

Do not match the voided transaction.

If the voided transaction has a matching imported bank transaction, select Match and Submit for a valid general ledger transaction, and then reconcile it.

To create a match group, do one of the following:

Match an existing general ledger transaction or transactions to the corresponding imported bank transaction associated with the voided transaction.
Create a new general ledger transaction or transactions and match to the imported bank transaction associated with the voided transaction.

A reconciled transaction is deleted.

If the transaction was matched, the transaction becomes unmatched and unreconciled (along with any transactions in the match group).

If the transaction was marked as cleared, the transaction becomes unreconciled and has its cleared status removed.

The deleted transaction is no longer visible anywhere in NetSuite. Any transactions belonging to the same match group move to the Transactions to Match subtab.

Use Match and Submit for any unmatched transactions that belonged to the same group as the deleted transaction, if needed. Then reconcile the transactions.

Note:

If it was marked as cleared before, you don't need to do anything.

To match transactions, see Matching Bank Data. To mark transactions without matching imported bank transactions as cleared, see Marking Transactions as Cleared.

To reconcile transactions, see Reconciling Transactions.

If you are still using the original reconciliation pages, see Reconciling Bank Statements and Reconciling Credit Card Statements.

Related Topics