How to Fix Bank Reconciliations in NetSuite

If you notice a difference in your bank reconciliation in NetSuite, you can review and correct it by following these steps.

Steps

1. Navigate to the Bank Reconciliation page

   • Go to Transactions > Bank > Reconcile Bank Statement.

   • Select the bank account you want to review (e.g. 1000 Checking).

2. Access Reconciliation History

   • Click History.

   • This opens the Reconciliation History screen.

   • If you don’t see records, enter an early date in the From field and click Refresh to display all reconciliations.

3. Identify the Difference

   • Look for any reconciliation that shows a dollar difference.

   • Click the difference amount to open that reconciliation.

4. Review and Adjust

   • Check which transactions may have been edited or changed after the reconciliation.

   • Select (check off) those transactions in the reconciliation box.

   • Confirm that the Difference now shows 0.00.

5. Save and Verify

   • Click Save to update the reconciliation.

   • Return to the Reconciliation History screen.

   • Backdate the From field and click Refresh again.

   • Confirm that the difference is now zero.

Notes

• This issue usually occurs when transactions (such as deposits) are edited after a reconciliation has already been completed.

• Always review changes carefully before saving to ensure accuracy.