Reconciliation differences can be brought about by different factors. Some of it are listed in this article: NSC | Possible Reasons for Reconciliation Difference. However, if there is a difference on the Last Reconciled Balance of this month’s reconciliation and the Ending Statement Balance of the previous month’s reconciliation, there might be an incorrectly saved reconciliation in between. If so, user will need to delete this reconciliation.
As doumented in SuiteAnswer Article: Deleting Reconciled Statements
- Go to Transactions > Bank > Reconcile Account Statement > List
- To filter the list on the Reconciled Statements page:
- From the Filter By Account dropdown list, select the appropriate account.
- To sort by the date column, click the Date column header.
- In the row of the statement you want to delete, click Delete. NetSuite displays the confirmation popup window.
- In the Reconciled Statements page, the statement is no longer in the list. The transactions from the deleted statement are now unreconciled but are still matched.
Note: Current Reconciled Statements needs to be deleted first to delete the old Reconciled Statement
To learn more about NetSuite Reconciliation: watch this webinar replay:
WEBINAR REPLAY | Techniques to Boost Your NetSuite Bank Reconciliation Skills
Hope this helped!