If you have already reconciled a bank statement but subsequently receive more transactions that need to be included in that statement period, you can delete the reconciled statement and start the reconciliation process over.
Important Considerations:
- Deleting a statement causes the transactions to become unreconciled but remain matched and submitted.
- After deleting, you cannot generate reconciliation reports for that statement period.
- You can only delete the most recent (latest) statement. If you need to delete an earlier statement, you must first delete any statements that were reconciled more recently.
Steps to Delete a Reconciled Statement:
- Navigate to Reconciled Statements List:
- Go to Transactions > Bank > Reconcile Account Statement > List.
- Filter and Sort Statements:
- Use the Filter By Account dropdown list to select the appropriate account.
- To find the latest statement quickly, click the Date column header to sort the statements by date in descending order. This places the most recent statement at the top of the list.
- Delete the Statement:
- In the row of the statement you want to delete, click the Delete link.
- A confirmation popup window will appear.
- Click OK to confirm the deletion.
Result:
- The statement is no longer listed on the Reconciled Statements page.
- Transactions from the deleted statement are now unreconciled but remain matched, making them available for inclusion in future reconciliations.
Tips:
- After deleting a statement, review the transactions to ensure they are accurately matched and prepared for the next reconciliation.
- Regularly communicate with your accounting team to avoid unintended deletions and ensure that all relevant transactions are included in the correct statement periods.
By following these steps, users can efficiently manage and update their reconciliation processes in NetSuite, ensuring all transactions are properly accounted for.