Troubleshooting Reconciliation Issues

If a reconciled transaction has its amount modified, is voided, or is deleted, NetSuite may do the following, depending on the situation:

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, the transactions becomes unmatched and unreconciled (along with any transactions in the match group). If the transaction was marked as cleared rather than matched, the transaction becomes unreconciled and has its cleared status removed. Note: Unmatched transactions or transactions that have their cleared status removed move to the To Be Matched subtab.	If the transaction was previously matched, create a new match group, submit the transactions, and then reconcile them. 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 the transaction was marked as cleared, clear the transaction again, submit it, and then reconcile it.
A reconciled transaction is voided with a reversing journal entry.	The transaction remains reconciled and matched or user-cleared. A reversing journal entry appears on the To Be Matched subtab.	If the reversing journal entry has a matching imported bank line, match the reversing entry to the corresponding bank line. Otherwise, clear the reversing journal entry. After you match or clear the reversing entry, submit it, and then reconcile it.
A reconciled transaction is voided without a reversing journal entry.	NetSuite sets the transaction amount to zero. 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. Note: Unmatched transactions or transactions that have their cleared status 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 corresponding imported bank line, match the bank line to a valid account transaction or transactions, and then submit and reconcile your transactions. 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 match group as the deleted transaction, if applicable. Note: If the transaction was previously marked as cleared, no action is required.

Scenario

Result

Action Required

A reconciled transaction has its amount modified.

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

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

Note:

Unmatched transactions or transactions that have their cleared status removed move to the To Be Matched subtab.

If the transaction was previously matched, create a new match group, submit the transactions, and then reconcile them.

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 the transaction was marked as cleared, clear the transaction again, submit it, and then reconcile it.

A reconciled transaction is voided with a reversing journal entry.

The transaction remains reconciled and matched or user-cleared.

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

If the reversing journal entry has a matching imported bank line, match the reversing entry to the corresponding bank line. Otherwise, clear the reversing journal entry. After you match or clear the reversing entry, submit it, and then reconcile it.

A reconciled transaction is voided without a reversing journal entry.

NetSuite sets the transaction amount to zero.

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.

Note:

Unmatched transactions or transactions that have their cleared status 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 corresponding imported bank line, match the bank line to a valid account transaction or transactions, and then submit and reconcile your transactions.

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 match group as the deleted transaction, if applicable.

Note:

If the transaction was previously marked as cleared, no action is required.

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