When deposits have been pushed to NetSuite through an integration and later need to be deleted, you may encounter an error preventing deletion if the deposits have already been reconciled through Match Bank Data. NetSuite protects reconciled transactions from accidental deletion, so you'll need to unreconcile them first.
Why This Happens
NetSuite prevents deletion of reconciled transactions to maintain the integrity of your bank reconciliation. Once a deposit is matched and reconciled in the Match Bank Data process, it becomes "locked" and cannot be deleted until the reconciliation is reversed.
Step-by-Step Solution
Step 1: Navigate to Match Bank Data
Go to Banking > Match Bank Data
Select the appropriate bank account
Choose the statement period that contains your reconciled deposits
Step 2: Locate the Reconciled Deposits
Look for deposits that show as "Matched" or "Reconciled"
You can filter by date range or amount to find specific transactions
Note: Reconciled deposits will typically have a checkmark or "Matched" status
Step 3: Unreconcile the Deposits
For Individual Deposits:
Click on the matched deposit line
Select "Unmatch" or "Remove Match"
Confirm the action when prompted
For Multiple Deposits:
Use checkboxes to select multiple reconciled deposits
Click "Unmatch Selected" or similar bulk action
Confirm the unmatching process
Step 4: Save Your Changes
Click "Save" to apply the unreconciliation
Wait for NetSuite to process the changes
The deposits should now show as unreconciled/unmatched
Step 5: Delete the Deposits
Navigate to the individual deposit records through:
Banking > Deposits (for deposit records)
Or through Transactions > Bank Deposits
Open each deposit you need to delete
Click "Delete"
Confirm the deletion when prompted
Alternative bulk deletion method:
Go to Lists > Search > Saved Searches
Create or use an existing search for deposits
Filter by date range and amounts
Use "Delete" from the bulk actions menu
Important Notes
Before You Begin:
Ensure you have proper permissions to unreconcile transactions and delete deposits
Consider the impact on your financial reporting and audit trail
Take screenshots or export records for your documentation
Pro Tips:
If you're deleting many deposits, work in smaller batches to avoid timeout issues
Double-check that you're unreconciling the correct transactions before deletion
Consider running a backup report of affected transactions before making changes
After Deletion
Once the deposits are successfully deleted:
Verify the transactions no longer appear in your deposit listings
Check that your bank reconciliation reflects the changes
Update any related integration settings to prevent future unwanted deposits
Document the deletion for audit purposes
Need Help?
If you continue to experience issues with unreconciling or deleting deposits, consider:
Checking NetSuite's help documentation for your specific version
Contacting your NetSuite administrator or consultant
Reviewing your user permissions for banking and reconciliation features
By following these steps, you should be able to successfully unreconcile and delete the problematic deposits from your NetSuite system.