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 user-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 To Be Matched subtab.	If the transaction was matched before, create a new match group, submit, and reconcile. To create a match group, do one of the following: Match an existing account transaction or transactions to the imported bank line associated with the transaction that had its amount modified. Create a new account transaction or transactions and match to the imported bank line associated with the transaction that had its amount modified. If it was cleared, clear it again, submit, and then reconcile.
A reconciled transaction is voided with a reversing journal entry.	The transaction stays reconciled and matched or user-cleared. The reversing journal entry appears on the To Be Matched subtab.	If there’s a matching imported bank line, match it. Otherwise, clear the reversing entry. After that, submit and reconcile.
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 To Be Matched subtab.	On the To Be Matched subtab, mark the voided transaction as cleared, and then submit and reconcile it. Warning: Do not match the voided transaction. If the voided transaction had a matching bank line, match it to a valid account transaction, submit, and reconcile. To create a match group, do one of the following: Match an existing account transaction or transactions to the corresponding imported bank line associated with the voided transaction. Create a new account transaction or transactions and match to the imported bank line 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 To Be Matched subtab.	Match, submit, and reconcile any unmatched transactions that belonged to the same group as the deleted transaction, if needed. 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 To Be Matched subtab.

If the transaction was matched before, create a new match group, submit, and reconcile.

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

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

If it was cleared, clear it again, submit, and then reconcile.

A reconciled transaction is voided with a reversing journal entry.

The transaction stays reconciled and matched or user-cleared.

The reversing journal entry appears on the To Be Matched subtab.

If there’s a matching imported bank line, match it. Otherwise, clear the reversing entry. After that, submit and reconcile.

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 To Be Matched subtab.

On the To Be Matched subtab, mark the voided transaction as cleared, and then submit and reconcile it.

Warning:

Do not match the voided transaction.

If the voided transaction had a matching bank line, match it to a valid account transaction, submit, and reconcile.

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

Match an existing account transaction or transactions to the corresponding imported bank line associated with the voided transaction.
Create a new account transaction or transactions and match to the imported bank line 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 To Be Matched subtab.

Match, submit, and reconcile any unmatched transactions that belonged to the same group as the deleted transaction, if needed.

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 lines 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